History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"stair"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
516 | 2024-04-03 06:35:07 | stair | 1 | 28756 | 7 | 0.500 | 57512.0 |
515 | 2024-03-31 04:20:17 | stair | 1 | 28756 | 7 | 1.080 | 26625.9 |
514 | 2024-03-30 11:56:04 | stair | 1 | 28756 | 7 | 0.533 | 53951.2 |
513 | 2024-03-29 08:54:28 | stair | 1 | 28756 | 7 | 1.733 | 16593.2 |
512 | 2024-03-18 07:34:02 | stair | 1 | 28756 | 7 | 0.516 | 55728.7 |
511 | 2024-03-04 02:27:49 | stair | 2 | 53800 | 113 | 1.890 | 28465.6 |
510 | 2024-03-04 02:19:55 | stair | 1 | 28756 | 7 | 0.500 | 57512.0 |
509 | 2024-03-01 07:54:09 | stair | 1 | 28756 | 7 | 0.530 | 54256.6 |
508 | 2024-02-28 07:47:35 | stair | 1 | 28756 | 7 | 1.080 | 26625.9 |
507 | 2024-02-03 00:10:11 | stair | 1 | 28756 | 7 | 0.500 | 57512.0 |
506 | 2024-01-29 07:03:35 | stair | 1 | 28756 | 7 | 0.436 | 65954.1 |
505 | 2024-01-29 06:13:33 | stair | 1 | 28756 | 7 | 0.530 | 54256.6 |
504 | 2023-12-28 08:26:30 | stair | 2 | 53800 | 113 | 1.390 | 38705.0 |
503 | 2023-12-20 06:28:05 | stair | 1 | 28756 | 7 | 0.513 | 56054.6 |
502 | 2023-12-09 06:57:12 | stair | 2 | 53800 | 113 | 1.390 | 38705.0 |
501 | 2023-12-07 12:21:37 | stair | 1 | 28756 | 7 | 0.500 | 57512.0 |
500 | 2023-11-13 17:23:10 | stair | 1 | 28756 | 7 | 0.453 | 63479.0 |
499 | 2023-11-10 17:39:04 | stair | 1 | 28756 | 7 | 0.453 | 63479.0 |
498 | 2023-11-05 09:45:48 | stair | 2 | 53800 | 113 | 2.860 | 18811.2 |
497 | 2023-11-04 03:02:27 | stair | 1 | 28756 | 7 | 0.533 | 53951.2 |
496 | 2023-10-21 03:40:45 | stair | 1 | 28756 | 7 | 0.513 | 56054.6 |
495 | 2023-10-20 16:51:09 | stair | 1 | 28756 | 7 | 0.596 | 48248.3 |
494 | 2023-10-15 13:22:30 | stair | 1 | 28756 | 7 | 0.486 | 59168.7 |
493 | 2023-10-08 09:29:51 | stair | 1 | 28756 | 7 | 0.436 | 65954.1 |
492 | 2023-10-05 21:25:59 | stair | 1 | 28756 | 7 | 0.516 | 55728.7 |
491 | 2023-09-26 17:50:36 | stair | 1 | 28756 | 7 | 0.563 | 51076.4 |
490 | 2023-09-23 13:19:38 | stair | 1 | 28756 | 7 | 0.546 | 52666.7 |
489 | 2023-08-04 06:24:09 | stair | 1 | 28756 | 7 | 0.453 | 63479.0 |
488 | 2023-08-02 00:06:15 | stair | 1 | 28756 | 7 | 0.470 | 61183.0 |
487 | 2023-04-28 10:53:48 | stair | 1 | 28756 | 7 | 0.500 | 57512.0 |
486 | 2023-04-12 02:02:51 | stair | 1 | 28756 | 7 | 0.436 | 65954.1 |
485 | 2023-02-19 17:09:16 | stair | 1 | 28756 | 7 | 0.486 | 59168.7 |
484 | 2022-12-26 18:49:06 | stair | 1 | 28756 | 7 | 0.470 | 61183.0 |
483 | 2022-12-19 08:47:41 | stair | 1 | 28756 | 7 | 0.470 | 61183.0 |
482 | 2022-08-28 16:01:37 | stair | 1 | 28756 | 7 | 0.513 | 56054.6 |
481 | 2022-08-26 13:53:57 | stair | 1 | 28756 | 7 | 0.906 | 31739.5 |
480 | 2022-08-14 18:52:41 | stair | 1 | 28756 | 7 | 0.436 | 65954.1 |
479 | 2022-07-29 09:29:11 | stair | 1 | 28756 | 7 | 0.453 | 63479.0 |
478 | 2022-07-18 19:22:26 | stair | 1 | 28756 | 7 | 0.516 | 55728.7 |
477 | 2022-07-17 22:23:49 | stair | 1 | 28756 | 7 | 0.436 | 65954.1 |
476 | 2022-06-26 08:52:07 | stair | 1 | 28756 | 7 | 0.530 | 54256.6 |
475 | 2022-06-08 22:31:51 | stair | 1 | 28756 | 7 | 0.483 | 59536.2 |
474 | 2022-04-15 14:09:47 | stair | 1 | 28756 | 7 | 0.766 | 37540.5 |
473 | 2022-04-15 10:00:12 | stair | 1 | 28756 | 7 | 0.500 | 57512.0 |
472 | 2022-01-13 10:40:42 | stair | 1 | 28756 | 7 | 0.483 | 59536.2 |
471 | 2022-01-11 06:52:23 | stair | 1 | 28756 | 7 | 0.453 | 63479.0 |
470 | 2021-12-21 03:51:27 | stair | 1 | 28756 | 7 | 0.516 | 55728.7 |
469 | 2021-11-09 08:14:36 | stair | 1 | 28756 | 7 | 0.453 | 63479.0 |
468 | 2021-11-07 08:04:22 | stair | 1 | 28756 | 7 | 0.640 | 44931.3 |
467 | 2021-09-24 18:25:37 | stair | 1 | 28756 | 7 | 0.453 | 63479.0 |
466 | 2021-09-09 18:28:48 | stair | 1 | 28756 | 7 | 0.466 | 61708.2 |
465 | 2021-09-07 11:13:55 | stair | 1 | 28756 | 7 | 0.486 | 59168.7 |
464 | 2021-06-06 13:37:07 | stair | 1 | 28756 | 7 | 0.500 | 57512.0 |
463 | 2021-06-03 09:03:00 | stair | 1 | 28756 | 7 | 0.486 | 59168.7 |
462 | 2021-05-21 12:36:41 | stair | 1 | 28756 | 7 | 0.546 | 52666.7 |
461 | 2021-04-22 03:37:11 | stair | 1 | 28756 | 7 | 0.516 | 55728.7 |
460 | 2021-02-28 22:18:10 | stair | 1 | 28756 | 7 | 0.500 | 57512.0 |
459 | 2021-02-02 21:14:43 | stair | 1 | 28756 | 7 | 0.516 | 55728.7 |
458 | 2021-01-07 04:50:23 | stair | 1 | 28756 | 7 | 0.593 | 48492.4 |
457 | 2020-11-24 11:38:56 | stair | 1 | 28756 | 7 | 0.453 | 63479.0 |
456 | 2020-10-17 22:14:17 | stair | 1 | 28756 | 7 | 0.436 | 65954.1 |
455 | 2020-10-15 04:57:38 | stair | 1 | 28756 | 7 | 0.466 | 61708.2 |
454 | 2020-10-14 16:37:44 | stair | 1 | 28756 | 7 | 0.486 | 59168.7 |
453 | 2020-08-19 11:45:43 | stair | 1 | 28756 | 7 | 0.450 | 63902.2 |
452 | 2020-08-08 17:22:44 | stair | 1 | 28756 | 7 | 0.453 | 63479.0 |
451 | 2020-08-05 11:05:29 | stair | 1 | 28756 | 7 | 0.486 | 59168.7 |
450 | 2020-07-26 00:48:11 | stair | 1 | 28756 | 7 | 0.500 | 57512.0 |
449 | 2020-05-18 06:04:36 | stair | 1 | 28756 | 7 | 0.470 | 61183.0 |
448 | 2020-04-27 09:36:30 | stair | 1 | 28756 | 7 | 0.546 | 52666.7 |
447 | 2020-03-24 20:28:30 | stair | 1 | 28756 | 7 | 0.483 | 59536.2 |
446 | 2020-03-23 22:56:08 | stair | 1 | 28756 | 7 | 0.516 | 55728.7 |
445 | 2020-03-22 02:21:16 | stair | 1 | 28756 | 7 | 0.470 | 61183.0 |
444 | 2020-03-21 05:29:39 | stair | 1 | 28756 | 7 | 0.500 | 57512.0 |
443 | 2020-03-20 12:01:21 | stair | 1 | 28756 | 7 | 0.533 | 53951.2 |
442 | 2020-03-17 19:40:56 | stair | 1 | 28756 | 7 | 0.470 | 61183.0 |
441 | 2020-02-25 21:43:45 | stair | 1 | 28756 | 7 | 0.530 | 54256.6 |
440 | 2020-02-24 20:23:49 | stair | 1 | 28756 | 7 | 0.466 | 61708.2 |
439 | 2020-02-19 13:39:49 | stair | 1 | 28756 | 7 | 1.423 | 20208.0 |
438 | 2020-02-18 17:57:27 | stair | 1 | 28756 | 7 | 0.533 | 53951.2 |
437 | 2020-02-15 09:14:29 | stair | 1 | 28756 | 7 | 0.453 | 63479.0 |
436 | 2020-02-14 15:59:05 | stair | 1 | 28756 | 7 | 0.453 | 63479.0 |
435 | 2020-02-12 10:54:26 | stair | 1 | 28756 | 7 | 1.736 | 16564.5 |
434 | 2020-02-09 18:38:18 | stair | 1 | 28756 | 7 | 1.156 | 24875.4 |
433 | 2020-01-29 23:45:09 | stair | 1 | 28756 | 7 | 0.560 | 51350.0 |
432 | 2020-01-29 18:09:05 | stair | 1 | 28756 | 7 | 1.030 | 27918.4 |
431 | 2020-01-29 03:38:47 | stair | 1 | 28756 | 7 | 1.173 | 24514.9 |
430 | 2020-01-23 20:38:47 | stair | 1 | 28756 | 7 | 0.673 | 42728.1 |
429 | 2020-01-23 04:51:00 | stair | 1 | 28756 | 7 | 0.530 | 54256.6 |
428 | 2020-01-21 16:23:27 | stair | 1 | 28756 | 7 | 0.546 | 52666.7 |
427 | 2020-01-10 23:59:39 | stair | 1 | 28756 | 7 | 0.516 | 55728.7 |
426 | 2020-01-10 09:49:52 | stair | 1 | 28756 | 7 | 1.096 | 26237.2 |
425 | 2020-01-07 22:53:06 | stair | 1 | 28756 | 7 | 1.156 | 24875.4 |
424 | 2020-01-03 06:00:51 | stair | 1 | 28756 | 7 | 1.080 | 26625.9 |
423 | 2019-12-24 12:47:07 | stair | 1 | 28756 | 7 | 0.500 | 57512.0 |
422 | 2019-12-24 11:31:05 | stair | 1 | 28756 | 7 | 0.530 | 54256.6 |
421 | 2019-12-24 05:55:19 | stair | 1 | 28756 | 7 | 0.453 | 63479.0 |
420 | 2019-12-24 00:45:05 | stair | 1 | 28756 | 7 | 0.453 | 63479.0 |
419 | 2019-12-18 20:28:35 | stair | 1 | 28756 | 7 | 0.483 | 59536.2 |
418 | 2019-11-15 11:58:14 | stair | 1 | 28756 | 7 | 0.500 | 57512.0 |
417 | 2019-11-12 09:36:26 | stair | 1 | 28756 | 7 | 0.453 | 63479.0 |