History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"merch"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
535 | 2024-04-23 03:31:16 | merch | 1 | 28756 | 6 | 0.546 | 52666.7 |
534 | 2024-04-22 23:56:19 | merch | 1 | 28756 | 6 | 0.436 | 65954.1 |
533 | 2024-04-10 21:07:50 | merch | 2 | 53800 | 84 | 3.550 | 15154.9 |
532 | 2024-04-10 20:57:53 | merch | 3 | 83667 | 789 | 8.406 | 9953.2 |
531 | 2024-04-08 22:11:46 | merch | 2 | 53800 | 84 | 5.143 | 10460.8 |
530 | 2024-04-08 22:11:13 | merch | 3 | 83667 | 789 | 5.123 | 16331.6 |
529 | 2024-04-08 08:23:26 | merch | 2 | 53800 | 84 | 1.703 | 31591.3 |
528 | 2024-04-08 08:23:03 | merch | 3 | 83667 | 789 | 6.420 | 13032.2 |
527 | 2024-04-08 02:45:46 | merch | 3 | 83667 | 789 | 4.466 | 18734.2 |
526 | 2024-04-07 10:54:16 | merch | 3 | 83667 | 789 | 4.656 | 17969.7 |
525 | 2024-04-02 20:39:34 | merch | 1 | 28756 | 6 | 0.486 | 59168.7 |
524 | 2024-03-31 07:30:38 | merch | 1 | 28756 | 6 | 0.450 | 63902.2 |
523 | 2024-03-29 09:42:03 | merch | 1 | 28756 | 6 | 0.470 | 61183.0 |
522 | 2024-03-06 10:38:24 | merch | 2 | 53800 | 84 | 1.893 | 28420.5 |
521 | 2024-03-02 17:59:43 | merch | 3 | 83667 | 789 | 13.923 | 6009.3 |
520 | 2024-03-02 17:59:40 | merch | 2 | 53800 | 84 | 3.830 | 14047.0 |
519 | 2024-03-02 17:54:56 | merch | 1 | 28756 | 6 | 1.140 | 25224.6 |
518 | 2024-02-28 05:27:35 | merch | 3 | 83667 | 789 | 7.140 | 11718.1 |
517 | 2024-02-28 03:41:34 | merch | 2 | 53800 | 84 | 3.576 | 15044.7 |
516 | 2024-02-28 03:41:07 | merch | 3 | 83667 | 789 | 7.876 | 10623.0 |
515 | 2024-02-28 03:01:10 | merch | 3 | 83667 | 789 | 6.420 | 13032.2 |
514 | 2024-02-28 03:01:10 | merch | 2 | 53800 | 84 | 1.670 | 32215.6 |
513 | 2024-02-28 03:01:08 | merch | 1 | 28756 | 6 | 0.470 | 61183.0 |
512 | 2024-01-28 22:22:13 | merch | 1 | 28756 | 6 | 0.483 | 59536.2 |
511 | 2024-01-21 09:34:18 | merch | 1 | 28756 | 6 | 0.436 | 65954.1 |
510 | 2023-12-28 15:24:47 | merch | 2 | 53800 | 84 | 1.376 | 39098.8 |
509 | 2023-12-27 06:17:47 | merch | 2 | 53800 | 84 | 1.390 | 38705.0 |
508 | 2023-12-25 23:10:20 | merch | 3 | 83667 | 789 | 6.436 | 12999.8 |
507 | 2023-12-23 15:32:37 | merch | 3 | 83667 | 789 | 3.716 | 22515.3 |
506 | 2023-12-08 18:05:10 | merch | 3 | 83667 | 789 | 6.890 | 12143.3 |
505 | 2023-12-08 08:23:30 | merch | 1 | 28756 | 6 | 0.560 | 51350.0 |
504 | 2023-12-08 08:23:29 | merch | 1 | 28756 | 6 | 0.563 | 51076.4 |
503 | 2023-11-25 18:38:51 | merch | 2 | 53800 | 84 | 1.390 | 38705.0 |
502 | 2023-11-17 15:15:59 | merch | 1 | 28756 | 6 | 0.500 | 57512.0 |
501 | 2023-11-16 03:14:09 | merch | 1 | 28756 | 6 | 0.436 | 65954.1 |
500 | 2023-11-13 07:37:50 | merch | 1 | 28756 | 6 | 0.483 | 59536.2 |
499 | 2023-11-12 18:19:46 | merch | 3 | 83667 | 789 | 3.860 | 21675.4 |
498 | 2023-11-12 18:19:08 | merch | 2 | 53800 | 84 | 1.560 | 34487.2 |
497 | 2023-11-03 12:48:22 | merch | 1 | 28756 | 6 | 0.500 | 57512.0 |
496 | 2023-10-21 10:18:24 | merch | 1 | 28756 | 6 | 0.483 | 59536.2 |
495 | 2023-10-18 20:05:16 | merch | 1 | 28756 | 6 | 0.470 | 61183.0 |
494 | 2023-10-14 02:34:06 | merch | 1 | 28756 | 6 | 0.436 | 65954.1 |
493 | 2023-10-09 15:50:55 | merch | 1 | 28756 | 6 | 0.500 | 57512.0 |
492 | 2023-10-05 01:36:12 | merch | 1 | 28756 | 6 | 0.423 | 67981.1 |
491 | 2023-09-27 00:14:54 | merch | 1 | 28756 | 6 | 0.500 | 57512.0 |
490 | 2023-09-11 21:28:18 | merch | 3 | 83667 | 789 | 7.250 | 11540.3 |
489 | 2023-09-10 19:57:18 | merch | 1 | 28756 | 6 | 0.533 | 53951.2 |
488 | 2023-09-05 15:14:06 | merch | 3 | 83667 | 789 | 3.686 | 22698.6 |
487 | 2023-09-04 06:33:44 | merch | 1 | 28756 | 6 | 0.440 | 65354.5 |
486 | 2023-08-24 19:11:46 | merch | 2 | 53800 | 84 | 1.420 | 37887.3 |
485 | 2023-06-22 15:46:43 | merch | 1 | 28756 | 6 | 0.423 | 67981.1 |
484 | 2023-05-23 01:35:35 | merch | 3 | 83667 | 789 | 3.233 | 25879.1 |
483 | 2023-05-09 02:33:36 | merch | 2 | 53800 | 84 | 1.343 | 40059.6 |
482 | 2023-04-29 14:42:14 | merch | 3 | 83667 | 789 | 3.360 | 24900.9 |
481 | 2023-04-28 12:16:36 | merch | 1 | 28756 | 6 | 0.423 | 67981.1 |
480 | 2023-04-22 18:33:55 | merch | 3 | 83667 | 789 | 3.533 | 23681.6 |
479 | 2023-03-31 16:51:54 | merch | 1 | 28756 | 6 | 0.500 | 57512.0 |
478 | 2023-03-24 04:36:22 | merch | 1 | 28756 | 6 | 0.436 | 65954.1 |
477 | 2023-03-22 11:05:28 | merch | 3 | 83667 | 789 | 3.220 | 25983.5 |
476 | 2023-02-28 23:21:06 | merch | 3 | 83667 | 789 | 3.216 | 26015.9 |
475 | 2023-02-28 09:32:59 | merch | 1 | 28756 | 6 | 0.486 | 59168.7 |
474 | 2023-02-16 06:12:52 | merch | 2 | 53800 | 84 | 1.343 | 40059.6 |
473 | 2023-01-12 02:58:02 | merch | 1 | 28756 | 6 | 0.483 | 59536.2 |
472 | 2022-12-10 08:21:31 | merch | 3 | 83667 | 789 | 3.373 | 24804.9 |
471 | 2022-11-28 05:29:09 | merch | 2 | 53800 | 84 | 1.343 | 40059.6 |
470 | 2022-11-25 08:03:56 | merch | 1 | 28756 | 6 | 0.423 | 67981.1 |
469 | 2022-11-01 00:54:43 | merch | 1 | 28756 | 6 | 0.516 | 55728.7 |
468 | 2022-10-15 10:05:51 | merch | 1 | 28756 | 6 | 0.513 | 56054.6 |
467 | 2022-09-10 18:12:45 | merch | 1 | 28756 | 6 | 0.453 | 63479.0 |
466 | 2022-09-03 11:37:59 | merch | 1 | 28756 | 6 | 0.483 | 59536.2 |
465 | 2022-09-02 06:39:00 | merch | 3 | 83667 | 789 | 8.220 | 10178.5 |
464 | 2022-08-26 08:46:32 | merch | 1 | 28756 | 6 | 0.466 | 61708.2 |
463 | 2022-08-14 02:57:39 | merch | 1 | 28756 | 6 | 0.436 | 65954.1 |
462 | 2022-08-06 23:59:27 | merch | 1 | 28756 | 6 | 0.436 | 65954.1 |
461 | 2022-07-30 01:30:03 | merch | 1 | 28756 | 6 | 0.453 | 63479.0 |
460 | 2022-07-28 23:23:00 | merch | 1 | 28756 | 6 | 0.453 | 63479.0 |
459 | 2022-07-26 17:57:02 | merch | 3 | 83667 | 789 | 3.763 | 22234.1 |
458 | 2022-07-14 20:39:53 | merch | 1 | 28756 | 6 | 0.440 | 65354.5 |
457 | 2022-07-03 09:42:08 | merch | 1 | 28756 | 6 | 0.436 | 65954.1 |
456 | 2022-07-02 10:03:36 | merch | 1 | 28756 | 6 | 0.483 | 59536.2 |
455 | 2022-06-16 09:40:22 | merch | 1 | 28756 | 6 | 0.436 | 65954.1 |
454 | 2022-06-15 20:34:32 | merch | 1 | 28756 | 6 | 0.486 | 59168.7 |
453 | 2022-06-08 16:45:19 | merch | 1 | 28756 | 6 | 0.436 | 65954.1 |
452 | 2022-06-05 20:19:46 | merch | 1 | 28756 | 6 | 0.420 | 68466.7 |
451 | 2022-06-03 14:15:25 | merch | 1 | 28756 | 6 | 0.436 | 65954.1 |
450 | 2022-06-01 13:05:30 | merch | 1 | 28756 | 6 | 0.436 | 65954.1 |
449 | 2022-06-01 08:44:10 | merch | 1 | 28756 | 6 | 0.440 | 65354.5 |
448 | 2022-05-30 02:25:36 | merch | 1 | 28756 | 6 | 0.423 | 67981.1 |
447 | 2022-05-26 02:12:05 | merch | 1 | 28756 | 6 | 0.486 | 59168.7 |
446 | 2022-05-25 16:36:25 | merch | 1 | 28756 | 6 | 0.483 | 59536.2 |
445 | 2022-04-27 01:50:57 | merch | 2 | 53800 | 84 | 1.563 | 34421.0 |
444 | 2022-03-14 09:02:46 | merch | 1 | 28756 | 6 | 0.716 | 40162.0 |
443 | 2022-02-15 02:23:29 | merch | 1 | 28756 | 6 | 0.500 | 57512.0 |
442 | 2022-02-11 06:31:51 | merch | 1 | 28756 | 6 | 0.513 | 56054.6 |
441 | 2021-12-26 10:11:43 | merch | 1 | 28756 | 6 | 0.513 | 56054.6 |
440 | 2021-12-05 11:54:28 | merch | 1 | 28756 | 6 | 0.483 | 59536.2 |
439 | 2021-12-04 22:41:40 | merch | 1 | 28756 | 6 | 0.483 | 59536.2 |
438 | 2021-11-30 15:20:35 | merch | 1 | 28756 | 6 | 1.096 | 26237.2 |
437 | 2021-11-04 02:29:00 | merch | 1 | 28756 | 6 | 0.516 | 55728.7 |
436 | 2021-10-20 14:20:40 | merch | 1 | 28756 | 6 | 0.453 | 63479.0 |