History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"fish"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
551 | 2024-03-05 20:19:09 | fish | 1 | 13983 | 8 | 0.796 | 17566.6 |
550 | 2024-03-03 19:31:28 | fish | 1 | 13983 | 8 | 0.236 | 59250.0 |
549 | 2024-03-01 16:07:58 | fish | 1 | 13983 | 8 | 0.546 | 25609.9 |
548 | 2024-02-29 20:43:11 | fish | 1 | 13983 | 8 | 0.266 | 52567.7 |
547 | 2024-02-25 16:35:50 | fish | 1 | 13983 | 8 | 0.266 | 52567.7 |
546 | 2024-02-03 02:17:30 | fish | 1 | 13983 | 8 | 0.516 | 27098.8 |
545 | 2024-02-02 15:53:31 | fish | 1 | 13983 | 8 | 0.250 | 55932.0 |
544 | 2024-01-28 16:35:47 | fish | 1 | 13983 | 8 | 0.203 | 68881.8 |
543 | 2024-01-25 18:46:21 | fish | 1 | 13983 | 8 | 0.500 | 27966.0 |
542 | 2024-01-12 03:02:02 | fish | 1 | 13983 | 8 | 0.280 | 49939.3 |
541 | 2024-01-10 19:40:28 | fish | 2 | 29872 | 192 | 0.826 | 36164.6 |
540 | 2023-12-29 19:37:51 | fish | 2 | 29872 | 192 | 0.860 | 34734.9 |
539 | 2023-12-09 16:24:05 | fish | 1 | 13983 | 8 | 0.200 | 69915.0 |
538 | 2023-12-01 13:49:14 | fish | 1 | 13983 | 8 | 0.233 | 60012.9 |
537 | 2023-11-26 23:14:13 | fish | 1 | 13983 | 8 | 0.216 | 64736.1 |
536 | 2023-11-18 22:01:44 | fish | 2 | 29872 | 192 | 0.843 | 35435.3 |
535 | 2023-11-16 07:25:38 | fish | 1 | 13983 | 8 | 0.216 | 64736.1 |
534 | 2023-11-08 16:53:30 | fish | 1 | 13983 | 8 | 0.220 | 63559.1 |
533 | 2023-11-03 02:04:52 | fish | 2 | 29872 | 192 | 0.733 | 40753.1 |
532 | 2023-10-26 03:15:45 | fish | 1 | 13983 | 8 | 0.483 | 28950.3 |
531 | 2023-10-20 20:23:39 | fish | 2 | 29872 | 192 | 0.733 | 40753.1 |
530 | 2023-10-19 15:03:41 | fish | 1 | 13983 | 8 | 0.250 | 55932.0 |
529 | 2023-10-17 04:03:32 | fish | 1 | 13983 | 8 | 0.220 | 63559.1 |
528 | 2023-10-15 09:10:51 | fish | 1 | 13983 | 8 | 0.250 | 55932.0 |
527 | 2023-10-04 13:43:59 | fish | 2 | 29872 | 192 | 0.733 | 40753.1 |
526 | 2023-10-03 23:49:48 | fish | 1 | 13983 | 8 | 0.236 | 59250.0 |
525 | 2023-09-28 18:31:33 | fish | 1 | 13983 | 8 | 0.220 | 63559.1 |
524 | 2023-09-23 12:11:20 | fish | 1 | 13983 | 8 | 0.203 | 68881.8 |
523 | 2023-09-12 01:56:47 | fish | 1 | 13983 | 8 | 0.216 | 64736.1 |
522 | 2023-08-12 14:34:24 | fish | 1 | 13983 | 8 | 0.233 | 60012.9 |
521 | 2023-07-20 09:05:39 | fish | 1 | 13983 | 8 | 0.233 | 60012.9 |
520 | 2023-07-15 04:47:16 | fish | 2 | 29872 | 192 | 0.796 | 37527.6 |
519 | 2023-05-01 09:27:20 | fish | 1 | 13983 | 8 | 0.216 | 64736.1 |
518 | 2023-04-27 17:30:43 | fish | 1 | 13983 | 8 | 0.216 | 64736.1 |
517 | 2023-04-22 10:35:03 | fish | 1 | 13983 | 8 | 0.216 | 64736.1 |
516 | 2023-04-01 03:36:33 | fish | 2 | 29872 | 192 | 0.746 | 40042.9 |
515 | 2023-02-15 18:40:04 | fish | 1 | 13983 | 8 | 0.220 | 63559.1 |
514 | 2023-01-15 10:02:46 | fish | 1 | 13983 | 8 | 0.203 | 68881.8 |
513 | 2022-12-28 21:07:03 | fish | 2 | 29872 | 192 | 0.716 | 41720.7 |
512 | 2022-12-13 04:40:04 | fish | 1 | 13983 | 8 | 0.233 | 60012.9 |
511 | 2022-11-25 07:08:43 | fish | 1 | 13983 | 8 | 0.236 | 59250.0 |
510 | 2022-10-05 00:29:50 | fish | 1 | 13983 | 8 | 0.203 | 68881.8 |
509 | 2022-09-01 02:14:12 | fish | 2 | 29872 | 192 | 0.893 | 33451.3 |
508 | 2022-08-29 16:00:46 | fish | 2 | 29872 | 192 | 0.766 | 38997.4 |
507 | 2022-08-19 21:38:52 | fish | 1 | 13983 | 8 | 0.220 | 63559.1 |
506 | 2022-08-17 09:38:26 | fish | 1 | 13983 | 8 | 0.216 | 64736.1 |
505 | 2022-08-15 01:48:15 | fish | 1 | 13983 | 8 | 0.216 | 64736.1 |
504 | 2022-07-29 09:51:32 | fish | 1 | 13983 | 8 | 0.203 | 68881.8 |
503 | 2022-06-18 03:31:54 | fish | 1 | 13983 | 8 | 0.220 | 63559.1 |
502 | 2022-04-08 03:57:41 | fish | 1 | 13983 | 8 | 0.233 | 60012.9 |
501 | 2022-03-24 10:40:32 | fish | 2 | 29872 | 192 | 0.890 | 33564.0 |
500 | 2022-03-02 15:37:18 | fish | 1 | 13983 | 8 | 0.250 | 55932.0 |
499 | 2022-01-11 21:02:13 | fish | 1 | 13983 | 8 | 0.216 | 64736.1 |
498 | 2022-01-09 17:19:33 | fish | 1 | 13983 | 8 | 0.233 | 60012.9 |
497 | 2021-11-25 18:25:47 | fish | 1 | 13983 | 8 | 0.233 | 60012.9 |
496 | 2021-11-09 22:40:09 | fish | 1 | 13983 | 8 | 0.250 | 55932.0 |
495 | 2021-11-07 19:58:12 | fish | 1 | 13983 | 8 | 0.233 | 60012.9 |
494 | 2021-09-18 23:14:16 | fish | 1 | 13983 | 8 | 0.220 | 63559.1 |
493 | 2021-08-30 07:14:51 | fish | 1 | 13983 | 8 | 0.216 | 64736.1 |
492 | 2021-08-22 21:15:57 | fish | 1 | 13983 | 8 | 0.203 | 68881.8 |
491 | 2021-07-13 12:34:35 | fish | 1 | 13983 | 8 | 0.236 | 59250.0 |
490 | 2021-05-12 02:20:58 | fish | 1 | 13983 | 8 | 0.250 | 55932.0 |
489 | 2021-03-31 14:13:37 | fish | 1 | 13983 | 8 | 0.250 | 55932.0 |
488 | 2021-02-07 17:56:36 | fish | 1 | 13983 | 8 | 0.203 | 68881.8 |
487 | 2020-11-13 08:00:22 | fish | 2 | 29872 | 192 | 0.766 | 38997.4 |
486 | 2020-11-05 23:51:41 | fish | 1 | 13983 | 8 | 0.220 | 63559.1 |
485 | 2020-11-01 07:53:45 | fish | 1 | 13983 | 8 | 0.220 | 63559.1 |
484 | 2020-10-26 17:25:46 | fish | 1 | 13983 | 8 | 0.220 | 63559.1 |
483 | 2020-10-02 02:38:59 | fish | 1 | 13983 | 8 | 0.220 | 63559.1 |
482 | 2020-09-18 14:01:45 | fish | 1 | 13983 | 8 | 0.216 | 64736.1 |
481 | 2020-09-05 09:38:47 | fish | 1 | 13983 | 8 | 0.216 | 64736.1 |
480 | 2020-09-02 01:35:49 | fish | 1 | 13983 | 8 | 0.203 | 68881.8 |
479 | 2020-08-18 13:43:49 | fish | 1 | 13983 | 8 | 0.233 | 60012.9 |
478 | 2020-08-12 14:21:22 | fish | 1 | 13983 | 8 | 0.250 | 55932.0 |
477 | 2020-08-05 09:54:24 | fish | 1 | 13983 | 8 | 0.220 | 63559.1 |
476 | 2020-08-05 01:47:36 | fish | 1 | 13983 | 8 | 0.216 | 64736.1 |
475 | 2020-08-01 20:20:07 | fish | 1 | 13983 | 8 | 0.220 | 63559.1 |
474 | 2020-07-19 12:54:23 | fish | 1 | 13983 | 8 | 0.233 | 60012.9 |
473 | 2020-06-17 05:12:10 | fish | 1 | 13983 | 8 | 0.250 | 55932.0 |
472 | 2020-06-08 03:24:08 | fish | 1 | 13983 | 8 | 0.220 | 63559.1 |
471 | 2020-04-30 09:10:07 | fish | 1 | 13983 | 8 | 0.250 | 55932.0 |
470 | 2020-03-30 09:45:10 | fish | 1 | 13983 | 8 | 0.250 | 55932.0 |
469 | 2020-03-27 05:26:20 | fish | 1 | 13983 | 8 | 0.250 | 55932.0 |
468 | 2020-03-25 14:20:47 | fish | 1 | 13983 | 8 | 0.220 | 63559.1 |
467 | 2020-03-24 16:46:39 | fish | 1 | 13983 | 8 | 0.266 | 52567.7 |
466 | 2020-03-23 17:46:02 | fish | 1 | 13983 | 8 | 0.513 | 27257.3 |
465 | 2020-03-22 08:20:58 | fish | 1 | 13983 | 8 | 0.250 | 55932.0 |
464 | 2020-03-20 18:25:24 | fish | 1 | 13983 | 8 | 0.266 | 52567.7 |
463 | 2020-03-19 22:05:08 | fish | 1 | 13983 | 8 | 0.203 | 68881.8 |
462 | 2020-03-19 19:20:16 | fish | 1 | 13983 | 8 | 0.233 | 60012.9 |
461 | 2020-03-18 19:02:33 | fish | 1 | 13983 | 8 | 0.250 | 55932.0 |
460 | 2020-03-18 00:21:29 | fish | 1 | 13983 | 8 | 0.203 | 68881.8 |
459 | 2020-02-27 05:28:27 | fish | 1 | 13983 | 8 | 0.360 | 38841.7 |
458 | 2020-02-24 16:43:30 | fish | 1 | 13983 | 8 | 0.203 | 68881.8 |
457 | 2020-02-15 02:05:34 | fish | 1 | 13983 | 8 | 0.560 | 24969.6 |
456 | 2020-02-14 22:05:38 | fish | 1 | 13983 | 8 | 0.576 | 24276.0 |
455 | 2020-02-12 13:32:22 | fish | 1 | 13983 | 8 | 0.266 | 52567.7 |
454 | 2020-02-09 09:32:33 | fish | 1 | 13983 | 8 | 0.250 | 55932.0 |
453 | 2020-01-31 05:55:01 | fish | 1 | 13983 | 8 | 0.550 | 25423.6 |
452 | 2020-01-29 10:12:31 | fish | 1 | 13983 | 8 | 0.266 | 52567.7 |