History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"joining"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
572 | 2024-05-30 12:17:15 | joining | 1 | 69583 | 5 | 4.716 | 14754.7 |
571 | 2024-05-29 12:04:59 | joining | 1 | 69583 | 5 | 3.156 | 22047.8 |
570 | 2024-05-24 09:41:34 | joining | 3 | 134027 | 902 | 11.110 | 12063.6 |
569 | 2024-05-24 09:41:12 | joining | 3 | 134027 | 902 | 16.203 | 8271.7 |
568 | 2024-05-16 00:57:22 | joining | 1 | 69583 | 5 | 1.296 | 53690.6 |
567 | 2024-05-07 02:54:55 | joining | 2 | 107671 | 97 | 3.140 | 34290.1 |
566 | 2024-05-06 22:32:17 | joining | 2 | 107671 | 97 | 3.360 | 32044.9 |
565 | 2024-05-05 00:14:41 | joining | 3 | 134027 | 902 | 15.033 | 8915.5 |
564 | 2024-05-03 22:26:19 | joining | 3 | 134027 | 902 | 20.876 | 6420.1 |
563 | 2024-05-03 18:55:51 | joining | 3 | 134027 | 902 | 7.783 | 17220.5 |
562 | 2024-05-03 18:15:39 | joining | 2 | 107671 | 97 | 6.140 | 17536.0 |
561 | 2024-05-03 14:33:27 | joining | 2 | 107671 | 97 | 3.296 | 32667.2 |
560 | 2024-05-01 11:15:15 | joining | 2 | 107671 | 97 | 3.733 | 28843.0 |
559 | 2024-04-28 13:30:42 | joining | 1 | 69583 | 5 | 2.546 | 27330.3 |
558 | 2024-03-15 19:58:09 | joining | 1 | 69583 | 5 | 1.156 | 60192.9 |
557 | 2024-02-03 03:48:10 | joining | 2 | 107671 | 97 | 3.326 | 32372.5 |
556 | 2024-02-01 06:47:11 | joining | 2 | 107671 | 97 | 3.110 | 34620.9 |
555 | 2024-01-30 21:44:27 | joining | 2 | 107671 | 97 | 4.890 | 22018.6 |
554 | 2024-01-30 21:43:07 | joining | 3 | 134027 | 902 | 5.970 | 22450.1 |
553 | 2024-01-30 12:33:43 | joining | 3 | 134027 | 902 | 13.986 | 9582.9 |
552 | 2024-01-07 21:39:37 | joining | 3 | 134027 | 902 | 5.706 | 23488.8 |
551 | 2024-01-04 06:51:44 | joining | 1 | 69583 | 5 | 1.250 | 55666.4 |
550 | 2023-12-25 11:35:35 | joining | 2 | 107671 | 97 | 6.703 | 16063.1 |
549 | 2023-12-20 03:59:20 | joining | 2 | 107671 | 97 | 2.813 | 38276.2 |
548 | 2023-12-15 12:28:59 | joining | 1 | 69583 | 5 | 1.156 | 60192.9 |
547 | 2023-12-10 23:51:51 | joining | 1 | 69583 | 5 | 1.016 | 68487.2 |
546 | 2023-12-10 06:35:57 | joining | 1 | 69583 | 5 | 1.123 | 61961.7 |
545 | 2023-11-01 23:00:39 | joining | 1 | 69583 | 5 | 1.170 | 59472.6 |
544 | 2023-10-29 13:15:52 | joining | 3 | 134027 | 902 | 6.423 | 20866.7 |
543 | 2023-10-24 16:25:26 | joining | 3 | 134027 | 902 | 5.860 | 22871.5 |
542 | 2023-10-15 01:04:42 | joining | 3 | 134027 | 902 | 6.906 | 19407.3 |
541 | 2023-10-06 16:54:09 | joining | 1 | 69583 | 5 | 1.013 | 68690.0 |
540 | 2023-09-29 13:05:33 | joining | 1 | 69583 | 5 | 1.046 | 66522.9 |
539 | 2023-09-26 07:51:39 | joining | 2 | 107671 | 97 | 2.733 | 39396.6 |
538 | 2023-09-25 22:12:48 | joining | 1 | 69583 | 5 | 1.046 | 66522.9 |
537 | 2023-09-12 03:27:00 | joining | 1 | 69583 | 5 | 1.153 | 60349.5 |
536 | 2023-08-19 12:27:01 | joining | 3 | 134027 | 902 | 5.826 | 23005.0 |
535 | 2023-07-25 13:56:53 | joining | 3 | 134027 | 902 | 6.016 | 22278.4 |
534 | 2023-07-06 02:09:34 | joining | 2 | 107671 | 97 | 2.750 | 39153.1 |
533 | 2023-05-26 04:01:19 | joining | 1 | 69583 | 5 | 1.156 | 60192.9 |
532 | 2023-04-11 09:34:17 | joining | 3 | 134027 | 902 | 5.673 | 23625.4 |
531 | 2023-04-05 12:40:16 | joining | 3 | 134027 | 902 | 6.420 | 20876.5 |
530 | 2023-03-30 14:03:19 | joining | 2 | 107671 | 97 | 3.046 | 35348.3 |
529 | 2023-02-06 03:13:16 | joining | 1 | 69583 | 5 | 1.016 | 68487.2 |
528 | 2023-01-21 08:37:58 | joining | 3 | 134027 | 902 | 5.720 | 23431.3 |
527 | 2023-01-02 02:41:17 | joining | 3 | 134027 | 902 | 5.750 | 23309.0 |
526 | 2022-12-26 07:42:58 | joining | 2 | 107671 | 97 | 2.700 | 39878.1 |
525 | 2022-12-19 14:23:41 | joining | 1 | 69583 | 5 | 1.126 | 61796.6 |
524 | 2022-12-07 06:22:21 | joining | 3 | 134027 | 902 | 6.266 | 21389.6 |
523 | 2022-11-11 06:23:25 | joining | 3 | 134027 | 902 | 5.533 | 24223.2 |
522 | 2022-10-19 17:49:27 | joining | 1 | 69583 | 5 | 1.046 | 66522.9 |
521 | 2022-10-14 07:20:04 | joining | 3 | 134027 | 902 | 5.640 | 23763.7 |
520 | 2022-09-19 19:59:07 | joining | 1 | 69583 | 5 | 1.033 | 67360.1 |
519 | 2022-09-07 00:01:32 | joining | 3 | 134027 | 902 | 5.626 | 23822.8 |
518 | 2022-08-30 02:10:07 | joining | 1 | 69583 | 5 | 1.013 | 68690.0 |
517 | 2022-08-25 10:59:59 | joining | 2 | 107671 | 97 | 2.876 | 37437.8 |
516 | 2022-08-23 01:24:16 | joining | 2 | 107671 | 97 | 2.783 | 38688.8 |
515 | 2022-08-14 19:07:16 | joining | 1 | 69583 | 5 | 1.153 | 60349.5 |
514 | 2022-07-29 03:20:21 | joining | 1 | 69583 | 5 | 1.186 | 58670.3 |
513 | 2022-06-22 00:42:43 | joining | 1 | 69583 | 5 | 1.033 | 67360.1 |
512 | 2022-04-12 11:37:18 | joining | 1 | 69583 | 5 | 1.296 | 53690.6 |
511 | 2022-04-04 07:56:22 | joining | 3 | 134027 | 902 | 6.533 | 20515.4 |
510 | 2022-03-28 06:18:50 | joining | 3 | 134027 | 902 | 6.110 | 21935.7 |
509 | 2022-03-18 11:33:36 | joining | 2 | 107671 | 97 | 3.376 | 31893.1 |
508 | 2022-03-16 08:24:29 | joining | 2 | 107671 | 97 | 3.516 | 30623.2 |
507 | 2022-03-06 04:26:14 | joining | 1 | 69583 | 5 | 1.156 | 60192.9 |
506 | 2022-01-14 17:03:03 | joining | 1 | 69583 | 5 | 1.266 | 54962.9 |
505 | 2021-12-05 13:14:24 | joining | 2 | 107671 | 97 | 3.046 | 35348.3 |
504 | 2021-11-25 20:42:13 | joining | 1 | 69583 | 5 | 1.203 | 57841.2 |
503 | 2021-11-15 09:57:45 | joining | 1 | 69583 | 5 | 1.216 | 57222.9 |
502 | 2021-11-10 13:29:45 | joining | 1 | 69583 | 5 | 1.153 | 60349.5 |
501 | 2021-11-08 12:08:12 | joining | 1 | 69583 | 5 | 1.123 | 61961.7 |
500 | 2021-10-06 04:28:40 | joining | 3 | 134027 | 902 | 8.016 | 16719.9 |
499 | 2021-09-28 03:24:37 | joining | 1 | 69583 | 5 | 1.063 | 65459.1 |
498 | 2021-09-26 00:35:12 | joining | 1 | 69583 | 5 | 1.170 | 59472.6 |
497 | 2021-09-11 01:15:13 | joining | 1 | 69583 | 5 | 1.050 | 66269.5 |
496 | 2021-09-08 21:36:42 | joining | 1 | 69583 | 5 | 1.063 | 65459.1 |
495 | 2021-08-22 23:30:29 | joining | 1 | 69583 | 5 | 1.063 | 65459.1 |
494 | 2021-08-17 10:15:39 | joining | 3 | 134027 | 902 | 5.703 | 23501.1 |
493 | 2021-07-21 19:28:59 | joining | 3 | 134027 | 902 | 5.643 | 23751.0 |
492 | 2021-05-22 03:32:08 | joining | 1 | 69583 | 5 | 1.203 | 57841.2 |
491 | 2021-05-04 08:59:12 | joining | 1 | 69583 | 5 | 1.200 | 57985.8 |
490 | 2021-04-02 10:57:14 | joining | 1 | 69583 | 5 | 1.203 | 57841.2 |
489 | 2021-02-28 02:29:51 | joining | 3 | 134027 | 902 | 5.750 | 23309.0 |
488 | 2021-02-21 03:39:43 | joining | 3 | 134027 | 902 | 6.733 | 19906.0 |
487 | 2021-02-15 17:12:33 | joining | 1 | 69583 | 5 | 1.046 | 66522.9 |
486 | 2021-01-17 12:22:10 | joining | 1 | 69583 | 5 | 1.126 | 61796.6 |
485 | 2020-11-11 10:16:48 | joining | 1 | 69583 | 5 | 1.126 | 61796.6 |
484 | 2020-10-27 23:07:11 | joining | 1 | 69583 | 5 | 1.033 | 67360.1 |
483 | 2020-10-26 15:38:25 | joining | 1 | 69583 | 5 | 1.250 | 55666.4 |
482 | 2020-10-26 15:08:33 | joining | 1 | 69583 | 5 | 1.140 | 61037.7 |
481 | 2020-10-26 00:21:15 | joining | 1 | 69583 | 5 | 1.173 | 59320.5 |
480 | 2020-10-02 19:23:23 | joining | 1 | 69583 | 5 | 1.033 | 67360.1 |
479 | 2020-08-31 18:04:48 | joining | 1 | 69583 | 5 | 1.060 | 65644.3 |
478 | 2020-08-14 04:24:41 | joining | 1 | 69583 | 5 | 1.330 | 52318.0 |
477 | 2020-08-08 06:08:14 | joining | 1 | 69583 | 5 | 1.033 | 67360.1 |
476 | 2020-08-05 04:44:42 | joining | 1 | 69583 | 5 | 1.013 | 68690.0 |
475 | 2020-07-14 10:12:16 | joining | 1 | 69583 | 5 | 1.093 | 63662.4 |
474 | 2020-05-03 16:44:51 | joining | 1 | 69583 | 5 | 1.093 | 63662.4 |
473 | 2020-04-13 09:13:19 | joining | 1 | 69583 | 5 | 1.093 | 63662.4 |