History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"finches"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
576 | 2024-05-02 10:19:30 | finches | 1 | 69583 | 9 | 1.406 | 49490.0 |
575 | 2024-04-27 18:15:48 | finches | 3 | 134027 | 576 | 13.623 | 9838.3 |
574 | 2024-04-27 16:29:15 | finches | 1 | 69583 | 9 | 1.376 | 50569.0 |
573 | 2024-04-26 11:58:46 | finches | 2 | 107671 | 86 | 11.173 | 9636.7 |
572 | 2024-04-26 11:56:33 | finches | 3 | 134027 | 576 | 9.250 | 14489.4 |
571 | 2024-04-25 15:48:50 | finches | 1 | 69583 | 9 | 1.250 | 55666.4 |
570 | 2024-04-24 14:00:57 | finches | 3 | 134027 | 576 | 16.596 | 8075.9 |
569 | 2024-04-23 03:50:59 | finches | 2 | 107671 | 86 | 11.420 | 9428.3 |
568 | 2024-04-20 21:18:59 | finches | 3 | 134027 | 576 | 17.576 | 7625.6 |
567 | 2024-04-20 18:50:19 | finches | 3 | 134027 | 576 | 24.863 | 5390.6 |
566 | 2024-04-20 06:21:08 | finches | 3 | 134027 | 576 | 22.126 | 6057.4 |
565 | 2024-04-18 22:58:03 | finches | 3 | 134027 | 576 | 7.720 | 17361.0 |
564 | 2024-04-18 21:10:34 | finches | 2 | 107671 | 86 | 4.376 | 24604.9 |
563 | 2024-04-17 01:38:44 | finches | 2 | 107671 | 86 | 4.080 | 26390.0 |
562 | 2024-03-28 17:28:04 | finches | 1 | 69583 | 9 | 2.360 | 29484.3 |
561 | 2024-03-04 13:53:46 | finches | 1 | 69583 | 9 | 1.063 | 65459.1 |
560 | 2024-02-29 21:27:08 | finches | 2 | 107671 | 86 | 3.330 | 32333.6 |
559 | 2024-02-29 21:26:09 | finches | 3 | 134027 | 576 | 7.686 | 17437.8 |
558 | 2024-02-28 15:31:08 | finches | 2 | 107671 | 86 | 8.923 | 12066.7 |
557 | 2024-02-28 08:55:01 | finches | 3 | 134027 | 576 | 9.533 | 14059.3 |
556 | 2024-02-27 00:44:04 | finches | 3 | 134027 | 576 | 6.470 | 20715.1 |
555 | 2024-02-27 00:44:03 | finches | 2 | 107671 | 86 | 3.233 | 33303.7 |
554 | 2024-02-27 00:44:01 | finches | 1 | 69583 | 9 | 1.203 | 57841.2 |
553 | 2024-02-17 20:38:16 | finches | 1 | 69583 | 9 | 1.186 | 58670.3 |
552 | 2024-02-17 13:57:40 | finches | 1 | 69583 | 9 | 1.203 | 57841.2 |
551 | 2023-12-28 10:45:21 | finches | 3 | 134027 | 576 | 6.640 | 20184.8 |
550 | 2023-12-28 10:45:19 | finches | 2 | 107671 | 86 | 3.170 | 33965.6 |
549 | 2023-12-20 03:58:15 | finches | 1 | 69583 | 9 | 1.110 | 62687.4 |
548 | 2023-12-19 20:05:13 | finches | 3 | 134027 | 576 | 5.720 | 23431.3 |
547 | 2023-12-15 14:24:21 | finches | 2 | 107671 | 86 | 2.890 | 37256.4 |
546 | 2023-12-04 17:37:49 | finches | 1 | 69583 | 9 | 1.190 | 58473.1 |
545 | 2023-12-02 12:05:29 | finches | 1 | 69583 | 9 | 1.123 | 61961.7 |
544 | 2023-11-23 13:15:29 | finches | 3 | 134027 | 576 | 5.673 | 23625.4 |
543 | 2023-11-23 13:15:24 | finches | 2 | 107671 | 86 | 3.343 | 32207.9 |
542 | 2023-11-18 07:41:10 | finches | 1 | 69583 | 9 | 1.186 | 58670.3 |
541 | 2023-11-13 22:14:27 | finches | 1 | 69583 | 9 | 1.250 | 55666.4 |
540 | 2023-11-05 10:20:02 | finches | 1 | 69583 | 9 | 1.170 | 59472.6 |
539 | 2023-11-05 00:39:53 | finches | 1 | 69583 | 9 | 1.046 | 66522.9 |
538 | 2023-10-21 19:20:12 | finches | 1 | 69583 | 9 | 1.203 | 57841.2 |
537 | 2023-10-05 04:44:35 | finches | 1 | 69583 | 9 | 1.140 | 61037.7 |
536 | 2023-10-04 07:20:31 | finches | 3 | 134027 | 576 | 11.420 | 11736.2 |
535 | 2023-10-01 06:15:29 | finches | 3 | 134027 | 576 | 7.970 | 16816.4 |
534 | 2023-09-28 03:47:16 | finches | 3 | 134027 | 576 | 14.440 | 9281.6 |
533 | 2023-09-26 05:56:19 | finches | 1 | 69583 | 9 | 1.173 | 59320.5 |
532 | 2023-09-24 13:43:34 | finches | 1 | 69583 | 9 | 2.423 | 28717.7 |
531 | 2023-09-20 18:16:16 | finches | 3 | 134027 | 576 | 5.563 | 24092.6 |
530 | 2023-09-19 12:08:33 | finches | 1 | 69583 | 9 | 1.186 | 58670.3 |
529 | 2023-09-15 20:13:24 | finches | 2 | 107671 | 86 | 2.783 | 38688.8 |
528 | 2023-07-29 04:40:24 | finches | 1 | 69583 | 9 | 1.156 | 60192.9 |
527 | 2023-07-14 07:51:44 | finches | 1 | 69583 | 9 | 1.190 | 58473.1 |
526 | 2023-07-08 12:52:51 | finches | 1 | 69583 | 9 | 1.186 | 58670.3 |
525 | 2023-06-27 19:54:17 | finches | 3 | 134027 | 576 | 6.610 | 20276.4 |
524 | 2023-06-16 20:20:27 | finches | 2 | 107671 | 86 | 3.110 | 34620.9 |
523 | 2023-04-20 20:53:06 | finches | 1 | 69583 | 9 | 1.220 | 57035.2 |
522 | 2023-04-20 06:31:31 | finches | 1 | 69583 | 9 | 1.046 | 66522.9 |
521 | 2023-03-23 07:29:33 | finches | 3 | 134027 | 576 | 6.236 | 21492.5 |
520 | 2023-03-17 11:42:36 | finches | 2 | 107671 | 86 | 2.733 | 39396.6 |
519 | 2023-02-07 13:32:32 | finches | 1 | 69583 | 9 | 1.156 | 60192.9 |
518 | 2023-01-08 11:32:47 | finches | 1 | 69583 | 9 | 1.050 | 66269.5 |
517 | 2022-12-28 19:26:26 | finches | 3 | 134027 | 576 | 6.690 | 20033.9 |
516 | 2022-12-22 06:08:31 | finches | 3 | 134027 | 576 | 6.156 | 21771.8 |
515 | 2022-12-18 15:18:43 | finches | 2 | 107671 | 86 | 2.920 | 36873.6 |
514 | 2022-12-05 21:40:33 | finches | 1 | 69583 | 9 | 1.046 | 66522.9 |
513 | 2022-12-03 11:11:41 | finches | 2 | 107671 | 86 | 7.126 | 15109.6 |
512 | 2022-11-12 15:58:55 | finches | 3 | 134027 | 576 | 6.420 | 20876.5 |
511 | 2022-10-31 00:08:23 | finches | 3 | 134027 | 576 | 6.500 | 20619.5 |
510 | 2022-10-24 06:49:46 | finches | 2 | 107671 | 86 | 2.720 | 39584.9 |
509 | 2022-10-21 05:00:42 | finches | 3 | 134027 | 576 | 5.983 | 22401.3 |
508 | 2022-09-24 15:58:47 | finches | 1 | 69583 | 9 | 1.173 | 59320.5 |
507 | 2022-09-22 05:06:16 | finches | 3 | 134027 | 576 | 5.626 | 23822.8 |
506 | 2022-09-21 01:37:03 | finches | 1 | 69583 | 9 | 1.063 | 65459.1 |
505 | 2022-08-21 09:09:46 | finches | 3 | 134027 | 576 | 5.486 | 24430.7 |
504 | 2022-08-15 01:32:27 | finches | 1 | 69583 | 9 | 1.140 | 61037.7 |
503 | 2022-08-13 14:15:06 | finches | 2 | 107671 | 86 | 2.843 | 37872.3 |
502 | 2022-08-06 19:55:02 | finches | 1 | 69583 | 9 | 1.110 | 62687.4 |
501 | 2022-08-04 12:15:40 | finches | 1 | 69583 | 9 | 1.313 | 52995.4 |
500 | 2022-07-29 09:36:33 | finches | 1 | 69583 | 9 | 1.156 | 60192.9 |
499 | 2022-07-10 10:49:22 | finches | 1 | 69583 | 9 | 1.096 | 63488.1 |
498 | 2022-06-04 02:35:41 | finches | 1 | 69583 | 9 | 1.160 | 59985.3 |
497 | 2022-05-08 07:10:20 | finches | 1 | 69583 | 9 | 1.106 | 62914.1 |
496 | 2022-03-27 11:09:41 | finches | 1 | 69583 | 9 | 1.233 | 56433.9 |
495 | 2022-03-25 08:16:29 | finches | 1 | 69583 | 9 | 1.436 | 48456.1 |
494 | 2022-02-24 06:46:53 | finches | 1 | 69583 | 9 | 1.123 | 61961.7 |
493 | 2022-02-17 15:45:17 | finches | 1 | 69583 | 9 | 1.156 | 60192.9 |
492 | 2021-12-31 06:00:21 | finches | 1 | 69583 | 9 | 1.143 | 60877.5 |
491 | 2021-12-29 02:49:56 | finches | 1 | 69583 | 9 | 1.220 | 57035.2 |
490 | 2021-11-19 10:20:58 | finches | 1 | 69583 | 9 | 1.080 | 64428.7 |
489 | 2021-11-16 02:49:28 | finches | 1 | 69583 | 9 | 1.063 | 65459.1 |
488 | 2021-10-31 17:47:00 | finches | 1 | 69583 | 9 | 1.063 | 65459.1 |
487 | 2021-09-18 00:14:43 | finches | 1 | 69583 | 9 | 1.063 | 65459.1 |
486 | 2021-08-29 06:58:39 | finches | 1 | 69583 | 9 | 1.153 | 60349.5 |
485 | 2021-08-13 06:38:08 | finches | 1 | 69583 | 9 | 1.063 | 65459.1 |
484 | 2021-06-23 10:17:04 | finches | 1 | 69583 | 9 | 1.186 | 58670.3 |
483 | 2021-06-21 18:31:28 | finches | 1 | 69583 | 9 | 1.250 | 55666.4 |
482 | 2021-05-13 01:24:14 | finches | 1 | 69583 | 9 | 1.200 | 57985.8 |
481 | 2021-05-12 13:20:34 | finches | 1 | 69583 | 9 | 2.313 | 30083.4 |
480 | 2021-02-18 17:22:58 | finches | 2 | 107671 | 86 | 3.093 | 34811.2 |
479 | 2021-02-08 12:41:18 | finches | 1 | 69583 | 9 | 1.093 | 63662.4 |
478 | 2020-11-06 18:19:01 | finches | 1 | 69583 | 9 | 1.080 | 64428.7 |
477 | 2020-10-27 22:14:27 | finches | 1 | 69583 | 9 | 1.063 | 65459.1 |