History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"potable"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
531 | 2024-04-27 17:33:37 | potable | 1 | 69583 | 8 | 1.406 | 49490.0 |
530 | 2024-04-22 13:47:53 | potable | 1 | 69583 | 8 | 1.436 | 48456.1 |
529 | 2024-03-30 19:23:40 | potable | 1 | 69583 | 8 | 3.626 | 19190.0 |
528 | 2024-03-26 08:30:04 | potable | 1 | 69583 | 8 | 1.326 | 52475.9 |
527 | 2024-03-21 12:09:50 | potable | 3 | 134027 | 379 | 19.640 | 6824.2 |
526 | 2024-03-15 12:28:35 | potable | 2 | 107671 | 56 | 4.190 | 25697.1 |
525 | 2024-03-15 12:09:34 | potable | 3 | 134027 | 379 | 8.690 | 15423.1 |
524 | 2024-03-15 02:27:04 | potable | 3 | 134027 | 379 | 10.686 | 12542.3 |
523 | 2024-03-14 14:11:08 | potable | 3 | 134027 | 379 | 25.923 | 5170.2 |
522 | 2024-03-14 14:10:21 | potable | 2 | 107671 | 56 | 3.983 | 27032.6 |
521 | 2024-03-13 21:54:56 | potable | 2 | 107671 | 56 | 8.470 | 12712.0 |
520 | 2024-03-13 21:54:16 | potable | 3 | 134027 | 379 | 8.626 | 15537.6 |
519 | 2024-03-13 17:47:05 | potable | 2 | 107671 | 56 | 11.813 | 9114.6 |
518 | 2024-03-13 17:47:06 | potable | 3 | 134027 | 379 | 8.436 | 15887.5 |
517 | 2024-03-13 17:46:32 | potable | 1 | 69583 | 8 | 1.390 | 50059.7 |
516 | 2024-03-13 17:46:12 | potable | 3 | 134027 | 379 | 14.470 | 9262.4 |
515 | 2024-03-13 17:46:13 | potable | 2 | 107671 | 56 | 4.296 | 25063.1 |
514 | 2024-03-13 17:46:03 | potable | 1 | 69583 | 8 | 1.280 | 54361.7 |
513 | 2024-03-10 13:35:04 | potable | 1 | 69583 | 8 | 3.516 | 19790.4 |
512 | 2024-02-29 06:37:24 | potable | 3 | 134027 | 379 | 7.360 | 18210.2 |
511 | 2024-02-28 11:17:46 | potable | 3 | 134027 | 379 | 12.843 | 10435.8 |
510 | 2024-02-27 02:02:50 | potable | 3 | 134027 | 379 | 9.953 | 13466.0 |
509 | 2024-02-26 04:14:16 | potable | 3 | 134027 | 379 | 7.843 | 17088.7 |
508 | 2024-02-25 15:29:54 | potable | 3 | 134027 | 379 | 6.076 | 22058.4 |
507 | 2024-02-24 10:55:22 | potable | 3 | 134027 | 379 | 6.750 | 19855.9 |
506 | 2024-02-23 16:35:39 | potable | 3 | 134027 | 379 | 5.873 | 22820.9 |
505 | 2024-02-22 17:58:54 | potable | 3 | 134027 | 379 | 15.733 | 8518.8 |
504 | 2024-02-14 09:24:51 | potable | 2 | 107671 | 56 | 3.563 | 30219.2 |
503 | 2024-02-14 08:02:24 | potable | 3 | 134027 | 379 | 7.346 | 18244.9 |
502 | 2024-02-12 14:00:16 | potable | 1 | 69583 | 8 | 1.123 | 61961.7 |
501 | 2024-02-12 13:49:25 | potable | 2 | 107671 | 56 | 3.016 | 35699.9 |
500 | 2024-02-12 13:47:28 | potable | 3 | 134027 | 379 | 8.173 | 16398.8 |
499 | 2024-02-10 09:38:48 | potable | 2 | 107671 | 56 | 2.846 | 37832.4 |
498 | 2024-02-10 09:20:26 | potable | 3 | 134027 | 379 | 6.593 | 20328.7 |
497 | 2024-02-09 12:40:09 | potable | 3 | 134027 | 379 | 6.890 | 19452.4 |
496 | 2024-02-09 07:14:37 | potable | 1 | 69583 | 8 | 1.296 | 53690.6 |
495 | 2024-02-09 07:06:14 | potable | 2 | 107671 | 56 | 3.420 | 31482.7 |
494 | 2024-02-09 07:02:42 | potable | 3 | 134027 | 379 | 7.656 | 17506.1 |
493 | 2024-02-08 22:13:08 | potable | 3 | 134027 | 379 | 11.516 | 11638.3 |
492 | 2024-02-07 22:45:56 | potable | 3 | 134027 | 379 | 13.376 | 10020.0 |
491 | 2024-02-07 22:16:29 | potable | 3 | 134027 | 379 | 15.953 | 8401.4 |
490 | 2024-02-07 21:36:50 | potable | 3 | 134027 | 379 | 6.110 | 21935.7 |
489 | 2024-01-11 22:07:12 | potable | 1 | 69583 | 8 | 1.296 | 53690.6 |
488 | 2024-01-10 06:09:23 | potable | 1 | 69583 | 8 | 1.110 | 62687.4 |
487 | 2024-01-04 16:47:39 | potable | 1 | 69583 | 8 | 1.080 | 64428.7 |
486 | 2023-12-24 12:43:13 | potable | 1 | 69583 | 8 | 1.126 | 61796.6 |
485 | 2023-12-21 08:05:47 | potable | 1 | 69583 | 8 | 1.140 | 61037.7 |
484 | 2023-11-25 17:31:47 | potable | 3 | 134027 | 379 | 6.126 | 21878.4 |
483 | 2023-11-24 05:36:01 | potable | 3 | 134027 | 379 | 8.280 | 16186.8 |
482 | 2023-11-20 01:27:21 | potable | 1 | 69583 | 8 | 1.106 | 62914.1 |
481 | 2023-11-19 10:15:42 | potable | 3 | 134027 | 379 | 8.470 | 15823.7 |
480 | 2023-11-05 02:48:54 | potable | 3 | 134027 | 379 | 6.466 | 20728.0 |
479 | 2023-11-05 02:48:52 | potable | 2 | 107671 | 56 | 3.126 | 34443.7 |
478 | 2023-10-28 07:17:54 | potable | 1 | 69583 | 8 | 2.373 | 29322.8 |
477 | 2023-10-24 13:46:24 | potable | 1 | 69583 | 8 | 1.063 | 65459.1 |
476 | 2023-10-21 03:01:10 | potable | 1 | 69583 | 8 | 1.656 | 42018.7 |
475 | 2023-10-12 07:08:26 | potable | 1 | 69583 | 8 | 1.203 | 57841.2 |
474 | 2023-10-06 04:49:24 | potable | 1 | 69583 | 8 | 2.453 | 28366.5 |
473 | 2023-09-22 22:09:01 | potable | 1 | 69583 | 8 | 1.140 | 61037.7 |
472 | 2023-08-26 11:24:33 | potable | 3 | 134027 | 379 | 6.206 | 21596.4 |
471 | 2023-08-22 22:03:03 | potable | 1 | 69583 | 8 | 1.126 | 61796.6 |
470 | 2023-08-21 22:26:38 | potable | 1 | 69583 | 8 | 1.080 | 64428.7 |
469 | 2023-07-04 21:19:31 | potable | 3 | 134027 | 379 | 6.220 | 21547.7 |
468 | 2023-07-03 23:53:58 | potable | 3 | 134027 | 379 | 6.780 | 19768.0 |
467 | 2023-07-02 20:37:44 | potable | 3 | 134027 | 379 | 7.216 | 18573.6 |
466 | 2023-07-01 19:48:43 | potable | 3 | 134027 | 379 | 6.626 | 20227.4 |
465 | 2023-06-27 20:40:40 | potable | 3 | 134027 | 379 | 6.280 | 21341.9 |
464 | 2023-06-25 20:24:35 | potable | 3 | 134027 | 379 | 7.110 | 18850.5 |
463 | 2023-06-24 19:26:34 | potable | 3 | 134027 | 379 | 6.860 | 19537.5 |
462 | 2023-06-22 19:33:47 | potable | 3 | 134027 | 379 | 11.686 | 11469.0 |
461 | 2023-06-21 19:18:38 | potable | 3 | 134027 | 379 | 6.846 | 19577.4 |
460 | 2023-06-20 20:34:14 | potable | 3 | 134027 | 379 | 7.190 | 18640.8 |
459 | 2023-06-19 20:04:54 | potable | 3 | 134027 | 379 | 9.720 | 13788.8 |
458 | 2023-06-18 20:15:32 | potable | 3 | 134027 | 379 | 6.860 | 19537.5 |
457 | 2023-06-15 11:00:35 | potable | 3 | 134027 | 379 | 6.656 | 20136.3 |
456 | 2023-06-14 14:32:42 | potable | 3 | 134027 | 379 | 7.233 | 18529.9 |
455 | 2023-06-13 21:56:00 | potable | 3 | 134027 | 379 | 6.690 | 20033.9 |
454 | 2023-05-25 11:52:55 | potable | 1 | 69583 | 8 | 1.076 | 64668.2 |
453 | 2023-05-08 05:34:32 | potable | 1 | 69583 | 8 | 1.060 | 65644.3 |
452 | 2023-03-19 23:22:13 | potable | 1 | 69583 | 8 | 1.063 | 65459.1 |
451 | 2023-01-25 20:57:30 | potable | 1 | 69583 | 8 | 1.080 | 64428.7 |
450 | 2023-01-07 00:46:58 | potable | 1 | 69583 | 8 | 1.186 | 58670.3 |
449 | 2022-12-24 11:05:55 | potable | 3 | 134027 | 379 | 9.706 | 13808.7 |
448 | 2022-12-02 00:11:47 | potable | 3 | 134027 | 379 | 6.860 | 19537.5 |
447 | 2022-11-25 12:38:14 | potable | 1 | 69583 | 8 | 1.063 | 65459.1 |
446 | 2022-11-07 14:36:45 | potable | 3 | 134027 | 379 | 6.233 | 21502.8 |
445 | 2022-10-30 20:42:49 | potable | 3 | 134027 | 379 | 6.686 | 20045.9 |
444 | 2022-10-11 13:32:29 | potable | 1 | 69583 | 8 | 1.203 | 57841.2 |
443 | 2022-10-03 20:59:35 | potable | 1 | 69583 | 8 | 1.093 | 63662.4 |
442 | 2022-09-25 18:03:03 | potable | 3 | 134027 | 379 | 5.826 | 23005.0 |
441 | 2022-06-24 22:39:26 | potable | 1 | 69583 | 8 | 1.203 | 57841.2 |
440 | 2022-05-23 20:22:26 | potable | 1 | 69583 | 8 | 1.126 | 61796.6 |
439 | 2022-05-13 01:29:05 | potable | 1 | 69583 | 8 | 2.080 | 33453.4 |
438 | 2022-03-08 19:03:11 | potable | 1 | 69583 | 8 | 1.533 | 45390.1 |
437 | 2022-02-03 02:03:05 | potable | 1 | 69583 | 8 | 1.126 | 61796.6 |
436 | 2021-11-27 01:46:47 | potable | 1 | 69583 | 8 | 1.250 | 55666.4 |
435 | 2021-11-25 02:53:09 | potable | 1 | 69583 | 8 | 1.123 | 61961.7 |
434 | 2021-11-24 23:04:48 | potable | 1 | 69583 | 8 | 1.263 | 55093.4 |
433 | 2021-11-21 16:32:23 | potable | 1 | 69583 | 8 | 1.250 | 55666.4 |
432 | 2021-10-08 14:28:54 | potable | 1 | 69583 | 8 | 1.076 | 64668.2 |