History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"booth"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
538 | 2024-04-24 09:23:15 | booth | 1 | 28756 | 9 | 0.703 | 40904.7 |
537 | 2024-04-16 06:54:31 | booth | 1 | 28756 | 9 | 0.500 | 57512.0 |
536 | 2024-04-09 03:10:59 | booth | 1 | 28756 | 9 | 0.593 | 48492.4 |
535 | 2024-04-03 04:13:04 | booth | 1 | 28756 | 9 | 1.156 | 24875.4 |
534 | 2024-03-30 22:27:14 | booth | 2 | 53800 | 131 | 1.936 | 27789.3 |
533 | 2024-03-30 21:59:38 | booth | 1 | 28756 | 9 | 0.450 | 63902.2 |
532 | 2024-03-28 23:05:28 | booth | 1 | 28756 | 9 | 0.513 | 56054.6 |
531 | 2024-03-28 23:05:15 | booth | 2 | 53800 | 131 | 1.703 | 31591.3 |
530 | 2024-03-28 23:05:08 | booth | 1 | 28756 | 9 | 0.576 | 49923.6 |
529 | 2024-03-04 07:01:38 | booth | 2 | 53800 | 131 | 5.783 | 9303.1 |
528 | 2024-03-04 03:41:27 | booth | 2 | 53800 | 131 | 1.560 | 34487.2 |
527 | 2024-03-04 00:49:35 | booth | 1 | 28756 | 9 | 0.546 | 52666.7 |
526 | 2024-02-27 20:56:29 | booth | 1 | 28756 | 9 | 0.500 | 57512.0 |
525 | 2024-02-16 18:25:30 | booth | 1 | 28756 | 9 | 0.466 | 61708.2 |
524 | 2024-02-02 22:45:07 | booth | 1 | 28756 | 9 | 1.000 | 28756.0 |
523 | 2024-01-10 20:14:23 | booth | 2 | 53800 | 131 | 1.500 | 35866.7 |
522 | 2024-01-09 13:44:14 | booth | 2 | 53800 | 131 | 1.373 | 39184.3 |
521 | 2024-01-07 02:26:59 | booth | 1 | 28756 | 9 | 0.436 | 65954.1 |
520 | 2023-12-10 11:26:19 | booth | 2 | 53800 | 131 | 1.546 | 34799.5 |
519 | 2023-12-01 15:05:07 | booth | 1 | 28756 | 9 | 0.690 | 41675.4 |
518 | 2023-11-15 17:18:33 | booth | 1 | 28756 | 9 | 0.500 | 57512.0 |
517 | 2023-11-11 07:08:42 | booth | 1 | 28756 | 9 | 0.440 | 65354.5 |
516 | 2023-11-04 15:38:06 | booth | 1 | 28756 | 9 | 0.453 | 63479.0 |
515 | 2023-10-31 23:17:53 | booth | 2 | 53800 | 131 | 1.373 | 39184.3 |
514 | 2023-10-31 19:47:18 | booth | 2 | 53800 | 131 | 1.906 | 28226.7 |
513 | 2023-10-20 20:33:02 | booth | 1 | 28756 | 9 | 0.483 | 59536.2 |
512 | 2023-10-19 17:56:04 | booth | 1 | 28756 | 9 | 0.500 | 57512.0 |
511 | 2023-10-11 12:50:27 | booth | 1 | 28756 | 9 | 1.013 | 28387.0 |
510 | 2023-10-05 05:03:41 | booth | 1 | 28756 | 9 | 0.500 | 57512.0 |
509 | 2023-09-29 02:53:14 | booth | 1 | 28756 | 9 | 0.486 | 59168.7 |
508 | 2023-09-24 13:07:38 | booth | 1 | 28756 | 9 | 0.453 | 63479.0 |
507 | 2023-09-20 17:32:46 | booth | 1 | 28756 | 9 | 0.530 | 54256.6 |
506 | 2023-09-15 07:09:54 | booth | 1 | 28756 | 9 | 0.530 | 54256.6 |
505 | 2023-07-03 15:03:55 | booth | 1 | 28756 | 9 | 0.483 | 59536.2 |
504 | 2023-06-20 12:14:07 | booth | 1 | 28756 | 9 | 0.453 | 63479.0 |
503 | 2023-04-08 01:22:19 | booth | 1 | 28756 | 9 | 0.483 | 59536.2 |
502 | 2023-03-18 04:58:22 | booth | 1 | 28756 | 9 | 0.530 | 54256.6 |
501 | 2023-01-21 03:27:26 | booth | 1 | 28756 | 9 | 0.440 | 65354.5 |
500 | 2023-01-04 18:31:20 | booth | 1 | 28756 | 9 | 0.516 | 55728.7 |
499 | 2022-12-12 07:53:12 | booth | 1 | 28756 | 9 | 0.500 | 57512.0 |
498 | 2022-12-11 00:14:01 | booth | 1 | 28756 | 9 | 0.436 | 65954.1 |
497 | 2022-12-10 23:03:22 | booth | 1 | 28756 | 9 | 0.436 | 65954.1 |
496 | 2022-12-09 23:30:17 | booth | 1 | 28756 | 9 | 0.486 | 59168.7 |
495 | 2022-12-09 17:56:52 | booth | 1 | 28756 | 9 | 0.483 | 59536.2 |
494 | 2022-11-25 06:04:50 | booth | 1 | 28756 | 9 | 0.436 | 65954.1 |
493 | 2022-11-17 06:30:57 | booth | 1 | 28756 | 9 | 0.500 | 57512.0 |
492 | 2022-11-17 02:01:46 | booth | 1 | 28756 | 9 | 0.466 | 61708.2 |
491 | 2022-11-15 21:43:52 | booth | 1 | 28756 | 9 | 0.500 | 57512.0 |
490 | 2022-08-30 00:55:11 | booth | 1 | 28756 | 9 | 0.436 | 65954.1 |
489 | 2022-07-09 07:28:39 | booth | 1 | 28756 | 9 | 0.453 | 63479.0 |
488 | 2022-05-17 11:19:04 | booth | 1 | 28756 | 9 | 0.656 | 43835.4 |
487 | 2022-05-13 22:07:28 | booth | 1 | 28756 | 9 | 0.890 | 32310.1 |
486 | 2022-03-09 17:43:20 | booth | 1 | 28756 | 9 | 0.546 | 52666.7 |
485 | 2022-03-07 13:20:34 | booth | 1 | 28756 | 9 | 0.606 | 47452.1 |
484 | 2022-02-09 04:36:32 | booth | 1 | 28756 | 9 | 0.436 | 65954.1 |
483 | 2021-12-15 21:50:54 | booth | 1 | 28756 | 9 | 0.483 | 59536.2 |
482 | 2021-11-08 07:35:33 | booth | 1 | 28756 | 9 | 0.500 | 57512.0 |
481 | 2021-11-06 18:12:50 | booth | 1 | 28756 | 9 | 0.436 | 65954.1 |
480 | 2021-10-25 04:05:44 | booth | 1 | 28756 | 9 | 0.500 | 57512.0 |
479 | 2021-10-23 03:26:42 | booth | 1 | 28756 | 9 | 0.576 | 49923.6 |
478 | 2021-09-26 07:28:17 | booth | 1 | 28756 | 9 | 0.453 | 63479.0 |
477 | 2021-09-13 04:08:47 | booth | 1 | 28756 | 9 | 0.453 | 63479.0 |
476 | 2021-08-22 05:15:03 | booth | 1 | 28756 | 9 | 0.486 | 59168.7 |
475 | 2021-08-05 05:11:48 | booth | 1 | 28756 | 9 | 0.436 | 65954.1 |
474 | 2021-05-23 21:56:38 | booth | 1 | 28756 | 9 | 0.500 | 57512.0 |
473 | 2021-05-01 01:27:20 | booth | 1 | 28756 | 9 | 0.500 | 57512.0 |
472 | 2021-04-26 22:29:04 | booth | 1 | 28756 | 9 | 0.716 | 40162.0 |
471 | 2021-03-27 03:14:12 | booth | 1 | 28756 | 9 | 0.453 | 63479.0 |
470 | 2021-02-24 14:00:40 | booth | 1 | 28756 | 9 | 0.533 | 53951.2 |
469 | 2021-01-28 14:56:04 | booth | 1 | 28756 | 9 | 0.486 | 59168.7 |
468 | 2021-01-26 10:49:35 | booth | 1 | 28756 | 9 | 0.483 | 59536.2 |
467 | 2021-01-10 10:06:26 | booth | 1 | 28756 | 9 | 0.456 | 63061.4 |
466 | 2020-10-25 19:14:17 | booth | 1 | 28756 | 9 | 0.500 | 57512.0 |
465 | 2020-10-21 11:16:17 | booth | 1 | 28756 | 9 | 1.076 | 26724.9 |
464 | 2020-10-19 13:02:33 | booth | 1 | 28756 | 9 | 0.453 | 63479.0 |
463 | 2020-10-12 07:33:52 | booth | 1 | 28756 | 9 | 0.453 | 63479.0 |
462 | 2020-09-30 05:33:29 | booth | 1 | 28756 | 9 | 0.516 | 55728.7 |
461 | 2020-09-28 15:29:27 | booth | 1 | 28756 | 9 | 0.453 | 63479.0 |
460 | 2020-09-06 09:18:56 | booth | 1 | 28756 | 9 | 0.440 | 65354.5 |
459 | 2020-09-04 05:21:37 | booth | 1 | 28756 | 9 | 0.453 | 63479.0 |
458 | 2020-09-03 00:47:48 | booth | 1 | 28756 | 9 | 0.513 | 56054.6 |
457 | 2020-08-22 09:47:21 | booth | 1 | 28756 | 9 | 0.486 | 59168.7 |
456 | 2020-07-22 07:21:45 | booth | 1 | 28756 | 9 | 0.516 | 55728.7 |
455 | 2020-04-20 09:00:24 | booth | 1 | 28756 | 9 | 0.516 | 55728.7 |
454 | 2020-03-29 23:56:23 | booth | 1 | 28756 | 9 | 0.500 | 57512.0 |
453 | 2020-03-27 01:52:51 | booth | 1 | 28756 | 9 | 0.530 | 54256.6 |
452 | 2020-03-25 05:12:15 | booth | 1 | 28756 | 9 | 0.750 | 38341.3 |
451 | 2020-03-24 05:54:40 | booth | 1 | 28756 | 9 | 0.530 | 54256.6 |
450 | 2020-03-22 08:12:15 | booth | 1 | 28756 | 9 | 0.516 | 55728.7 |
449 | 2020-03-22 04:52:30 | booth | 1 | 28756 | 9 | 0.486 | 59168.7 |
448 | 2020-03-21 08:18:54 | booth | 1 | 28756 | 9 | 0.516 | 55728.7 |
447 | 2020-03-18 05:24:58 | booth | 1 | 28756 | 9 | 0.453 | 63479.0 |
446 | 2020-02-29 20:46:58 | booth | 1 | 28756 | 9 | 0.533 | 53951.2 |
445 | 2020-02-29 18:37:25 | booth | 1 | 28756 | 9 | 1.140 | 25224.6 |
444 | 2020-02-27 06:46:37 | booth | 1 | 28756 | 9 | 0.516 | 55728.7 |
443 | 2020-02-23 20:04:49 | booth | 1 | 28756 | 9 | 0.533 | 53951.2 |
442 | 2020-02-15 03:47:45 | booth | 1 | 28756 | 9 | 0.843 | 34111.5 |
441 | 2020-02-13 22:50:44 | booth | 1 | 28756 | 9 | 1.313 | 21901.0 |
440 | 2020-02-08 21:30:07 | booth | 1 | 28756 | 9 | 1.110 | 25906.3 |
439 | 2020-02-01 06:42:14 | booth | 1 | 28756 | 9 | 0.533 | 53951.2 |