History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"loch"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
604 | 2024-03-26 19:15:45 | loch | 1 | 13983 | 11 | 0.826 | 16928.6 |
603 | 2024-03-17 19:36:30 | loch | 1 | 13983 | 11 | 0.263 | 53167.3 |
602 | 2024-03-05 20:39:09 | loch | 1 | 13983 | 11 | 0.830 | 16847.0 |
601 | 2024-03-03 20:08:30 | loch | 1 | 13983 | 11 | 0.220 | 63559.1 |
600 | 2024-02-25 16:12:24 | loch | 1 | 13983 | 11 | 0.533 | 26234.5 |
599 | 2024-02-19 00:22:19 | loch | 1 | 13983 | 11 | 0.563 | 24836.6 |
598 | 2024-02-14 16:49:22 | loch | 1 | 13983 | 11 | 0.563 | 24836.6 |
597 | 2024-02-03 00:48:10 | loch | 1 | 13983 | 11 | 0.263 | 53167.3 |
596 | 2024-02-02 16:08:39 | loch | 1 | 13983 | 11 | 0.266 | 52567.7 |
595 | 2024-01-25 19:14:29 | loch | 1 | 13983 | 11 | 0.516 | 27098.8 |
594 | 2024-01-24 05:10:27 | loch | 1 | 13983 | 11 | 0.203 | 68881.8 |
593 | 2024-01-20 19:20:47 | loch | 1 | 13983 | 11 | 0.236 | 59250.0 |
592 | 2024-01-11 11:23:29 | loch | 1 | 13983 | 11 | 0.266 | 52567.7 |
591 | 2023-12-16 04:19:55 | loch | 2 | 29872 | 203 | 0.890 | 33564.0 |
590 | 2023-12-14 04:14:05 | loch | 2 | 29872 | 203 | 0.860 | 34734.9 |
589 | 2023-11-28 11:06:26 | loch | 2 | 29872 | 203 | 0.733 | 40753.1 |
588 | 2023-11-18 19:19:32 | loch | 1 | 13983 | 11 | 0.216 | 64736.1 |
587 | 2023-11-13 13:46:42 | loch | 2 | 29872 | 203 | 0.860 | 34734.9 |
586 | 2023-11-11 12:57:04 | loch | 1 | 13983 | 11 | 0.250 | 55932.0 |
585 | 2023-11-09 22:55:52 | loch | 1 | 13983 | 11 | 0.500 | 27966.0 |
584 | 2023-10-28 07:07:43 | loch | 2 | 29872 | 203 | 0.840 | 35561.9 |
583 | 2023-10-26 18:46:31 | loch | 1 | 13983 | 11 | 0.250 | 55932.0 |
582 | 2023-10-26 02:26:48 | loch | 1 | 13983 | 11 | 0.220 | 63559.1 |
581 | 2023-10-19 20:42:59 | loch | 1 | 13983 | 11 | 0.360 | 38841.7 |
580 | 2023-10-17 07:06:44 | loch | 1 | 13983 | 11 | 0.233 | 60012.9 |
579 | 2023-10-11 16:33:48 | loch | 1 | 13983 | 11 | 0.216 | 64736.1 |
578 | 2023-10-04 00:40:22 | loch | 1 | 13983 | 11 | 0.220 | 63559.1 |
577 | 2023-09-21 00:09:44 | loch | 2 | 29872 | 203 | 0.843 | 35435.3 |
576 | 2023-09-18 20:10:54 | loch | 1 | 13983 | 11 | 0.216 | 64736.1 |
575 | 2023-09-15 09:21:12 | loch | 2 | 29872 | 203 | 0.780 | 38297.4 |
574 | 2023-09-05 20:30:36 | loch | 1 | 13983 | 11 | 0.220 | 63559.1 |
573 | 2023-07-05 15:36:00 | loch | 1 | 13983 | 11 | 0.233 | 60012.9 |
572 | 2023-06-13 09:34:15 | loch | 2 | 29872 | 203 | 0.733 | 40753.1 |
571 | 2023-06-08 00:49:16 | loch | 1 | 13983 | 11 | 0.250 | 55932.0 |
570 | 2023-03-27 14:02:15 | loch | 1 | 13983 | 11 | 0.516 | 27098.8 |
569 | 2023-03-22 02:37:42 | loch | 1 | 13983 | 11 | 0.220 | 63559.1 |
568 | 2023-03-15 01:07:07 | loch | 2 | 29872 | 203 | 0.750 | 39829.3 |
567 | 2023-01-11 01:01:42 | loch | 1 | 13983 | 11 | 0.216 | 64736.1 |
566 | 2022-12-17 19:22:33 | loch | 2 | 29872 | 203 | 0.826 | 36164.6 |
565 | 2022-11-30 17:06:58 | loch | 1 | 13983 | 11 | 0.220 | 63559.1 |
564 | 2022-11-27 10:19:01 | loch | 1 | 13983 | 11 | 0.220 | 63559.1 |
563 | 2022-11-25 08:01:26 | loch | 1 | 13983 | 11 | 0.233 | 60012.9 |
562 | 2022-10-19 22:17:33 | loch | 1 | 13983 | 11 | 0.233 | 60012.9 |
561 | 2022-09-12 00:18:54 | loch | 1 | 13983 | 11 | 0.220 | 63559.1 |
560 | 2022-09-01 00:39:00 | loch | 1 | 13983 | 11 | 0.250 | 55932.0 |
559 | 2022-08-24 04:16:13 | loch | 1 | 13983 | 11 | 0.220 | 63559.1 |
558 | 2022-08-15 22:44:20 | loch | 1 | 13983 | 11 | 0.203 | 68881.8 |
557 | 2022-08-10 12:40:07 | loch | 2 | 29872 | 203 | 0.783 | 38150.7 |
556 | 2022-07-31 08:12:47 | loch | 1 | 13983 | 11 | 0.216 | 64736.1 |
555 | 2022-07-18 14:08:40 | loch | 1 | 13983 | 11 | 0.216 | 64736.1 |
554 | 2022-06-25 08:49:10 | loch | 1 | 13983 | 11 | 0.220 | 63559.1 |
553 | 2022-06-25 01:50:41 | loch | 1 | 13983 | 11 | 0.313 | 44674.1 |
552 | 2022-06-09 17:36:03 | loch | 1 | 13983 | 11 | 0.233 | 60012.9 |
551 | 2022-04-05 19:29:53 | loch | 1 | 13983 | 11 | 0.203 | 68881.8 |
550 | 2022-03-15 18:29:06 | loch | 2 | 29872 | 203 | 1.013 | 29488.6 |
549 | 2022-02-12 23:12:55 | loch | 1 | 13983 | 11 | 0.266 | 52567.7 |
548 | 2021-12-21 21:40:58 | loch | 1 | 13983 | 11 | 0.500 | 27966.0 |
547 | 2021-12-18 16:21:39 | loch | 1 | 13983 | 11 | 0.233 | 60012.9 |
546 | 2021-12-08 16:28:39 | loch | 1 | 13983 | 11 | 0.263 | 53167.3 |
545 | 2021-10-20 03:21:48 | loch | 1 | 13983 | 11 | 0.216 | 64736.1 |
544 | 2021-10-13 21:00:07 | loch | 2 | 29872 | 203 | 0.826 | 36164.6 |
543 | 2021-09-14 17:11:16 | loch | 1 | 13983 | 11 | 0.313 | 44674.1 |
542 | 2021-09-12 05:25:01 | loch | 1 | 13983 | 11 | 0.220 | 63559.1 |
541 | 2021-09-05 02:17:38 | loch | 2 | 29872 | 203 | 0.780 | 38297.4 |
540 | 2021-09-03 22:12:55 | loch | 2 | 29872 | 203 | 0.923 | 32364.0 |
539 | 2021-09-03 10:47:24 | loch | 2 | 29872 | 203 | 0.736 | 40587.0 |
538 | 2021-09-02 15:38:12 | loch | 2 | 29872 | 203 | 0.843 | 35435.3 |
537 | 2021-09-01 11:43:59 | loch | 2 | 29872 | 203 | 0.796 | 37527.6 |
536 | 2021-08-31 22:56:21 | loch | 2 | 29872 | 203 | 0.936 | 31914.5 |
535 | 2021-08-30 15:34:36 | loch | 2 | 29872 | 203 | 0.750 | 39829.3 |
534 | 2021-08-28 16:33:57 | loch | 2 | 29872 | 203 | 0.940 | 31778.7 |
533 | 2021-08-26 15:08:22 | loch | 2 | 29872 | 203 | 0.893 | 33451.3 |
532 | 2021-08-23 10:50:26 | loch | 1 | 13983 | 11 | 0.220 | 63559.1 |
531 | 2021-08-22 23:45:26 | loch | 2 | 29872 | 203 | 1.513 | 19743.6 |
530 | 2021-08-21 06:17:26 | loch | 1 | 13983 | 11 | 0.233 | 60012.9 |
529 | 2021-08-17 12:15:40 | loch | 2 | 29872 | 203 | 0.810 | 36879.0 |
528 | 2021-08-15 09:42:58 | loch | 2 | 29872 | 203 | 0.783 | 38150.7 |
527 | 2021-08-14 19:32:48 | loch | 2 | 29872 | 203 | 0.810 | 36879.0 |
526 | 2021-08-12 03:02:39 | loch | 2 | 29872 | 203 | 0.936 | 31914.5 |
525 | 2021-08-07 23:34:36 | loch | 2 | 29872 | 203 | 0.906 | 32971.3 |
524 | 2021-07-21 12:33:50 | loch | 1 | 13983 | 11 | 0.313 | 44674.1 |
523 | 2021-07-13 18:15:15 | loch | 2 | 29872 | 203 | 0.873 | 34217.6 |
522 | 2021-07-12 00:12:31 | loch | 2 | 29872 | 203 | 0.843 | 35435.3 |
521 | 2021-07-10 23:19:53 | loch | 2 | 29872 | 203 | 0.876 | 34100.5 |
520 | 2021-07-08 19:12:29 | loch | 2 | 29872 | 203 | 0.906 | 32971.3 |
519 | 2021-07-08 19:03:32 | loch | 2 | 29872 | 203 | 0.796 | 37527.6 |
518 | 2021-07-07 18:54:04 | loch | 2 | 29872 | 203 | 0.890 | 33564.0 |
517 | 2021-07-06 19:29:24 | loch | 2 | 29872 | 203 | 0.750 | 39829.3 |
516 | 2021-06-26 21:34:24 | loch | 2 | 29872 | 203 | 0.736 | 40587.0 |
515 | 2021-06-26 06:22:38 | loch | 2 | 29872 | 203 | 0.750 | 39829.3 |
514 | 2021-06-25 19:07:50 | loch | 2 | 29872 | 203 | 0.843 | 35435.3 |
513 | 2021-06-24 02:55:17 | loch | 2 | 29872 | 203 | 0.860 | 34734.9 |
512 | 2021-06-24 01:10:12 | loch | 2 | 29872 | 203 | 0.860 | 34734.9 |
511 | 2021-06-23 21:00:15 | loch | 2 | 29872 | 203 | 0.766 | 38997.4 |
510 | 2021-06-23 14:23:33 | loch | 2 | 29872 | 203 | 0.750 | 39829.3 |
509 | 2021-06-22 04:01:41 | loch | 2 | 29872 | 203 | 1.733 | 17237.2 |
508 | 2021-06-20 00:26:28 | loch | 2 | 29872 | 203 | 0.750 | 39829.3 |
507 | 2021-06-16 17:28:55 | loch | 2 | 29872 | 203 | 0.906 | 32971.3 |
506 | 2021-06-15 10:17:56 | loch | 2 | 29872 | 203 | 0.893 | 33451.3 |
505 | 2021-06-14 14:58:26 | loch | 2 | 29872 | 203 | 0.780 | 38297.4 |