History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"encored"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
538 | 2024-04-15 02:24:03 | encored | 2 | 107671 | 35 | 12.516 | 8602.7 |
537 | 2024-04-06 00:20:54 | encored | 1 | 69583 | 4 | 1.343 | 51811.6 |
536 | 2024-03-14 12:23:15 | encored | 1 | 69583 | 4 | 1.046 | 66522.9 |
535 | 2024-03-06 23:42:27 | encored | 3 | 134027 | 389 | 22.656 | 5915.7 |
534 | 2024-03-05 21:49:40 | encored | 3 | 134027 | 389 | 12.016 | 11154.0 |
533 | 2024-03-05 20:04:09 | encored | 2 | 107671 | 35 | 10.283 | 10470.8 |
532 | 2024-03-05 15:32:31 | encored | 2 | 107671 | 35 | 3.343 | 32207.9 |
531 | 2024-03-05 02:42:31 | encored | 3 | 134027 | 389 | 17.250 | 7769.7 |
530 | 2024-03-04 14:09:17 | encored | 2 | 107671 | 35 | 3.483 | 30913.3 |
529 | 2024-03-04 14:05:09 | encored | 3 | 134027 | 389 | 7.953 | 16852.4 |
528 | 2024-03-04 09:57:54 | encored | 2 | 107671 | 35 | 8.546 | 12599.0 |
527 | 2024-03-04 09:57:53 | encored | 3 | 134027 | 389 | 8.733 | 15347.2 |
526 | 2024-03-04 09:55:04 | encored | 1 | 69583 | 4 | 2.763 | 25183.9 |
525 | 2024-03-04 09:54:51 | encored | 2 | 107671 | 35 | 4.186 | 25721.7 |
524 | 2024-03-04 09:54:49 | encored | 1 | 69583 | 4 | 3.970 | 17527.2 |
523 | 2024-02-28 10:26:56 | encored | 1 | 69583 | 4 | 1.250 | 55666.4 |
522 | 2024-02-04 16:37:26 | encored | 3 | 134027 | 389 | 7.860 | 17051.8 |
521 | 2024-02-04 12:40:31 | encored | 3 | 134027 | 389 | 26.063 | 5142.4 |
520 | 2024-01-30 09:01:20 | encored | 3 | 134027 | 389 | 6.470 | 20715.1 |
519 | 2024-01-17 20:20:10 | encored | 3 | 134027 | 389 | 6.966 | 19240.2 |
518 | 2024-01-17 01:15:37 | encored | 3 | 134027 | 389 | 6.593 | 20328.7 |
517 | 2024-01-14 11:00:14 | encored | 1 | 69583 | 4 | 1.093 | 63662.4 |
516 | 2024-01-14 07:04:53 | encored | 2 | 107671 | 35 | 3.453 | 31181.9 |
515 | 2024-01-06 13:28:23 | encored | 3 | 134027 | 389 | 5.826 | 23005.0 |
514 | 2024-01-05 11:24:05 | encored | 1 | 69583 | 4 | 1.063 | 65459.1 |
513 | 2023-12-13 17:43:41 | encored | 2 | 107671 | 35 | 3.186 | 33795.0 |
512 | 2023-12-07 12:00:01 | encored | 1 | 69583 | 4 | 1.233 | 56433.9 |
511 | 2023-11-28 02:25:14 | encored | 1 | 69583 | 4 | 1.076 | 64668.2 |
510 | 2023-11-22 20:38:50 | encored | 3 | 134027 | 389 | 7.470 | 17942.0 |
509 | 2023-11-21 20:14:54 | encored | 1 | 69583 | 4 | 1.170 | 59472.6 |
508 | 2023-11-18 11:51:20 | encored | 1 | 69583 | 4 | 1.110 | 62687.4 |
507 | 2023-11-18 07:23:49 | encored | 2 | 107671 | 35 | 3.466 | 31064.9 |
506 | 2023-11-17 16:41:10 | encored | 3 | 134027 | 389 | 16.393 | 8175.9 |
505 | 2023-11-09 17:40:19 | encored | 1 | 69583 | 4 | 1.063 | 65459.1 |
504 | 2023-11-08 13:43:42 | encored | 1 | 69583 | 4 | 1.143 | 60877.5 |
503 | 2023-11-07 12:16:11 | encored | 3 | 134027 | 389 | 7.360 | 18210.2 |
502 | 2023-11-02 00:02:24 | encored | 3 | 134027 | 389 | 7.050 | 19010.9 |
501 | 2023-10-20 06:15:35 | encored | 3 | 134027 | 389 | 17.283 | 7754.8 |
500 | 2023-10-14 00:04:07 | encored | 1 | 69583 | 4 | 1.106 | 62914.1 |
499 | 2023-10-13 17:30:08 | encored | 3 | 134027 | 389 | 6.000 | 22337.8 |
498 | 2023-10-09 02:26:18 | encored | 1 | 69583 | 4 | 1.200 | 57985.8 |
497 | 2023-09-26 10:09:42 | encored | 1 | 69583 | 4 | 1.233 | 56433.9 |
496 | 2023-09-23 02:24:21 | encored | 1 | 69583 | 4 | 1.203 | 57841.2 |
495 | 2023-09-14 16:55:05 | encored | 2 | 107671 | 35 | 2.796 | 38508.9 |
494 | 2023-08-30 14:32:09 | encored | 1 | 69583 | 4 | 1.186 | 58670.3 |
493 | 2023-08-15 01:07:52 | encored | 1 | 69583 | 4 | 1.140 | 61037.7 |
492 | 2023-07-24 22:04:10 | encored | 3 | 134027 | 389 | 6.093 | 21996.9 |
491 | 2023-06-18 04:23:31 | encored | 2 | 107671 | 35 | 3.423 | 31455.2 |
490 | 2023-06-03 23:15:28 | encored | 1 | 69583 | 4 | 1.126 | 61796.6 |
489 | 2023-05-04 04:16:12 | encored | 1 | 69583 | 4 | 1.080 | 64428.7 |
488 | 2023-04-05 15:49:05 | encored | 3 | 134027 | 389 | 5.673 | 23625.4 |
487 | 2023-03-28 05:35:20 | encored | 1 | 69583 | 4 | 1.126 | 61796.6 |
486 | 2023-03-14 02:50:53 | encored | 2 | 107671 | 35 | 2.736 | 39353.4 |
485 | 2023-01-25 14:49:49 | encored | 1 | 69583 | 4 | 1.060 | 65644.3 |
484 | 2023-01-17 08:46:10 | encored | 1 | 69583 | 4 | 1.060 | 65644.3 |
483 | 2023-01-11 11:33:48 | encored | 1 | 69583 | 4 | 1.170 | 59472.6 |
482 | 2023-01-03 20:31:00 | encored | 3 | 134027 | 389 | 6.280 | 21341.9 |
481 | 2022-12-15 13:39:40 | encored | 2 | 107671 | 35 | 2.780 | 38730.6 |
480 | 2022-10-24 16:31:23 | encored | 1 | 69583 | 4 | 1.123 | 61961.7 |
479 | 2022-10-11 07:27:30 | encored | 1 | 69583 | 4 | 1.280 | 54361.7 |
478 | 2022-09-08 18:45:49 | encored | 3 | 134027 | 389 | 5.810 | 23068.3 |
477 | 2022-08-05 20:29:57 | encored | 2 | 107671 | 35 | 3.233 | 33303.7 |
476 | 2022-07-18 21:00:46 | encored | 1 | 69583 | 4 | 1.296 | 53690.6 |
475 | 2022-06-17 04:23:20 | encored | 1 | 69583 | 4 | 1.173 | 59320.5 |
474 | 2022-06-13 15:15:48 | encored | 1 | 69583 | 4 | 1.063 | 65459.1 |
473 | 2022-03-26 13:06:38 | encored | 2 | 107671 | 35 | 3.063 | 35152.1 |
472 | 2022-02-26 08:00:06 | encored | 1 | 69583 | 4 | 1.076 | 64668.2 |
471 | 2022-02-16 21:52:29 | encored | 1 | 69583 | 4 | 1.283 | 54234.6 |
470 | 2022-02-14 18:02:56 | encored | 1 | 69583 | 4 | 1.296 | 53690.6 |
469 | 2021-12-06 05:55:49 | encored | 1 | 69583 | 4 | 1.186 | 58670.3 |
468 | 2021-11-14 19:37:00 | encored | 1 | 69583 | 4 | 1.263 | 55093.4 |
467 | 2021-10-19 17:24:28 | encored | 1 | 69583 | 4 | 1.283 | 54234.6 |
466 | 2021-09-26 19:48:50 | encored | 1 | 69583 | 4 | 1.233 | 56433.9 |
465 | 2021-09-24 15:58:05 | encored | 1 | 69583 | 4 | 1.250 | 55666.4 |
464 | 2021-09-08 01:17:53 | encored | 1 | 69583 | 4 | 1.186 | 58670.3 |
463 | 2021-08-15 06:38:58 | encored | 1 | 69583 | 4 | 1.203 | 57841.2 |
462 | 2021-06-10 15:41:47 | encored | 1 | 69583 | 4 | 1.220 | 57035.2 |
461 | 2021-05-21 16:00:00 | encored | 1 | 69583 | 4 | 1.220 | 57035.2 |
460 | 2021-05-14 14:50:36 | encored | 1 | 69583 | 4 | 1.250 | 55666.4 |
459 | 2021-02-11 13:32:08 | encored | 1 | 69583 | 4 | 1.093 | 63662.4 |
458 | 2021-02-06 16:17:56 | encored | 1 | 69583 | 4 | 1.186 | 58670.3 |
457 | 2020-11-04 15:23:18 | encored | 1 | 69583 | 4 | 1.080 | 64428.7 |
456 | 2020-11-01 22:18:58 | encored | 1 | 69583 | 4 | 1.220 | 57035.2 |
455 | 2020-10-03 10:10:59 | encored | 1 | 69583 | 4 | 1.250 | 55666.4 |
454 | 2020-10-01 21:11:03 | encored | 1 | 69583 | 4 | 1.063 | 65459.1 |
453 | 2020-09-15 12:51:18 | encored | 1 | 69583 | 4 | 1.126 | 61796.6 |
452 | 2020-08-31 12:15:59 | encored | 1 | 69583 | 4 | 1.406 | 49490.0 |
451 | 2020-08-02 02:57:28 | encored | 1 | 69583 | 4 | 1.140 | 61037.7 |
450 | 2020-08-01 19:58:15 | encored | 1 | 69583 | 4 | 1.170 | 59472.6 |
449 | 2020-08-01 06:05:43 | encored | 1 | 69583 | 4 | 1.203 | 57841.2 |
448 | 2020-08-01 00:21:04 | encored | 1 | 69583 | 4 | 1.250 | 55666.4 |
447 | 2020-07-31 08:29:06 | encored | 1 | 69583 | 4 | 1.093 | 63662.4 |
446 | 2020-06-05 15:24:40 | encored | 1 | 69583 | 4 | 1.123 | 61961.7 |
445 | 2020-04-29 13:07:32 | encored | 1 | 69583 | 4 | 1.250 | 55666.4 |
444 | 2020-03-24 02:54:17 | encored | 1 | 69583 | 4 | 1.360 | 51164.0 |
443 | 2020-03-21 05:37:04 | encored | 1 | 69583 | 4 | 1.250 | 55666.4 |
442 | 2020-03-16 23:22:09 | encored | 1 | 69583 | 4 | 1.046 | 66522.9 |
441 | 2020-02-24 18:11:51 | encored | 1 | 69583 | 4 | 2.623 | 26528.0 |
440 | 2020-02-24 04:52:41 | encored | 3 | 134027 | 389 | 5.890 | 22755.0 |
439 | 2020-02-18 12:14:01 | encored | 1 | 69583 | 4 | 2.500 | 27833.2 |