History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"choice"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
542 | 2025-01-27 22:41:22 | choice | 1 | 48755 | 3 | 4.173 | 11683.4 |
541 | 2025-01-24 19:33:24 | choice | 1 | 48755 | 3 | 5.300 | 9199.1 |
540 | 2025-01-06 17:07:15 | choice | 1 | 48755 | 3 | 3.720 | 13106.2 |
539 | 2024-12-28 20:13:24 | choice | 1 | 48755 | 3 | 1.970 | 24748.7 |
538 | 2024-12-28 11:31:11 | choice | 1 | 48755 | 3 | 2.093 | 23294.3 |
537 | 2024-12-17 09:54:08 | choice | 1 | 48755 | 3 | 1.703 | 28628.9 |
536 | 2024-12-09 21:23:03 | choice | 2 | 82551 | 41 | 11.470 | 7197.1 |
535 | 2024-12-09 15:37:00 | choice | 3 | 112716 | 516 | 27.063 | 4164.9 |
534 | 2024-12-09 00:15:06 | choice | 2 | 82551 | 41 | 15.363 | 5373.4 |
533 | 2024-12-09 00:06:11 | choice | 3 | 112716 | 516 | 5.796 | 19447.2 |
532 | 2024-12-07 16:41:44 | choice | 2 | 82551 | 41 | 2.500 | 33020.4 |
531 | 2024-12-07 16:41:35 | choice | 3 | 112716 | 516 | 5.423 | 20784.8 |
530 | 2024-12-07 11:12:08 | choice | 3 | 112716 | 516 | 5.016 | 22471.3 |
529 | 2024-12-07 11:12:09 | choice | 2 | 82551 | 41 | 2.376 | 34743.7 |
528 | 2024-12-07 11:11:49 | choice | 1 | 48755 | 3 | 0.750 | 65006.7 |
527 | 2024-11-28 02:22:31 | choice | 1 | 48755 | 3 | 3.890 | 12533.4 |
526 | 2024-11-27 15:36:00 | choice | 1 | 48755 | 3 | 4.563 | 10684.9 |
525 | 2024-11-07 10:29:28 | choice | 1 | 48755 | 3 | 2.016 | 24184.0 |
524 | 2024-11-07 06:06:29 | choice | 1 | 48755 | 3 | 5.670 | 8598.8 |
523 | 2024-10-28 12:17:30 | choice | 1 | 48755 | 3 | 6.406 | 7610.8 |
522 | 2024-10-14 05:12:20 | choice | 1 | 48755 | 3 | 4.233 | 11517.8 |
521 | 2024-10-08 06:56:10 | choice | 1 | 48755 | 3 | 2.953 | 16510.3 |
520 | 2024-10-06 22:53:27 | choice | 1 | 48755 | 3 | 6.063 | 8041.4 |
519 | 2024-09-24 22:47:47 | choice | 2 | 82551 | 41 | 19.360 | 4264.0 |
518 | 2024-09-17 08:23:40 | choice | 1 | 48755 | 3 | 5.436 | 8968.9 |
517 | 2024-09-05 11:10:38 | choice | 3 | 112716 | 516 | 37.940 | 2970.9 |
516 | 2024-09-05 11:10:26 | choice | 2 | 82551 | 41 | 18.470 | 4469.5 |
515 | 2024-09-05 11:00:19 | choice | 3 | 112716 | 516 | 48.456 | 2326.2 |
514 | 2024-09-05 05:37:08 | choice | 3 | 112716 | 516 | 47.860 | 2355.1 |
513 | 2024-09-04 23:31:44 | choice | 1 | 48755 | 3 | 7.936 | 6143.5 |
512 | 2024-09-04 23:29:05 | choice | 3 | 112716 | 516 | 34.113 | 3304.2 |
511 | 2024-09-04 23:28:59 | choice | 2 | 82551 | 41 | 19.640 | 4203.2 |
510 | 2024-08-29 17:32:46 | choice | 1 | 48755 | 3 | 2.046 | 23829.4 |
509 | 2024-08-27 01:55:55 | choice | 1 | 48755 | 3 | 5.843 | 8344.2 |
508 | 2024-08-16 19:24:22 | choice | 1 | 48755 | 3 | 9.000 | 5417.2 |
507 | 2024-08-10 07:40:19 | choice | 1 | 48755 | 3 | 4.453 | 10948.8 |
506 | 2024-07-31 11:58:17 | choice | 1 | 48755 | 3 | 2.420 | 20146.7 |
505 | 2024-07-28 09:09:53 | choice | 1 | 48755 | 3 | 4.156 | 11731.2 |
504 | 2024-07-27 08:31:57 | choice | 1 | 48755 | 3 | 3.766 | 12946.1 |
503 | 2024-07-10 23:22:02 | choice | 1 | 48755 | 3 | 4.593 | 10615.1 |
502 | 2024-07-08 12:53:59 | choice | 1 | 48755 | 3 | 1.736 | 28084.7 |
501 | 2024-07-06 14:24:14 | choice | 1 | 48755 | 3 | 1.576 | 30935.9 |
500 | 2024-07-01 01:30:42 | choice | 1 | 48755 | 3 | 4.220 | 11553.3 |
499 | 2024-06-30 19:49:51 | choice | 1 | 48755 | 3 | 2.813 | 17332.0 |
498 | 2024-06-28 09:05:35 | choice | 1 | 48755 | 3 | 3.546 | 13749.3 |
497 | 2024-06-27 05:30:36 | choice | 3 | 112716 | 516 | 16.236 | 6942.4 |
496 | 2024-06-27 05:30:17 | choice | 1 | 48755 | 3 | 2.236 | 21804.6 |
495 | 2024-06-23 20:12:18 | choice | 3 | 112716 | 516 | 17.876 | 6305.4 |
494 | 2024-06-23 09:43:06 | choice | 3 | 112716 | 516 | 10.343 | 10897.8 |
493 | 2024-06-20 22:48:34 | choice | 3 | 112716 | 516 | 21.203 | 5316.0 |
492 | 2024-06-20 21:54:38 | choice | 3 | 112716 | 516 | 23.546 | 4787.1 |
491 | 2024-06-20 15:38:12 | choice | 3 | 112716 | 516 | 24.236 | 4650.8 |
490 | 2024-06-20 15:38:13 | choice | 2 | 82551 | 41 | 8.843 | 9335.2 |
489 | 2024-06-20 15:38:03 | choice | 1 | 48755 | 3 | 2.263 | 21544.4 |
488 | 2024-06-13 22:25:34 | choice | 1 | 48755 | 3 | 4.406 | 11065.6 |
487 | 2024-06-11 03:36:25 | choice | 1 | 48755 | 3 | 1.986 | 24549.3 |
486 | 2024-05-28 01:33:21 | choice | 1 | 48755 | 3 | 4.203 | 11600.0 |
485 | 2024-04-28 08:10:58 | choice | 1 | 48755 | 3 | 0.873 | 55847.7 |
484 | 2024-04-12 23:23:09 | choice | 2 | 82551 | 41 | 2.513 | 32849.6 |
483 | 2024-04-10 04:04:20 | choice | 2 | 82551 | 41 | 2.626 | 31436.0 |
482 | 2024-04-09 19:21:04 | choice | 2 | 82551 | 41 | 6.173 | 13372.9 |
481 | 2024-04-05 23:28:50 | choice | 3 | 112716 | 516 | 19.093 | 5903.5 |
480 | 2024-04-05 09:55:29 | choice | 3 | 112716 | 516 | 10.796 | 10440.5 |
479 | 2024-04-05 09:55:31 | choice | 2 | 82551 | 41 | 7.000 | 11793.0 |
478 | 2024-04-05 09:55:25 | choice | 1 | 48755 | 3 | 2.330 | 20924.9 |
477 | 2024-04-05 09:55:17 | choice | 3 | 112716 | 516 | 10.126 | 11131.3 |
476 | 2024-04-05 09:55:18 | choice | 2 | 82551 | 41 | 3.093 | 26689.6 |
475 | 2024-04-05 09:55:12 | choice | 1 | 48755 | 3 | 2.950 | 16527.1 |
474 | 2024-04-04 01:30:33 | choice | 1 | 48755 | 3 | 0.940 | 51867.0 |
473 | 2024-03-07 20:42:03 | choice | 2 | 82551 | 41 | 3.046 | 27101.4 |
472 | 2024-03-07 20:29:52 | choice | 3 | 112716 | 516 | 5.343 | 21096.0 |
471 | 2024-03-06 22:45:46 | choice | 3 | 112716 | 516 | 19.563 | 5761.7 |
470 | 2024-03-06 11:36:01 | choice | 2 | 82551 | 41 | 8.403 | 9824.0 |
469 | 2024-03-06 08:29:25 | choice | 3 | 112716 | 516 | 12.783 | 8817.6 |
468 | 2024-03-06 08:29:27 | choice | 2 | 82551 | 41 | 3.656 | 22579.6 |
467 | 2024-03-06 08:29:22 | choice | 1 | 48755 | 3 | 0.906 | 53813.5 |
466 | 2024-03-06 08:28:56 | choice | 3 | 112716 | 516 | 6.063 | 18590.8 |
465 | 2024-03-06 08:11:24 | choice | 3 | 112716 | 516 | 9.123 | 12355.1 |
464 | 2024-02-17 13:24:21 | choice | 1 | 48755 | 3 | 0.813 | 59969.2 |
463 | 2023-12-26 15:06:46 | choice | 1 | 48755 | 3 | 0.750 | 65006.7 |
462 | 2023-12-21 09:25:23 | choice | 2 | 82551 | 41 | 2.263 | 36478.6 |
461 | 2023-12-14 21:55:10 | choice | 2 | 82551 | 41 | 4.173 | 19782.2 |
460 | 2023-12-13 16:21:09 | choice | 3 | 112716 | 516 | 5.516 | 20434.4 |
459 | 2023-12-10 11:19:11 | choice | 2 | 82551 | 41 | 2.376 | 34743.7 |
458 | 2023-12-09 04:29:56 | choice | 3 | 112716 | 516 | 5.640 | 19985.1 |
457 | 2023-11-23 07:49:59 | choice | 3 | 112716 | 516 | 4.623 | 24381.6 |
456 | 2023-11-17 00:36:41 | choice | 1 | 48755 | 3 | 0.763 | 63899.1 |
455 | 2023-11-13 23:01:48 | choice | 1 | 48755 | 3 | 0.733 | 66514.3 |
454 | 2023-11-12 03:05:24 | choice | 1 | 48755 | 3 | 0.826 | 59025.4 |
453 | 2023-11-11 21:04:06 | choice | 1 | 48755 | 3 | 0.780 | 62506.4 |
452 | 2023-11-11 10:25:56 | choice | 2 | 82551 | 41 | 2.283 | 36159.0 |
451 | 2023-11-11 10:25:35 | choice | 3 | 112716 | 516 | 4.703 | 23966.8 |
450 | 2023-11-08 16:50:21 | choice | 1 | 48755 | 3 | 0.750 | 65006.7 |
449 | 2023-10-25 21:30:59 | choice | 1 | 48755 | 3 | 1.606 | 30358.0 |
448 | 2023-10-21 10:00:34 | choice | 1 | 48755 | 3 | 2.156 | 22613.6 |
447 | 2023-10-18 16:18:34 | choice | 1 | 48755 | 3 | 0.843 | 57835.1 |
446 | 2023-10-14 23:46:23 | choice | 1 | 48755 | 3 | 0.813 | 59969.2 |
445 | 2023-10-14 22:30:22 | choice | 1 | 48755 | 3 | 0.780 | 62506.4 |
444 | 2023-10-07 08:11:16 | choice | 1 | 48755 | 3 | 0.843 | 57835.1 |
443 | 2023-09-24 08:38:27 | choice | 1 | 48755 | 3 | 0.750 | 65006.7 |