History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"passerby"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 594 | 2025-10-21 07:10:54 | passerby | 1 | 82945 | 2 | 10.596 | 7828.0 |
| 593 | 2025-10-21 07:10:28 | passerby | 1 | 82945 | 2 | 8.970 | 9246.9 |
| 592 | 2025-10-21 07:09:56 | passerby | 1 | 82945 | 2 | 5.670 | 14628.7 |
| 591 | 2025-10-21 07:09:36 | passerby | 1 | 82945 | 2 | 7.483 | 11084.5 |
| 590 | 2025-09-22 13:10:43 | passerby | 3 | 146162 | 41 | 7.236 | 20199.3 |
| 589 | 2025-09-08 01:49:57 | passerby | 1 | 82945 | 2 | 1.436 | 57761.1 |
| 588 | 2025-08-23 00:49:05 | passerby | 1 | 82945 | 2 | 11.030 | 7519.9 |
| 587 | 2025-08-09 12:43:04 | passerby | 1 | 82945 | 2 | 6.690 | 12398.4 |
| 586 | 2025-08-06 06:48:52 | passerby | 3 | 146162 | 41 | 21.376 | 6837.7 |
| 585 | 2025-08-03 23:59:48 | passerby | 1 | 82945 | 2 | 5.046 | 16437.8 |
| 584 | 2025-07-29 02:47:10 | passerby | 2 | 121059 | 4 | 20.123 | 6016.0 |
| 583 | 2025-07-29 01:48:30 | passerby | 3 | 146162 | 41 | 26.483 | 5519.1 |
| 582 | 2025-07-25 20:52:55 | passerby | 1 | 82945 | 2 | 4.110 | 20181.3 |
| 581 | 2025-07-23 22:15:41 | passerby | 1 | 82945 | 2 | 6.470 | 12819.9 |
| 580 | 2025-07-19 07:28:36 | passerby | 1 | 82945 | 2 | 1.296 | 64000.8 |
| 579 | 2025-07-17 09:35:48 | passerby | 1 | 82945 | 2 | 5.170 | 16043.5 |
| 578 | 2025-07-10 16:07:54 | passerby | 1 | 82945 | 2 | 6.080 | 13642.3 |
| 577 | 2025-07-05 01:22:41 | passerby | 3 | 146162 | 41 | 38.440 | 3802.3 |
| 576 | 2025-07-05 01:13:55 | passerby | 2 | 121059 | 4 | 23.160 | 5227.1 |
| 575 | 2025-07-04 12:21:05 | passerby | 1 | 82945 | 2 | 4.266 | 19443.3 |
| 574 | 2025-07-04 04:48:33 | passerby | 3 | 146162 | 41 | 33.953 | 4304.8 |
| 573 | 2025-07-02 20:04:21 | passerby | 3 | 146162 | 41 | 25.923 | 5638.3 |
| 572 | 2025-06-29 21:06:59 | passerby | 1 | 82945 | 2 | 11.000 | 7540.5 |
| 571 | 2025-06-25 03:25:48 | passerby | 3 | 146162 | 41 | 32.720 | 4467.1 |
| 570 | 2025-06-22 09:53:15 | passerby | 3 | 146162 | 41 | 34.800 | 4200.1 |
| 569 | 2025-06-20 18:35:22 | passerby | 2 | 121059 | 4 | 12.970 | 9333.8 |
| 568 | 2025-06-19 07:54:20 | passerby | 3 | 146162 | 41 | 7.076 | 20656.0 |
| 567 | 2025-06-19 02:17:43 | passerby | 3 | 146162 | 41 | 7.656 | 19091.2 |
| 566 | 2025-06-14 06:11:33 | passerby | 3 | 146162 | 41 | 53.643 | 2724.7 |
| 565 | 2025-06-12 17:59:04 | passerby | 3 | 146162 | 41 | 9.890 | 14778.8 |
| 564 | 2025-06-12 14:49:06 | passerby | 2 | 121059 | 4 | 23.473 | 5157.4 |
| 563 | 2025-06-12 02:40:31 | passerby | 3 | 146162 | 41 | 25.280 | 5781.7 |
| 562 | 2025-06-12 00:08:58 | passerby | 1 | 82945 | 2 | 6.563 | 12638.3 |
| 561 | 2025-06-10 19:29:23 | passerby | 1 | 82945 | 2 | 5.093 | 16286.1 |
| 560 | 2025-06-09 21:56:39 | passerby | 2 | 121059 | 4 | 20.973 | 5772.1 |
| 559 | 2025-06-09 13:50:53 | passerby | 1 | 82945 | 2 | 1.516 | 54713.1 |
| 558 | 2025-06-05 04:22:07 | passerby | 3 | 146162 | 41 | 40.486 | 3610.2 |
| 557 | 2025-06-03 04:14:17 | passerby | 3 | 146162 | 41 | 32.736 | 4464.9 |
| 556 | 2025-06-01 07:33:59 | passerby | 3 | 146162 | 41 | 6.516 | 22431.2 |
| 555 | 2025-05-29 00:19:30 | passerby | 1 | 82945 | 2 | 4.016 | 20653.6 |
| 554 | 2025-05-25 05:12:40 | passerby | 3 | 146162 | 41 | 8.970 | 16294.5 |
| 553 | 2025-05-19 21:32:27 | passerby | 2 | 121059 | 4 | 14.376 | 8420.9 |
| 552 | 2025-05-19 20:46:22 | passerby | 3 | 146162 | 41 | 36.316 | 4024.7 |
| 551 | 2025-05-18 20:28:33 | passerby | 1 | 82945 | 2 | 1.530 | 54212.4 |
| 550 | 2025-05-18 10:12:03 | passerby | 3 | 146162 | 41 | 30.580 | 4779.7 |
| 549 | 2025-05-16 14:29:50 | passerby | 2 | 121059 | 4 | 12.783 | 9470.3 |
| 548 | 2025-05-15 02:05:57 | passerby | 3 | 146162 | 41 | 7.516 | 19446.8 |
| 547 | 2025-05-12 05:41:11 | passerby | 3 | 146162 | 41 | 45.613 | 3204.4 |
| 546 | 2025-05-10 16:18:42 | passerby | 2 | 121059 | 4 | 13.486 | 8976.6 |
| 545 | 2025-05-10 05:53:01 | passerby | 3 | 146162 | 41 | 40.020 | 3652.2 |
| 544 | 2025-05-08 19:53:41 | passerby | 1 | 82945 | 2 | 6.983 | 11878.1 |
| 543 | 2025-04-30 11:43:29 | passerby | 1 | 82945 | 2 | 10.873 | 7628.5 |
| 542 | 2025-04-18 13:15:12 | passerby | 1 | 82945 | 2 | 3.546 | 23391.1 |
| 541 | 2025-03-29 14:36:32 | passerby | 1 | 82945 | 2 | 3.770 | 22001.3 |
| 540 | 2025-03-26 19:42:16 | passerby | 2 | 121059 | 4 | 3.796 | 31891.2 |
| 539 | 2025-03-26 13:48:02 | passerby | 3 | 146162 | 41 | 47.346 | 3087.1 |
| 538 | 2025-03-23 11:47:36 | passerby | 3 | 146162 | 41 | 19.406 | 7531.8 |
| 537 | 2025-03-22 03:31:00 | passerby | 3 | 146162 | 41 | 44.860 | 3258.2 |
| 536 | 2025-03-21 20:22:34 | passerby | 1 | 82945 | 2 | 1.470 | 56425.2 |
| 535 | 2025-03-10 18:25:50 | passerby | 1 | 82945 | 2 | 10.110 | 8204.3 |
| 534 | 2025-03-07 00:02:02 | passerby | 1 | 82945 | 2 | 7.716 | 10749.7 |
| 533 | 2025-02-17 14:19:38 | passerby | 1 | 82945 | 2 | 5.810 | 14276.2 |
| 532 | 2025-02-03 23:48:09 | passerby | 3 | 146162 | 41 | 30.803 | 4745.1 |
| 531 | 2025-02-02 11:09:49 | passerby | 3 | 146162 | 41 | 53.270 | 2743.8 |
| 530 | 2025-02-02 11:09:41 | passerby | 2 | 121059 | 4 | 8.906 | 13593.0 |
| 529 | 2025-02-01 22:00:33 | passerby | 3 | 146162 | 41 | 46.693 | 3130.3 |
| 528 | 2025-02-01 21:59:55 | passerby | 3 | 146162 | 41 | 62.966 | 2321.3 |
| 527 | 2025-02-01 22:00:00 | passerby | 2 | 121059 | 4 | 13.503 | 8965.3 |
| 526 | 2025-02-01 21:59:44 | passerby | 1 | 82945 | 2 | 7.376 | 11245.3 |
| 525 | 2025-01-23 12:30:08 | passerby | 1 | 82945 | 2 | 7.936 | 10451.7 |
| 524 | 2025-01-19 16:16:50 | passerby | 1 | 82945 | 2 | 5.346 | 15515.3 |
| 523 | 2024-12-31 18:14:19 | passerby | 3 | 146162 | 41 | 36.206 | 4037.0 |
| 522 | 2024-12-31 18:13:50 | passerby | 3 | 146162 | 41 | 39.486 | 3701.6 |
| 521 | 2024-12-31 18:14:07 | passerby | 2 | 121059 | 4 | 18.953 | 6387.3 |
| 520 | 2024-12-28 16:35:17 | passerby | 1 | 82945 | 2 | 9.656 | 8590.0 |
| 519 | 2024-12-21 01:37:15 | passerby | 1 | 82945 | 2 | 3.670 | 22600.8 |
| 518 | 2024-12-19 15:37:22 | passerby | 1 | 82945 | 2 | 9.300 | 8918.8 |
| 517 | 2024-12-18 18:43:15 | passerby | 3 | 146162 | 41 | 46.096 | 3170.8 |
| 516 | 2024-12-18 18:43:15 | passerby | 2 | 121059 | 4 | 14.986 | 8078.1 |
| 515 | 2024-12-18 18:41:05 | passerby | 1 | 82945 | 2 | 4.813 | 17233.5 |
| 514 | 2024-12-12 10:15:48 | passerby | 3 | 146162 | 41 | 48.830 | 2993.3 |
| 513 | 2024-12-12 10:15:44 | passerby | 2 | 121059 | 4 | 27.940 | 4332.8 |
| 512 | 2024-11-22 11:50:21 | passerby | 3 | 146162 | 41 | 15.923 | 9179.3 |
| 511 | 2024-11-18 03:52:54 | passerby | 3 | 146162 | 41 | 35.190 | 4153.5 |
| 510 | 2024-11-16 14:39:23 | passerby | 1 | 82945 | 2 | 7.280 | 11393.5 |
| 509 | 2024-11-15 13:54:28 | passerby | 3 | 146162 | 41 | 36.500 | 4004.4 |
| 508 | 2024-11-15 13:54:20 | passerby | 3 | 146162 | 41 | 37.706 | 3876.4 |
| 507 | 2024-11-15 13:54:21 | passerby | 2 | 121059 | 4 | 19.176 | 6313.0 |
| 506 | 2024-11-15 13:54:18 | passerby | 1 | 82945 | 2 | 7.566 | 10962.9 |
| 505 | 2024-11-14 20:23:49 | passerby | 1 | 82945 | 2 | 5.563 | 14910.1 |
| 504 | 2024-10-30 01:32:34 | passerby | 1 | 82945 | 2 | 5.640 | 14706.6 |
| 503 | 2024-10-13 13:48:42 | passerby | 3 | 146162 | 41 | 31.986 | 4569.6 |
| 502 | 2024-10-13 07:12:52 | passerby | 3 | 146162 | 41 | 41.706 | 3504.6 |
| 501 | 2024-10-13 07:12:53 | passerby | 2 | 121059 | 4 | 19.173 | 6314.0 |
| 500 | 2024-10-13 07:11:24 | passerby | 1 | 82945 | 2 | 6.623 | 12523.8 |
| 499 | 2024-10-12 03:24:28 | passerby | 3 | 146162 | 41 | 26.860 | 5441.6 |
| 498 | 2024-10-11 21:19:06 | passerby | 3 | 146162 | 41 | 50.503 | 2894.1 |
| 497 | 2024-10-11 13:08:46 | passerby | 3 | 146162 | 41 | 33.673 | 4340.6 |
| 496 | 2024-10-10 19:27:00 | passerby | 4 | 161609 | 547 | 67.243 | 2403.4 |
| 495 | 2024-10-10 19:27:00 | passerby | 3 | 146162 | 41 | 46.553 | 3139.7 |