History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"knives"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
591 | 2024-04-23 01:11:11 | knives | 1 | 48755 | 3 | 0.793 | 61481.7 |
590 | 2024-04-18 21:57:42 | knives | 1 | 48755 | 3 | 0.736 | 66243.2 |
589 | 2024-04-12 20:52:04 | knives | 2 | 82551 | 54 | 3.716 | 22215.0 |
588 | 2024-04-12 20:51:28 | knives | 3 | 112716 | 813 | 5.486 | 20546.1 |
587 | 2024-04-11 20:28:02 | knives | 3 | 112716 | 813 | 8.156 | 13820.0 |
586 | 2024-04-11 20:23:57 | knives | 3 | 112716 | 813 | 17.406 | 6475.7 |
585 | 2024-04-11 11:24:54 | knives | 2 | 82551 | 54 | 3.763 | 21937.5 |
584 | 2024-04-11 11:23:23 | knives | 3 | 112716 | 813 | 5.986 | 18829.9 |
583 | 2024-04-10 09:13:05 | knives | 3 | 112716 | 813 | 13.376 | 8426.7 |
582 | 2024-04-08 22:09:45 | knives | 3 | 112716 | 813 | 14.470 | 7789.6 |
581 | 2024-04-08 22:09:54 | knives | 1 | 48755 | 3 | 1.780 | 27390.4 |
580 | 2024-04-08 22:09:44 | knives | 2 | 82551 | 54 | 6.000 | 13758.5 |
579 | 2024-04-03 10:32:45 | knives | 1 | 48755 | 3 | 1.826 | 26700.4 |
578 | 2024-04-01 09:58:52 | knives | 1 | 48755 | 3 | 1.093 | 44606.6 |
577 | 2024-03-08 22:57:36 | knives | 3 | 112716 | 813 | 6.170 | 18268.4 |
576 | 2024-03-08 22:57:38 | knives | 2 | 82551 | 54 | 2.703 | 30540.5 |
575 | 2024-03-06 03:26:25 | knives | 2 | 82551 | 54 | 2.656 | 31080.9 |
574 | 2024-03-05 19:45:49 | knives | 2 | 82551 | 54 | 4.436 | 18609.3 |
573 | 2024-03-05 19:44:47 | knives | 3 | 112716 | 813 | 5.110 | 22057.9 |
572 | 2024-03-05 18:15:34 | knives | 3 | 112716 | 813 | 15.266 | 7383.5 |
571 | 2024-03-05 16:32:26 | knives | 2 | 82551 | 54 | 2.656 | 31080.9 |
570 | 2024-03-05 16:32:00 | knives | 3 | 112716 | 813 | 5.813 | 19390.3 |
569 | 2024-03-04 08:35:46 | knives | 3 | 112716 | 813 | 5.296 | 21283.2 |
568 | 2024-03-04 08:35:47 | knives | 2 | 82551 | 54 | 2.423 | 34069.7 |
567 | 2024-03-04 08:35:46 | knives | 1 | 48755 | 3 | 0.890 | 54780.9 |
566 | 2024-03-02 05:26:10 | knives | 2 | 82551 | 54 | 5.360 | 15401.3 |
565 | 2024-03-02 05:26:04 | knives | 1 | 48755 | 3 | 2.670 | 18260.3 |
564 | 2024-02-07 17:55:01 | knives | 3 | 112716 | 813 | 17.033 | 6617.5 |
563 | 2024-02-07 13:54:53 | knives | 3 | 112716 | 813 | 5.986 | 18829.9 |
562 | 2024-02-07 13:54:45 | knives | 2 | 82551 | 54 | 2.656 | 31080.9 |
561 | 2024-01-29 13:58:12 | knives | 1 | 48755 | 3 | 0.796 | 61250.0 |
560 | 2024-01-27 05:32:13 | knives | 1 | 48755 | 3 | 0.813 | 59969.2 |
559 | 2023-12-24 08:42:33 | knives | 3 | 112716 | 813 | 5.390 | 20912.1 |
558 | 2023-12-22 14:01:33 | knives | 3 | 112716 | 813 | 4.686 | 24053.8 |
557 | 2023-12-16 20:30:48 | knives | 3 | 112716 | 813 | 5.813 | 19390.3 |
556 | 2023-12-08 17:29:11 | knives | 3 | 112716 | 813 | 5.016 | 22471.3 |
555 | 2023-12-08 17:29:13 | knives | 2 | 82551 | 54 | 2.266 | 36430.3 |
554 | 2023-12-07 18:24:21 | knives | 1 | 48755 | 3 | 0.720 | 67715.3 |
553 | 2023-12-07 18:24:20 | knives | 1 | 48755 | 3 | 0.720 | 67715.3 |
552 | 2023-11-28 18:33:34 | knives | 3 | 112716 | 813 | 4.546 | 24794.5 |
551 | 2023-11-28 18:33:32 | knives | 2 | 82551 | 54 | 2.016 | 40947.9 |
550 | 2023-11-24 01:45:38 | knives | 3 | 112716 | 813 | 4.703 | 23966.8 |
549 | 2023-11-24 01:45:39 | knives | 2 | 82551 | 54 | 2.343 | 35233.0 |
548 | 2023-11-24 01:39:47 | knives | 1 | 48755 | 3 | 0.796 | 61250.0 |
547 | 2023-11-18 22:59:53 | knives | 1 | 48755 | 3 | 0.700 | 69650.0 |
546 | 2023-11-11 23:02:41 | knives | 2 | 82551 | 54 | 2.640 | 31269.3 |
545 | 2023-11-11 23:02:37 | knives | 3 | 112716 | 813 | 5.266 | 21404.5 |
544 | 2023-11-11 00:19:07 | knives | 1 | 48755 | 3 | 0.703 | 69352.8 |
543 | 2023-11-09 13:45:06 | knives | 1 | 48755 | 3 | 0.763 | 63899.1 |
542 | 2023-10-27 15:20:29 | knives | 1 | 48755 | 3 | 0.733 | 66514.3 |
541 | 2023-10-21 08:37:17 | knives | 1 | 48755 | 3 | 1.420 | 34334.5 |
540 | 2023-10-17 20:05:51 | knives | 1 | 48755 | 3 | 0.843 | 57835.1 |
539 | 2023-10-14 05:37:05 | knives | 1 | 48755 | 3 | 0.796 | 61250.0 |
538 | 2023-10-04 11:08:19 | knives | 1 | 48755 | 3 | 0.720 | 67715.3 |
537 | 2023-09-26 03:56:51 | knives | 3 | 112716 | 813 | 4.826 | 23356.0 |
536 | 2023-09-26 03:50:14 | knives | 2 | 82551 | 54 | 1.983 | 41629.3 |
535 | 2023-09-19 15:01:02 | knives | 1 | 48755 | 3 | 0.766 | 63648.8 |
534 | 2023-09-12 10:18:08 | knives | 1 | 48755 | 3 | 0.720 | 67715.3 |
533 | 2023-09-09 06:56:57 | knives | 1 | 48755 | 3 | 0.796 | 61250.0 |
532 | 2023-07-29 07:31:42 | knives | 1 | 48755 | 3 | 0.733 | 66514.3 |
531 | 2023-06-14 15:36:56 | knives | 1 | 48755 | 3 | 0.843 | 57835.1 |
530 | 2023-04-10 01:28:26 | knives | 1 | 48755 | 3 | 0.686 | 71071.4 |
529 | 2022-12-24 16:35:01 | knives | 1 | 48755 | 3 | 0.703 | 69352.8 |
528 | 2022-08-24 11:37:31 | knives | 1 | 48755 | 3 | 0.703 | 69352.8 |
527 | 2022-08-15 11:23:35 | knives | 1 | 48755 | 3 | 0.783 | 62266.9 |
526 | 2022-08-14 05:00:11 | knives | 1 | 48755 | 3 | 0.720 | 67715.3 |
525 | 2022-07-16 01:37:59 | knives | 2 | 82551 | 54 | 2.250 | 36689.3 |
524 | 2022-05-05 00:05:41 | knives | 1 | 48755 | 3 | 0.720 | 67715.3 |
523 | 2022-05-02 20:08:13 | knives | 1 | 48755 | 3 | 0.750 | 65006.7 |
522 | 2022-04-20 07:14:55 | knives | 1 | 48755 | 3 | 0.716 | 68093.6 |
521 | 2022-04-16 21:49:04 | knives | 1 | 48755 | 3 | 0.796 | 61250.0 |
520 | 2022-02-06 01:26:28 | knives | 1 | 48755 | 3 | 0.796 | 61250.0 |
519 | 2021-12-25 18:05:10 | knives | 1 | 48755 | 3 | 0.733 | 66514.3 |
518 | 2021-11-01 12:03:11 | knives | 2 | 82551 | 54 | 2.126 | 38829.3 |
517 | 2021-10-31 15:49:06 | knives | 2 | 82551 | 54 | 2.033 | 40605.5 |
516 | 2021-10-26 08:55:50 | knives | 2 | 82551 | 54 | 2.050 | 40268.8 |
515 | 2021-10-25 15:08:44 | knives | 2 | 82551 | 54 | 2.326 | 35490.5 |
514 | 2021-10-25 06:29:34 | knives | 2 | 82551 | 54 | 2.063 | 40015.0 |
513 | 2021-10-24 20:42:26 | knives | 2 | 82551 | 54 | 2.423 | 34069.7 |
512 | 2021-10-24 08:59:20 | knives | 2 | 82551 | 54 | 2.233 | 36968.7 |
511 | 2021-10-24 01:08:16 | knives | 2 | 82551 | 54 | 2.390 | 34540.2 |
510 | 2021-10-23 14:01:58 | knives | 2 | 82551 | 54 | 2.423 | 34069.7 |
509 | 2021-10-23 02:49:47 | knives | 2 | 82551 | 54 | 2.250 | 36689.3 |
508 | 2021-10-22 18:20:39 | knives | 2 | 82551 | 54 | 2.076 | 39764.5 |
507 | 2021-10-09 14:17:45 | knives | 2 | 82551 | 54 | 2.173 | 37989.4 |
506 | 2021-10-09 00:44:51 | knives | 2 | 82551 | 54 | 2.453 | 33653.1 |
505 | 2021-10-08 05:45:43 | knives | 2 | 82551 | 54 | 2.156 | 38289.0 |
504 | 2021-10-07 22:08:52 | knives | 2 | 82551 | 54 | 2.296 | 35954.3 |
503 | 2021-10-07 11:27:03 | knives | 2 | 82551 | 54 | 5.266 | 15676.2 |
502 | 2021-10-07 00:53:26 | knives | 2 | 82551 | 54 | 4.843 | 17045.4 |
501 | 2021-10-06 14:32:26 | knives | 2 | 82551 | 54 | 2.203 | 37472.1 |
500 | 2021-10-06 02:44:13 | knives | 2 | 82551 | 54 | 2.093 | 39441.5 |
499 | 2021-10-05 13:00:18 | knives | 2 | 82551 | 54 | 2.326 | 35490.5 |
498 | 2021-10-05 01:05:37 | knives | 2 | 82551 | 54 | 2.030 | 40665.5 |
497 | 2021-10-04 18:15:29 | knives | 2 | 82551 | 54 | 4.673 | 17665.5 |
496 | 2021-10-04 06:44:18 | knives | 2 | 82551 | 54 | 2.063 | 40015.0 |
495 | 2021-10-03 21:11:01 | knives | 2 | 82551 | 54 | 2.330 | 35429.6 |
494 | 2021-10-03 09:21:47 | knives | 2 | 82551 | 54 | 2.000 | 41275.5 |
493 | 2021-10-02 21:36:26 | knives | 2 | 82551 | 54 | 2.016 | 40947.9 |
492 | 2021-10-02 11:08:49 | knives | 2 | 82551 | 54 | 2.356 | 35038.6 |