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 |
| 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 |
| 551 | 2023-12-08 02:04:37 | firearm | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 550 | 2023-12-01 21:32:06 | firearm | 2 | 107671 | 11 | 2.796 | 38508.9 |
| 549 | 2023-11-22 05:53:29 | firearm | 3 | 134027 | 141 | 6.486 | 20664.0 |
| 548 | 2023-11-13 21:11:23 | firearm | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 547 | 2023-11-12 00:14:13 | firearm | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 546 | 2023-11-11 08:46:28 | firearm | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 545 | 2023-11-06 03:25:21 | firearm | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 544 | 2023-11-04 13:07:00 | firearm | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 543 | 2023-11-01 06:49:56 | firearm | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 542 | 2023-10-16 13:55:47 | firearm | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 541 | 2023-09-25 03:15:37 | firearm | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 540 | 2023-08-30 20:03:27 | firearm | 2 | 107671 | 11 | 2.720 | 39584.9 |
| 539 | 2023-08-23 00:16:05 | firearm | 3 | 134027 | 141 | 5.703 | 23501.1 |
| 538 | 2023-08-01 01:00:21 | firearm | 3 | 134027 | 141 | 9.843 | 13616.5 |
| 537 | 2023-07-26 21:12:19 | firearm | 3 | 134027 | 141 | 6.796 | 19721.5 |
| 536 | 2023-07-21 11:17:55 | firearm | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 535 | 2023-07-12 16:20:48 | firearm | 1 | 69583 | 3 | 1.033 | 67360.1 |
| 534 | 2023-05-18 23:36:57 | firearm | 2 | 107671 | 11 | 2.750 | 39153.1 |
| 533 | 2023-05-08 09:59:03 | firearm | 3 | 134027 | 141 | 5.640 | 23763.7 |
| 532 | 2023-04-21 11:39:21 | firearm | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 531 | 2023-04-01 08:54:54 | firearm | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 530 | 2023-02-26 13:16:58 | firearm | 2 | 107671 | 11 | 2.736 | 39353.4 |
| 529 | 2023-02-26 08:38:27 | firearm | 3 | 134027 | 141 | 7.216 | 18573.6 |
| 528 | 2023-02-15 22:22:54 | firearm | 3 | 134027 | 141 | 6.096 | 21986.1 |
| 527 | 2023-02-12 03:51:07 | firearm | 1 | 69583 | 3 | 1.890 | 36816.4 |
| 526 | 2022-12-16 13:31:51 | firearm | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 525 | 2022-12-09 10:12:43 | firearm | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 524 | 2022-12-08 09:50:32 | firearm | 2 | 107671 | 11 | 3.846 | 27995.6 |
| 523 | 2022-11-28 03:56:39 | firearm | 3 | 134027 | 141 | 5.640 | 23763.7 |
| 522 | 2022-11-03 10:13:27 | firearm | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 521 | 2022-08-16 09:25:16 | firearm | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 520 | 2022-08-10 11:31:19 | firearm | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 519 | 2022-07-21 18:20:13 | firearm | 2 | 107671 | 11 | 2.826 | 38100.1 |
| 518 | 2022-07-01 06:47:40 | firearm | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 517 | 2022-06-17 17:40:37 | firearm | 3 | 134027 | 141 | 5.906 | 22693.4 |
| 516 | 2022-06-14 00:37:26 | firearm | 3 | 134027 | 141 | 6.406 | 20922.1 |
| 515 | 2022-05-01 19:23:58 | firearm | 3 | 134027 | 141 | 6.530 | 20524.8 |
| 514 | 2022-05-01 06:18:33 | firearm | 3 | 134027 | 141 | 6.686 | 20045.9 |
| 513 | 2022-04-30 17:11:28 | firearm | 3 | 134027 | 141 | 5.733 | 23378.2 |
| 512 | 2022-04-30 04:10:54 | firearm | 3 | 134027 | 141 | 5.936 | 22578.7 |
| 511 | 2022-04-29 14:56:58 | firearm | 3 | 134027 | 141 | 6.453 | 20769.7 |
| 510 | 2022-04-29 03:08:32 | firearm | 3 | 134027 | 141 | 7.080 | 18930.4 |
| 509 | 2022-04-28 17:17:54 | firearm | 3 | 134027 | 141 | 11.046 | 12133.5 |
| 508 | 2022-04-28 05:52:30 | firearm | 3 | 134027 | 141 | 5.796 | 23124.1 |
| 507 | 2022-04-27 14:30:32 | firearm | 3 | 134027 | 141 | 6.563 | 20421.6 |
| 506 | 2022-04-27 01:14:16 | firearm | 3 | 134027 | 141 | 6.360 | 21073.4 |
| 505 | 2022-04-26 11:10:36 | firearm | 3 | 134027 | 141 | 7.250 | 18486.5 |
| 504 | 2022-04-25 19:04:44 | firearm | 3 | 134027 | 141 | 6.563 | 20421.6 |
| 503 | 2022-04-25 08:01:11 | firearm | 3 | 134027 | 141 | 5.763 | 23256.5 |
| 502 | 2022-04-24 19:44:40 | firearm | 3 | 134027 | 141 | 6.546 | 20474.6 |
| 501 | 2022-04-24 15:53:45 | firearm | 3 | 134027 | 141 | 6.220 | 21547.7 |
| 500 | 2022-04-23 17:22:30 | firearm | 3 | 134027 | 141 | 6.110 | 21935.7 |
| 499 | 2022-04-22 22:10:01 | firearm | 3 | 134027 | 141 | 7.796 | 17191.8 |
| 498 | 2022-04-22 03:49:38 | firearm | 3 | 134027 | 141 | 7.580 | 17681.7 |
| 497 | 2022-04-21 13:42:35 | firearm | 3 | 134027 | 141 | 7.283 | 18402.7 |
| 496 | 2022-04-20 08:20:09 | firearm | 3 | 134027 | 141 | 7.076 | 18941.1 |
| 495 | 2022-04-19 19:30:11 | firearm | 3 | 134027 | 141 | 7.173 | 18684.9 |
| 494 | 2022-04-19 05:58:38 | firearm | 3 | 134027 | 141 | 5.656 | 23696.4 |
| 493 | 2022-04-18 17:47:28 | firearm | 3 | 134027 | 141 | 6.033 | 22215.6 |
| 492 | 2022-04-17 23:25:00 | firearm | 3 | 134027 | 141 | 5.843 | 22938.0 |
| 491 | 2022-04-17 09:57:23 | firearm | 3 | 134027 | 141 | 5.876 | 22809.2 |
| 490 | 2022-04-16 14:40:53 | firearm | 3 | 134027 | 141 | 5.626 | 23822.8 |
| 489 | 2022-04-15 22:26:12 | firearm | 3 | 134027 | 141 | 5.813 | 23056.4 |
| 488 | 2022-04-14 23:05:08 | firearm | 3 | 134027 | 141 | 6.830 | 19623.3 |
| 487 | 2022-04-14 04:32:19 | firearm | 3 | 134027 | 141 | 6.610 | 20276.4 |
| 486 | 2022-04-13 23:51:54 | firearm | 3 | 134027 | 141 | 6.953 | 19276.1 |
| 485 | 2022-04-12 14:23:46 | firearm | 3 | 134027 | 141 | 6.986 | 19185.1 |
| 484 | 2022-04-12 06:45:42 | firearm | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 483 | 2022-04-12 01:57:35 | firearm | 3 | 134027 | 141 | 5.983 | 22401.3 |
| 482 | 2022-04-11 18:48:35 | firearm | 3 | 134027 | 141 | 6.610 | 20276.4 |
| 481 | 2022-04-11 05:33:37 | firearm | 3 | 134027 | 141 | 5.796 | 23124.1 |
| 480 | 2022-04-10 18:18:43 | firearm | 3 | 134027 | 141 | 5.923 | 22628.2 |
| 479 | 2022-04-10 00:20:51 | firearm | 3 | 134027 | 141 | 6.420 | 20876.5 |
| 478 | 2022-04-09 11:03:45 | firearm | 3 | 134027 | 141 | 5.703 | 23501.1 |
| 477 | 2022-04-01 22:02:53 | firearm | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 476 | 2022-03-25 15:15:07 | firearm | 3 | 134027 | 141 | 7.390 | 18136.3 |
| 475 | 2022-03-25 01:04:23 | firearm | 3 | 134027 | 141 | 6.000 | 22337.8 |
| 474 | 2022-03-24 09:54:30 | firearm | 3 | 134027 | 141 | 7.623 | 17581.9 |
| 473 | 2022-03-23 10:10:46 | firearm | 3 | 134027 | 141 | 7.500 | 17870.3 |
| 472 | 2022-03-22 23:38:54 | firearm | 3 | 134027 | 141 | 6.703 | 19995.1 |
| 471 | 2022-03-19 15:44:05 | firearm | 3 | 134027 | 141 | 5.610 | 23890.7 |
| 470 | 2022-03-18 20:23:02 | firearm | 3 | 134027 | 141 | 6.436 | 20824.6 |