History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"knot"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
611 | 2024-04-27 12:14:09 | knot | 1 | 13983 | 9 | 0.656 | 21315.5 |
610 | 2024-04-19 13:52:15 | knot | 1 | 13983 | 9 | 0.296 | 47239.9 |
609 | 2024-04-17 08:18:19 | knot | 1 | 13983 | 9 | 0.453 | 30867.5 |
608 | 2024-04-03 03:11:01 | knot | 1 | 13983 | 9 | 0.513 | 27257.3 |
607 | 2024-04-01 16:12:44 | knot | 1 | 13983 | 9 | 0.470 | 29751.1 |
606 | 2024-03-31 01:03:24 | knot | 1 | 13983 | 9 | 0.266 | 52567.7 |
605 | 2024-03-04 03:53:21 | knot | 2 | 29872 | 133 | 0.903 | 33080.8 |
604 | 2024-03-04 00:44:21 | knot | 1 | 13983 | 9 | 0.250 | 55932.0 |
603 | 2024-03-03 08:23:50 | knot | 2 | 29872 | 133 | 0.846 | 35309.7 |
602 | 2024-03-02 14:42:44 | knot | 2 | 29872 | 133 | 1.953 | 15295.4 |
601 | 2024-03-02 13:36:15 | knot | 1 | 13983 | 9 | 0.263 | 53167.3 |
600 | 2024-02-25 16:55:17 | knot | 1 | 13983 | 9 | 0.250 | 55932.0 |
599 | 2024-02-03 00:35:35 | knot | 1 | 13983 | 9 | 0.483 | 28950.3 |
598 | 2024-01-28 13:34:27 | knot | 1 | 13983 | 9 | 0.220 | 63559.1 |
597 | 2024-01-26 15:07:35 | knot | 1 | 13983 | 9 | 0.236 | 59250.0 |
596 | 2024-01-25 23:56:01 | knot | 1 | 13983 | 9 | 0.220 | 63559.1 |
595 | 2024-01-15 08:36:55 | knot | 1 | 13983 | 9 | 0.220 | 63559.1 |
594 | 2023-12-06 23:11:22 | knot | 1 | 13983 | 9 | 0.216 | 64736.1 |
593 | 2023-12-06 23:11:22 | knot | 1 | 13983 | 9 | 0.233 | 60012.9 |
592 | 2023-11-28 20:28:38 | knot | 2 | 29872 | 133 | 0.796 | 37527.6 |
591 | 2023-11-25 23:18:03 | knot | 2 | 29872 | 133 | 0.720 | 41488.9 |
590 | 2023-11-23 03:57:01 | knot | 2 | 29872 | 133 | 0.736 | 40587.0 |
589 | 2023-11-23 01:31:01 | knot | 2 | 29872 | 133 | 0.843 | 35435.3 |
588 | 2023-11-22 11:53:48 | knot | 1 | 13983 | 9 | 0.203 | 68881.8 |
587 | 2023-11-13 12:26:05 | knot | 1 | 13983 | 9 | 0.203 | 68881.8 |
586 | 2023-11-10 21:22:55 | knot | 1 | 13983 | 9 | 0.236 | 59250.0 |
585 | 2023-11-09 08:31:23 | knot | 2 | 29872 | 133 | 0.843 | 35435.3 |
584 | 2023-10-27 15:27:38 | knot | 1 | 13983 | 9 | 0.203 | 68881.8 |
583 | 2023-10-21 08:40:38 | knot | 1 | 13983 | 9 | 0.233 | 60012.9 |
582 | 2023-10-17 20:09:39 | knot | 1 | 13983 | 9 | 0.203 | 68881.8 |
581 | 2023-10-13 00:26:24 | knot | 1 | 13983 | 9 | 0.236 | 59250.0 |
580 | 2023-10-03 17:05:30 | knot | 1 | 13983 | 9 | 0.203 | 68881.8 |
579 | 2023-09-24 00:22:26 | knot | 1 | 13983 | 9 | 0.203 | 68881.8 |
578 | 2023-09-08 07:55:38 | knot | 1 | 13983 | 9 | 0.220 | 63559.1 |
577 | 2023-09-05 03:53:51 | knot | 1 | 13983 | 9 | 0.236 | 59250.0 |
576 | 2023-06-15 12:35:42 | knot | 1 | 13983 | 9 | 0.203 | 68881.8 |
575 | 2023-05-05 04:18:41 | knot | 1 | 13983 | 9 | 0.250 | 55932.0 |
574 | 2023-04-01 10:09:39 | knot | 1 | 13983 | 9 | 0.236 | 59250.0 |
573 | 2023-03-21 02:48:09 | knot | 1 | 13983 | 9 | 0.203 | 68881.8 |
572 | 2023-01-25 18:41:00 | knot | 1 | 13983 | 9 | 0.200 | 69915.0 |
571 | 2023-01-14 12:39:02 | knot | 1 | 13983 | 9 | 0.203 | 68881.8 |
570 | 2023-01-04 05:42:33 | knot | 1 | 13983 | 9 | 0.220 | 63559.1 |
569 | 2022-12-11 14:03:08 | knot | 1 | 13983 | 9 | 0.220 | 63559.1 |
568 | 2022-11-23 18:57:17 | knot | 1 | 13983 | 9 | 0.233 | 60012.9 |
567 | 2022-11-16 19:58:23 | knot | 1 | 13983 | 9 | 0.203 | 68881.8 |
566 | 2022-09-02 22:19:10 | knot | 1 | 13983 | 9 | 0.203 | 68881.8 |
565 | 2022-08-30 16:48:09 | knot | 1 | 13983 | 9 | 0.203 | 68881.8 |
564 | 2022-08-14 05:02:43 | knot | 1 | 13983 | 9 | 0.206 | 67878.6 |
563 | 2022-08-07 04:43:26 | knot | 1 | 13983 | 9 | 0.203 | 68881.8 |
562 | 2022-08-05 21:35:16 | knot | 1 | 13983 | 9 | 0.203 | 68881.8 |
561 | 2022-06-04 20:00:06 | knot | 1 | 13983 | 9 | 0.203 | 68881.8 |
560 | 2022-06-02 14:34:35 | knot | 1 | 13983 | 9 | 0.203 | 68881.8 |
559 | 2022-04-16 07:58:55 | knot | 1 | 13983 | 9 | 0.233 | 60012.9 |
558 | 2022-02-27 14:36:31 | knot | 1 | 13983 | 9 | 0.203 | 68881.8 |
557 | 2022-02-12 11:53:54 | knot | 1 | 13983 | 9 | 0.296 | 47239.9 |
556 | 2021-12-29 15:24:11 | knot | 1 | 13983 | 9 | 0.250 | 55932.0 |
555 | 2021-12-21 23:34:56 | knot | 1 | 13983 | 9 | 0.220 | 63559.1 |
554 | 2021-12-18 18:23:25 | knot | 1 | 13983 | 9 | 0.220 | 63559.1 |
553 | 2021-12-01 23:33:27 | knot | 1 | 13983 | 9 | 0.263 | 53167.3 |
552 | 2021-11-29 21:19:26 | knot | 1 | 13983 | 9 | 0.233 | 60012.9 |
551 | 2021-11-23 20:19:30 | knot | 1 | 13983 | 9 | 0.233 | 60012.9 |
550 | 2021-11-01 19:57:10 | knot | 1 | 13983 | 9 | 0.406 | 34440.9 |
549 | 2021-10-09 09:09:02 | knot | 1 | 13983 | 9 | 0.453 | 30867.5 |
548 | 2021-09-22 06:43:52 | knot | 1 | 13983 | 9 | 0.313 | 44674.1 |
547 | 2021-09-08 07:25:53 | knot | 1 | 13983 | 9 | 0.233 | 60012.9 |
546 | 2021-08-31 16:21:56 | knot | 1 | 13983 | 9 | 0.233 | 60012.9 |
545 | 2021-08-29 11:58:04 | knot | 1 | 13983 | 9 | 0.216 | 64736.1 |
544 | 2021-08-20 04:12:31 | knot | 1 | 13983 | 9 | 0.236 | 59250.0 |
543 | 2021-08-14 06:07:39 | knot | 1 | 13983 | 9 | 0.200 | 69915.0 |
542 | 2021-07-23 01:21:57 | knot | 1 | 13983 | 9 | 0.203 | 68881.8 |
541 | 2021-07-07 04:25:48 | knot | 1 | 13983 | 9 | 0.250 | 55932.0 |
540 | 2021-05-31 18:14:38 | knot | 1 | 13983 | 9 | 0.233 | 60012.9 |
539 | 2021-05-25 09:44:04 | knot | 1 | 13983 | 9 | 0.233 | 60012.9 |
538 | 2021-04-30 22:50:13 | knot | 1 | 13983 | 9 | 0.216 | 64736.1 |
537 | 2021-04-21 23:15:26 | knot | 1 | 13983 | 9 | 0.236 | 59250.0 |
536 | 2021-04-06 12:57:29 | knot | 2 | 29872 | 133 | 0.860 | 34734.9 |
535 | 2021-04-04 17:31:20 | knot | 1 | 13983 | 9 | 0.250 | 55932.0 |
534 | 2021-03-24 09:10:17 | knot | 1 | 13983 | 9 | 0.250 | 55932.0 |
533 | 2021-02-19 21:22:26 | knot | 1 | 13983 | 9 | 0.220 | 63559.1 |
532 | 2021-02-02 17:43:19 | knot | 1 | 13983 | 9 | 0.220 | 63559.1 |
531 | 2021-01-21 19:29:24 | knot | 2 | 29872 | 133 | 0.813 | 36742.9 |
530 | 2021-01-07 00:45:19 | knot | 1 | 13983 | 9 | 0.233 | 60012.9 |
529 | 2020-11-20 23:04:43 | knot | 1 | 13983 | 9 | 0.203 | 68881.8 |
528 | 2020-11-01 20:19:53 | knot | 2 | 29872 | 133 | 0.780 | 38297.4 |
527 | 2020-10-30 19:39:38 | knot | 1 | 13983 | 9 | 0.203 | 68881.8 |
526 | 2020-10-25 19:16:34 | knot | 1 | 13983 | 9 | 0.453 | 30867.5 |
525 | 2020-10-20 10:38:49 | knot | 1 | 13983 | 9 | 0.203 | 68881.8 |
524 | 2020-10-19 16:26:52 | knot | 1 | 13983 | 9 | 0.203 | 68881.8 |
523 | 2020-10-17 14:06:03 | knot | 1 | 13983 | 9 | 0.236 | 59250.0 |
522 | 2020-08-29 19:28:37 | knot | 1 | 13983 | 9 | 0.216 | 64736.1 |
521 | 2020-08-26 02:21:36 | knot | 1 | 13983 | 9 | 0.203 | 68881.8 |
520 | 2020-08-25 03:11:20 | knot | 1 | 13983 | 9 | 0.220 | 63559.1 |
519 | 2020-08-23 04:03:35 | knot | 1 | 13983 | 9 | 0.203 | 68881.8 |
518 | 2020-08-20 07:47:35 | knot | 1 | 13983 | 9 | 0.203 | 68881.8 |
517 | 2020-08-20 06:19:50 | knot | 1 | 13983 | 9 | 0.203 | 68881.8 |
516 | 2020-05-16 01:25:51 | knot | 1 | 13983 | 9 | 0.216 | 64736.1 |
515 | 2020-05-15 12:36:49 | knot | 1 | 13983 | 9 | 0.233 | 60012.9 |
514 | 2020-05-09 20:55:32 | knot | 1 | 13983 | 9 | 0.203 | 68881.8 |
513 | 2020-03-30 03:58:14 | knot | 1 | 13983 | 9 | 0.220 | 63559.1 |
512 | 2020-03-25 02:04:34 | knot | 1 | 13983 | 9 | 0.266 | 52567.7 |