History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"desks"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
535 | 2025-01-06 15:36:08 | desks | 1 | 28756 | 5 | 2.266 | 12690.2 |
534 | 2025-01-06 09:53:12 | desks | 1 | 28756 | 5 | 2.263 | 12707.0 |
533 | 2025-01-01 18:04:51 | desks | 1 | 28756 | 5 | 0.483 | 59536.2 |
532 | 2024-12-29 14:05:11 | desks | 2 | 53800 | 144 | 7.813 | 6886.0 |
531 | 2024-12-29 13:50:16 | desks | 1 | 28756 | 5 | 0.500 | 57512.0 |
530 | 2024-12-07 09:39:42 | desks | 2 | 53800 | 144 | 3.983 | 13507.4 |
529 | 2024-12-07 09:39:34 | desks | 1 | 28756 | 5 | 1.156 | 24875.4 |
528 | 2024-12-01 23:43:33 | desks | 1 | 28756 | 5 | 3.470 | 8287.0 |
527 | 2024-11-29 06:29:18 | desks | 2 | 53800 | 144 | 5.800 | 9275.9 |
526 | 2024-11-29 06:19:59 | desks | 1 | 28756 | 5 | 3.280 | 8767.1 |
525 | 2024-11-29 06:09:43 | desks | 1 | 28756 | 5 | 0.436 | 65954.1 |
524 | 2024-11-15 02:38:13 | desks | 1 | 28756 | 5 | 1.000 | 28756.0 |
523 | 2024-11-07 08:39:45 | desks | 2 | 53800 | 144 | 6.500 | 8276.9 |
522 | 2024-11-07 08:39:44 | desks | 1 | 28756 | 5 | 0.953 | 30174.2 |
521 | 2024-11-03 17:14:20 | desks | 2 | 53800 | 144 | 5.046 | 10661.9 |
520 | 2024-10-31 20:49:08 | desks | 2 | 53800 | 144 | 7.970 | 6750.3 |
519 | 2024-10-31 20:46:03 | desks | 1 | 28756 | 5 | 0.500 | 57512.0 |
518 | 2024-10-30 05:39:11 | desks | 2 | 53800 | 144 | 6.626 | 8119.5 |
517 | 2024-10-30 04:45:14 | desks | 1 | 28756 | 5 | 0.436 | 65954.1 |
516 | 2024-10-02 11:44:25 | desks | 2 | 53800 | 144 | 12.376 | 4347.1 |
515 | 2024-09-30 09:18:45 | desks | 1 | 28756 | 5 | 0.456 | 63061.4 |
514 | 2024-09-29 18:06:41 | desks | 2 | 53800 | 144 | 2.763 | 19471.6 |
513 | 2024-09-29 17:58:36 | desks | 2 | 53800 | 144 | 1.483 | 36277.8 |
512 | 2024-09-29 17:58:31 | desks | 1 | 28756 | 5 | 0.453 | 63479.0 |
511 | 2024-09-29 05:43:09 | desks | 1 | 28756 | 5 | 3.233 | 8894.5 |
510 | 2024-09-07 09:43:42 | desks | 1 | 28756 | 5 | 4.470 | 6433.1 |
509 | 2024-09-02 21:19:47 | desks | 2 | 53800 | 144 | 17.313 | 3107.5 |
508 | 2024-09-02 21:18:50 | desks | 1 | 28756 | 5 | 2.810 | 10233.5 |
507 | 2024-08-31 06:28:22 | desks | 1 | 28756 | 5 | 4.233 | 6793.3 |
506 | 2024-08-30 00:43:42 | desks | 2 | 53800 | 144 | 16.313 | 3298.0 |
505 | 2024-08-29 19:00:28 | desks | 1 | 28756 | 5 | 2.220 | 12953.2 |
504 | 2024-08-29 18:45:09 | desks | 2 | 53800 | 144 | 11.576 | 4647.5 |
503 | 2024-08-29 12:25:25 | desks | 2 | 53800 | 144 | 9.076 | 5927.7 |
502 | 2024-08-29 12:05:44 | desks | 1 | 28756 | 5 | 3.376 | 8517.8 |
501 | 2024-08-21 05:50:58 | desks | 2 | 53800 | 144 | 12.283 | 4380.0 |
500 | 2024-08-15 08:21:17 | desks | 1 | 28756 | 5 | 1.810 | 15887.3 |
499 | 2024-08-12 12:57:45 | desks | 1 | 28756 | 5 | 3.013 | 9544.0 |
498 | 2024-08-08 01:42:05 | desks | 1 | 28756 | 5 | 2.653 | 10839.1 |
497 | 2024-08-01 22:28:05 | desks | 2 | 53800 | 144 | 7.516 | 7158.1 |
496 | 2024-07-30 17:23:11 | desks | 1 | 28756 | 5 | 0.873 | 32939.3 |
495 | 2024-07-30 09:33:21 | desks | 2 | 53800 | 144 | 6.220 | 8649.5 |
494 | 2024-07-30 07:25:03 | desks | 1 | 28756 | 5 | 0.656 | 43835.4 |
493 | 2024-07-29 13:43:53 | desks | 1 | 28756 | 5 | 2.330 | 12341.6 |
492 | 2024-07-28 00:15:27 | desks | 1 | 28756 | 5 | 1.500 | 19170.7 |
491 | 2024-07-26 19:53:17 | desks | 1 | 28756 | 5 | 2.173 | 13233.3 |
490 | 2024-07-13 16:58:33 | desks | 2 | 53800 | 144 | 5.640 | 9539.0 |
489 | 2024-07-13 16:55:00 | desks | 1 | 28756 | 5 | 1.826 | 15748.1 |
488 | 2024-06-30 10:49:42 | desks | 1 | 28756 | 5 | 1.140 | 25224.6 |
487 | 2024-06-30 07:13:42 | desks | 1 | 28756 | 5 | 1.486 | 19351.3 |
486 | 2024-06-28 06:36:03 | desks | 1 | 28756 | 5 | 1.483 | 19390.4 |
485 | 2024-06-27 14:08:37 | desks | 1 | 28756 | 5 | 0.953 | 30174.2 |
484 | 2024-06-19 01:09:35 | desks | 1 | 28756 | 5 | 1.890 | 15214.8 |
483 | 2024-06-12 14:44:15 | desks | 1 | 28756 | 5 | 1.423 | 20208.0 |
482 | 2024-06-09 00:11:01 | desks | 1 | 28756 | 5 | 1.813 | 15861.0 |
481 | 2024-06-04 01:45:58 | desks | 2 | 53800 | 144 | 7.530 | 7144.8 |
480 | 2024-06-03 23:18:47 | desks | 2 | 53800 | 144 | 2.203 | 24421.2 |
479 | 2024-06-03 23:18:43 | desks | 1 | 28756 | 5 | 0.830 | 34645.8 |
478 | 2024-05-31 03:29:28 | desks | 1 | 28756 | 5 | 0.530 | 54256.6 |
477 | 2024-05-30 15:10:59 | desks | 1 | 28756 | 5 | 0.766 | 37540.5 |
476 | 2024-05-28 02:21:31 | desks | 1 | 28756 | 5 | 1.970 | 14597.0 |
475 | 2024-05-04 03:59:59 | desks | 1 | 28756 | 5 | 0.530 | 54256.6 |
474 | 2024-05-03 10:47:32 | desks | 1 | 28756 | 5 | 0.546 | 52666.7 |
473 | 2024-05-01 01:30:43 | desks | 1 | 28756 | 5 | 0.550 | 52283.6 |
472 | 2024-04-29 00:50:37 | desks | 1 | 28756 | 5 | 0.513 | 56054.6 |
471 | 2024-04-27 08:12:23 | desks | 1 | 28756 | 5 | 0.500 | 57512.0 |
470 | 2024-04-26 07:32:29 | desks | 1 | 28756 | 5 | 0.610 | 47141.0 |
469 | 2024-04-19 02:14:30 | desks | 1 | 28756 | 5 | 0.440 | 65354.5 |
468 | 2024-04-02 20:35:15 | desks | 1 | 28756 | 5 | 0.453 | 63479.0 |
467 | 2024-03-31 09:50:41 | desks | 2 | 53800 | 144 | 4.766 | 11288.3 |
466 | 2024-03-31 09:50:31 | desks | 1 | 28756 | 5 | 1.046 | 27491.4 |
465 | 2024-03-31 09:50:20 | desks | 2 | 53800 | 144 | 5.733 | 9384.3 |
464 | 2024-03-31 08:49:43 | desks | 1 | 28756 | 5 | 0.546 | 52666.7 |
463 | 2024-03-27 01:30:31 | desks | 1 | 28756 | 5 | 0.513 | 56054.6 |
462 | 2024-03-04 03:17:57 | desks | 1 | 28756 | 5 | 0.530 | 54256.6 |
461 | 2024-03-02 18:13:38 | desks | 1 | 28756 | 5 | 2.326 | 12362.9 |
460 | 2024-02-25 17:34:26 | desks | 1 | 28756 | 5 | 0.453 | 63479.0 |
459 | 2024-01-24 13:28:21 | desks | 1 | 28756 | 5 | 0.550 | 52283.6 |
458 | 2024-01-05 09:02:41 | desks | 1 | 28756 | 5 | 0.440 | 65354.5 |
457 | 2023-12-31 13:57:10 | desks | 2 | 53800 | 144 | 1.423 | 37807.4 |
456 | 2023-12-03 21:04:59 | desks | 2 | 53800 | 144 | 1.640 | 32804.9 |
455 | 2023-11-27 23:57:17 | desks | 1 | 28756 | 5 | 1.093 | 26309.2 |
454 | 2023-11-18 23:51:18 | desks | 1 | 28756 | 5 | 0.483 | 59536.2 |
453 | 2023-11-14 01:31:03 | desks | 1 | 28756 | 5 | 0.500 | 57512.0 |
452 | 2023-11-01 03:39:08 | desks | 2 | 53800 | 144 | 1.453 | 37026.8 |
451 | 2023-10-27 12:33:58 | desks | 1 | 28756 | 5 | 1.013 | 28387.0 |
450 | 2023-10-26 00:53:29 | desks | 1 | 28756 | 5 | 0.436 | 65954.1 |
449 | 2023-10-22 07:43:46 | desks | 1 | 28756 | 5 | 0.440 | 65354.5 |
448 | 2023-10-18 13:14:03 | desks | 1 | 28756 | 5 | 0.440 | 65354.5 |
447 | 2023-10-13 16:45:02 | desks | 1 | 28756 | 5 | 0.516 | 55728.7 |
446 | 2023-10-04 23:25:38 | desks | 1 | 28756 | 5 | 0.500 | 57512.0 |
445 | 2023-09-26 19:16:36 | desks | 1 | 28756 | 5 | 0.500 | 57512.0 |
444 | 2023-09-12 20:26:38 | desks | 1 | 28756 | 5 | 0.500 | 57512.0 |
443 | 2023-08-21 18:50:20 | desks | 1 | 28756 | 5 | 0.440 | 65354.5 |
442 | 2023-08-08 16:16:55 | desks | 1 | 28756 | 5 | 0.436 | 65954.1 |
441 | 2023-05-21 08:51:38 | desks | 1 | 28756 | 5 | 0.436 | 65954.1 |
440 | 2023-05-01 01:29:55 | desks | 1 | 28756 | 5 | 0.453 | 63479.0 |
439 | 2023-04-08 19:46:42 | desks | 1 | 28756 | 5 | 0.423 | 67981.1 |
438 | 2023-03-16 06:00:16 | desks | 1 | 28756 | 5 | 0.483 | 59536.2 |
437 | 2023-01-18 18:51:17 | desks | 1 | 28756 | 5 | 0.453 | 63479.0 |
436 | 2023-01-04 16:16:59 | desks | 1 | 28756 | 5 | 0.423 | 67981.1 |