History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"firearm"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 651 | 2025-10-24 17:58:38 | firearm | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 650 | 2025-10-23 21:14:29 | firearm | 1 | 69583 | 3 | 3.046 | 22844.1 |
| 649 | 2025-10-20 14:09:19 | firearm | 1 | 69583 | 3 | 1.393 | 49951.9 |
| 648 | 2025-09-26 11:45:34 | firearm | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 647 | 2025-09-18 15:33:37 | firearm | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 646 | 2025-08-22 05:44:16 | firearm | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 645 | 2025-08-17 16:07:34 | firearm | 1 | 69583 | 3 | 6.483 | 10733.1 |
| 644 | 2025-08-13 16:01:16 | firearm | 1 | 69583 | 3 | 8.470 | 8215.2 |
| 643 | 2025-08-12 10:00:52 | firearm | 1 | 69583 | 3 | 2.766 | 25156.5 |
| 642 | 2025-08-04 23:26:34 | firearm | 1 | 69583 | 3 | 3.623 | 19205.9 |
| 641 | 2025-07-27 07:46:57 | firearm | 1 | 69583 | 3 | 3.173 | 21929.7 |
| 640 | 2025-07-24 18:00:51 | firearm | 1 | 69583 | 3 | 4.953 | 14048.7 |
| 639 | 2025-07-23 03:58:15 | firearm | 1 | 69583 | 3 | 2.780 | 25029.9 |
| 638 | 2025-07-23 00:24:05 | firearm | 1 | 69583 | 3 | 2.826 | 24622.4 |
| 637 | 2025-07-20 23:35:58 | firearm | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 636 | 2025-07-19 06:31:47 | firearm | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 635 | 2025-07-14 13:38:45 | firearm | 1 | 69583 | 3 | 2.686 | 25905.8 |
| 634 | 2025-07-10 21:13:37 | firearm | 1 | 69583 | 3 | 8.376 | 8307.4 |
| 633 | 2025-07-10 20:05:48 | firearm | 1 | 69583 | 3 | 5.720 | 12164.9 |
| 632 | 2025-07-02 01:47:32 | firearm | 1 | 69583 | 3 | 5.836 | 11923.1 |
| 631 | 2025-06-26 07:02:32 | firearm | 1 | 69583 | 3 | 2.766 | 25156.5 |
| 630 | 2025-06-20 18:20:48 | firearm | 3 | 134027 | 141 | 32.986 | 4063.1 |
| 629 | 2025-06-20 15:55:16 | firearm | 1 | 69583 | 3 | 5.500 | 12651.5 |
| 628 | 2025-06-19 08:55:23 | firearm | 3 | 134027 | 141 | 12.126 | 11052.9 |
| 627 | 2025-06-18 23:14:07 | firearm | 3 | 134027 | 141 | 6.233 | 21502.8 |
| 626 | 2025-06-14 06:51:07 | firearm | 3 | 134027 | 141 | 28.236 | 4746.7 |
| 625 | 2025-06-13 11:11:10 | firearm | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 624 | 2025-06-08 15:07:10 | firearm | 1 | 69583 | 3 | 3.390 | 20526.0 |
| 623 | 2025-06-05 11:22:12 | firearm | 1 | 69583 | 3 | 4.093 | 17000.5 |
| 622 | 2025-05-29 00:48:56 | firearm | 1 | 69583 | 3 | 5.220 | 13330.1 |
| 621 | 2025-05-26 07:17:20 | firearm | 1 | 69583 | 3 | 5.530 | 12582.8 |
| 620 | 2025-05-18 12:59:02 | firearm | 1 | 69583 | 3 | 6.093 | 11420.2 |
| 619 | 2025-05-16 10:37:13 | firearm | 1 | 69583 | 3 | 6.080 | 11444.6 |
| 618 | 2025-05-04 14:30:53 | firearm | 1 | 69583 | 3 | 7.873 | 8838.2 |
| 617 | 2025-04-28 01:10:31 | firearm | 1 | 69583 | 3 | 5.330 | 13055.0 |
| 616 | 2025-04-25 06:06:53 | firearm | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 615 | 2025-04-09 10:04:48 | firearm | 1 | 69583 | 3 | 3.343 | 20814.5 |
| 614 | 2025-04-03 09:56:00 | firearm | 1 | 69583 | 3 | 2.860 | 24329.7 |
| 613 | 2025-04-02 11:28:51 | firearm | 1 | 69583 | 3 | 7.486 | 9295.1 |
| 612 | 2025-03-31 16:45:42 | firearm | 1 | 69583 | 3 | 2.533 | 27470.6 |
| 611 | 2025-03-23 07:45:15 | firearm | 1 | 69583 | 3 | 2.766 | 25156.5 |
| 610 | 2025-03-23 01:02:10 | firearm | 1 | 69583 | 3 | 11.110 | 6263.1 |
| 609 | 2025-03-20 12:50:00 | firearm | 1 | 69583 | 3 | 5.546 | 12546.5 |
| 608 | 2025-03-05 08:10:08 | firearm | 1 | 69583 | 3 | 3.326 | 20920.9 |
| 607 | 2025-02-24 17:08:27 | firearm | 1 | 69583 | 3 | 2.810 | 24762.6 |
| 606 | 2025-02-13 12:33:05 | firearm | 1 | 69583 | 3 | 8.336 | 8347.3 |
| 605 | 2025-02-08 15:59:32 | firearm | 1 | 69583 | 3 | 5.390 | 12909.6 |
| 604 | 2025-02-05 07:09:38 | firearm | 1 | 69583 | 3 | 3.046 | 22844.1 |
| 603 | 2025-01-12 17:53:29 | firearm | 1 | 69583 | 3 | 8.326 | 8357.3 |
| 602 | 2024-12-16 15:50:25 | firearm | 2 | 107671 | 11 | 3.406 | 31612.2 |
| 601 | 2024-12-15 16:55:51 | firearm | 3 | 134027 | 141 | 25.610 | 5233.4 |
| 600 | 2024-12-11 20:58:53 | firearm | 3 | 134027 | 141 | 20.046 | 6686.0 |
| 599 | 2024-12-10 18:45:47 | firearm | 3 | 134027 | 141 | 32.456 | 4129.5 |
| 598 | 2024-12-10 18:26:10 | firearm | 3 | 134027 | 141 | 36.893 | 3632.9 |
| 597 | 2024-12-10 18:26:11 | firearm | 2 | 107671 | 11 | 9.720 | 11077.3 |
| 596 | 2024-12-10 18:23:22 | firearm | 1 | 69583 | 3 | 2.953 | 23563.5 |
| 595 | 2024-11-03 13:13:01 | firearm | 1 | 69583 | 3 | 5.796 | 12005.3 |
| 594 | 2024-11-01 04:56:37 | firearm | 1 | 69583 | 3 | 5.750 | 12101.4 |
| 593 | 2024-09-29 19:37:05 | firearm | 1 | 69583 | 3 | 13.626 | 5106.6 |
| 592 | 2024-09-25 18:37:08 | firearm | 1 | 69583 | 3 | 8.843 | 7868.7 |
| 591 | 2024-09-21 23:34:46 | firearm | 1 | 69583 | 3 | 14.186 | 4905.0 |
| 590 | 2024-09-08 17:39:06 | firearm | 1 | 69583 | 3 | 5.656 | 12302.5 |
| 589 | 2024-08-26 12:48:41 | firearm | 1 | 69583 | 3 | 16.190 | 4297.9 |
| 588 | 2024-08-25 22:58:31 | firearm | 1 | 69583 | 3 | 9.393 | 7408.0 |
| 587 | 2024-08-12 15:01:59 | firearm | 1 | 69583 | 3 | 9.670 | 7195.8 |
| 586 | 2024-07-31 05:01:18 | firearm | 1 | 69583 | 3 | 2.343 | 29698.3 |
| 585 | 2024-07-30 21:46:24 | firearm | 1 | 69583 | 3 | 1.406 | 49490.0 |
| 584 | 2024-07-25 14:23:51 | firearm | 1 | 69583 | 3 | 6.750 | 10308.6 |
| 583 | 2024-07-20 19:11:35 | firearm | 2 | 107671 | 11 | 3.530 | 30501.7 |
| 582 | 2024-07-20 19:11:20 | firearm | 3 | 134027 | 141 | 9.076 | 14767.2 |
| 581 | 2024-07-20 13:41:41 | firearm | 3 | 134027 | 141 | 38.456 | 3485.2 |
| 580 | 2024-07-20 13:19:17 | firearm | 2 | 107671 | 11 | 8.720 | 12347.6 |
| 579 | 2024-07-20 13:18:15 | firearm | 3 | 134027 | 141 | 29.563 | 4533.6 |
| 578 | 2024-07-20 13:18:05 | firearm | 1 | 69583 | 3 | 3.686 | 18877.6 |
| 577 | 2024-07-07 11:29:20 | firearm | 1 | 69583 | 3 | 4.220 | 16488.9 |
| 576 | 2024-07-07 11:05:08 | firearm | 1 | 69583 | 3 | 2.266 | 30707.4 |
| 575 | 2024-07-02 01:01:11 | firearm | 1 | 69583 | 3 | 3.750 | 18555.5 |
| 574 | 2024-06-30 15:32:57 | firearm | 1 | 69583 | 3 | 2.000 | 34791.5 |
| 573 | 2024-06-22 11:10:59 | firearm | 1 | 69583 | 3 | 4.626 | 15041.7 |
| 572 | 2024-06-14 21:29:38 | firearm | 1 | 69583 | 3 | 3.500 | 19880.9 |
| 571 | 2024-06-09 05:50:00 | firearm | 1 | 69583 | 3 | 4.346 | 16010.8 |
| 570 | 2024-05-12 15:34:28 | firearm | 1 | 69583 | 3 | 1.453 | 47889.2 |
| 569 | 2024-04-07 14:17:19 | firearm | 1 | 69583 | 3 | 4.140 | 16807.5 |
| 568 | 2024-03-29 09:12:54 | firearm | 1 | 69583 | 3 | 3.080 | 22591.9 |
| 567 | 2024-03-27 03:53:18 | firearm | 2 | 107671 | 11 | 2.783 | 38688.8 |
| 566 | 2024-03-04 02:56:00 | firearm | 1 | 69583 | 3 | 1.326 | 52475.9 |
| 565 | 2024-03-01 19:52:58 | firearm | 1 | 69583 | 3 | 3.000 | 23194.3 |
| 564 | 2024-03-01 07:46:49 | firearm | 3 | 134027 | 141 | 6.640 | 20184.8 |
| 563 | 2024-02-29 22:58:20 | firearm | 2 | 107671 | 11 | 5.190 | 20745.9 |
| 562 | 2024-02-29 22:58:05 | firearm | 3 | 134027 | 141 | 8.906 | 15049.1 |
| 561 | 2024-02-28 14:54:09 | firearm | 3 | 134027 | 141 | 13.766 | 9736.1 |
| 560 | 2024-02-28 08:51:48 | firearm | 3 | 134027 | 141 | 21.780 | 6153.7 |
| 559 | 2024-02-28 08:51:45 | firearm | 2 | 107671 | 11 | 3.750 | 28712.3 |
| 558 | 2024-02-28 06:56:06 | firearm | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 557 | 2024-01-14 22:07:48 | firearm | 3 | 134027 | 141 | 6.296 | 21287.6 |
| 556 | 2023-12-28 21:37:10 | firearm | 3 | 134027 | 141 | 6.660 | 20124.2 |
| 555 | 2023-12-28 21:37:09 | firearm | 2 | 107671 | 11 | 3.376 | 31893.1 |
| 554 | 2023-12-14 03:53:46 | firearm | 3 | 134027 | 141 | 6.013 | 22289.5 |
| 553 | 2023-12-14 03:53:42 | firearm | 2 | 107671 | 11 | 2.890 | 37256.4 |
| 552 | 2023-12-11 14:26:16 | firearm | 1 | 69583 | 3 | 1.030 | 67556.3 |