History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"suits"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
530 | 2024-04-28 12:36:28 | suits | 1 | 28756 | 14 | 0.640 | 44931.3 |
529 | 2024-04-25 22:48:07 | suits | 1 | 28756 | 14 | 0.563 | 51076.4 |
528 | 2024-04-14 23:29:46 | suits | 2 | 53800 | 264 | 1.936 | 27789.3 |
527 | 2024-04-14 23:24:27 | suits | 2 | 53800 | 264 | 5.063 | 10626.1 |
526 | 2024-04-14 23:24:30 | suits | 1 | 28756 | 14 | 0.733 | 39230.6 |
525 | 2024-04-14 23:15:59 | suits | 1 | 28756 | 14 | 1.626 | 17685.1 |
524 | 2024-04-03 04:43:41 | suits | 2 | 53800 | 264 | 4.030 | 13349.9 |
523 | 2024-04-03 04:39:27 | suits | 1 | 28756 | 14 | 0.576 | 49923.6 |
522 | 2024-04-01 17:47:52 | suits | 1 | 28756 | 14 | 0.576 | 49923.6 |
521 | 2024-03-30 20:54:13 | suits | 2 | 53800 | 264 | 5.940 | 9057.2 |
520 | 2024-03-30 20:47:52 | suits | 1 | 28756 | 14 | 0.546 | 52666.7 |
519 | 2024-03-28 23:47:58 | suits | 2 | 53800 | 264 | 5.466 | 9842.7 |
518 | 2024-03-28 23:17:50 | suits | 1 | 28756 | 14 | 0.483 | 59536.2 |
517 | 2024-03-27 20:10:33 | suits | 1 | 28756 | 14 | 0.453 | 63479.0 |
516 | 2024-03-14 07:54:35 | suits | 1 | 28756 | 14 | 0.516 | 55728.7 |
515 | 2024-03-04 01:42:59 | suits | 1 | 28756 | 14 | 0.500 | 57512.0 |
514 | 2024-02-28 00:50:20 | suits | 2 | 53800 | 264 | 1.656 | 32487.9 |
513 | 2024-02-27 21:49:16 | suits | 2 | 53800 | 264 | 1.846 | 29144.1 |
512 | 2024-02-27 21:10:01 | suits | 1 | 28756 | 14 | 0.516 | 55728.7 |
511 | 2024-02-03 02:47:59 | suits | 1 | 28756 | 14 | 0.500 | 57512.0 |
510 | 2024-01-29 20:54:39 | suits | 1 | 28756 | 14 | 0.953 | 30174.2 |
509 | 2024-01-28 19:41:01 | suits | 1 | 28756 | 14 | 0.516 | 55728.7 |
508 | 2024-01-09 19:17:56 | suits | 1 | 28756 | 14 | 0.513 | 56054.6 |
507 | 2024-01-02 00:09:05 | suits | 2 | 53800 | 264 | 1.530 | 35163.4 |
506 | 2023-12-30 05:24:08 | suits | 1 | 28756 | 14 | 0.470 | 61183.0 |
505 | 2023-12-28 08:40:20 | suits | 2 | 53800 | 264 | 1.576 | 34137.1 |
504 | 2023-12-28 03:55:39 | suits | 2 | 53800 | 264 | 1.390 | 38705.0 |
503 | 2023-11-22 12:42:50 | suits | 1 | 28756 | 14 | 0.530 | 54256.6 |
502 | 2023-11-13 17:48:26 | suits | 1 | 28756 | 14 | 0.440 | 65354.5 |
501 | 2023-11-13 11:32:40 | suits | 1 | 28756 | 14 | 0.576 | 49923.6 |
500 | 2023-11-13 02:44:07 | suits | 1 | 28756 | 14 | 0.453 | 63479.0 |
499 | 2023-11-05 21:03:45 | suits | 2 | 53800 | 264 | 1.486 | 36204.6 |
498 | 2023-11-01 08:23:16 | suits | 1 | 28756 | 14 | 0.450 | 63902.2 |
497 | 2023-11-01 01:49:07 | suits | 2 | 53800 | 264 | 3.530 | 15240.8 |
496 | 2023-10-30 23:52:17 | suits | 1 | 28756 | 14 | 0.596 | 48248.3 |
495 | 2023-10-21 09:01:02 | suits | 1 | 28756 | 14 | 0.470 | 61183.0 |
494 | 2023-10-21 04:30:39 | suits | 1 | 28756 | 14 | 0.453 | 63479.0 |
493 | 2023-10-13 07:34:17 | suits | 1 | 28756 | 14 | 0.450 | 63902.2 |
492 | 2023-10-13 00:49:07 | suits | 2 | 53800 | 264 | 1.436 | 37465.2 |
491 | 2023-10-09 07:54:17 | suits | 2 | 53800 | 264 | 1.390 | 38705.0 |
490 | 2023-10-03 15:30:59 | suits | 1 | 28756 | 14 | 0.453 | 63479.0 |
489 | 2023-09-28 04:45:51 | suits | 2 | 53800 | 264 | 1.516 | 35488.1 |
488 | 2023-09-26 06:55:26 | suits | 1 | 28756 | 14 | 0.436 | 65954.1 |
487 | 2023-09-22 10:39:49 | suits | 1 | 28756 | 14 | 0.453 | 63479.0 |
486 | 2023-08-25 05:21:39 | suits | 1 | 28756 | 14 | 0.530 | 54256.6 |
485 | 2023-07-25 18:06:26 | suits | 1 | 28756 | 14 | 0.470 | 61183.0 |
484 | 2023-05-25 19:57:55 | suits | 1 | 28756 | 14 | 0.450 | 63902.2 |
483 | 2023-04-10 06:51:34 | suits | 1 | 28756 | 14 | 0.483 | 59536.2 |
482 | 2023-03-21 11:18:43 | suits | 1 | 28756 | 14 | 0.436 | 65954.1 |
481 | 2023-02-15 01:30:23 | suits | 1 | 28756 | 14 | 0.533 | 53951.2 |
480 | 2023-01-07 04:32:39 | suits | 1 | 28756 | 14 | 0.400 | 71890.0 |
479 | 2022-12-26 18:07:00 | suits | 1 | 28756 | 14 | 0.436 | 65954.1 |
478 | 2022-12-17 20:01:37 | suits | 1 | 28756 | 14 | 0.453 | 63479.0 |
477 | 2022-11-14 08:35:06 | suits | 1 | 28756 | 14 | 0.610 | 47141.0 |
476 | 2022-11-13 01:31:15 | suits | 1 | 28756 | 14 | 0.453 | 63479.0 |
475 | 2022-10-02 06:08:14 | suits | 1 | 28756 | 14 | 0.500 | 57512.0 |
474 | 2022-08-07 22:49:42 | suits | 1 | 28756 | 14 | 0.453 | 63479.0 |
473 | 2022-07-29 06:18:52 | suits | 1 | 28756 | 14 | 0.453 | 63479.0 |
472 | 2022-05-18 15:35:32 | suits | 1 | 28756 | 14 | 0.530 | 54256.6 |
471 | 2022-04-06 16:59:07 | suits | 1 | 28756 | 14 | 0.923 | 31154.9 |
470 | 2022-02-02 06:44:56 | suits | 1 | 28756 | 14 | 0.453 | 63479.0 |
469 | 2021-12-19 13:42:16 | suits | 1 | 28756 | 14 | 0.563 | 51076.4 |
468 | 2021-11-22 04:05:27 | suits | 1 | 28756 | 14 | 0.470 | 61183.0 |
467 | 2021-10-07 20:18:34 | suits | 1 | 28756 | 14 | 0.453 | 63479.0 |
466 | 2021-10-05 17:35:06 | suits | 1 | 28756 | 14 | 0.483 | 59536.2 |
465 | 2021-09-05 20:41:56 | suits | 1 | 28756 | 14 | 0.513 | 56054.6 |
464 | 2021-06-05 05:08:04 | suits | 1 | 28756 | 14 | 0.453 | 63479.0 |
463 | 2021-06-01 18:38:17 | suits | 1 | 28756 | 14 | 0.453 | 63479.0 |
462 | 2021-04-18 23:05:39 | suits | 1 | 28756 | 14 | 0.533 | 53951.2 |
461 | 2021-04-09 20:31:17 | suits | 1 | 28756 | 14 | 0.500 | 57512.0 |
460 | 2021-03-02 14:36:54 | suits | 1 | 28756 | 14 | 0.453 | 63479.0 |
459 | 2021-02-23 23:56:49 | suits | 1 | 28756 | 14 | 0.453 | 63479.0 |
458 | 2021-02-17 05:12:35 | suits | 1 | 28756 | 14 | 0.436 | 65954.1 |
457 | 2020-11-26 21:12:52 | suits | 1 | 28756 | 14 | 0.453 | 63479.0 |
456 | 2020-11-11 10:50:57 | suits | 1 | 28756 | 14 | 0.466 | 61708.2 |
455 | 2020-10-29 12:48:41 | suits | 1 | 28756 | 14 | 0.500 | 57512.0 |
454 | 2020-10-16 07:12:54 | suits | 1 | 28756 | 14 | 0.453 | 63479.0 |
453 | 2020-10-15 06:28:51 | suits | 1 | 28756 | 14 | 0.470 | 61183.0 |
452 | 2020-10-09 22:13:04 | suits | 1 | 28756 | 14 | 0.436 | 65954.1 |
451 | 2020-09-02 22:34:20 | suits | 1 | 28756 | 14 | 0.450 | 63902.2 |
450 | 2020-08-31 23:36:22 | suits | 1 | 28756 | 14 | 0.470 | 61183.0 |
449 | 2020-08-29 23:03:09 | suits | 1 | 28756 | 14 | 0.466 | 61708.2 |
448 | 2020-08-29 04:18:43 | suits | 1 | 28756 | 14 | 0.453 | 63479.0 |
447 | 2020-08-24 06:03:44 | suits | 1 | 28756 | 14 | 0.470 | 61183.0 |
446 | 2020-07-27 02:53:39 | suits | 1 | 28756 | 14 | 0.533 | 53951.2 |
445 | 2020-05-16 16:16:53 | suits | 1 | 28756 | 14 | 0.500 | 57512.0 |
444 | 2020-05-15 14:20:56 | suits | 1 | 28756 | 14 | 0.546 | 52666.7 |
443 | 2020-04-16 18:38:41 | suits | 1 | 28756 | 14 | 0.500 | 57512.0 |
442 | 2020-03-30 02:38:17 | suits | 1 | 28756 | 14 | 0.436 | 65954.1 |
441 | 2020-03-24 16:18:32 | suits | 1 | 28756 | 14 | 0.576 | 49923.6 |
440 | 2020-03-23 04:52:32 | suits | 1 | 28756 | 14 | 0.546 | 52666.7 |
439 | 2020-03-22 21:45:45 | suits | 1 | 28756 | 14 | 0.436 | 65954.1 |
438 | 2020-03-22 21:34:51 | suits | 1 | 28756 | 14 | 0.530 | 54256.6 |
437 | 2020-03-21 08:40:04 | suits | 1 | 28756 | 14 | 0.500 | 57512.0 |
436 | 2020-03-18 00:14:20 | suits | 1 | 28756 | 14 | 0.500 | 57512.0 |
435 | 2020-02-29 02:11:53 | suits | 1 | 28756 | 14 | 1.050 | 27386.7 |
434 | 2020-02-23 01:36:20 | suits | 1 | 28756 | 14 | 0.576 | 49923.6 |
433 | 2020-02-20 12:24:03 | suits | 1 | 28756 | 14 | 0.533 | 53951.2 |
432 | 2020-02-17 05:02:09 | suits | 1 | 28756 | 14 | 1.233 | 23322.0 |
431 | 2020-02-13 20:27:11 | suits | 1 | 28756 | 14 | 1.140 | 25224.6 |