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 |
| 593 | 2026-04-04 17:31:08 | johnson | 4 | 151207 | 489 | 47.973 | 3151.9 |
| 592 | 2026-04-04 14:43:50 | johnson | 4 | 151207 | 489 | 50.363 | 3002.3 |
| 591 | 2026-04-03 14:14:03 | johnson | 4 | 151207 | 489 | 68.110 | 2220.0 |
| 590 | 2026-04-03 03:34:06 | johnson | 1 | 69583 | 2 | 2.873 | 24219.6 |
| 589 | 2026-04-03 02:13:31 | johnson | 1 | 69583 | 2 | 5.436 | 12800.4 |
| 588 | 2026-03-31 10:28:24 | johnson | 4 | 151207 | 489 | 53.990 | 2800.6 |
| 587 | 2026-03-29 00:49:39 | johnson | 4 | 151207 | 489 | 89.786 | 1684.1 |
| 586 | 2026-03-26 15:58:57 | johnson | 4 | 151207 | 489 | 47.203 | 3203.3 |
| 585 | 2026-03-23 21:53:36 | johnson | 1 | 69583 | 2 | 5.873 | 11847.9 |
| 584 | 2026-03-22 14:19:47 | johnson | 1 | 69583 | 2 | 8.173 | 8513.8 |
| 583 | 2026-03-20 11:14:19 | johnson | 4 | 151207 | 489 | 20.253 | 7465.9 |
| 582 | 2026-03-16 00:27:58 | johnson | 4 | 151207 | 489 | 13.003 | 11628.6 |
| 581 | 2026-03-10 20:28:49 | johnson | 1 | 69583 | 2 | 5.110 | 13617.0 |
| 580 | 2026-03-10 02:21:39 | johnson | 1 | 69583 | 2 | 1.250 | 55666.4 |
| 579 | 2026-03-10 01:58:08 | johnson | 1 | 69583 | 2 | 1.126 | 61796.6 |
| 578 | 2026-03-10 01:06:26 | johnson | 1 | 69583 | 2 | 2.046 | 34009.3 |
| 577 | 2026-03-06 12:23:46 | johnson | 4 | 151207 | 489 | 11.593 | 13043.0 |
| 576 | 2026-03-05 23:09:16 | johnson | 3 | 134027 | 33 | 6.186 | 21666.2 |
| 575 | 2026-03-04 20:03:35 | johnson | 4 | 151207 | 489 | 10.033 | 15071.0 |
| 574 | 2026-03-04 17:00:15 | johnson | 4 | 151207 | 489 | 10.843 | 13945.1 |
| 573 | 2026-03-01 12:17:53 | johnson | 4 | 151207 | 489 | 10.420 | 14511.2 |
| 572 | 2026-03-01 10:17:55 | johnson | 3 | 134027 | 33 | 10.143 | 13213.7 |
| 571 | 2026-03-01 07:37:26 | johnson | 4 | 151207 | 489 | 9.846 | 15357.2 |
| 570 | 2026-02-27 20:40:24 | johnson | 4 | 151207 | 489 | 55.800 | 2709.8 |
| 569 | 2026-02-23 08:43:07 | johnson | 3 | 134027 | 33 | 6.720 | 19944.5 |
| 568 | 2026-02-20 07:08:33 | johnson | 4 | 151207 | 489 | 51.033 | 2962.9 |
| 567 | 2026-02-15 18:52:44 | johnson | 1 | 69583 | 2 | 1.250 | 55666.4 |
| 566 | 2026-02-15 00:54:42 | johnson | 1 | 69583 | 2 | 1.216 | 57222.9 |
| 565 | 2026-02-14 16:58:15 | johnson | 3 | 134027 | 33 | 9.376 | 14294.7 |
| 564 | 2026-02-09 03:50:14 | johnson | 1 | 69583 | 2 | 2.373 | 29322.8 |
| 563 | 2026-01-31 13:13:59 | johnson | 1 | 69583 | 2 | 1.186 | 58670.3 |
| 562 | 2026-01-30 12:25:03 | johnson | 1 | 69583 | 2 | 1.266 | 54962.9 |
| 561 | 2026-01-30 12:24:51 | johnson | 1 | 69583 | 2 | 1.280 | 54361.7 |
| 560 | 2026-01-24 05:47:25 | johnson | 1 | 69583 | 2 | 4.856 | 14329.3 |
| 559 | 2026-01-24 05:45:11 | johnson | 1 | 69583 | 2 | 1.250 | 55666.4 |
| 558 | 2026-01-23 08:07:38 | johnson | 1 | 69583 | 2 | 1.173 | 59320.5 |
| 557 | 2026-01-23 06:20:20 | johnson | 1 | 69583 | 2 | 2.453 | 28366.5 |
| 556 | 2026-01-10 06:43:33 | johnson | 1 | 69583 | 2 | 1.220 | 57035.2 |
| 555 | 2025-12-25 18:04:00 | johnson | 1 | 69583 | 2 | 1.456 | 47790.5 |
| 554 | 2025-12-11 20:06:25 | johnson | 1 | 69583 | 2 | 5.373 | 12950.5 |
| 553 | 2025-12-09 20:16:17 | johnson | 1 | 69583 | 2 | 1.063 | 65459.1 |
| 552 | 2025-12-05 08:57:45 | johnson | 1 | 69583 | 2 | 1.173 | 59320.5 |
| 551 | 2025-11-29 15:23:41 | johnson | 1 | 69583 | 2 | 1.203 | 57841.2 |
| 550 | 2025-11-29 08:44:10 | johnson | 4 | 151207 | 489 | 11.643 | 12986.9 |
| 549 | 2025-11-28 18:23:03 | johnson | 1 | 69583 | 2 | 1.186 | 58670.3 |
| 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 |