History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"vampire"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 552 | 2026-04-22 14:15:28 | vampire | 1 | 69583 | 3 | 6.923 | 10051.0 |
| 551 | 2026-04-19 10:19:23 | vampire | 3 | 134027 | 185 | 33.376 | 4015.7 |
| 550 | 2026-04-10 22:49:36 | vampire | 3 | 134027 | 185 | 34.250 | 3913.2 |
| 549 | 2026-04-05 13:09:36 | vampire | 3 | 134027 | 185 | 50.910 | 2632.6 |
| 548 | 2026-04-03 15:54:19 | vampire | 3 | 134027 | 185 | 48.890 | 2741.4 |
| 547 | 2026-04-03 15:54:28 | vampire | 3 | 134027 | 185 | 16.970 | 7897.9 |
| 546 | 2026-04-03 15:53:33 | vampire | 3 | 134027 | 185 | 56.473 | 2373.3 |
| 545 | 2026-04-02 11:58:26 | vampire | 1 | 69583 | 3 | 5.360 | 12981.9 |
| 544 | 2026-03-29 18:48:09 | vampire | 1 | 69583 | 3 | 1.253 | 55533.1 |
| 543 | 2026-03-26 17:04:41 | vampire | 1 | 69583 | 3 | 5.423 | 12831.1 |
| 542 | 2026-03-18 23:46:47 | vampire | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 541 | 2026-03-12 12:35:40 | vampire | 1 | 69583 | 3 | 1.326 | 52475.9 |
| 540 | 2026-03-11 23:01:03 | vampire | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 539 | 2026-03-11 01:27:05 | vampire | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 538 | 2026-03-11 00:37:54 | vampire | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 537 | 2026-03-09 15:05:26 | vampire | 1 | 69583 | 3 | 1.670 | 41666.5 |
| 536 | 2026-03-01 04:57:39 | vampire | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 535 | 2026-02-28 22:16:47 | vampire | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 534 | 2026-02-28 07:34:00 | vampire | 3 | 134027 | 185 | 7.123 | 18816.1 |
| 533 | 2026-02-26 09:45:02 | vampire | 3 | 134027 | 185 | 6.343 | 21129.9 |
| 532 | 2026-02-25 22:18:38 | vampire | 2 | 107671 | 17 | 3.703 | 29076.7 |
| 531 | 2026-02-23 05:54:35 | vampire | 1 | 69583 | 3 | 1.533 | 45390.1 |
| 530 | 2026-02-12 06:43:35 | vampire | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 529 | 2026-02-12 00:16:40 | vampire | 2 | 107671 | 17 | 12.330 | 8732.4 |
| 528 | 2026-02-12 00:16:30 | vampire | 2 | 107671 | 17 | 15.720 | 6849.3 |
| 527 | 2026-02-12 00:16:09 | vampire | 2 | 107671 | 17 | 16.156 | 6664.5 |
| 526 | 2026-02-11 18:18:55 | vampire | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 525 | 2026-02-10 00:52:24 | vampire | 1 | 69583 | 3 | 2.906 | 23944.6 |
| 524 | 2026-02-07 09:34:48 | vampire | 3 | 134027 | 185 | 27.813 | 4818.9 |
| 523 | 2026-02-04 08:32:56 | vampire | 3 | 134027 | 185 | 7.063 | 18975.9 |
| 522 | 2026-02-04 06:53:48 | vampire | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 521 | 2026-01-30 02:47:01 | vampire | 2 | 107671 | 17 | 3.326 | 32372.5 |
| 520 | 2026-01-26 23:16:03 | vampire | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 519 | 2026-01-23 17:19:06 | vampire | 1 | 69583 | 3 | 1.673 | 41591.8 |
| 518 | 2026-01-20 18:40:54 | vampire | 3 | 134027 | 185 | 8.203 | 16338.8 |
| 517 | 2026-01-18 10:54:10 | vampire | 1 | 69583 | 3 | 1.263 | 55093.4 |
| 516 | 2026-01-16 10:20:18 | vampire | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 515 | 2026-01-16 10:18:27 | vampire | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 514 | 2026-01-13 20:29:08 | vampire | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 513 | 2026-01-13 07:28:50 | vampire | 1 | 69583 | 3 | 2.420 | 28753.3 |
| 512 | 2026-01-13 05:11:23 | vampire | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 511 | 2026-01-11 02:54:20 | vampire | 1 | 69583 | 3 | 1.530 | 45479.1 |
| 510 | 2026-01-02 16:05:29 | vampire | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 509 | 2025-12-27 01:13:37 | vampire | 1 | 69583 | 3 | 2.606 | 26701.1 |
| 508 | 2025-12-26 12:15:14 | vampire | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 507 | 2025-12-24 16:42:10 | vampire | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 506 | 2025-12-24 15:01:35 | vampire | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 505 | 2025-12-18 17:22:59 | vampire | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 504 | 2025-12-02 12:31:37 | vampire | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 503 | 2025-11-21 22:56:41 | vampire | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 502 | 2025-11-20 07:43:19 | vampire | 1 | 69583 | 3 | 1.096 | 63488.1 |
| 501 | 2025-11-18 12:04:27 | vampire | 2 | 107671 | 17 | 4.046 | 26611.7 |
| 500 | 2025-11-16 02:43:40 | vampire | 2 | 107671 | 17 | 3.503 | 30736.8 |
| 499 | 2025-11-14 12:22:40 | vampire | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 498 | 2025-11-09 02:28:36 | vampire | 1 | 69583 | 3 | 1.200 | 57985.8 |
| 497 | 2025-11-05 16:54:41 | vampire | 2 | 107671 | 17 | 3.580 | 30075.7 |
| 496 | 2025-11-04 04:47:55 | vampire | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 495 | 2025-11-03 20:27:08 | vampire | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 494 | 2025-10-27 08:06:15 | vampire | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 493 | 2025-10-22 02:01:42 | vampire | 1 | 69583 | 3 | 3.000 | 23194.3 |
| 492 | 2025-10-20 20:48:27 | vampire | 1 | 69583 | 3 | 5.903 | 11787.7 |
| 491 | 2025-10-20 20:48:05 | vampire | 1 | 69583 | 3 | 5.140 | 13537.5 |
| 490 | 2025-10-20 20:47:43 | vampire | 1 | 69583 | 3 | 5.846 | 11902.7 |
| 489 | 2025-10-20 20:47:31 | vampire | 1 | 69583 | 3 | 5.563 | 12508.2 |
| 488 | 2025-10-16 13:11:21 | vampire | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 487 | 2025-10-09 01:46:16 | vampire | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 486 | 2025-10-03 13:02:38 | vampire | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 485 | 2025-09-25 20:32:36 | vampire | 1 | 69583 | 3 | 2.673 | 26031.8 |
| 484 | 2025-09-19 03:29:16 | vampire | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 483 | 2025-09-18 00:00:00 | vampire | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 482 | 2025-08-25 17:43:47 | vampire | 1 | 69583 | 3 | 3.000 | 23194.3 |
| 481 | 2025-08-24 19:10:03 | vampire | 1 | 69583 | 3 | 5.720 | 12164.9 |
| 480 | 2025-08-20 19:47:01 | vampire | 1 | 69583 | 3 | 2.860 | 24329.7 |
| 479 | 2025-08-15 12:08:48 | vampire | 1 | 69583 | 3 | 3.376 | 20611.1 |
| 478 | 2025-08-13 04:16:50 | vampire | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 477 | 2025-08-07 21:53:02 | vampire | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 476 | 2025-08-01 14:00:38 | vampire | 1 | 69583 | 3 | 3.296 | 21111.3 |
| 475 | 2025-07-29 00:48:54 | vampire | 1 | 69583 | 3 | 2.190 | 31773.1 |
| 474 | 2025-07-28 11:15:43 | vampire | 1 | 69583 | 3 | 2.953 | 23563.5 |
| 473 | 2025-07-25 08:00:38 | vampire | 1 | 69583 | 3 | 5.453 | 12760.5 |
| 472 | 2025-07-24 23:24:34 | vampire | 1 | 69583 | 3 | 3.970 | 17527.2 |
| 471 | 2025-07-24 21:41:33 | vampire | 1 | 69583 | 3 | 5.706 | 12194.7 |
| 470 | 2025-07-22 08:29:32 | vampire | 1 | 69583 | 3 | 2.796 | 24886.6 |
| 469 | 2025-07-19 10:30:45 | vampire | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 468 | 2025-07-18 08:52:58 | vampire | 1 | 69583 | 3 | 5.830 | 11935.3 |
| 467 | 2025-07-17 10:04:22 | vampire | 1 | 69583 | 3 | 5.876 | 11841.9 |
| 466 | 2025-07-17 09:29:19 | vampire | 1 | 69583 | 3 | 3.236 | 21502.8 |
| 465 | 2025-07-10 22:15:17 | vampire | 1 | 69583 | 3 | 5.906 | 11781.7 |
| 464 | 2025-07-10 14:29:13 | vampire | 1 | 69583 | 3 | 3.090 | 22518.8 |
| 463 | 2025-07-03 22:35:21 | vampire | 1 | 69583 | 3 | 4.610 | 15093.9 |
| 462 | 2025-06-29 22:20:35 | vampire | 1 | 69583 | 3 | 8.670 | 8025.7 |
| 461 | 2025-06-26 13:00:18 | vampire | 1 | 69583 | 3 | 5.080 | 13697.4 |
| 460 | 2025-06-20 16:04:58 | vampire | 1 | 69583 | 3 | 5.970 | 11655.4 |
| 459 | 2025-06-15 11:01:26 | vampire | 2 | 107671 | 17 | 2.923 | 36835.8 |
| 458 | 2025-06-14 18:16:14 | vampire | 1 | 69583 | 3 | 6.016 | 11566.3 |
| 457 | 2025-06-08 14:11:24 | vampire | 3 | 134027 | 185 | 17.813 | 7524.1 |
| 456 | 2025-06-07 22:28:54 | vampire | 3 | 134027 | 185 | 47.893 | 2798.5 |
| 455 | 2025-06-07 07:47:10 | vampire | 1 | 69583 | 3 | 5.500 | 12651.5 |
| 454 | 2025-06-06 03:12:12 | vampire | 3 | 134027 | 185 | 31.343 | 4276.1 |
| 453 | 2025-06-05 00:06:31 | vampire | 3 | 134027 | 185 | 34.156 | 3924.0 |