History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"johnson"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 548 | 2025-11-28 09:31:19 | johnson | 3 | 134027 | 33 | 12.656 | 10590.0 |
| 547 | 2025-11-28 08:07:31 | johnson | 1 | 69583 | 2 | 1.080 | 64428.7 |
| 546 | 2025-11-21 14:28:25 | johnson | 1 | 69583 | 2 | 1.173 | 59320.5 |
| 545 | 2025-11-12 23:31:23 | johnson | 1 | 69583 | 2 | 1.200 | 57985.8 |
| 544 | 2025-10-23 13:49:58 | johnson | 1 | 69583 | 2 | 1.076 | 64668.2 |
| 543 | 2025-10-22 09:08:29 | johnson | 4 | 151207 | 489 | 50.333 | 3004.1 |
| 542 | 2025-10-18 22:55:40 | johnson | 1 | 69583 | 2 | 1.173 | 59320.5 |
| 541 | 2025-10-06 20:19:46 | johnson | 2 | 107671 | 3 | 5.796 | 18576.8 |
| 540 | 2025-10-05 18:45:09 | johnson | 4 | 151207 | 489 | 18.453 | 8194.2 |
| 539 | 2025-10-05 17:12:25 | johnson | 3 | 134027 | 33 | 6.860 | 19537.5 |
| 538 | 2025-10-04 10:40:23 | johnson | 1 | 69583 | 2 | 1.063 | 65459.1 |
| 537 | 2025-09-18 18:47:51 | johnson | 1 | 69583 | 2 | 2.266 | 30707.4 |
| 536 | 2025-09-17 16:51:49 | johnson | 3 | 134027 | 33 | 6.233 | 21502.8 |
| 535 | 2025-08-24 22:18:33 | johnson | 1 | 69583 | 2 | 2.966 | 23460.2 |
| 534 | 2025-08-16 20:29:39 | johnson | 1 | 69583 | 2 | 2.673 | 26031.8 |
| 533 | 2025-07-26 07:19:31 | johnson | 1 | 69583 | 2 | 4.690 | 14836.5 |
| 532 | 2025-07-24 15:52:47 | johnson | 1 | 69583 | 2 | 2.923 | 23805.3 |
| 531 | 2025-07-24 03:25:03 | johnson | 1 | 69583 | 2 | 5.063 | 13743.4 |
| 530 | 2025-07-23 04:33:12 | johnson | 1 | 69583 | 2 | 5.983 | 11630.1 |
| 529 | 2025-07-22 14:37:03 | johnson | 1 | 69583 | 2 | 3.610 | 19275.1 |
| 528 | 2025-07-15 22:52:47 | johnson | 1 | 69583 | 2 | 1.156 | 60192.9 |
| 527 | 2025-07-14 15:24:46 | johnson | 2 | 107671 | 3 | 17.936 | 6003.1 |
| 526 | 2025-07-13 03:58:15 | johnson | 1 | 69583 | 2 | 1.266 | 54962.9 |
| 525 | 2025-07-05 02:00:32 | johnson | 3 | 134027 | 33 | 54.643 | 2452.8 |
| 524 | 2025-07-02 14:38:56 | johnson | 3 | 134027 | 33 | 36.003 | 3722.7 |
| 523 | 2025-06-30 00:30:13 | johnson | 1 | 69583 | 2 | 2.533 | 27470.6 |
| 522 | 2025-06-22 12:25:59 | johnson | 4 | 151207 | 489 | 58.443 | 2587.3 |
| 521 | 2025-06-22 09:52:22 | johnson | 1 | 69583 | 2 | 3.093 | 22496.9 |
| 520 | 2025-06-22 02:09:00 | johnson | 2 | 107671 | 3 | 16.233 | 6632.8 |
| 519 | 2025-06-20 15:51:44 | johnson | 4 | 151207 | 489 | 53.440 | 2829.5 |
| 518 | 2025-06-20 15:50:52 | johnson | 4 | 151207 | 489 | 68.270 | 2214.8 |
| 517 | 2025-06-20 13:49:03 | johnson | 4 | 151207 | 489 | 48.206 | 3136.7 |
| 516 | 2025-06-19 22:35:27 | johnson | 4 | 151207 | 489 | 67.680 | 2234.1 |
| 515 | 2025-06-19 20:32:40 | johnson | 4 | 151207 | 489 | 53.516 | 2825.5 |
| 514 | 2025-06-18 19:16:46 | johnson | 4 | 151207 | 489 | 12.270 | 12323.3 |
| 513 | 2025-06-15 03:00:57 | johnson | 3 | 134027 | 33 | 13.390 | 10009.5 |
| 512 | 2025-06-14 03:17:09 | johnson | 1 | 69583 | 2 | 5.406 | 12871.4 |
| 511 | 2025-06-06 01:05:06 | johnson | 1 | 69583 | 2 | 4.153 | 16754.9 |
| 510 | 2025-05-24 07:46:28 | johnson | 3 | 134027 | 33 | 39.376 | 3403.8 |
| 509 | 2025-05-22 09:32:52 | johnson | 1 | 69583 | 2 | 5.860 | 11874.2 |
| 508 | 2025-05-18 01:51:56 | johnson | 3 | 134027 | 33 | 33.030 | 4057.7 |
| 507 | 2025-05-15 00:39:45 | johnson | 3 | 134027 | 33 | 5.920 | 22639.7 |
| 506 | 2025-05-12 02:46:59 | johnson | 1 | 69583 | 2 | 3.216 | 21636.5 |
| 505 | 2025-05-11 16:57:32 | johnson | 1 | 69583 | 2 | 1.250 | 55666.4 |
| 504 | 2025-05-10 06:33:10 | johnson | 1 | 69583 | 2 | 4.436 | 15686.0 |
| 503 | 2025-05-10 06:13:21 | johnson | 1 | 69583 | 2 | 7.096 | 9805.9 |
| 502 | 2025-04-30 06:19:09 | johnson | 3 | 134027 | 33 | 34.470 | 3888.2 |
| 501 | 2025-04-23 15:51:02 | johnson | 3 | 134027 | 33 | 40.393 | 3318.1 |
| 500 | 2025-04-22 19:54:19 | johnson | 1 | 69583 | 2 | 1.123 | 61961.7 |
| 499 | 2025-04-21 05:39:31 | johnson | 2 | 107671 | 3 | 15.673 | 6869.8 |
| 498 | 2025-04-11 10:25:39 | johnson | 3 | 134027 | 33 | 42.706 | 3138.4 |
| 497 | 2025-04-11 04:36:08 | johnson | 2 | 107671 | 3 | 13.813 | 7794.9 |
| 496 | 2025-04-11 02:15:31 | johnson | 2 | 107671 | 3 | 13.893 | 7750.0 |
| 495 | 2025-04-10 02:06:35 | johnson | 1 | 69583 | 2 | 1.173 | 59320.5 |
| 494 | 2025-04-10 00:02:16 | johnson | 1 | 69583 | 2 | 2.030 | 34277.3 |
| 493 | 2025-04-06 00:15:17 | johnson | 1 | 69583 | 2 | 6.893 | 10094.7 |
| 492 | 2025-03-29 13:47:33 | johnson | 4 | 151207 | 489 | 57.506 | 2629.4 |
| 491 | 2025-03-28 19:08:54 | johnson | 1 | 69583 | 2 | 1.033 | 67360.1 |
| 490 | 2025-03-27 14:26:05 | johnson | 4 | 151207 | 489 | 57.206 | 2643.2 |
| 489 | 2025-03-27 11:41:42 | johnson | 4 | 151207 | 489 | 66.953 | 2258.4 |
| 488 | 2025-03-26 21:21:52 | johnson | 4 | 151207 | 489 | 29.740 | 5084.3 |
| 487 | 2025-03-25 15:06:51 | johnson | 4 | 151207 | 489 | 53.250 | 2839.6 |
| 486 | 2025-03-24 00:47:50 | johnson | 4 | 151207 | 489 | 36.313 | 4164.0 |
| 485 | 2025-03-23 21:00:36 | johnson | 2 | 107671 | 3 | 13.830 | 7785.3 |
| 484 | 2025-03-22 23:15:07 | johnson | 3 | 134027 | 33 | 23.483 | 5707.4 |
| 483 | 2025-03-22 10:15:23 | johnson | 1 | 69583 | 2 | 4.390 | 15850.3 |
| 482 | 2025-03-16 11:33:32 | johnson | 1 | 69583 | 2 | 6.326 | 10999.5 |
| 481 | 2025-03-10 14:08:50 | johnson | 3 | 134027 | 33 | 25.973 | 5160.2 |
| 480 | 2025-03-10 14:08:55 | johnson | 2 | 107671 | 3 | 12.610 | 8538.5 |
| 479 | 2025-03-10 13:01:45 | johnson | 1 | 69583 | 2 | 3.626 | 19190.0 |
| 478 | 2025-03-09 12:40:06 | johnson | 1 | 69583 | 2 | 3.343 | 20814.5 |
| 477 | 2025-02-09 22:20:48 | johnson | 1 | 69583 | 2 | 6.296 | 11051.9 |
| 476 | 2025-02-01 10:07:12 | johnson | 1 | 69583 | 2 | 5.360 | 12981.9 |
| 475 | 2025-01-16 14:28:29 | johnson | 1 | 69583 | 2 | 5.126 | 13574.5 |
| 474 | 2025-01-15 15:11:57 | johnson | 1 | 69583 | 2 | 3.063 | 22717.3 |
| 473 | 2025-01-02 00:58:57 | johnson | 1 | 69583 | 2 | 4.733 | 14701.7 |
| 472 | 2024-12-19 12:18:07 | johnson | 1 | 69583 | 2 | 4.610 | 15093.9 |
| 471 | 2024-12-09 10:18:25 | johnson | 1 | 69583 | 2 | 5.670 | 12272.1 |
| 470 | 2024-11-21 23:51:36 | johnson | 3 | 134027 | 33 | 34.033 | 3938.1 |
| 469 | 2024-11-10 18:58:18 | johnson | 4 | 151207 | 489 | 60.206 | 2511.5 |
| 468 | 2024-11-10 14:18:11 | johnson | 3 | 134027 | 33 | 7.220 | 18563.3 |
| 467 | 2024-11-10 13:52:49 | johnson | 1 | 69583 | 2 | 1.920 | 36241.1 |
| 466 | 2024-11-10 10:53:57 | johnson | 4 | 151207 | 489 | 60.190 | 2512.2 |
| 465 | 2024-11-10 05:34:55 | johnson | 4 | 151207 | 489 | 54.423 | 2778.4 |
| 464 | 2024-11-10 05:34:52 | johnson | 3 | 134027 | 33 | 26.080 | 5139.1 |
| 463 | 2024-11-10 05:34:53 | johnson | 2 | 107671 | 3 | 9.846 | 10935.5 |
| 462 | 2024-11-08 07:30:40 | johnson | 1 | 69583 | 2 | 5.140 | 13537.5 |
| 461 | 2024-11-03 14:09:31 | johnson | 1 | 69583 | 2 | 5.983 | 11630.1 |
| 460 | 2024-10-27 07:08:54 | johnson | 1 | 69583 | 2 | 2.826 | 24622.4 |
| 459 | 2024-10-26 18:25:00 | johnson | 1 | 69583 | 2 | 5.876 | 11841.9 |
| 458 | 2024-10-09 13:01:02 | johnson | 1 | 69583 | 2 | 3.716 | 18725.2 |
| 457 | 2024-09-27 01:35:11 | johnson | 1 | 69583 | 2 | 9.920 | 7014.4 |
| 456 | 2024-08-30 17:58:55 | johnson | 1 | 69583 | 2 | 7.733 | 8998.2 |
| 455 | 2024-08-07 19:27:48 | johnson | 4 | 151207 | 489 | 45.970 | 3289.3 |
| 454 | 2024-08-07 08:59:10 | johnson | 4 | 151207 | 489 | 22.093 | 6844.1 |
| 453 | 2024-07-27 10:42:16 | johnson | 4 | 151207 | 489 | 27.143 | 5570.8 |
| 452 | 2024-07-27 09:42:52 | johnson | 4 | 151207 | 489 | 49.236 | 3071.1 |
| 451 | 2024-07-26 05:29:46 | johnson | 4 | 151207 | 489 | 20.500 | 7376.0 |
| 450 | 2024-07-25 07:16:48 | johnson | 4 | 151207 | 489 | 42.346 | 3570.8 |
| 449 | 2024-07-22 08:30:34 | johnson | 1 | 69583 | 2 | 4.283 | 16246.3 |