History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sandman"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
611 | 2024-04-24 19:28:40 | sandman | 3 | 134027 | 222 | 23.440 | 5717.9 |
610 | 2024-04-24 18:03:14 | sandman | 1 | 69583 | 3 | 1.216 | 57222.9 |
609 | 2024-04-22 20:02:42 | sandman | 3 | 134027 | 222 | 6.533 | 20515.4 |
608 | 2024-04-22 17:48:34 | sandman | 3 | 134027 | 222 | 23.236 | 5768.1 |
607 | 2024-04-22 11:04:46 | sandman | 3 | 134027 | 222 | 14.846 | 9027.8 |
606 | 2024-04-20 21:52:12 | sandman | 2 | 107671 | 25 | 8.110 | 13276.3 |
605 | 2024-04-20 21:43:01 | sandman | 3 | 134027 | 222 | 11.876 | 11285.5 |
604 | 2024-04-20 15:50:51 | sandman | 3 | 134027 | 222 | 9.750 | 13746.4 |
603 | 2024-04-20 15:50:51 | sandman | 2 | 107671 | 25 | 4.856 | 22172.8 |
602 | 2024-04-07 06:31:05 | sandman | 1 | 69583 | 3 | 4.533 | 15350.3 |
601 | 2024-02-11 03:42:46 | sandman | 2 | 107671 | 25 | 5.360 | 20087.9 |
600 | 2024-02-04 18:19:06 | sandman | 3 | 134027 | 222 | 6.783 | 19759.3 |
599 | 2024-02-03 01:07:41 | sandman | 2 | 107671 | 25 | 2.906 | 37051.3 |
598 | 2024-02-03 01:07:37 | sandman | 1 | 69583 | 3 | 1.233 | 56433.9 |
597 | 2024-01-28 22:38:21 | sandman | 3 | 134027 | 222 | 6.593 | 20328.7 |
596 | 2024-01-14 11:55:02 | sandman | 2 | 107671 | 25 | 3.656 | 29450.5 |
595 | 2024-01-12 11:12:46 | sandman | 1 | 69583 | 3 | 1.250 | 55666.4 |
594 | 2024-01-04 22:45:32 | sandman | 1 | 69583 | 3 | 2.733 | 25460.3 |
593 | 2024-01-02 05:05:47 | sandman | 1 | 69583 | 3 | 1.330 | 52318.0 |
592 | 2023-12-06 12:27:17 | sandman | 2 | 107671 | 25 | 3.436 | 31336.1 |
591 | 2023-11-20 08:48:29 | sandman | 3 | 134027 | 222 | 7.330 | 18284.7 |
590 | 2023-11-17 05:21:32 | sandman | 1 | 69583 | 3 | 1.220 | 57035.2 |
589 | 2023-11-13 01:28:11 | sandman | 2 | 107671 | 25 | 2.953 | 36461.6 |
588 | 2023-11-10 18:36:06 | sandman | 3 | 134027 | 222 | 7.003 | 19138.5 |
587 | 2023-11-10 15:51:35 | sandman | 3 | 134027 | 222 | 6.486 | 20664.0 |
586 | 2023-11-07 18:41:03 | sandman | 3 | 134027 | 222 | 6.000 | 22337.8 |
585 | 2023-10-29 01:01:42 | sandman | 1 | 69583 | 3 | 1.266 | 54962.9 |
584 | 2023-10-27 14:16:45 | sandman | 1 | 69583 | 3 | 1.656 | 42018.7 |
583 | 2023-09-29 10:58:54 | sandman | 1 | 69583 | 3 | 1.110 | 62687.4 |
582 | 2023-09-16 14:46:10 | sandman | 1 | 69583 | 3 | 1.203 | 57841.2 |
581 | 2023-09-05 23:11:52 | sandman | 1 | 69583 | 3 | 1.203 | 57841.2 |
580 | 2023-08-20 20:38:24 | sandman | 1 | 69583 | 3 | 1.296 | 53690.6 |
579 | 2023-08-15 21:05:00 | sandman | 2 | 107671 | 25 | 3.373 | 31921.4 |
578 | 2023-08-12 02:11:52 | sandman | 3 | 134027 | 222 | 7.033 | 19056.9 |
577 | 2023-05-24 11:49:32 | sandman | 1 | 69583 | 3 | 1.093 | 63662.4 |
576 | 2023-05-06 01:04:02 | sandman | 1 | 69583 | 3 | 1.263 | 55093.4 |
575 | 2023-04-27 23:31:53 | sandman | 2 | 107671 | 25 | 3.436 | 31336.1 |
574 | 2023-04-25 02:58:17 | sandman | 3 | 134027 | 222 | 6.656 | 20136.3 |
573 | 2023-03-17 08:29:01 | sandman | 1 | 69583 | 3 | 1.096 | 63488.1 |
572 | 2023-01-31 19:11:10 | sandman | 2 | 107671 | 25 | 2.860 | 37647.2 |
571 | 2023-01-30 06:47:02 | sandman | 1 | 69583 | 3 | 1.360 | 51164.0 |
570 | 2023-01-29 13:50:31 | sandman | 3 | 134027 | 222 | 5.986 | 22390.1 |
569 | 2023-01-08 19:42:44 | sandman | 1 | 69583 | 3 | 1.123 | 61961.7 |
568 | 2023-01-04 01:50:40 | sandman | 1 | 69583 | 3 | 2.186 | 31831.2 |
567 | 2022-11-13 00:05:35 | sandman | 2 | 107671 | 25 | 3.906 | 27565.5 |
566 | 2022-11-11 19:53:33 | sandman | 3 | 134027 | 222 | 5.843 | 22938.0 |
565 | 2022-09-27 19:48:50 | sandman | 1 | 69583 | 3 | 1.123 | 61961.7 |
564 | 2022-09-07 01:06:52 | sandman | 1 | 69583 | 3 | 1.126 | 61796.6 |
563 | 2022-05-30 20:06:08 | sandman | 3 | 134027 | 222 | 5.873 | 22820.9 |
562 | 2022-05-13 16:13:36 | sandman | 2 | 107671 | 25 | 3.783 | 28461.8 |
561 | 2022-05-10 02:24:35 | sandman | 1 | 69583 | 3 | 1.190 | 58473.1 |
560 | 2022-04-23 23:54:09 | sandman | 1 | 69583 | 3 | 1.123 | 61961.7 |
559 | 2022-02-04 16:01:00 | sandman | 1 | 69583 | 3 | 1.233 | 56433.9 |
558 | 2022-02-02 11:22:45 | sandman | 1 | 69583 | 3 | 2.500 | 27833.2 |
557 | 2022-01-01 06:32:41 | sandman | 1 | 69583 | 3 | 1.406 | 49490.0 |
556 | 2021-12-13 03:58:03 | sandman | 1 | 69583 | 3 | 1.123 | 61961.7 |
555 | 2021-09-18 18:02:31 | sandman | 1 | 69583 | 3 | 1.110 | 62687.4 |
554 | 2021-07-15 22:34:42 | sandman | 1 | 69583 | 3 | 1.143 | 60877.5 |
553 | 2021-06-18 21:45:14 | sandman | 1 | 69583 | 3 | 1.390 | 50059.7 |
552 | 2021-05-05 06:35:42 | sandman | 1 | 69583 | 3 | 1.156 | 60192.9 |
551 | 2021-03-12 16:16:25 | sandman | 1 | 69583 | 3 | 1.250 | 55666.4 |
550 | 2021-01-30 10:19:08 | sandman | 3 | 134027 | 222 | 6.000 | 22337.8 |
549 | 2021-01-18 06:58:03 | sandman | 1 | 69583 | 3 | 1.106 | 62914.1 |
548 | 2020-11-26 20:27:44 | sandman | 1 | 69583 | 3 | 1.110 | 62687.4 |
547 | 2020-11-23 21:44:42 | sandman | 1 | 69583 | 3 | 1.110 | 62687.4 |
546 | 2020-11-14 15:48:49 | sandman | 1 | 69583 | 3 | 1.170 | 59472.6 |
545 | 2020-10-31 19:29:04 | sandman | 1 | 69583 | 3 | 1.326 | 52475.9 |
544 | 2020-10-27 13:16:02 | sandman | 3 | 134027 | 222 | 8.123 | 16499.7 |
543 | 2020-10-17 13:08:31 | sandman | 1 | 69583 | 3 | 1.093 | 63662.4 |
542 | 2020-09-17 10:58:55 | sandman | 1 | 69583 | 3 | 1.110 | 62687.4 |
541 | 2020-08-28 06:09:26 | sandman | 1 | 69583 | 3 | 1.220 | 57035.2 |
540 | 2020-08-11 18:19:46 | sandman | 1 | 69583 | 3 | 1.203 | 57841.2 |
539 | 2020-08-09 15:12:46 | sandman | 1 | 69583 | 3 | 1.156 | 60192.9 |
538 | 2020-08-03 02:40:46 | sandman | 1 | 69583 | 3 | 1.203 | 57841.2 |
537 | 2020-05-18 18:37:26 | sandman | 1 | 69583 | 3 | 1.106 | 62914.1 |
536 | 2020-05-07 14:14:02 | sandman | 1 | 69583 | 3 | 1.216 | 57222.9 |
535 | 2020-04-18 04:49:01 | sandman | 1 | 69583 | 3 | 1.123 | 61961.7 |
534 | 2020-04-17 05:48:22 | sandman | 1 | 69583 | 3 | 1.156 | 60192.9 |
533 | 2020-04-16 05:33:50 | sandman | 1 | 69583 | 3 | 1.170 | 59472.6 |
532 | 2020-04-15 05:30:50 | sandman | 1 | 69583 | 3 | 1.126 | 61796.6 |
531 | 2020-03-30 03:58:59 | sandman | 1 | 69583 | 3 | 1.280 | 54361.7 |
530 | 2020-03-29 03:11:31 | sandman | 1 | 69583 | 3 | 1.376 | 50569.0 |
529 | 2020-03-25 01:09:12 | sandman | 1 | 69583 | 3 | 2.593 | 26834.9 |
528 | 2020-03-23 23:47:25 | sandman | 1 | 69583 | 3 | 1.313 | 52995.4 |
527 | 2020-03-20 23:26:08 | sandman | 1 | 69583 | 3 | 1.293 | 53815.2 |
526 | 2020-03-01 18:11:50 | sandman | 1 | 69583 | 3 | 1.160 | 59985.3 |
525 | 2020-02-27 04:22:05 | sandman | 1 | 69583 | 3 | 2.716 | 25619.7 |
524 | 2020-02-23 02:28:58 | sandman | 1 | 69583 | 3 | 1.296 | 53690.6 |
523 | 2020-02-14 01:10:27 | sandman | 1 | 69583 | 3 | 1.406 | 49490.0 |
522 | 2020-02-12 13:51:27 | sandman | 1 | 69583 | 3 | 2.716 | 25619.7 |
521 | 2020-02-05 14:45:57 | sandman | 1 | 69583 | 3 | 1.390 | 50059.7 |
520 | 2020-02-03 18:58:39 | sandman | 1 | 69583 | 3 | 2.950 | 23587.5 |
519 | 2020-02-03 02:55:32 | sandman | 1 | 69583 | 3 | 1.593 | 43680.5 |
518 | 2020-02-02 03:11:29 | sandman | 1 | 69583 | 3 | 4.343 | 16021.9 |
517 | 2020-01-31 10:06:18 | sandman | 1 | 69583 | 3 | 2.830 | 24587.6 |
516 | 2020-01-27 19:51:54 | sandman | 1 | 69583 | 3 | 2.703 | 25742.9 |
515 | 2020-01-23 01:28:13 | sandman | 1 | 69583 | 3 | 2.170 | 32065.9 |
514 | 2020-01-16 16:09:48 | sandman | 1 | 69583 | 3 | 2.733 | 25460.3 |
513 | 2020-01-15 03:06:50 | sandman | 1 | 69583 | 3 | 2.156 | 32274.1 |
512 | 2020-01-11 21:22:59 | sandman | 1 | 69583 | 3 | 2.170 | 32065.9 |