History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"foam"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
604 | 2024-04-23 12:34:04 | foam | 1 | 13983 | 9 | 0.220 | 63559.1 |
603 | 2024-04-05 00:35:17 | foam | 1 | 13983 | 9 | 0.220 | 63559.1 |
602 | 2024-04-02 20:47:45 | foam | 1 | 13983 | 9 | 0.280 | 49939.3 |
601 | 2024-03-31 15:37:43 | foam | 1 | 13983 | 9 | 0.250 | 55932.0 |
600 | 2024-03-27 07:02:47 | foam | 1 | 13983 | 9 | 0.250 | 55932.0 |
599 | 2024-03-20 07:36:10 | foam | 1 | 13983 | 9 | 0.250 | 55932.0 |
598 | 2024-03-20 07:35:58 | foam | 2 | 29872 | 206 | 0.936 | 31914.5 |
597 | 2024-03-05 20:05:47 | foam | 1 | 13983 | 9 | 0.546 | 25609.9 |
596 | 2024-03-03 19:38:15 | foam | 1 | 13983 | 9 | 0.216 | 64736.1 |
595 | 2024-03-01 12:27:39 | foam | 1 | 13983 | 9 | 0.216 | 64736.1 |
594 | 2024-02-26 01:55:24 | foam | 2 | 29872 | 206 | 1.423 | 20992.3 |
593 | 2024-02-26 01:34:45 | foam | 1 | 13983 | 9 | 0.486 | 28771.6 |
592 | 2024-02-22 07:00:01 | foam | 1 | 13983 | 9 | 0.266 | 52567.7 |
591 | 2024-02-15 01:44:41 | foam | 1 | 13983 | 9 | 0.610 | 22923.0 |
590 | 2024-02-03 03:12:58 | foam | 1 | 13983 | 9 | 0.250 | 55932.0 |
589 | 2024-02-02 15:33:35 | foam | 1 | 13983 | 9 | 0.250 | 55932.0 |
588 | 2024-01-28 13:32:03 | foam | 1 | 13983 | 9 | 0.220 | 63559.1 |
587 | 2024-01-27 15:58:26 | foam | 1 | 13983 | 9 | 0.220 | 63559.1 |
586 | 2024-01-26 20:06:05 | foam | 1 | 13983 | 9 | 0.500 | 27966.0 |
585 | 2024-01-26 20:05:57 | foam | 1 | 13983 | 9 | 0.250 | 55932.0 |
584 | 2024-01-06 11:05:08 | foam | 1 | 13983 | 9 | 0.233 | 60012.9 |
583 | 2023-12-25 03:25:39 | foam | 1 | 13983 | 9 | 0.216 | 64736.1 |
582 | 2023-12-20 19:23:26 | foam | 2 | 29872 | 206 | 0.826 | 36164.6 |
581 | 2023-12-09 21:45:32 | foam | 2 | 29872 | 206 | 0.856 | 34897.2 |
580 | 2023-12-06 21:40:24 | foam | 1 | 13983 | 9 | 0.250 | 55932.0 |
579 | 2023-12-06 21:40:23 | foam | 1 | 13983 | 9 | 0.250 | 55932.0 |
578 | 2023-12-04 20:39:44 | foam | 2 | 29872 | 206 | 0.846 | 35309.7 |
577 | 2023-11-27 01:38:33 | foam | 2 | 29872 | 206 | 0.843 | 35435.3 |
576 | 2023-11-20 21:44:07 | foam | 1 | 13983 | 9 | 0.233 | 60012.9 |
575 | 2023-11-15 12:17:23 | foam | 1 | 13983 | 9 | 0.220 | 63559.1 |
574 | 2023-11-11 04:25:19 | foam | 1 | 13983 | 9 | 0.220 | 63559.1 |
573 | 2023-11-10 03:17:48 | foam | 1 | 13983 | 9 | 0.220 | 63559.1 |
572 | 2023-11-07 10:07:50 | foam | 1 | 13983 | 9 | 0.233 | 60012.9 |
571 | 2023-11-02 03:11:08 | foam | 2 | 29872 | 206 | 0.906 | 32971.3 |
570 | 2023-11-02 01:56:29 | foam | 1 | 13983 | 9 | 0.236 | 59250.0 |
569 | 2023-10-30 04:39:46 | foam | 1 | 13983 | 9 | 0.216 | 64736.1 |
568 | 2023-10-29 10:25:45 | foam | 2 | 29872 | 206 | 0.750 | 39829.3 |
567 | 2023-10-28 01:51:56 | foam | 1 | 13983 | 9 | 0.250 | 55932.0 |
566 | 2023-10-24 17:21:56 | foam | 1 | 13983 | 9 | 0.233 | 60012.9 |
565 | 2023-10-19 21:26:17 | foam | 1 | 13983 | 9 | 0.250 | 55932.0 |
564 | 2023-10-17 23:44:14 | foam | 1 | 13983 | 9 | 0.440 | 31779.5 |
563 | 2023-10-16 06:52:05 | foam | 1 | 13983 | 9 | 0.233 | 60012.9 |
562 | 2023-10-14 23:57:39 | foam | 2 | 29872 | 206 | 0.860 | 34734.9 |
561 | 2023-10-10 20:41:13 | foam | 1 | 13983 | 9 | 0.250 | 55932.0 |
560 | 2023-10-04 12:17:00 | foam | 1 | 13983 | 9 | 0.220 | 63559.1 |
559 | 2023-09-23 12:39:44 | foam | 1 | 13983 | 9 | 0.220 | 63559.1 |
558 | 2023-09-20 13:07:04 | foam | 2 | 29872 | 206 | 0.796 | 37527.6 |
557 | 2023-09-10 22:04:13 | foam | 1 | 13983 | 9 | 0.233 | 60012.9 |
556 | 2023-09-02 14:07:04 | foam | 2 | 29872 | 206 | 0.826 | 36164.6 |
555 | 2023-08-23 09:11:14 | foam | 1 | 13983 | 9 | 0.250 | 55932.0 |
554 | 2023-07-06 20:26:22 | foam | 1 | 13983 | 9 | 0.233 | 60012.9 |
553 | 2023-06-29 16:11:08 | foam | 1 | 13983 | 9 | 0.220 | 63559.1 |
552 | 2023-06-23 06:36:58 | foam | 2 | 29872 | 206 | 0.750 | 39829.3 |
551 | 2023-05-25 16:42:52 | foam | 1 | 13983 | 9 | 0.420 | 33292.9 |
550 | 2023-03-31 13:41:17 | foam | 1 | 13983 | 9 | 0.236 | 59250.0 |
549 | 2023-03-27 00:43:23 | foam | 2 | 29872 | 206 | 0.843 | 35435.3 |
548 | 2023-03-23 03:49:59 | foam | 1 | 13983 | 9 | 0.220 | 63559.1 |
547 | 2023-03-20 05:54:18 | foam | 1 | 13983 | 9 | 0.203 | 68881.8 |
546 | 2023-03-19 08:11:04 | foam | 2 | 29872 | 206 | 0.750 | 39829.3 |
545 | 2023-01-07 04:33:33 | foam | 1 | 13983 | 9 | 0.226 | 61871.7 |
544 | 2022-12-20 15:36:28 | foam | 2 | 29872 | 206 | 0.733 | 40753.1 |
543 | 2022-12-08 08:16:02 | foam | 1 | 13983 | 9 | 0.233 | 60012.9 |
542 | 2022-12-05 01:34:14 | foam | 1 | 13983 | 9 | 0.236 | 59250.0 |
541 | 2022-10-04 23:06:00 | foam | 1 | 13983 | 9 | 0.203 | 68881.8 |
540 | 2022-09-03 17:15:52 | foam | 1 | 13983 | 9 | 0.250 | 55932.0 |
539 | 2022-09-01 23:40:03 | foam | 1 | 13983 | 9 | 0.326 | 42892.6 |
538 | 2022-08-31 16:11:47 | foam | 1 | 13983 | 9 | 0.250 | 55932.0 |
537 | 2022-08-17 19:22:41 | foam | 1 | 13983 | 9 | 0.216 | 64736.1 |
536 | 2022-08-16 00:12:13 | foam | 2 | 29872 | 206 | 0.733 | 40753.1 |
535 | 2022-08-14 16:24:25 | foam | 1 | 13983 | 9 | 0.233 | 60012.9 |
534 | 2022-08-10 15:54:05 | foam | 1 | 13983 | 9 | 0.220 | 63559.1 |
533 | 2022-08-02 23:53:29 | foam | 1 | 13983 | 9 | 0.216 | 64736.1 |
532 | 2022-05-28 20:55:35 | foam | 1 | 13983 | 9 | 0.203 | 68881.8 |
531 | 2022-05-18 22:22:14 | foam | 1 | 13983 | 9 | 0.220 | 63559.1 |
530 | 2022-05-08 23:17:08 | foam | 1 | 13983 | 9 | 0.220 | 63559.1 |
529 | 2022-03-16 11:46:12 | foam | 2 | 29872 | 206 | 0.953 | 31345.2 |
528 | 2022-03-14 07:49:34 | foam | 2 | 29872 | 206 | 0.873 | 34217.6 |
527 | 2022-02-17 16:38:23 | foam | 1 | 13983 | 9 | 0.203 | 68881.8 |
526 | 2022-02-15 12:23:47 | foam | 1 | 13983 | 9 | 0.250 | 55932.0 |
525 | 2022-02-03 23:01:52 | foam | 1 | 13983 | 9 | 0.250 | 55932.0 |
524 | 2021-12-03 14:19:42 | foam | 2 | 29872 | 206 | 0.856 | 34897.2 |
523 | 2021-12-01 13:28:16 | foam | 2 | 29872 | 206 | 0.873 | 34217.6 |
522 | 2021-11-14 03:23:44 | foam | 1 | 13983 | 9 | 0.203 | 68881.8 |
521 | 2021-11-03 06:29:35 | foam | 1 | 13983 | 9 | 0.220 | 63559.1 |
520 | 2021-09-29 17:20:31 | foam | 1 | 13983 | 9 | 0.233 | 60012.9 |
519 | 2021-09-22 00:50:12 | foam | 2 | 29872 | 206 | 0.843 | 35435.3 |
518 | 2021-09-01 13:38:01 | foam | 1 | 13983 | 9 | 0.250 | 55932.0 |
517 | 2021-08-30 07:55:51 | foam | 1 | 13983 | 9 | 0.220 | 63559.1 |
516 | 2021-08-17 06:49:11 | foam | 1 | 13983 | 9 | 0.220 | 63559.1 |
515 | 2021-08-15 02:45:48 | foam | 1 | 13983 | 9 | 0.203 | 68881.8 |
514 | 2021-08-03 12:01:10 | foam | 1 | 13983 | 9 | 0.250 | 55932.0 |
513 | 2021-06-03 06:26:27 | foam | 1 | 13983 | 9 | 0.203 | 68881.8 |
512 | 2021-05-08 23:08:28 | foam | 1 | 13983 | 9 | 0.483 | 28950.3 |
511 | 2021-04-29 02:32:30 | foam | 1 | 13983 | 9 | 0.233 | 60012.9 |
510 | 2021-04-07 11:32:02 | foam | 1 | 13983 | 9 | 0.236 | 59250.0 |
509 | 2021-03-11 17:41:13 | foam | 1 | 13983 | 9 | 0.216 | 64736.1 |
508 | 2021-01-24 16:45:45 | foam | 1 | 13983 | 9 | 0.203 | 68881.8 |
507 | 2021-01-22 13:46:37 | foam | 1 | 13983 | 9 | 0.203 | 68881.8 |
506 | 2020-12-27 16:15:21 | foam | 1 | 13983 | 9 | 0.233 | 60012.9 |
505 | 2020-11-27 03:12:22 | foam | 1 | 13983 | 9 | 0.220 | 63559.1 |