History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"cottars"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
521 | 2024-04-26 22:15:43 | cottars | 1 | 69583 | 6 | 1.143 | 60877.5 |
520 | 2024-04-16 15:53:39 | cottars | 1 | 69583 | 6 | 1.280 | 54361.7 |
519 | 2024-04-16 15:53:01 | cottars | 1 | 69583 | 6 | 2.983 | 23326.5 |
518 | 2024-04-10 23:57:06 | cottars | 3 | 134027 | 449 | 12.986 | 10320.9 |
517 | 2024-04-09 03:25:13 | cottars | 2 | 107671 | 38 | 3.953 | 27237.8 |
516 | 2024-04-09 03:18:09 | cottars | 3 | 134027 | 449 | 7.640 | 17542.8 |
515 | 2024-04-08 06:45:41 | cottars | 2 | 107671 | 38 | 4.233 | 25436.1 |
514 | 2024-04-08 06:45:22 | cottars | 3 | 134027 | 449 | 7.780 | 17227.1 |
513 | 2024-04-08 02:54:33 | cottars | 2 | 107671 | 38 | 3.623 | 29718.7 |
512 | 2024-04-07 06:36:30 | cottars | 3 | 134027 | 449 | 20.983 | 6387.4 |
511 | 2024-04-07 04:21:56 | cottars | 3 | 134027 | 449 | 14.686 | 9126.2 |
510 | 2024-01-07 16:04:33 | cottars | 1 | 69583 | 6 | 1.110 | 62687.4 |
509 | 2023-12-09 22:46:22 | cottars | 2 | 107671 | 38 | 3.233 | 33303.7 |
508 | 2023-12-08 17:44:39 | cottars | 3 | 134027 | 449 | 6.856 | 19548.9 |
507 | 2023-11-21 14:55:08 | cottars | 1 | 69583 | 6 | 1.233 | 56433.9 |
506 | 2023-11-21 05:08:01 | cottars | 1 | 69583 | 6 | 1.190 | 58473.1 |
505 | 2023-11-20 11:23:37 | cottars | 1 | 69583 | 6 | 1.186 | 58670.3 |
504 | 2023-11-12 20:17:36 | cottars | 1 | 69583 | 6 | 1.173 | 59320.5 |
503 | 2023-11-01 21:58:19 | cottars | 1 | 69583 | 6 | 1.173 | 59320.5 |
502 | 2023-11-01 08:33:53 | cottars | 1 | 69583 | 6 | 1.080 | 64428.7 |
501 | 2023-10-31 09:12:52 | cottars | 1 | 69583 | 6 | 1.153 | 60349.5 |
500 | 2023-10-15 01:55:42 | cottars | 1 | 69583 | 6 | 1.250 | 55666.4 |
499 | 2023-09-24 23:06:33 | cottars | 1 | 69583 | 6 | 1.170 | 59472.6 |
498 | 2023-09-17 01:46:47 | cottars | 1 | 69583 | 6 | 2.420 | 28753.3 |
497 | 2023-09-06 19:00:59 | cottars | 2 | 107671 | 38 | 3.403 | 31640.0 |
496 | 2023-09-04 18:07:41 | cottars | 3 | 134027 | 449 | 5.796 | 23124.1 |
495 | 2023-08-23 14:03:49 | cottars | 1 | 69583 | 6 | 1.093 | 63662.4 |
494 | 2023-08-01 08:10:38 | cottars | 1 | 69583 | 6 | 1.203 | 57841.2 |
493 | 2023-05-26 12:35:24 | cottars | 1 | 69583 | 6 | 1.110 | 62687.4 |
492 | 2023-05-23 05:28:50 | cottars | 2 | 107671 | 38 | 3.110 | 34620.9 |
491 | 2023-05-21 06:47:13 | cottars | 3 | 134027 | 449 | 6.656 | 20136.3 |
490 | 2023-05-05 12:03:21 | cottars | 3 | 134027 | 449 | 12.220 | 10967.8 |
489 | 2023-04-23 23:03:26 | cottars | 1 | 69583 | 6 | 1.096 | 63488.1 |
488 | 2023-03-20 23:29:11 | cottars | 1 | 69583 | 6 | 1.236 | 56296.9 |
487 | 2023-03-19 09:20:19 | cottars | 3 | 134027 | 449 | 9.140 | 14663.8 |
486 | 2023-03-01 17:16:05 | cottars | 3 | 134027 | 449 | 5.813 | 23056.4 |
485 | 2023-02-28 19:13:21 | cottars | 2 | 107671 | 38 | 2.876 | 37437.8 |
484 | 2023-01-24 02:49:20 | cottars | 3 | 134027 | 449 | 6.466 | 20728.0 |
483 | 2023-01-19 00:21:33 | cottars | 1 | 69583 | 6 | 1.203 | 57841.2 |
482 | 2023-01-07 14:45:25 | cottars | 1 | 69583 | 6 | 1.206 | 57697.3 |
481 | 2023-01-06 01:49:40 | cottars | 3 | 134027 | 449 | 5.736 | 23365.9 |
480 | 2022-12-31 13:59:37 | cottars | 3 | 134027 | 449 | 6.983 | 19193.3 |
479 | 2022-12-22 12:43:59 | cottars | 3 | 134027 | 449 | 6.280 | 21341.9 |
478 | 2022-12-11 15:17:48 | cottars | 2 | 107671 | 38 | 3.140 | 34290.1 |
477 | 2022-12-11 00:10:25 | cottars | 3 | 134027 | 449 | 5.813 | 23056.4 |
476 | 2022-11-22 07:57:04 | cottars | 3 | 134027 | 449 | 6.453 | 20769.7 |
475 | 2022-11-16 01:03:20 | cottars | 3 | 134027 | 449 | 6.000 | 22337.8 |
474 | 2022-11-14 16:52:48 | cottars | 3 | 134027 | 449 | 6.466 | 20728.0 |
473 | 2022-11-11 14:19:15 | cottars | 3 | 134027 | 449 | 7.373 | 18178.1 |
472 | 2022-10-15 20:43:48 | cottars | 1 | 69583 | 6 | 1.266 | 54962.9 |
471 | 2022-10-09 16:09:00 | cottars | 3 | 134027 | 449 | 5.703 | 23501.1 |
470 | 2022-10-04 03:16:11 | cottars | 1 | 69583 | 6 | 1.140 | 61037.7 |
469 | 2022-09-30 23:18:54 | cottars | 3 | 134027 | 449 | 6.313 | 21230.3 |
468 | 2022-09-29 20:05:37 | cottars | 3 | 134027 | 449 | 6.783 | 19759.3 |
467 | 2022-09-11 07:42:40 | cottars | 3 | 134027 | 449 | 7.236 | 18522.2 |
466 | 2022-09-01 06:09:55 | cottars | 3 | 134027 | 449 | 5.920 | 22639.7 |
465 | 2022-08-27 15:53:19 | cottars | 3 | 134027 | 449 | 5.733 | 23378.2 |
464 | 2022-08-23 21:33:58 | cottars | 3 | 134027 | 449 | 6.200 | 21617.3 |
463 | 2022-07-30 01:56:58 | cottars | 2 | 107671 | 38 | 2.876 | 37437.8 |
462 | 2022-07-26 04:14:16 | cottars | 3 | 134027 | 449 | 5.796 | 23124.1 |
461 | 2022-06-25 13:46:54 | cottars | 1 | 69583 | 6 | 1.110 | 62687.4 |
460 | 2022-05-20 15:05:57 | cottars | 1 | 69583 | 6 | 1.233 | 56433.9 |
459 | 2022-05-18 09:41:46 | cottars | 1 | 69583 | 6 | 1.143 | 60877.5 |
458 | 2022-03-09 07:49:53 | cottars | 1 | 69583 | 6 | 2.440 | 28517.6 |
457 | 2022-03-03 01:47:25 | cottars | 2 | 107671 | 38 | 2.953 | 36461.6 |
456 | 2022-02-04 04:35:38 | cottars | 1 | 69583 | 6 | 1.110 | 62687.4 |
455 | 2021-12-16 23:03:40 | cottars | 1 | 69583 | 6 | 1.156 | 60192.9 |
454 | 2021-12-15 17:24:09 | cottars | 2 | 107671 | 38 | 4.406 | 24437.4 |
453 | 2021-11-22 05:20:48 | cottars | 1 | 69583 | 6 | 1.143 | 60877.5 |
452 | 2021-11-21 20:18:25 | cottars | 1 | 69583 | 6 | 1.516 | 45899.1 |
451 | 2021-11-18 20:09:05 | cottars | 1 | 69583 | 6 | 1.250 | 55666.4 |
450 | 2021-10-03 09:38:59 | cottars | 1 | 69583 | 6 | 1.080 | 64428.7 |
449 | 2021-10-01 07:25:46 | cottars | 1 | 69583 | 6 | 1.376 | 50569.0 |
448 | 2021-08-25 10:47:42 | cottars | 1 | 69583 | 6 | 2.220 | 31343.7 |
447 | 2021-08-23 07:02:16 | cottars | 1 | 69583 | 6 | 2.156 | 32274.1 |
446 | 2021-08-16 01:07:44 | cottars | 1 | 69583 | 6 | 1.063 | 65459.1 |
445 | 2021-07-27 12:19:50 | cottars | 3 | 134027 | 449 | 6.890 | 19452.4 |
444 | 2021-06-28 05:43:10 | cottars | 3 | 134027 | 449 | 6.203 | 21606.8 |
443 | 2021-05-11 23:55:24 | cottars | 1 | 69583 | 6 | 1.200 | 57985.8 |
442 | 2021-04-15 10:51:54 | cottars | 1 | 69583 | 6 | 1.110 | 62687.4 |
441 | 2021-02-07 14:14:59 | cottars | 1 | 69583 | 6 | 1.203 | 57841.2 |
440 | 2021-01-28 13:58:45 | cottars | 1 | 69583 | 6 | 1.173 | 59320.5 |
439 | 2020-12-30 21:40:32 | cottars | 1 | 69583 | 6 | 1.110 | 62687.4 |
438 | 2020-11-05 19:55:18 | cottars | 1 | 69583 | 6 | 1.203 | 57841.2 |
437 | 2020-10-26 19:47:04 | cottars | 2 | 107671 | 38 | 2.906 | 37051.3 |
436 | 2020-10-24 16:08:49 | cottars | 1 | 69583 | 6 | 1.466 | 47464.5 |
435 | 2020-10-21 08:32:42 | cottars | 1 | 69583 | 6 | 1.140 | 61037.7 |
434 | 2020-10-19 02:54:17 | cottars | 1 | 69583 | 6 | 1.216 | 57222.9 |
433 | 2020-10-18 17:14:04 | cottars | 1 | 69583 | 6 | 1.173 | 59320.5 |
432 | 2020-10-16 10:39:09 | cottars | 1 | 69583 | 6 | 1.263 | 55093.4 |
431 | 2020-08-28 09:24:51 | cottars | 1 | 69583 | 6 | 1.110 | 62687.4 |
430 | 2020-08-27 21:58:49 | cottars | 1 | 69583 | 6 | 1.236 | 56296.9 |
429 | 2020-08-20 19:21:12 | cottars | 1 | 69583 | 6 | 1.156 | 60192.9 |
428 | 2020-08-18 06:16:07 | cottars | 1 | 69583 | 6 | 1.143 | 60877.5 |
427 | 2020-08-17 21:42:18 | cottars | 1 | 69583 | 6 | 1.326 | 52475.9 |
426 | 2020-08-04 23:39:26 | cottars | 1 | 69583 | 6 | 1.093 | 63662.4 |
425 | 2020-08-01 18:05:12 | cottars | 1 | 69583 | 6 | 1.173 | 59320.5 |
424 | 2020-06-21 06:54:56 | cottars | 1 | 69583 | 6 | 1.576 | 44151.6 |
423 | 2020-06-20 06:39:46 | cottars | 1 | 69583 | 6 | 1.186 | 58670.3 |
422 | 2020-06-17 04:53:24 | cottars | 1 | 69583 | 6 | 1.126 | 61796.6 |