History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"offish"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
537 | 2024-05-02 09:20:40 | offish | 1 | 48755 | 2 | 0.876 | 55656.4 |
536 | 2024-04-26 19:45:15 | offish | 2 | 82551 | 25 | 2.716 | 30394.3 |
535 | 2024-04-26 19:45:11 | offish | 3 | 112716 | 241 | 6.000 | 18786.0 |
534 | 2024-04-26 19:45:07 | offish | 1 | 48755 | 2 | 0.873 | 55847.7 |
533 | 2024-04-26 19:45:02 | offish | 2 | 82551 | 25 | 2.530 | 32628.9 |
532 | 2024-04-26 19:44:50 | offish | 3 | 112716 | 241 | 6.830 | 16503.1 |
531 | 2024-04-26 19:17:38 | offish | 3 | 112716 | 241 | 10.530 | 10704.3 |
530 | 2024-04-09 07:02:10 | offish | 1 | 48755 | 2 | 0.843 | 57835.1 |
529 | 2024-04-06 06:23:08 | offish | 1 | 48755 | 2 | 2.703 | 18037.4 |
528 | 2023-12-26 12:04:20 | offish | 1 | 48755 | 2 | 0.750 | 65006.7 |
527 | 2023-12-16 11:57:07 | offish | 3 | 112716 | 241 | 5.373 | 20978.2 |
526 | 2023-12-16 11:57:08 | offish | 2 | 82551 | 25 | 2.576 | 32046.2 |
525 | 2023-12-15 14:47:47 | offish | 3 | 112716 | 241 | 4.593 | 24540.8 |
524 | 2023-12-13 07:59:36 | offish | 2 | 82551 | 25 | 2.250 | 36689.3 |
523 | 2023-12-04 17:12:02 | offish | 3 | 112716 | 241 | 5.266 | 21404.5 |
522 | 2023-11-19 08:40:26 | offish | 3 | 112716 | 241 | 5.203 | 21663.7 |
521 | 2023-11-19 08:40:24 | offish | 2 | 82551 | 25 | 2.500 | 33020.4 |
520 | 2023-11-12 04:56:42 | offish | 1 | 48755 | 2 | 0.890 | 54780.9 |
519 | 2023-11-08 17:57:17 | offish | 1 | 48755 | 2 | 0.733 | 66514.3 |
518 | 2023-11-05 07:05:30 | offish | 1 | 48755 | 2 | 0.716 | 68093.6 |
517 | 2023-11-02 18:04:14 | offish | 1 | 48755 | 2 | 0.796 | 61250.0 |
516 | 2023-10-30 22:58:43 | offish | 1 | 48755 | 2 | 0.766 | 63648.8 |
515 | 2023-10-15 06:40:39 | offish | 1 | 48755 | 2 | 0.763 | 63899.1 |
514 | 2023-10-14 05:57:20 | offish | 1 | 48755 | 2 | 0.763 | 63899.1 |
513 | 2023-10-10 09:09:23 | offish | 1 | 48755 | 2 | 0.810 | 60191.4 |
512 | 2023-10-07 23:01:48 | offish | 1 | 48755 | 2 | 0.733 | 66514.3 |
511 | 2023-09-29 13:22:58 | offish | 1 | 48755 | 2 | 0.830 | 58741.0 |
510 | 2023-09-27 19:59:41 | offish | 3 | 112716 | 241 | 5.686 | 19823.4 |
509 | 2023-09-16 04:47:29 | offish | 3 | 112716 | 241 | 4.813 | 23419.1 |
508 | 2023-09-13 11:49:43 | offish | 1 | 48755 | 2 | 0.780 | 62506.4 |
507 | 2023-09-11 09:37:00 | offish | 2 | 82551 | 25 | 2.420 | 34112.0 |
506 | 2023-08-10 19:45:14 | offish | 1 | 48755 | 2 | 0.720 | 67715.3 |
505 | 2023-08-08 12:38:45 | offish | 2 | 82551 | 25 | 2.143 | 38521.2 |
504 | 2023-07-07 11:56:36 | offish | 2 | 82551 | 25 | 2.376 | 34743.7 |
503 | 2023-06-27 20:24:33 | offish | 3 | 112716 | 241 | 5.216 | 21609.7 |
502 | 2023-06-10 07:03:21 | offish | 1 | 48755 | 2 | 0.720 | 67715.3 |
501 | 2023-06-06 23:57:40 | offish | 1 | 48755 | 2 | 0.783 | 62266.9 |
500 | 2023-06-05 06:13:40 | offish | 2 | 82551 | 25 | 2.046 | 40347.5 |
499 | 2023-05-10 12:07:41 | offish | 1 | 48755 | 2 | 0.733 | 66514.3 |
498 | 2023-03-19 17:00:30 | offish | 3 | 112716 | 241 | 7.016 | 16065.6 |
497 | 2023-03-10 14:34:44 | offish | 2 | 82551 | 25 | 2.013 | 41008.9 |
496 | 2023-03-04 20:54:12 | offish | 1 | 48755 | 2 | 0.733 | 66514.3 |
495 | 2023-02-08 10:54:39 | offish | 1 | 48755 | 2 | 0.796 | 61250.0 |
494 | 2023-01-07 14:25:50 | offish | 3 | 112716 | 241 | 4.440 | 25386.5 |
493 | 2023-01-04 14:57:32 | offish | 3 | 112716 | 241 | 8.486 | 13282.6 |
492 | 2023-01-03 20:12:48 | offish | 3 | 112716 | 241 | 5.046 | 22337.7 |
491 | 2022-12-28 11:59:27 | offish | 1 | 48755 | 2 | 0.800 | 60943.8 |
490 | 2022-12-20 05:54:17 | offish | 3 | 112716 | 241 | 4.953 | 22757.1 |
489 | 2022-12-15 19:16:21 | offish | 2 | 82551 | 25 | 2.046 | 40347.5 |
488 | 2022-11-20 23:31:09 | offish | 3 | 112716 | 241 | 5.313 | 21215.1 |
487 | 2022-11-19 06:23:00 | offish | 3 | 112716 | 241 | 4.483 | 25143.0 |
486 | 2022-10-10 23:11:37 | offish | 1 | 48755 | 2 | 0.800 | 60943.8 |
485 | 2022-10-05 02:22:49 | offish | 3 | 112716 | 241 | 5.233 | 21539.5 |
484 | 2022-09-27 19:48:06 | offish | 3 | 112716 | 241 | 5.063 | 22262.7 |
483 | 2022-09-16 07:14:10 | offish | 1 | 48755 | 2 | 0.830 | 58741.0 |
482 | 2022-09-12 15:18:55 | offish | 3 | 112716 | 241 | 4.530 | 24882.1 |
481 | 2022-09-02 14:41:19 | offish | 3 | 112716 | 241 | 4.406 | 25582.4 |
480 | 2022-08-19 00:39:28 | offish | 3 | 112716 | 241 | 4.530 | 24882.1 |
479 | 2022-08-06 18:49:54 | offish | 2 | 82551 | 25 | 2.063 | 40015.0 |
478 | 2022-07-12 19:47:25 | offish | 1 | 48755 | 2 | 0.750 | 65006.7 |
477 | 2022-06-02 13:34:48 | offish | 1 | 48755 | 2 | 0.906 | 53813.5 |
476 | 2022-03-27 09:25:13 | offish | 2 | 82551 | 25 | 2.046 | 40347.5 |
475 | 2022-03-12 19:05:00 | offish | 1 | 48755 | 2 | 0.893 | 54596.9 |
474 | 2022-01-29 05:49:53 | offish | 1 | 48755 | 2 | 1.640 | 29728.7 |
473 | 2022-01-04 05:20:19 | offish | 2 | 82551 | 25 | 2.503 | 32980.8 |
472 | 2022-01-03 11:04:23 | offish | 2 | 82551 | 25 | 2.436 | 33887.9 |
471 | 2022-01-02 19:43:43 | offish | 2 | 82551 | 25 | 2.623 | 31472.0 |
470 | 2022-01-02 18:56:37 | offish | 2 | 82551 | 25 | 2.453 | 33653.1 |
469 | 2022-01-02 10:03:55 | offish | 2 | 82551 | 25 | 5.593 | 14759.7 |
468 | 2022-01-01 15:13:25 | offish | 2 | 82551 | 25 | 2.280 | 36206.6 |
467 | 2021-12-23 23:11:49 | offish | 2 | 82551 | 25 | 3.766 | 21920.1 |
466 | 2021-12-23 11:20:13 | offish | 2 | 82551 | 25 | 2.643 | 31233.8 |
465 | 2021-12-22 23:59:07 | offish | 2 | 82551 | 25 | 2.453 | 33653.1 |
464 | 2021-12-22 14:08:08 | offish | 2 | 82551 | 25 | 2.703 | 30540.5 |
463 | 2021-12-22 04:32:34 | offish | 2 | 82551 | 25 | 2.143 | 38521.2 |
462 | 2021-12-21 17:09:35 | offish | 2 | 82551 | 25 | 2.453 | 33653.1 |
461 | 2021-12-21 06:03:23 | offish | 2 | 82551 | 25 | 2.376 | 34743.7 |
460 | 2021-12-20 19:21:27 | offish | 2 | 82551 | 25 | 2.140 | 38575.2 |
459 | 2021-12-20 07:42:49 | offish | 2 | 82551 | 25 | 2.343 | 35233.0 |
458 | 2021-12-17 05:47:39 | offish | 2 | 82551 | 25 | 2.063 | 40015.0 |
457 | 2021-12-16 18:27:54 | offish | 2 | 82551 | 25 | 2.046 | 40347.5 |
456 | 2021-12-16 04:20:54 | offish | 2 | 82551 | 25 | 2.313 | 35690.0 |
455 | 2021-12-15 10:41:10 | offish | 2 | 82551 | 25 | 2.703 | 30540.5 |
454 | 2021-12-14 20:58:19 | offish | 2 | 82551 | 25 | 3.266 | 25275.9 |
453 | 2021-11-22 05:31:01 | offish | 2 | 82551 | 25 | 2.110 | 39123.7 |
452 | 2021-11-21 17:24:03 | offish | 2 | 82551 | 25 | 2.140 | 38575.2 |
451 | 2021-11-21 00:29:32 | offish | 2 | 82551 | 25 | 2.156 | 38289.0 |
450 | 2021-11-19 04:47:49 | offish | 2 | 82551 | 25 | 2.063 | 40015.0 |
449 | 2021-11-18 16:24:46 | offish | 2 | 82551 | 25 | 2.470 | 33421.5 |
448 | 2021-11-18 04:35:37 | offish | 2 | 82551 | 25 | 2.533 | 32590.2 |
447 | 2021-11-17 19:59:47 | offish | 2 | 82551 | 25 | 2.093 | 39441.5 |
446 | 2021-11-15 22:00:18 | offish | 2 | 82551 | 25 | 2.563 | 32208.7 |
445 | 2021-11-15 13:22:38 | offish | 2 | 82551 | 25 | 2.423 | 34069.7 |
444 | 2021-11-14 20:08:35 | offish | 2 | 82551 | 25 | 2.343 | 35233.0 |
443 | 2021-11-14 08:42:32 | offish | 2 | 82551 | 25 | 4.140 | 19939.9 |
442 | 2021-11-13 22:53:30 | offish | 2 | 82551 | 25 | 2.516 | 32810.4 |
441 | 2021-11-13 13:22:54 | offish | 2 | 82551 | 25 | 5.003 | 16500.3 |
440 | 2021-11-12 19:35:55 | offish | 2 | 82551 | 25 | 2.750 | 30018.5 |
439 | 2021-11-12 07:38:45 | offish | 2 | 82551 | 25 | 2.810 | 29377.6 |
438 | 2021-11-11 12:22:33 | offish | 2 | 82551 | 25 | 5.030 | 16411.7 |