History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sofa"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
630 | 2024-05-09 13:59:13 | sofa | 1 | 13983 | 13 | 0.283 | 49409.9 |
629 | 2024-05-03 23:51:35 | sofa | 1 | 13983 | 13 | 0.546 | 25609.9 |
628 | 2024-05-02 12:48:15 | sofa | 1 | 13983 | 13 | 0.263 | 53167.3 |
627 | 2024-04-30 01:52:01 | sofa | 1 | 13983 | 13 | 0.516 | 27098.8 |
626 | 2024-04-29 09:43:40 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
625 | 2024-04-03 11:02:29 | sofa | 2 | 29872 | 167 | 1.046 | 28558.3 |
624 | 2024-04-03 10:56:05 | sofa | 1 | 13983 | 13 | 0.360 | 38841.7 |
623 | 2024-04-01 16:49:35 | sofa | 1 | 13983 | 13 | 0.593 | 23580.1 |
622 | 2024-03-31 00:46:20 | sofa | 2 | 29872 | 167 | 1.030 | 29001.9 |
621 | 2024-03-30 23:42:35 | sofa | 1 | 13983 | 13 | 0.313 | 44674.1 |
620 | 2024-03-28 14:32:12 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
619 | 2024-03-26 23:43:00 | sofa | 1 | 13983 | 13 | 0.533 | 26234.5 |
618 | 2024-03-04 06:18:27 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
617 | 2024-03-02 13:05:32 | sofa | 1 | 13983 | 13 | 0.296 | 47239.9 |
616 | 2024-02-29 21:26:52 | sofa | 1 | 13983 | 13 | 0.516 | 27098.8 |
615 | 2024-02-25 22:32:55 | sofa | 2 | 29872 | 167 | 2.966 | 10071.5 |
614 | 2024-02-25 22:32:10 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
613 | 2024-02-03 01:25:55 | sofa | 1 | 13983 | 13 | 0.500 | 27966.0 |
612 | 2024-01-28 19:23:03 | sofa | 1 | 13983 | 13 | 0.220 | 63559.1 |
611 | 2024-01-28 03:08:29 | sofa | 1 | 13983 | 13 | 0.236 | 59250.0 |
610 | 2024-01-26 20:10:41 | sofa | 1 | 13983 | 13 | 0.263 | 53167.3 |
609 | 2024-01-20 06:58:53 | sofa | 2 | 29872 | 167 | 0.970 | 30795.9 |
608 | 2023-12-26 13:26:06 | sofa | 1 | 13983 | 13 | 0.550 | 25423.6 |
607 | 2023-12-24 00:50:53 | sofa | 2 | 29872 | 167 | 0.766 | 38997.4 |
606 | 2023-12-09 05:29:09 | sofa | 2 | 29872 | 167 | 0.890 | 33564.0 |
605 | 2023-11-23 06:50:16 | sofa | 1 | 13983 | 13 | 0.263 | 53167.3 |
604 | 2023-11-18 08:54:43 | sofa | 1 | 13983 | 13 | 0.216 | 64736.1 |
603 | 2023-11-12 07:35:14 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
602 | 2023-10-29 03:32:36 | sofa | 2 | 29872 | 167 | 0.906 | 32971.3 |
601 | 2023-10-28 10:14:37 | sofa | 1 | 13983 | 13 | 0.233 | 60012.9 |
600 | 2023-10-21 13:40:52 | sofa | 2 | 29872 | 167 | 0.783 | 38150.7 |
599 | 2023-10-19 21:13:47 | sofa | 1 | 13983 | 13 | 0.203 | 68881.8 |
598 | 2023-10-16 23:54:26 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
597 | 2023-10-13 07:10:55 | sofa | 1 | 13983 | 13 | 0.216 | 64736.1 |
596 | 2023-10-05 04:19:53 | sofa | 1 | 13983 | 13 | 0.266 | 52567.7 |
595 | 2023-09-29 10:12:19 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
594 | 2023-09-23 00:24:18 | sofa | 1 | 13983 | 13 | 0.216 | 64736.1 |
593 | 2023-09-09 13:20:41 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
592 | 2023-08-20 19:09:47 | sofa | 1 | 13983 | 13 | 0.220 | 63559.1 |
591 | 2023-06-14 04:08:38 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
590 | 2023-05-03 03:16:08 | sofa | 1 | 13983 | 13 | 0.220 | 63559.1 |
589 | 2023-03-31 01:06:13 | sofa | 1 | 13983 | 13 | 0.220 | 63559.1 |
588 | 2023-01-13 13:03:18 | sofa | 1 | 13983 | 13 | 0.220 | 63559.1 |
587 | 2023-01-13 09:42:05 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
586 | 2023-01-09 15:38:30 | sofa | 1 | 13983 | 13 | 0.220 | 63559.1 |
585 | 2022-11-01 19:33:12 | sofa | 1 | 13983 | 13 | 0.220 | 63559.1 |
584 | 2022-09-07 21:03:20 | sofa | 1 | 13983 | 13 | 0.266 | 52567.7 |
583 | 2022-07-29 05:20:38 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
582 | 2022-06-21 22:11:11 | sofa | 1 | 13983 | 13 | 0.233 | 60012.9 |
581 | 2022-05-09 12:37:17 | sofa | 1 | 13983 | 13 | 0.313 | 44674.1 |
580 | 2022-03-05 14:29:54 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
579 | 2022-01-21 11:05:01 | sofa | 1 | 13983 | 13 | 0.233 | 60012.9 |
578 | 2022-01-18 04:39:15 | sofa | 1 | 13983 | 13 | 0.266 | 52567.7 |
577 | 2022-01-14 21:47:46 | sofa | 1 | 13983 | 13 | 0.263 | 53167.3 |
576 | 2022-01-11 15:39:53 | sofa | 1 | 13983 | 13 | 0.233 | 60012.9 |
575 | 2021-12-18 06:07:13 | sofa | 1 | 13983 | 13 | 0.470 | 29751.1 |
574 | 2021-10-25 08:14:24 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
573 | 2021-10-23 06:54:29 | sofa | 1 | 13983 | 13 | 0.436 | 32071.1 |
572 | 2021-10-02 06:19:28 | sofa | 1 | 13983 | 13 | 0.263 | 53167.3 |
571 | 2021-09-29 01:10:33 | sofa | 1 | 13983 | 13 | 0.233 | 60012.9 |
570 | 2021-09-13 09:35:42 | sofa | 1 | 13983 | 13 | 0.220 | 63559.1 |
569 | 2021-08-24 14:45:14 | sofa | 1 | 13983 | 13 | 0.220 | 63559.1 |
568 | 2021-07-05 07:52:47 | sofa | 1 | 13983 | 13 | 0.233 | 60012.9 |
567 | 2021-06-26 00:17:26 | sofa | 1 | 13983 | 13 | 0.266 | 52567.7 |
566 | 2021-06-22 18:04:49 | sofa | 1 | 13983 | 13 | 0.233 | 60012.9 |
565 | 2021-04-19 08:40:32 | sofa | 1 | 13983 | 13 | 0.220 | 63559.1 |
564 | 2021-03-20 13:36:59 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
563 | 2021-01-31 19:15:54 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
562 | 2021-01-04 01:46:05 | sofa | 1 | 13983 | 13 | 0.236 | 59250.0 |
561 | 2020-12-17 15:53:25 | sofa | 1 | 13983 | 13 | 0.233 | 60012.9 |
560 | 2020-11-17 15:52:06 | sofa | 1 | 13983 | 13 | 0.233 | 60012.9 |
559 | 2020-10-26 10:30:25 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
558 | 2020-10-26 04:34:20 | sofa | 1 | 13983 | 13 | 0.266 | 52567.7 |
557 | 2020-10-24 10:04:35 | sofa | 1 | 13983 | 13 | 0.216 | 64736.1 |
556 | 2020-10-19 05:04:40 | sofa | 1 | 13983 | 13 | 0.513 | 27257.3 |
555 | 2020-09-13 18:26:20 | sofa | 1 | 13983 | 13 | 0.233 | 60012.9 |
554 | 2020-09-10 14:12:47 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
553 | 2020-09-03 13:30:54 | sofa | 1 | 13983 | 13 | 0.263 | 53167.3 |
552 | 2020-08-25 07:59:31 | sofa | 1 | 13983 | 13 | 0.236 | 59250.0 |
551 | 2020-07-20 03:42:36 | sofa | 1 | 13983 | 13 | 0.233 | 60012.9 |
550 | 2020-07-14 22:33:56 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
549 | 2020-06-07 02:24:02 | sofa | 1 | 13983 | 13 | 0.216 | 64736.1 |
548 | 2020-06-06 03:04:40 | sofa | 1 | 13983 | 13 | 0.263 | 53167.3 |
547 | 2020-06-05 02:29:23 | sofa | 1 | 13983 | 13 | 0.220 | 63559.1 |
546 | 2020-06-04 19:12:30 | sofa | 1 | 13983 | 13 | 0.220 | 63559.1 |
545 | 2020-06-04 02:24:35 | sofa | 1 | 13983 | 13 | 0.233 | 60012.9 |
544 | 2020-06-03 02:25:40 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
543 | 2020-05-15 08:10:27 | sofa | 1 | 13983 | 13 | 0.280 | 49939.3 |
542 | 2020-04-13 20:32:50 | sofa | 1 | 13983 | 13 | 0.283 | 49409.9 |
541 | 2020-03-24 15:34:13 | sofa | 1 | 13983 | 13 | 0.263 | 53167.3 |
540 | 2020-03-24 10:54:12 | sofa | 1 | 13983 | 13 | 0.263 | 53167.3 |
539 | 2020-03-24 07:55:59 | sofa | 1 | 13983 | 13 | 0.280 | 49939.3 |
538 | 2020-03-23 03:34:22 | sofa | 1 | 13983 | 13 | 0.220 | 63559.1 |
537 | 2020-03-21 11:55:25 | sofa | 1 | 13983 | 13 | 0.266 | 52567.7 |
536 | 2020-03-20 16:06:17 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
535 | 2020-03-20 07:47:33 | sofa | 1 | 13983 | 13 | 0.233 | 60012.9 |
534 | 2020-03-20 00:36:37 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
533 | 2020-03-17 21:47:34 | sofa | 1 | 13983 | 13 | 0.220 | 63559.1 |
532 | 2020-03-13 04:54:20 | sofa | 1 | 13983 | 13 | 0.250 | 55932.0 |
531 | 2020-03-04 20:28:00 | sofa | 1 | 13983 | 13 | 0.236 | 59250.0 |