History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"stall"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
514 | 2024-04-11 10:24:24 | stall | 1 | 28756 | 12 | 0.516 | 55728.7 |
513 | 2024-04-08 16:32:23 | stall | 1 | 28756 | 12 | 1.203 | 23903.6 |
512 | 2024-04-03 06:34:55 | stall | 1 | 28756 | 12 | 1.013 | 28387.0 |
511 | 2024-04-03 06:34:46 | stall | 2 | 53800 | 148 | 2.830 | 19010.6 |
510 | 2024-04-03 06:14:47 | stall | 1 | 28756 | 12 | 0.546 | 52666.7 |
509 | 2024-03-31 02:44:00 | stall | 1 | 28756 | 12 | 0.533 | 53951.2 |
508 | 2024-03-29 00:09:37 | stall | 2 | 53800 | 148 | 3.986 | 13497.2 |
507 | 2024-03-28 22:58:26 | stall | 1 | 28756 | 12 | 0.516 | 55728.7 |
506 | 2024-03-21 15:02:01 | stall | 1 | 28756 | 12 | 0.810 | 35501.2 |
505 | 2024-03-08 06:46:10 | stall | 2 | 53800 | 148 | 1.890 | 28465.6 |
504 | 2024-03-08 06:45:08 | stall | 1 | 28756 | 12 | 1.686 | 17055.8 |
503 | 2024-03-03 21:21:28 | stall | 1 | 28756 | 12 | 0.546 | 52666.7 |
502 | 2024-02-27 19:59:36 | stall | 1 | 28756 | 12 | 0.470 | 61183.0 |
501 | 2024-02-18 14:24:05 | stall | 1 | 28756 | 12 | 0.500 | 57512.0 |
500 | 2024-02-06 02:44:14 | stall | 2 | 53800 | 148 | 1.703 | 31591.3 |
499 | 2024-02-06 02:44:10 | stall | 1 | 28756 | 12 | 0.516 | 55728.7 |
498 | 2024-02-02 21:07:15 | stall | 1 | 28756 | 12 | 0.453 | 63479.0 |
497 | 2024-01-30 04:20:36 | stall | 1 | 28756 | 12 | 1.110 | 25906.3 |
496 | 2024-01-17 00:56:52 | stall | 2 | 53800 | 148 | 1.406 | 38264.6 |
495 | 2024-01-07 01:10:17 | stall | 1 | 28756 | 12 | 0.516 | 55728.7 |
494 | 2023-12-29 14:55:16 | stall | 1 | 28756 | 12 | 0.486 | 59168.7 |
493 | 2023-12-08 11:48:56 | stall | 1 | 28756 | 12 | 0.450 | 63902.2 |
492 | 2023-12-08 11:48:55 | stall | 1 | 28756 | 12 | 0.516 | 55728.7 |
491 | 2023-11-30 20:11:40 | stall | 1 | 28756 | 12 | 0.466 | 61708.2 |
490 | 2023-11-26 15:39:52 | stall | 2 | 53800 | 148 | 1.670 | 32215.6 |
489 | 2023-11-24 00:46:33 | stall | 1 | 28756 | 12 | 0.483 | 59536.2 |
488 | 2023-11-18 06:15:14 | stall | 1 | 28756 | 12 | 0.486 | 59168.7 |
487 | 2023-10-31 11:18:12 | stall | 1 | 28756 | 12 | 0.516 | 55728.7 |
486 | 2023-10-31 04:38:18 | stall | 1 | 28756 | 12 | 0.453 | 63479.0 |
485 | 2023-10-30 01:46:15 | stall | 1 | 28756 | 12 | 0.470 | 61183.0 |
484 | 2023-10-27 08:17:24 | stall | 2 | 53800 | 148 | 1.703 | 31591.3 |
483 | 2023-10-20 16:51:17 | stall | 1 | 28756 | 12 | 0.580 | 49579.3 |
482 | 2023-10-11 02:22:54 | stall | 1 | 28756 | 12 | 0.453 | 63479.0 |
481 | 2023-10-07 23:49:37 | stall | 1 | 28756 | 12 | 0.483 | 59536.2 |
480 | 2023-09-29 03:20:58 | stall | 1 | 28756 | 12 | 0.453 | 63479.0 |
479 | 2023-09-13 19:18:45 | stall | 1 | 28756 | 12 | 0.500 | 57512.0 |
478 | 2023-09-09 03:30:48 | stall | 1 | 28756 | 12 | 0.453 | 63479.0 |
477 | 2023-09-03 03:19:50 | stall | 1 | 28756 | 12 | 0.513 | 56054.6 |
476 | 2023-08-04 17:28:11 | stall | 2 | 53800 | 148 | 1.546 | 34799.5 |
475 | 2023-06-18 01:27:57 | stall | 1 | 28756 | 12 | 0.453 | 63479.0 |
474 | 2023-05-13 22:01:07 | stall | 1 | 28756 | 12 | 0.500 | 57512.0 |
473 | 2023-04-17 12:16:38 | stall | 2 | 53800 | 148 | 1.360 | 39558.8 |
472 | 2023-04-01 18:00:19 | stall | 1 | 28756 | 12 | 0.530 | 54256.6 |
471 | 2023-01-24 03:18:55 | stall | 2 | 53800 | 148 | 1.356 | 39675.5 |
470 | 2023-01-20 16:40:51 | stall | 1 | 28756 | 12 | 0.440 | 65354.5 |
469 | 2023-01-14 20:18:39 | stall | 1 | 28756 | 12 | 0.436 | 65954.1 |
468 | 2022-11-26 14:19:05 | stall | 1 | 28756 | 12 | 0.440 | 65354.5 |
467 | 2022-11-05 15:19:31 | stall | 1 | 28756 | 12 | 0.436 | 65954.1 |
466 | 2022-11-04 18:22:42 | stall | 2 | 53800 | 148 | 1.410 | 38156.0 |
465 | 2022-09-22 01:30:49 | stall | 1 | 28756 | 12 | 0.450 | 63902.2 |
464 | 2022-09-01 21:57:02 | stall | 1 | 28756 | 12 | 0.486 | 59168.7 |
463 | 2022-07-29 06:18:36 | stall | 1 | 28756 | 12 | 0.486 | 59168.7 |
462 | 2022-07-19 05:09:38 | stall | 2 | 53800 | 148 | 1.393 | 38621.7 |
461 | 2022-06-26 02:48:40 | stall | 1 | 28756 | 12 | 0.453 | 63479.0 |
460 | 2022-06-06 11:39:47 | stall | 2 | 53800 | 148 | 1.360 | 39558.8 |
459 | 2022-05-16 02:32:11 | stall | 1 | 28756 | 12 | 1.030 | 27918.4 |
458 | 2022-03-05 08:54:41 | stall | 1 | 28756 | 12 | 0.440 | 65354.5 |
457 | 2022-01-28 09:47:50 | stall | 1 | 28756 | 12 | 0.470 | 61183.0 |
456 | 2021-12-15 21:50:09 | stall | 1 | 28756 | 12 | 0.500 | 57512.0 |
455 | 2021-11-14 07:11:19 | stall | 1 | 28756 | 12 | 0.500 | 57512.0 |
454 | 2021-10-25 01:45:50 | stall | 1 | 28756 | 12 | 0.500 | 57512.0 |
453 | 2021-10-14 23:04:25 | stall | 1 | 28756 | 12 | 0.516 | 55728.7 |
452 | 2021-09-13 03:11:17 | stall | 1 | 28756 | 12 | 0.450 | 63902.2 |
451 | 2021-08-26 12:55:16 | stall | 1 | 28756 | 12 | 0.453 | 63479.0 |
450 | 2021-07-13 23:36:00 | stall | 1 | 28756 | 12 | 0.453 | 63479.0 |
449 | 2021-05-22 18:30:02 | stall | 1 | 28756 | 12 | 0.453 | 63479.0 |
448 | 2021-04-23 18:48:16 | stall | 1 | 28756 | 12 | 0.500 | 57512.0 |
447 | 2021-04-10 17:02:29 | stall | 1 | 28756 | 12 | 0.563 | 51076.4 |
446 | 2021-03-27 01:43:06 | stall | 2 | 53800 | 148 | 1.550 | 34709.7 |
445 | 2021-02-18 15:59:43 | stall | 1 | 28756 | 12 | 0.500 | 57512.0 |
444 | 2021-02-05 04:47:10 | stall | 2 | 53800 | 148 | 1.626 | 33087.3 |
443 | 2021-01-09 03:18:47 | stall | 1 | 28756 | 12 | 0.436 | 65954.1 |
442 | 2020-12-28 13:06:27 | stall | 1 | 28756 | 12 | 0.453 | 63479.0 |
441 | 2020-11-24 11:44:37 | stall | 1 | 28756 | 12 | 0.453 | 63479.0 |
440 | 2020-10-16 08:35:12 | stall | 1 | 28756 | 12 | 0.513 | 56054.6 |
439 | 2020-09-30 14:42:23 | stall | 1 | 28756 | 12 | 0.436 | 65954.1 |
438 | 2020-09-27 18:06:22 | stall | 1 | 28756 | 12 | 0.453 | 63479.0 |
437 | 2020-09-21 02:18:40 | stall | 1 | 28756 | 12 | 0.483 | 59536.2 |
436 | 2020-09-09 15:54:57 | stall | 1 | 28756 | 12 | 0.516 | 55728.7 |
435 | 2020-09-03 15:51:12 | stall | 1 | 28756 | 12 | 0.516 | 55728.7 |
434 | 2020-08-30 23:27:08 | stall | 1 | 28756 | 12 | 0.516 | 55728.7 |
433 | 2020-07-24 05:41:26 | stall | 1 | 28756 | 12 | 0.453 | 63479.0 |
432 | 2020-06-04 15:51:37 | stall | 1 | 28756 | 12 | 0.483 | 59536.2 |
431 | 2020-05-27 16:54:07 | stall | 1 | 28756 | 12 | 0.486 | 59168.7 |
430 | 2020-04-13 15:18:43 | stall | 1 | 28756 | 12 | 0.563 | 51076.4 |
429 | 2020-03-25 03:05:47 | stall | 1 | 28756 | 12 | 0.533 | 53951.2 |
428 | 2020-03-23 10:36:51 | stall | 1 | 28756 | 12 | 0.983 | 29253.3 |
427 | 2020-03-22 16:54:14 | stall | 1 | 28756 | 12 | 0.483 | 59536.2 |
426 | 2020-03-22 02:17:12 | stall | 1 | 28756 | 12 | 0.533 | 53951.2 |
425 | 2020-03-20 23:18:09 | stall | 1 | 28756 | 12 | 0.453 | 63479.0 |
424 | 2020-03-18 02:42:00 | stall | 1 | 28756 | 12 | 0.513 | 56054.6 |
423 | 2020-03-13 06:15:11 | stall | 1 | 28756 | 12 | 0.453 | 63479.0 |
422 | 2020-03-09 07:05:48 | stall | 1 | 28756 | 12 | 0.500 | 57512.0 |
421 | 2020-03-04 06:38:23 | stall | 1 | 28756 | 12 | 0.453 | 63479.0 |
420 | 2020-03-03 03:24:56 | stall | 1 | 28756 | 12 | 0.436 | 65954.1 |
419 | 2020-03-02 23:24:08 | stall | 2 | 53800 | 148 | 2.983 | 18035.5 |
418 | 2020-03-02 22:10:28 | stall | 2 | 53800 | 148 | 3.653 | 14727.6 |
417 | 2020-03-02 09:54:10 | stall | 1 | 28756 | 12 | 0.593 | 48492.4 |
416 | 2020-02-29 05:43:46 | stall | 1 | 28756 | 12 | 0.533 | 53951.2 |
415 | 2020-02-25 15:26:41 | stall | 1 | 28756 | 12 | 0.546 | 52666.7 |