History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"idea"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
534 | 2024-04-27 11:44:26 | idea | 2 | 29872 | 117 | 1.013 | 29488.6 |
533 | 2024-04-25 16:15:20 | idea | 1 | 13983 | 7 | 0.233 | 60012.9 |
532 | 2024-04-16 07:50:43 | idea | 1 | 13983 | 7 | 0.233 | 60012.9 |
531 | 2024-04-16 07:35:12 | idea | 1 | 13983 | 7 | 0.250 | 55932.0 |
530 | 2024-04-16 06:21:11 | idea | 1 | 13983 | 7 | 0.233 | 60012.9 |
529 | 2024-04-06 05:41:24 | idea | 2 | 29872 | 117 | 1.906 | 15672.6 |
528 | 2024-04-06 05:41:18 | idea | 1 | 13983 | 7 | 0.233 | 60012.9 |
527 | 2024-04-05 00:57:09 | idea | 1 | 13983 | 7 | 0.310 | 45106.5 |
526 | 2024-03-31 03:19:51 | idea | 1 | 13983 | 7 | 0.513 | 27257.3 |
525 | 2024-03-28 13:34:03 | idea | 1 | 13983 | 7 | 0.250 | 55932.0 |
524 | 2024-03-26 20:57:43 | idea | 1 | 13983 | 7 | 0.233 | 60012.9 |
523 | 2024-03-07 04:40:11 | idea | 1 | 13983 | 7 | 0.783 | 17858.2 |
522 | 2024-03-05 19:34:01 | idea | 1 | 13983 | 7 | 0.236 | 59250.0 |
521 | 2024-03-05 14:19:24 | idea | 1 | 13983 | 7 | 0.263 | 53167.3 |
520 | 2024-02-29 22:39:44 | idea | 1 | 13983 | 7 | 0.263 | 53167.3 |
519 | 2024-02-25 16:36:21 | idea | 1 | 13983 | 7 | 0.500 | 27966.0 |
518 | 2024-02-03 19:41:11 | idea | 1 | 13983 | 7 | 0.500 | 27966.0 |
517 | 2024-02-02 23:27:21 | idea | 1 | 13983 | 7 | 0.250 | 55932.0 |
516 | 2024-01-28 15:17:11 | idea | 1 | 13983 | 7 | 0.250 | 55932.0 |
515 | 2024-01-26 00:04:57 | idea | 1 | 13983 | 7 | 0.420 | 33292.9 |
514 | 2023-12-30 11:08:30 | idea | 1 | 13983 | 7 | 0.250 | 55932.0 |
513 | 2023-12-30 07:33:34 | idea | 2 | 29872 | 117 | 0.733 | 40753.1 |
512 | 2023-12-22 10:55:04 | idea | 1 | 13983 | 7 | 0.216 | 64736.1 |
511 | 2023-12-20 22:36:11 | idea | 2 | 29872 | 117 | 0.936 | 31914.5 |
510 | 2023-12-09 05:13:39 | idea | 2 | 29872 | 117 | 0.830 | 35990.4 |
509 | 2023-11-26 03:30:33 | idea | 1 | 13983 | 7 | 0.200 | 69915.0 |
508 | 2023-11-23 22:32:34 | idea | 1 | 13983 | 7 | 0.200 | 69915.0 |
507 | 2023-11-17 08:15:37 | idea | 1 | 13983 | 7 | 0.250 | 55932.0 |
506 | 2023-11-12 20:59:32 | idea | 2 | 29872 | 117 | 0.890 | 33564.0 |
505 | 2023-11-10 19:19:21 | idea | 1 | 13983 | 7 | 0.250 | 55932.0 |
504 | 2023-11-02 07:40:17 | idea | 1 | 13983 | 7 | 0.513 | 27257.3 |
503 | 2023-11-01 20:23:08 | idea | 2 | 29872 | 117 | 1.560 | 19148.7 |
502 | 2023-10-26 01:40:34 | idea | 1 | 13983 | 7 | 0.203 | 68881.8 |
501 | 2023-10-23 00:18:27 | idea | 1 | 13983 | 7 | 0.216 | 64736.1 |
500 | 2023-10-21 09:08:55 | idea | 1 | 13983 | 7 | 0.283 | 49409.9 |
499 | 2023-10-17 09:10:24 | idea | 2 | 29872 | 117 | 0.733 | 40753.1 |
498 | 2023-10-16 18:33:00 | idea | 1 | 13983 | 7 | 0.220 | 63559.1 |
497 | 2023-10-12 03:31:03 | idea | 1 | 13983 | 7 | 0.513 | 27257.3 |
496 | 2023-10-05 03:42:26 | idea | 1 | 13983 | 7 | 0.236 | 59250.0 |
495 | 2023-10-03 19:36:20 | idea | 2 | 29872 | 117 | 0.813 | 36742.9 |
494 | 2023-10-03 01:47:23 | idea | 2 | 29872 | 117 | 0.733 | 40753.1 |
493 | 2023-09-25 23:23:18 | idea | 1 | 13983 | 7 | 0.233 | 60012.9 |
492 | 2023-09-24 12:53:03 | idea | 1 | 13983 | 7 | 0.250 | 55932.0 |
491 | 2023-08-17 15:25:06 | idea | 1 | 13983 | 7 | 0.203 | 68881.8 |
490 | 2023-08-06 12:51:51 | idea | 1 | 13983 | 7 | 0.203 | 68881.8 |
489 | 2023-07-14 15:46:17 | idea | 2 | 29872 | 117 | 0.800 | 37340.0 |
488 | 2023-05-19 06:25:44 | idea | 1 | 13983 | 7 | 0.260 | 53780.8 |
487 | 2023-05-02 16:24:24 | idea | 1 | 13983 | 7 | 0.220 | 63559.1 |
486 | 2023-03-31 21:55:44 | idea | 2 | 29872 | 117 | 0.830 | 35990.4 |
485 | 2023-03-17 08:26:50 | idea | 1 | 13983 | 7 | 0.233 | 60012.9 |
484 | 2023-01-24 03:39:37 | idea | 1 | 13983 | 7 | 0.406 | 34440.9 |
483 | 2023-01-05 11:27:38 | idea | 1 | 13983 | 7 | 0.203 | 68881.8 |
482 | 2022-12-28 09:44:04 | idea | 2 | 29872 | 117 | 0.860 | 34734.9 |
481 | 2022-10-06 05:03:36 | idea | 1 | 13983 | 7 | 0.233 | 60012.9 |
480 | 2022-10-05 12:15:43 | idea | 1 | 13983 | 7 | 0.203 | 68881.8 |
479 | 2022-09-19 21:56:07 | idea | 1 | 13983 | 7 | 0.220 | 63559.1 |
478 | 2022-09-18 16:13:30 | idea | 1 | 13983 | 7 | 0.220 | 63559.1 |
477 | 2022-09-12 04:28:23 | idea | 1 | 13983 | 7 | 0.250 | 55932.0 |
476 | 2022-09-03 18:43:18 | idea | 1 | 13983 | 7 | 0.220 | 63559.1 |
475 | 2022-09-01 06:26:40 | idea | 1 | 13983 | 7 | 0.220 | 63559.1 |
474 | 2022-08-30 02:07:59 | idea | 2 | 29872 | 117 | 0.750 | 39829.3 |
473 | 2022-08-14 11:49:49 | idea | 1 | 13983 | 7 | 0.220 | 63559.1 |
472 | 2022-08-06 21:33:34 | idea | 1 | 13983 | 7 | 0.220 | 63559.1 |
471 | 2022-07-17 21:39:04 | idea | 1 | 13983 | 7 | 0.220 | 63559.1 |
470 | 2022-07-11 08:31:39 | idea | 2 | 29872 | 117 | 0.750 | 39829.3 |
469 | 2022-07-02 21:21:22 | idea | 1 | 13983 | 7 | 0.266 | 52567.7 |
468 | 2022-06-25 22:15:50 | idea | 2 | 29872 | 117 | 0.733 | 40753.1 |
467 | 2022-06-23 04:04:20 | idea | 1 | 13983 | 7 | 0.216 | 64736.1 |
466 | 2022-05-27 22:18:08 | idea | 1 | 13983 | 7 | 0.220 | 63559.1 |
465 | 2022-03-07 05:06:28 | idea | 1 | 13983 | 7 | 0.220 | 63559.1 |
464 | 2022-03-03 18:45:06 | idea | 1 | 13983 | 7 | 0.200 | 69915.0 |
463 | 2022-02-11 07:33:37 | idea | 1 | 13983 | 7 | 0.250 | 55932.0 |
462 | 2022-02-09 03:40:27 | idea | 1 | 13983 | 7 | 0.203 | 68881.8 |
461 | 2021-12-02 21:45:00 | idea | 1 | 13983 | 7 | 0.216 | 64736.1 |
460 | 2021-11-20 03:30:20 | idea | 1 | 13983 | 7 | 0.233 | 60012.9 |
459 | 2021-10-14 10:33:06 | idea | 1 | 13983 | 7 | 0.203 | 68881.8 |
458 | 2021-10-12 09:54:21 | idea | 1 | 13983 | 7 | 0.220 | 63559.1 |
457 | 2021-09-23 09:53:19 | idea | 1 | 13983 | 7 | 0.236 | 59250.0 |
456 | 2021-09-21 02:10:23 | idea | 1 | 13983 | 7 | 0.483 | 28950.3 |
455 | 2021-08-20 13:18:07 | idea | 1 | 13983 | 7 | 0.236 | 59250.0 |
454 | 2021-07-18 00:23:24 | idea | 1 | 13983 | 7 | 0.236 | 59250.0 |
453 | 2021-05-19 22:23:47 | idea | 1 | 13983 | 7 | 0.236 | 59250.0 |
452 | 2021-05-07 06:59:10 | idea | 1 | 13983 | 7 | 0.233 | 60012.9 |
451 | 2021-02-17 02:31:34 | idea | 1 | 13983 | 7 | 0.263 | 53167.3 |
450 | 2021-02-09 12:24:45 | idea | 1 | 13983 | 7 | 0.220 | 63559.1 |
449 | 2021-01-21 00:51:29 | idea | 1 | 13983 | 7 | 0.233 | 60012.9 |
448 | 2020-12-30 22:50:05 | idea | 1 | 13983 | 7 | 0.220 | 63559.1 |
447 | 2020-12-21 13:34:40 | idea | 1 | 13983 | 7 | 0.216 | 64736.1 |
446 | 2020-11-07 19:25:29 | idea | 1 | 13983 | 7 | 0.236 | 59250.0 |
445 | 2020-11-02 00:08:21 | idea | 1 | 13983 | 7 | 0.250 | 55932.0 |
444 | 2020-11-01 04:33:20 | idea | 1 | 13983 | 7 | 0.236 | 59250.0 |
443 | 2020-10-16 08:28:38 | idea | 1 | 13983 | 7 | 0.203 | 68881.8 |
442 | 2020-10-10 05:00:38 | idea | 1 | 13983 | 7 | 0.220 | 63559.1 |
441 | 2020-09-14 17:11:29 | idea | 1 | 13983 | 7 | 0.250 | 55932.0 |
440 | 2020-08-30 13:21:56 | idea | 1 | 13983 | 7 | 0.236 | 59250.0 |
439 | 2020-08-26 08:03:03 | idea | 1 | 13983 | 7 | 0.266 | 52567.7 |
438 | 2020-08-25 14:35:09 | idea | 1 | 13983 | 7 | 0.236 | 59250.0 |
437 | 2020-08-25 02:54:46 | idea | 1 | 13983 | 7 | 0.220 | 63559.1 |
436 | 2020-08-21 06:51:10 | idea | 1 | 13983 | 7 | 0.216 | 64736.1 |
435 | 2020-08-19 23:33:28 | idea | 1 | 13983 | 7 | 0.216 | 64736.1 |