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 |
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 |
442 | 2023-09-15 04:43:13 | choice | 2 | 82551 | 41 | 2.390 | 34540.2 |
441 | 2023-09-14 02:02:10 | choice | 1 | 48755 | 3 | 0.750 | 65006.7 |
440 | 2023-09-08 11:43:14 | choice | 2 | 82551 | 41 | 2.440 | 33832.4 |
439 | 2023-08-24 11:06:08 | choice | 3 | 112716 | 516 | 4.623 | 24381.6 |
438 | 2023-08-11 11:09:48 | choice | 1 | 48755 | 3 | 0.813 | 59969.2 |
437 | 2023-08-06 05:41:45 | choice | 3 | 112716 | 516 | 4.780 | 23580.8 |
436 | 2023-07-29 03:46:55 | choice | 1 | 48755 | 3 | 0.766 | 63648.8 |
435 | 2023-07-07 05:18:16 | choice | 3 | 112716 | 516 | 4.846 | 23259.6 |
434 | 2023-05-26 17:05:23 | choice | 2 | 82551 | 41 | 2.060 | 40073.3 |
433 | 2023-05-17 17:03:57 | choice | 3 | 112716 | 516 | 5.093 | 22131.6 |
432 | 2023-05-12 08:42:39 | choice | 1 | 48755 | 3 | 0.830 | 58741.0 |
431 | 2023-05-09 05:57:54 | choice | 3 | 112716 | 516 | 4.656 | 24208.8 |
430 | 2023-04-20 19:47:05 | choice | 1 | 48755 | 3 | 0.763 | 63899.1 |
429 | 2023-04-10 23:31:11 | choice | 3 | 112716 | 516 | 4.890 | 23050.3 |
428 | 2023-03-08 11:45:18 | choice | 1 | 48755 | 3 | 0.750 | 65006.7 |
427 | 2023-03-03 19:04:37 | choice | 2 | 82551 | 41 | 2.080 | 39688.0 |
426 | 2023-02-14 20:33:40 | choice | 3 | 112716 | 516 | 4.626 | 24365.8 |
425 | 2023-01-08 10:39:22 | choice | 1 | 48755 | 3 | 0.826 | 59025.4 |
424 | 2022-12-30 03:02:49 | choice | 1 | 48755 | 3 | 0.733 | 66514.3 |
423 | 2022-12-11 05:52:44 | choice | 2 | 82551 | 41 | 2.060 | 40073.3 |
422 | 2022-11-24 16:38:47 | choice | 3 | 112716 | 516 | 4.656 | 24208.8 |
421 | 2022-09-24 15:12:12 | choice | 1 | 48755 | 3 | 0.796 | 61250.0 |
420 | 2022-09-21 00:44:02 | choice | 1 | 48755 | 3 | 0.766 | 63648.8 |
419 | 2022-09-20 12:54:32 | choice | 1 | 48755 | 3 | 0.813 | 59969.2 |
418 | 2022-07-30 22:59:01 | choice | 3 | 112716 | 516 | 4.830 | 23336.6 |
417 | 2022-07-30 13:50:09 | choice | 2 | 82551 | 41 | 2.110 | 39123.7 |
416 | 2022-07-29 01:36:40 | choice | 1 | 48755 | 3 | 0.750 | 65006.7 |
415 | 2022-07-02 12:47:46 | choice | 3 | 112716 | 516 | 5.453 | 20670.5 |
414 | 2022-06-19 03:39:54 | choice | 3 | 112716 | 516 | 4.843 | 23274.0 |
413 | 2022-06-07 15:22:05 | choice | 1 | 48755 | 3 | 0.766 | 63648.8 |
412 | 2022-05-01 22:24:24 | choice | 1 | 48755 | 3 | 0.750 | 65006.7 |
411 | 2022-04-16 14:17:38 | choice | 3 | 112716 | 516 | 4.563 | 24702.2 |
410 | 2022-02-24 06:15:36 | choice | 1 | 48755 | 3 | 0.906 | 53813.5 |
409 | 2022-01-20 22:14:55 | choice | 1 | 48755 | 3 | 0.983 | 49598.2 |
408 | 2021-11-19 09:40:53 | choice | 1 | 48755 | 3 | 0.876 | 55656.4 |
407 | 2021-11-18 14:14:54 | choice | 1 | 48755 | 3 | 0.830 | 58741.0 |
406 | 2021-11-16 02:11:39 | choice | 1 | 48755 | 3 | 0.766 | 63648.8 |
405 | 2021-10-04 07:34:22 | choice | 1 | 48755 | 3 | 0.733 | 66514.3 |
404 | 2021-10-02 04:22:38 | choice | 1 | 48755 | 3 | 1.483 | 32875.9 |
403 | 2021-08-24 05:44:12 | choice | 1 | 48755 | 3 | 0.843 | 57835.1 |
402 | 2021-08-22 00:38:35 | choice | 1 | 48755 | 3 | 0.936 | 52088.7 |
401 | 2021-08-13 05:57:43 | choice | 1 | 48755 | 3 | 0.780 | 62506.4 |
400 | 2021-05-20 13:03:39 | choice | 1 | 48755 | 3 | 0.750 | 65006.7 |
399 | 2021-05-12 12:38:46 | choice | 1 | 48755 | 3 | 0.796 | 61250.0 |
398 | 2021-02-08 11:50:34 | choice | 1 | 48755 | 3 | 0.766 | 63648.8 |
397 | 2021-02-03 08:05:46 | choice | 1 | 48755 | 3 | 0.780 | 62506.4 |
396 | 2021-02-01 21:13:47 | choice | 1 | 48755 | 3 | 0.860 | 56691.9 |
395 | 2021-01-05 11:39:29 | choice | 1 | 48755 | 3 | 0.830 | 58741.0 |
394 | 2020-11-08 02:06:39 | choice | 1 | 48755 | 3 | 0.783 | 62266.9 |
393 | 2020-11-07 18:02:20 | choice | 3 | 112716 | 516 | 4.890 | 23050.3 |
392 | 2020-11-01 13:08:41 | choice | 1 | 48755 | 3 | 0.860 | 56691.9 |
391 | 2020-10-29 23:33:16 | choice | 1 | 48755 | 3 | 0.750 | 65006.7 |
390 | 2020-10-23 15:20:32 | choice | 1 | 48755 | 3 | 0.750 | 65006.7 |
389 | 2020-10-23 08:56:18 | choice | 1 | 48755 | 3 | 0.750 | 65006.7 |
388 | 2020-10-19 16:16:39 | choice | 1 | 48755 | 3 | 0.906 | 53813.5 |
387 | 2020-09-07 22:19:47 | choice | 1 | 48755 | 3 | 0.750 | 65006.7 |
386 | 2020-07-30 00:51:13 | choice | 1 | 48755 | 3 | 0.796 | 61250.0 |
385 | 2020-07-26 17:48:56 | choice | 1 | 48755 | 3 | 0.876 | 55656.4 |