History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"compare"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
615 | 2024-04-27 04:48:39 | compare | 1 | 69583 | 7 | 1.393 | 49951.9 |
614 | 2024-04-14 13:46:59 | compare | 3 | 134027 | 257 | 17.670 | 7585.0 |
613 | 2024-04-10 23:34:20 | compare | 3 | 134027 | 257 | 7.720 | 17361.0 |
612 | 2024-04-10 01:20:11 | compare | 3 | 134027 | 257 | 14.233 | 9416.6 |
611 | 2024-04-09 21:36:32 | compare | 3 | 134027 | 257 | 6.953 | 19276.1 |
610 | 2024-04-09 10:58:44 | compare | 3 | 134027 | 257 | 33.300 | 4024.8 |
609 | 2024-04-08 22:02:13 | compare | 3 | 134027 | 257 | 23.656 | 5665.7 |
608 | 2024-04-08 22:02:14 | compare | 2 | 107671 | 30 | 7.750 | 13893.0 |
607 | 2024-04-08 21:52:58 | compare | 1 | 69583 | 7 | 2.390 | 29114.2 |
606 | 2024-03-10 10:17:32 | compare | 3 | 134027 | 257 | 8.516 | 15738.3 |
605 | 2024-03-09 19:27:57 | compare | 3 | 134027 | 257 | 12.986 | 10320.9 |
604 | 2024-03-09 04:12:12 | compare | 3 | 134027 | 257 | 8.953 | 14970.1 |
603 | 2024-03-09 04:12:12 | compare | 2 | 107671 | 30 | 3.670 | 29338.1 |
602 | 2024-03-09 04:11:12 | compare | 1 | 69583 | 7 | 1.110 | 62687.4 |
601 | 2024-03-07 14:52:54 | compare | 2 | 107671 | 30 | 3.203 | 33615.7 |
600 | 2024-03-07 13:10:41 | compare | 1 | 69583 | 7 | 1.266 | 54962.9 |
599 | 2024-02-25 23:05:22 | compare | 1 | 69583 | 7 | 2.750 | 25302.9 |
598 | 2024-02-18 21:01:20 | compare | 1 | 69583 | 7 | 1.280 | 54361.7 |
597 | 2024-02-18 09:18:45 | compare | 3 | 134027 | 257 | 22.626 | 5923.6 |
596 | 2024-02-15 10:08:41 | compare | 2 | 107671 | 30 | 3.390 | 31761.4 |
595 | 2024-02-15 09:25:17 | compare | 3 | 134027 | 257 | 6.890 | 19452.4 |
594 | 2024-02-09 05:35:54 | compare | 2 | 107671 | 30 | 3.706 | 29053.2 |
593 | 2024-02-09 05:35:32 | compare | 3 | 134027 | 257 | 7.500 | 17870.3 |
592 | 2024-02-08 07:57:41 | compare | 3 | 134027 | 257 | 13.076 | 10249.8 |
591 | 2024-02-08 03:48:22 | compare | 3 | 134027 | 257 | 10.423 | 12858.8 |
590 | 2024-02-08 03:48:21 | compare | 2 | 107671 | 30 | 7.080 | 15207.8 |
589 | 2024-02-08 03:48:03 | compare | 1 | 69583 | 7 | 1.233 | 56433.9 |
588 | 2024-01-25 23:08:36 | compare | 1 | 69583 | 7 | 1.330 | 52318.0 |
587 | 2024-01-22 10:07:38 | compare | 1 | 69583 | 7 | 1.250 | 55666.4 |
586 | 2024-01-17 21:49:08 | compare | 1 | 69583 | 7 | 1.250 | 55666.4 |
585 | 2024-01-08 22:04:55 | compare | 1 | 69583 | 7 | 1.356 | 51314.9 |
584 | 2023-12-10 20:54:38 | compare | 3 | 134027 | 257 | 14.456 | 9271.4 |
583 | 2023-12-10 20:54:33 | compare | 2 | 107671 | 30 | 3.860 | 27894.0 |
582 | 2023-12-03 12:13:24 | compare | 3 | 134027 | 257 | 6.846 | 19577.4 |
581 | 2023-12-03 12:13:25 | compare | 2 | 107671 | 30 | 3.423 | 31455.2 |
580 | 2023-11-27 05:58:01 | compare | 3 | 134027 | 257 | 6.280 | 21341.9 |
579 | 2023-11-27 05:57:41 | compare | 2 | 107671 | 30 | 3.203 | 33615.7 |
578 | 2023-11-19 16:55:47 | compare | 1 | 69583 | 7 | 1.093 | 63662.4 |
577 | 2023-11-11 01:27:46 | compare | 1 | 69583 | 7 | 1.190 | 58473.1 |
576 | 2023-11-10 02:03:16 | compare | 1 | 69583 | 7 | 1.076 | 64668.2 |
575 | 2023-10-27 23:37:17 | compare | 1 | 69583 | 7 | 1.186 | 58670.3 |
574 | 2023-10-20 04:03:50 | compare | 1 | 69583 | 7 | 1.186 | 58670.3 |
573 | 2023-10-18 00:15:36 | compare | 1 | 69583 | 7 | 1.233 | 56433.9 |
572 | 2023-10-14 04:05:35 | compare | 1 | 69583 | 7 | 1.093 | 63662.4 |
571 | 2023-10-04 05:38:23 | compare | 1 | 69583 | 7 | 1.093 | 63662.4 |
570 | 2023-09-24 06:37:55 | compare | 1 | 69583 | 7 | 1.110 | 62687.4 |
569 | 2023-09-23 12:29:11 | compare | 1 | 69583 | 7 | 1.140 | 61037.7 |
568 | 2023-09-21 00:07:30 | compare | 1 | 69583 | 7 | 1.220 | 57035.2 |
567 | 2023-09-12 05:32:35 | compare | 1 | 69583 | 7 | 1.123 | 61961.7 |
566 | 2023-09-05 08:32:49 | compare | 1 | 69583 | 7 | 1.143 | 60877.5 |
565 | 2023-07-31 20:06:41 | compare | 1 | 69583 | 7 | 1.236 | 56296.9 |
564 | 2023-07-30 16:57:18 | compare | 1 | 69583 | 7 | 1.250 | 55666.4 |
563 | 2023-07-29 05:04:43 | compare | 1 | 69583 | 7 | 1.076 | 64668.2 |
562 | 2023-07-27 09:51:54 | compare | 1 | 69583 | 7 | 1.080 | 64428.7 |
561 | 2023-07-26 08:00:15 | compare | 1 | 69583 | 7 | 1.233 | 56433.9 |
560 | 2023-07-25 14:59:32 | compare | 1 | 69583 | 7 | 1.080 | 64428.7 |
559 | 2023-07-24 14:32:56 | compare | 1 | 69583 | 7 | 1.263 | 55093.4 |
558 | 2023-07-22 19:56:50 | compare | 1 | 69583 | 7 | 1.123 | 61961.7 |
557 | 2023-07-21 13:50:57 | compare | 1 | 69583 | 7 | 1.170 | 59472.6 |
556 | 2023-07-20 10:45:37 | compare | 1 | 69583 | 7 | 1.220 | 57035.2 |
555 | 2023-07-19 06:24:57 | compare | 1 | 69583 | 7 | 1.110 | 62687.4 |
554 | 2023-07-12 02:30:58 | compare | 1 | 69583 | 7 | 1.203 | 57841.2 |
553 | 2023-07-10 08:28:25 | compare | 1 | 69583 | 7 | 1.093 | 63662.4 |
552 | 2023-07-09 18:23:46 | compare | 1 | 69583 | 7 | 1.080 | 64428.7 |
551 | 2023-07-08 18:01:47 | compare | 1 | 69583 | 7 | 1.080 | 64428.7 |
550 | 2023-07-08 05:16:25 | compare | 1 | 69583 | 7 | 1.060 | 65644.3 |
549 | 2023-07-07 15:45:19 | compare | 1 | 69583 | 7 | 1.096 | 63488.1 |
548 | 2023-07-06 22:59:57 | compare | 1 | 69583 | 7 | 1.200 | 57985.8 |
547 | 2023-07-06 04:58:04 | compare | 1 | 69583 | 7 | 1.106 | 62914.1 |
546 | 2023-07-04 20:22:50 | compare | 1 | 69583 | 7 | 1.186 | 58670.3 |
545 | 2023-07-04 01:19:36 | compare | 1 | 69583 | 7 | 1.313 | 52995.4 |
544 | 2023-07-03 10:20:43 | compare | 1 | 69583 | 7 | 2.266 | 30707.4 |
543 | 2023-07-02 14:30:10 | compare | 1 | 69583 | 7 | 1.143 | 60877.5 |
542 | 2023-07-02 00:11:12 | compare | 1 | 69583 | 7 | 1.236 | 56296.9 |
541 | 2023-07-01 06:37:52 | compare | 1 | 69583 | 7 | 1.203 | 57841.2 |
540 | 2023-06-30 14:41:56 | compare | 1 | 69583 | 7 | 2.420 | 28753.3 |
539 | 2023-06-30 00:23:41 | compare | 1 | 69583 | 7 | 1.156 | 60192.9 |
538 | 2023-06-29 11:25:41 | compare | 1 | 69583 | 7 | 1.093 | 63662.4 |
537 | 2023-06-28 18:46:58 | compare | 1 | 69583 | 7 | 1.233 | 56433.9 |
536 | 2023-06-27 22:21:53 | compare | 1 | 69583 | 7 | 1.250 | 55666.4 |
535 | 2023-06-27 07:19:26 | compare | 1 | 69583 | 7 | 1.126 | 61796.6 |
534 | 2023-06-26 19:57:47 | compare | 1 | 69583 | 7 | 1.093 | 63662.4 |
533 | 2023-06-26 00:11:04 | compare | 1 | 69583 | 7 | 1.093 | 63662.4 |
532 | 2023-06-25 06:58:33 | compare | 1 | 69583 | 7 | 1.110 | 62687.4 |
531 | 2023-06-24 14:41:58 | compare | 1 | 69583 | 7 | 2.436 | 28564.4 |
530 | 2023-06-24 01:00:59 | compare | 1 | 69583 | 7 | 1.096 | 63488.1 |
529 | 2023-06-23 11:57:28 | compare | 1 | 69583 | 7 | 1.093 | 63662.4 |
528 | 2023-06-22 16:45:35 | compare | 1 | 69583 | 7 | 1.110 | 62687.4 |
527 | 2023-06-22 00:10:19 | compare | 1 | 69583 | 7 | 1.156 | 60192.9 |
526 | 2023-06-21 06:30:30 | compare | 1 | 69583 | 7 | 1.096 | 63488.1 |
525 | 2023-06-20 17:22:24 | compare | 1 | 69583 | 7 | 1.186 | 58670.3 |
524 | 2023-06-20 00:16:13 | compare | 1 | 69583 | 7 | 1.186 | 58670.3 |
523 | 2023-06-19 07:20:38 | compare | 1 | 69583 | 7 | 1.093 | 63662.4 |
522 | 2023-06-18 19:57:02 | compare | 1 | 69583 | 7 | 1.186 | 58670.3 |
521 | 2023-06-18 00:08:52 | compare | 1 | 69583 | 7 | 1.093 | 63662.4 |
520 | 2023-06-16 20:44:12 | compare | 1 | 69583 | 7 | 1.250 | 55666.4 |
519 | 2023-06-16 03:22:31 | compare | 1 | 69583 | 7 | 1.110 | 62687.4 |
518 | 2023-06-15 15:40:27 | compare | 1 | 69583 | 7 | 1.173 | 59320.5 |
517 | 2023-06-14 03:01:35 | compare | 1 | 69583 | 7 | 1.093 | 63662.4 |
516 | 2023-06-13 10:15:52 | compare | 1 | 69583 | 7 | 1.173 | 59320.5 |