History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"candy"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
510 | 2024-04-29 12:35:14 | candy | 1 | 28756 | 10 | 0.440 | 65354.5 |
509 | 2024-04-29 09:43:34 | candy | 1 | 28756 | 10 | 0.483 | 59536.2 |
508 | 2024-04-28 04:33:22 | candy | 1 | 28756 | 10 | 0.576 | 49923.6 |
507 | 2024-04-27 16:35:17 | candy | 2 | 53800 | 127 | 1.953 | 27547.4 |
506 | 2024-04-25 23:05:53 | candy | 1 | 28756 | 10 | 0.546 | 52666.7 |
505 | 2024-04-03 02:47:32 | candy | 1 | 28756 | 10 | 0.593 | 48492.4 |
504 | 2024-03-31 06:49:29 | candy | 2 | 53800 | 127 | 5.580 | 9641.6 |
503 | 2024-03-31 06:43:36 | candy | 1 | 28756 | 10 | 0.593 | 48492.4 |
502 | 2024-03-28 18:08:37 | candy | 1 | 28756 | 10 | 1.736 | 16564.5 |
501 | 2024-03-27 06:22:17 | candy | 1 | 28756 | 10 | 0.530 | 54256.6 |
500 | 2024-03-03 23:28:52 | candy | 2 | 53800 | 127 | 6.453 | 8337.2 |
499 | 2024-03-03 22:15:51 | candy | 1 | 28756 | 10 | 1.156 | 24875.4 |
498 | 2024-03-01 05:14:53 | candy | 1 | 28756 | 10 | 1.123 | 25606.4 |
497 | 2024-02-28 10:24:00 | candy | 1 | 28756 | 10 | 0.530 | 54256.6 |
496 | 2024-02-26 07:51:39 | candy | 1 | 28756 | 10 | 0.470 | 61183.0 |
495 | 2024-02-02 18:58:47 | candy | 1 | 28756 | 10 | 0.453 | 63479.0 |
494 | 2024-01-26 23:09:05 | candy | 1 | 28756 | 10 | 0.470 | 61183.0 |
493 | 2024-01-18 23:45:38 | candy | 2 | 53800 | 127 | 1.580 | 34050.6 |
492 | 2024-01-07 16:26:29 | candy | 1 | 28756 | 10 | 0.500 | 57512.0 |
491 | 2023-12-26 09:07:10 | candy | 1 | 28756 | 10 | 0.500 | 57512.0 |
490 | 2023-12-25 16:54:37 | candy | 2 | 53800 | 127 | 1.453 | 37026.8 |
489 | 2023-12-05 14:52:04 | candy | 2 | 53800 | 127 | 1.576 | 34137.1 |
488 | 2023-11-25 04:52:44 | candy | 2 | 53800 | 127 | 1.390 | 38705.0 |
487 | 2023-11-18 22:25:47 | candy | 1 | 28756 | 10 | 0.470 | 61183.0 |
486 | 2023-11-18 15:44:50 | candy | 1 | 28756 | 10 | 0.500 | 57512.0 |
485 | 2023-11-13 00:19:13 | candy | 1 | 28756 | 10 | 0.530 | 54256.6 |
484 | 2023-11-09 14:54:57 | candy | 1 | 28756 | 10 | 0.483 | 59536.2 |
483 | 2023-10-30 07:22:37 | candy | 1 | 28756 | 10 | 0.453 | 63479.0 |
482 | 2023-10-28 19:04:05 | candy | 2 | 53800 | 127 | 1.623 | 33148.5 |
481 | 2023-10-28 02:56:10 | candy | 1 | 28756 | 10 | 0.453 | 63479.0 |
480 | 2023-10-21 23:32:56 | candy | 1 | 28756 | 10 | 0.440 | 65354.5 |
479 | 2023-10-20 17:38:41 | candy | 1 | 28756 | 10 | 0.453 | 63479.0 |
478 | 2023-10-17 22:32:08 | candy | 1 | 28756 | 10 | 0.530 | 54256.6 |
477 | 2023-10-14 21:43:53 | candy | 1 | 28756 | 10 | 0.466 | 61708.2 |
476 | 2023-10-11 12:08:27 | candy | 1 | 28756 | 10 | 0.656 | 43835.4 |
475 | 2023-10-04 14:28:27 | candy | 1 | 28756 | 10 | 0.470 | 61183.0 |
474 | 2023-09-26 00:01:45 | candy | 1 | 28756 | 10 | 0.516 | 55728.7 |
473 | 2023-09-20 21:22:52 | candy | 1 | 28756 | 10 | 0.436 | 65954.1 |
472 | 2023-08-24 05:24:55 | candy | 1 | 28756 | 10 | 0.453 | 63479.0 |
471 | 2023-08-06 21:19:08 | candy | 2 | 53800 | 127 | 2.016 | 26686.5 |
470 | 2023-08-05 13:09:21 | candy | 1 | 28756 | 10 | 0.516 | 55728.7 |
469 | 2023-08-01 18:15:48 | candy | 1 | 28756 | 10 | 0.500 | 57512.0 |
468 | 2023-05-26 00:33:36 | candy | 1 | 28756 | 10 | 0.453 | 63479.0 |
467 | 2023-04-28 00:50:09 | candy | 1 | 28756 | 10 | 0.500 | 57512.0 |
466 | 2023-04-13 04:27:44 | candy | 2 | 53800 | 127 | 1.640 | 32804.9 |
465 | 2023-03-26 20:24:37 | candy | 1 | 28756 | 10 | 0.486 | 59168.7 |
464 | 2023-03-20 17:13:39 | candy | 1 | 28756 | 10 | 0.453 | 63479.0 |
463 | 2023-03-03 02:07:37 | candy | 1 | 28756 | 10 | 0.500 | 57512.0 |
462 | 2023-02-19 21:45:49 | candy | 1 | 28756 | 10 | 0.533 | 53951.2 |
461 | 2023-01-19 18:45:56 | candy | 2 | 53800 | 127 | 1.406 | 38264.6 |
460 | 2023-01-19 10:03:44 | candy | 1 | 28756 | 10 | 0.500 | 57512.0 |
459 | 2023-01-15 16:34:43 | candy | 1 | 28756 | 10 | 0.453 | 63479.0 |
458 | 2023-01-08 01:00:19 | candy | 1 | 28756 | 10 | 0.453 | 63479.0 |
457 | 2022-11-25 09:56:57 | candy | 1 | 28756 | 10 | 0.453 | 63479.0 |
456 | 2022-11-02 01:38:41 | candy | 2 | 53800 | 127 | 1.533 | 35094.6 |
455 | 2022-10-07 08:21:29 | candy | 1 | 28756 | 10 | 0.453 | 63479.0 |
454 | 2022-09-28 01:45:40 | candy | 1 | 28756 | 10 | 0.453 | 63479.0 |
453 | 2022-09-14 11:30:47 | candy | 1 | 28756 | 10 | 0.500 | 57512.0 |
452 | 2022-09-01 18:07:27 | candy | 1 | 28756 | 10 | 0.513 | 56054.6 |
451 | 2022-08-28 07:17:04 | candy | 1 | 28756 | 10 | 0.453 | 63479.0 |
450 | 2022-08-16 01:07:32 | candy | 1 | 28756 | 10 | 0.456 | 63061.4 |
449 | 2022-08-14 20:40:37 | candy | 1 | 28756 | 10 | 0.453 | 63479.0 |
448 | 2022-08-06 13:56:24 | candy | 1 | 28756 | 10 | 0.470 | 61183.0 |
447 | 2022-07-18 08:14:47 | candy | 1 | 28756 | 10 | 0.436 | 65954.1 |
446 | 2022-07-11 12:39:10 | candy | 1 | 28756 | 10 | 0.516 | 55728.7 |
445 | 2022-07-10 10:54:05 | candy | 1 | 28756 | 10 | 0.470 | 61183.0 |
444 | 2022-06-25 16:03:31 | candy | 1 | 28756 | 10 | 0.486 | 59168.7 |
443 | 2022-06-09 20:44:20 | candy | 1 | 28756 | 10 | 0.483 | 59536.2 |
442 | 2022-06-07 11:09:35 | candy | 1 | 28756 | 10 | 0.486 | 59168.7 |
441 | 2022-06-01 19:42:45 | candy | 1 | 28756 | 10 | 0.440 | 65354.5 |
440 | 2022-05-23 13:33:17 | candy | 1 | 28756 | 10 | 0.516 | 55728.7 |
439 | 2022-05-17 00:00:27 | candy | 2 | 53800 | 127 | 1.983 | 27130.6 |
438 | 2022-02-24 01:54:54 | candy | 1 | 28756 | 10 | 0.516 | 55728.7 |
437 | 2022-01-31 14:00:06 | candy | 1 | 28756 | 10 | 0.530 | 54256.6 |
436 | 2022-01-29 11:06:09 | candy | 1 | 28756 | 10 | 0.470 | 61183.0 |
435 | 2022-01-12 02:24:37 | candy | 2 | 53800 | 127 | 1.720 | 31279.1 |
434 | 2021-11-22 15:09:22 | candy | 1 | 28756 | 10 | 0.486 | 59168.7 |
433 | 2021-11-22 12:53:17 | candy | 1 | 28756 | 10 | 0.530 | 54256.6 |
432 | 2021-10-22 17:28:40 | candy | 1 | 28756 | 10 | 0.533 | 53951.2 |
431 | 2021-09-04 00:30:20 | candy | 1 | 28756 | 10 | 0.450 | 63902.2 |
430 | 2021-09-01 17:49:06 | candy | 1 | 28756 | 10 | 0.466 | 61708.2 |
429 | 2021-08-23 03:23:08 | candy | 1 | 28756 | 10 | 0.450 | 63902.2 |
428 | 2021-08-17 11:40:37 | candy | 1 | 28756 | 10 | 0.453 | 63479.0 |
427 | 2021-06-02 04:32:45 | candy | 1 | 28756 | 10 | 0.466 | 61708.2 |
426 | 2021-05-22 08:26:36 | candy | 1 | 28756 | 10 | 0.516 | 55728.7 |
425 | 2021-05-07 23:12:18 | candy | 1 | 28756 | 10 | 0.500 | 57512.0 |
424 | 2021-04-03 19:36:44 | candy | 1 | 28756 | 10 | 0.453 | 63479.0 |
423 | 2021-02-15 23:03:48 | candy | 1 | 28756 | 10 | 0.453 | 63479.0 |
422 | 2021-02-08 05:35:25 | candy | 1 | 28756 | 10 | 0.500 | 57512.0 |
421 | 2021-02-08 04:54:23 | candy | 1 | 28756 | 10 | 0.450 | 63902.2 |
420 | 2021-02-08 04:32:44 | candy | 1 | 28756 | 10 | 0.516 | 55728.7 |
419 | 2021-02-03 03:22:28 | candy | 1 | 28756 | 10 | 0.453 | 63479.0 |
418 | 2020-11-17 17:32:53 | candy | 1 | 28756 | 10 | 0.486 | 59168.7 |
417 | 2020-11-01 07:09:31 | candy | 1 | 28756 | 10 | 0.596 | 48248.3 |
416 | 2020-10-22 05:10:43 | candy | 1 | 28756 | 10 | 0.546 | 52666.7 |
415 | 2020-10-21 11:16:11 | candy | 1 | 28756 | 10 | 0.530 | 54256.6 |
414 | 2020-09-23 19:50:20 | candy | 1 | 28756 | 10 | 0.453 | 63479.0 |
413 | 2020-09-15 05:26:18 | candy | 1 | 28756 | 10 | 0.466 | 61708.2 |
412 | 2020-08-24 23:52:32 | candy | 1 | 28756 | 10 | 0.453 | 63479.0 |
411 | 2020-08-21 15:16:23 | candy | 1 | 28756 | 10 | 0.453 | 63479.0 |