History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"compared"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
608 | 2024-04-26 21:40:45 | compared | 1 | 82945 | 6 | 3.403 | 24374.1 |
607 | 2024-04-26 11:37:03 | compared | 1 | 82945 | 6 | 3.253 | 25498.0 |
606 | 2024-04-24 22:05:12 | compared | 1 | 82945 | 6 | 1.296 | 64000.8 |
605 | 2024-04-24 04:45:24 | compared | 1 | 82945 | 6 | 3.626 | 22875.1 |
604 | 2024-04-23 21:59:21 | compared | 1 | 82945 | 6 | 3.936 | 21073.4 |
603 | 2024-04-23 03:16:28 | compared | 1 | 82945 | 6 | 1.623 | 51106.0 |
602 | 2024-04-22 02:37:55 | compared | 1 | 82945 | 6 | 6.796 | 12205.0 |
601 | 2024-04-21 03:20:50 | compared | 1 | 82945 | 6 | 4.206 | 19720.6 |
600 | 2024-04-18 14:49:46 | compared | 1 | 82945 | 6 | 5.686 | 14587.6 |
599 | 2024-04-17 15:27:04 | compared | 1 | 82945 | 6 | 5.470 | 15163.6 |
598 | 2024-04-17 00:39:33 | compared | 1 | 82945 | 6 | 4.233 | 19594.8 |
597 | 2024-04-16 00:28:41 | compared | 1 | 82945 | 6 | 1.330 | 62364.7 |
596 | 2024-04-15 00:05:43 | compared | 1 | 82945 | 6 | 1.983 | 41828.0 |
595 | 2024-04-13 23:52:44 | compared | 1 | 82945 | 6 | 2.016 | 41143.4 |
594 | 2024-04-10 21:23:51 | compared | 1 | 82945 | 6 | 1.876 | 44213.8 |
593 | 2024-04-09 20:38:23 | compared | 1 | 82945 | 6 | 3.033 | 27347.5 |
592 | 2024-04-08 20:37:45 | compared | 1 | 82945 | 6 | 1.576 | 52630.1 |
591 | 2024-04-08 07:35:20 | compared | 1 | 82945 | 6 | 5.626 | 14743.2 |
590 | 2024-04-07 18:45:07 | compared | 1 | 82945 | 6 | 1.703 | 48705.2 |
589 | 2024-04-06 18:48:34 | compared | 1 | 82945 | 6 | 1.686 | 49196.3 |
588 | 2024-04-05 18:46:46 | compared | 1 | 82945 | 6 | 1.673 | 49578.6 |
587 | 2024-04-05 09:58:29 | compared | 1 | 82945 | 6 | 3.173 | 26140.9 |
586 | 2024-04-04 09:26:34 | compared | 1 | 82945 | 6 | 1.813 | 45750.1 |
585 | 2024-04-03 09:53:41 | compared | 1 | 82945 | 6 | 3.656 | 22687.4 |
584 | 2024-04-01 21:10:29 | compared | 1 | 82945 | 6 | 1.453 | 57085.3 |
583 | 2024-03-31 19:47:02 | compared | 3 | 146162 | 185 | 24.236 | 6030.8 |
582 | 2024-03-31 01:49:09 | compared | 2 | 121059 | 30 | 11.063 | 10942.7 |
581 | 2024-03-30 22:31:47 | compared | 3 | 146162 | 185 | 21.610 | 6763.6 |
580 | 2024-03-30 22:31:41 | compared | 2 | 121059 | 30 | 5.516 | 21946.9 |
579 | 2024-03-30 02:59:55 | compared | 3 | 146162 | 185 | 8.000 | 18270.3 |
578 | 2024-03-30 00:50:53 | compared | 3 | 146162 | 185 | 15.270 | 9571.8 |
577 | 2024-03-30 00:50:56 | compared | 2 | 121059 | 30 | 10.000 | 12105.9 |
576 | 2024-03-29 23:54:11 | compared | 1 | 82945 | 6 | 1.673 | 49578.6 |
575 | 2024-03-29 05:13:45 | compared | 1 | 82945 | 6 | 5.033 | 16480.2 |
574 | 2024-03-29 02:28:12 | compared | 1 | 82945 | 6 | 2.126 | 39014.6 |
573 | 2024-03-28 02:44:26 | compared | 1 | 82945 | 6 | 1.483 | 55930.5 |
572 | 2024-03-27 14:07:44 | compared | 1 | 82945 | 6 | 1.406 | 58993.6 |
571 | 2024-03-27 02:11:21 | compared | 1 | 82945 | 6 | 1.640 | 50576.2 |
570 | 2024-03-26 02:47:10 | compared | 1 | 82945 | 6 | 1.596 | 51970.6 |
569 | 2024-03-25 18:04:35 | compared | 1 | 82945 | 6 | 1.846 | 44932.3 |
568 | 2024-03-25 01:53:57 | compared | 1 | 82945 | 6 | 1.576 | 52630.1 |
567 | 2024-03-24 01:46:52 | compared | 1 | 82945 | 6 | 1.456 | 56967.7 |
566 | 2024-03-23 15:21:54 | compared | 1 | 82945 | 6 | 1.406 | 58993.6 |
565 | 2024-03-23 02:22:29 | compared | 1 | 82945 | 6 | 2.953 | 28088.4 |
564 | 2024-03-22 00:09:00 | compared | 1 | 82945 | 6 | 3.420 | 24252.9 |
563 | 2024-03-20 23:33:45 | compared | 1 | 82945 | 6 | 5.126 | 16181.2 |
562 | 2024-03-19 22:33:06 | compared | 1 | 82945 | 6 | 1.440 | 57600.7 |
561 | 2024-03-17 07:13:17 | compared | 1 | 82945 | 6 | 4.796 | 17294.6 |
560 | 2024-03-17 00:23:58 | compared | 1 | 82945 | 6 | 1.360 | 60989.0 |
559 | 2024-03-15 23:49:40 | compared | 1 | 82945 | 6 | 1.330 | 62364.7 |
558 | 2024-03-15 07:01:17 | compared | 1 | 82945 | 6 | 2.030 | 40859.6 |
557 | 2024-03-14 17:56:06 | compared | 1 | 82945 | 6 | 3.436 | 24140.0 |
556 | 2024-03-14 07:00:40 | compared | 1 | 82945 | 6 | 1.313 | 63172.1 |
555 | 2024-03-13 17:47:37 | compared | 1 | 82945 | 6 | 3.390 | 24467.6 |
554 | 2024-03-13 17:30:41 | compared | 1 | 82945 | 6 | 1.686 | 49196.3 |
553 | 2024-03-12 18:01:05 | compared | 1 | 82945 | 6 | 1.470 | 56425.2 |
552 | 2024-03-12 04:59:05 | compared | 1 | 82945 | 6 | 1.656 | 50087.6 |
551 | 2024-03-11 04:10:00 | compared | 1 | 82945 | 6 | 1.563 | 53067.8 |
550 | 2024-03-10 19:21:49 | compared | 1 | 82945 | 6 | 1.706 | 48619.6 |
549 | 2024-03-10 05:21:50 | compared | 1 | 82945 | 6 | 4.500 | 18432.2 |
548 | 2024-03-07 12:02:31 | compared | 1 | 82945 | 6 | 6.890 | 12038.5 |
547 | 2024-03-07 01:05:31 | compared | 1 | 82945 | 6 | 1.436 | 57761.1 |
546 | 2024-03-06 12:26:59 | compared | 1 | 82945 | 6 | 6.330 | 13103.5 |
545 | 2024-03-06 01:09:25 | compared | 1 | 82945 | 6 | 1.593 | 52068.4 |
544 | 2024-03-04 19:59:39 | compared | 1 | 82945 | 6 | 1.686 | 49196.3 |
543 | 2024-03-03 18:55:34 | compared | 1 | 82945 | 6 | 2.736 | 30316.2 |
542 | 2024-03-03 03:24:56 | compared | 1 | 82945 | 6 | 2.910 | 28503.4 |
541 | 2024-03-02 03:35:52 | compared | 1 | 82945 | 6 | 4.953 | 16746.4 |
540 | 2024-03-01 15:44:27 | compared | 2 | 121059 | 30 | 12.813 | 9448.1 |
539 | 2024-03-01 13:43:51 | compared | 3 | 146162 | 185 | 8.750 | 16704.2 |
538 | 2024-03-01 04:33:30 | compared | 1 | 82945 | 6 | 1.516 | 54713.1 |
537 | 2024-02-29 18:46:32 | compared | 3 | 146162 | 185 | 15.330 | 9534.4 |
536 | 2024-02-29 16:47:03 | compared | 1 | 82945 | 6 | 3.093 | 26817.0 |
535 | 2024-02-29 16:26:00 | compared | 1 | 82945 | 6 | 1.516 | 54713.1 |
534 | 2024-02-29 12:41:11 | compared | 2 | 121059 | 30 | 3.656 | 33112.4 |
533 | 2024-02-29 04:22:53 | compared | 1 | 82945 | 6 | 1.626 | 51011.7 |
532 | 2024-02-28 19:56:57 | compared | 1 | 82945 | 6 | 1.640 | 50576.2 |
531 | 2024-02-28 16:21:02 | compared | 2 | 121059 | 30 | 4.436 | 27290.1 |
530 | 2024-02-28 16:20:52 | compared | 3 | 146162 | 185 | 9.000 | 16240.2 |
529 | 2024-02-28 14:08:30 | compared | 1 | 82945 | 6 | 1.280 | 64800.8 |
528 | 2024-02-27 23:28:29 | compared | 1 | 82945 | 6 | 1.643 | 50483.9 |
527 | 2024-02-27 19:37:07 | compared | 1 | 82945 | 6 | 1.423 | 58288.8 |
526 | 2024-02-26 19:39:25 | compared | 1 | 82945 | 6 | 1.360 | 60989.0 |
525 | 2024-02-26 11:41:27 | compared | 1 | 82945 | 6 | 1.516 | 54713.1 |
524 | 2024-02-25 19:31:08 | compared | 1 | 82945 | 6 | 1.456 | 56967.7 |
523 | 2024-02-25 15:53:33 | compared | 1 | 82945 | 6 | 1.733 | 47862.1 |
522 | 2024-02-25 10:31:03 | compared | 1 | 82945 | 6 | 4.610 | 17992.4 |
521 | 2024-02-24 20:00:20 | compared | 1 | 82945 | 6 | 1.686 | 49196.3 |
520 | 2024-02-24 19:52:58 | compared | 1 | 82945 | 6 | 1.640 | 50576.2 |
519 | 2024-02-24 18:31:07 | compared | 1 | 82945 | 6 | 1.420 | 58412.0 |
518 | 2024-02-23 18:36:02 | compared | 1 | 82945 | 6 | 1.440 | 57600.7 |
517 | 2024-02-23 16:51:28 | compared | 1 | 82945 | 6 | 1.656 | 50087.6 |
516 | 2024-02-22 18:08:23 | compared | 1 | 82945 | 6 | 1.486 | 55817.6 |
515 | 2024-02-21 18:16:18 | compared | 1 | 82945 | 6 | 1.500 | 55296.7 |
514 | 2024-02-20 18:20:43 | compared | 1 | 82945 | 6 | 1.563 | 53067.8 |
513 | 2024-02-19 18:12:41 | compared | 1 | 82945 | 6 | 1.440 | 57600.7 |
512 | 2024-02-14 03:37:50 | compared | 1 | 82945 | 6 | 3.423 | 24231.7 |
511 | 2024-02-13 03:34:13 | compared | 1 | 82945 | 6 | 1.296 | 64000.8 |
510 | 2024-02-12 04:50:26 | compared | 1 | 82945 | 6 | 3.266 | 25396.5 |
509 | 2024-02-11 15:32:38 | compared | 1 | 82945 | 6 | 1.673 | 49578.6 |