History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"drummer"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
510 | 2024-04-28 17:33:53 | drummer | 3 | 134027 | 315 | 9.623 | 13927.8 |
509 | 2024-04-27 20:25:05 | drummer | 3 | 134027 | 315 | 22.440 | 5972.7 |
508 | 2024-04-27 19:33:09 | drummer | 3 | 134027 | 315 | 6.220 | 21547.7 |
507 | 2024-04-09 22:30:46 | drummer | 1 | 69583 | 5 | 1.280 | 54361.7 |
506 | 2024-04-08 23:38:24 | drummer | 1 | 69583 | 5 | 1.190 | 58473.1 |
505 | 2024-03-29 07:01:53 | drummer | 3 | 134027 | 315 | 23.816 | 5627.6 |
504 | 2024-03-29 07:01:50 | drummer | 2 | 107671 | 41 | 5.500 | 19576.5 |
503 | 2024-03-29 06:55:12 | drummer | 1 | 69583 | 5 | 1.296 | 53690.6 |
502 | 2024-03-28 06:23:49 | drummer | 1 | 69583 | 5 | 1.673 | 41591.8 |
501 | 2024-03-25 17:33:29 | drummer | 2 | 107671 | 41 | 6.593 | 16331.1 |
500 | 2024-03-25 17:29:40 | drummer | 3 | 134027 | 315 | 7.046 | 19021.7 |
499 | 2024-03-25 04:29:10 | drummer | 3 | 134027 | 315 | 18.046 | 7427.0 |
498 | 2024-03-20 19:23:16 | drummer | 2 | 107671 | 41 | 5.703 | 18879.7 |
497 | 2024-03-20 19:22:35 | drummer | 3 | 134027 | 315 | 7.190 | 18640.8 |
496 | 2024-03-19 23:41:58 | drummer | 2 | 107671 | 41 | 7.140 | 15080.0 |
495 | 2024-03-19 23:41:57 | drummer | 1 | 69583 | 5 | 2.500 | 27833.2 |
494 | 2024-03-19 23:41:40 | drummer | 3 | 134027 | 315 | 7.216 | 18573.6 |
493 | 2024-03-18 22:44:57 | drummer | 3 | 134027 | 315 | 23.376 | 5733.5 |
492 | 2024-03-18 22:44:57 | drummer | 2 | 107671 | 41 | 3.813 | 28237.9 |
491 | 2024-03-18 22:42:57 | drummer | 1 | 69583 | 5 | 5.453 | 12760.5 |
490 | 2024-03-01 19:38:50 | drummer | 1 | 69583 | 5 | 3.080 | 22591.9 |
489 | 2024-03-01 11:17:07 | drummer | 1 | 69583 | 5 | 1.703 | 40859.1 |
488 | 2024-02-27 22:56:53 | drummer | 1 | 69583 | 5 | 2.656 | 26198.4 |
487 | 2024-02-16 21:15:38 | drummer | 1 | 69583 | 5 | 2.750 | 25302.9 |
486 | 2024-02-05 23:10:57 | drummer | 2 | 107671 | 41 | 6.593 | 16331.1 |
485 | 2024-02-05 04:25:24 | drummer | 2 | 107671 | 41 | 4.953 | 21738.5 |
484 | 2024-01-20 17:18:22 | drummer | 3 | 134027 | 315 | 6.563 | 20421.6 |
483 | 2024-01-15 02:47:56 | drummer | 1 | 69583 | 5 | 2.500 | 27833.2 |
482 | 2024-01-09 21:56:52 | drummer | 3 | 134027 | 315 | 6.700 | 20004.0 |
481 | 2024-01-08 13:35:53 | drummer | 3 | 134027 | 315 | 5.703 | 23501.1 |
480 | 2024-01-07 05:31:26 | drummer | 3 | 134027 | 315 | 6.280 | 21341.9 |
479 | 2023-12-31 12:08:42 | drummer | 2 | 107671 | 41 | 3.143 | 34257.4 |
478 | 2023-12-28 15:24:38 | drummer | 1 | 69583 | 5 | 1.236 | 56296.9 |
477 | 2023-12-28 12:40:38 | drummer | 2 | 107671 | 41 | 3.313 | 32499.5 |
476 | 2023-12-17 06:26:29 | drummer | 1 | 69583 | 5 | 1.080 | 64428.7 |
475 | 2023-11-19 01:25:12 | drummer | 1 | 69583 | 5 | 1.030 | 67556.3 |
474 | 2023-11-18 09:54:24 | drummer | 1 | 69583 | 5 | 1.046 | 66522.9 |
473 | 2023-11-15 11:45:04 | drummer | 3 | 134027 | 315 | 6.530 | 20524.8 |
472 | 2023-11-12 08:34:10 | drummer | 2 | 107671 | 41 | 2.736 | 39353.4 |
471 | 2023-10-29 18:48:23 | drummer | 3 | 134027 | 315 | 5.843 | 22938.0 |
470 | 2023-10-19 22:58:27 | drummer | 3 | 134027 | 315 | 5.623 | 23835.5 |
469 | 2023-10-18 11:03:56 | drummer | 1 | 69583 | 5 | 1.016 | 68487.2 |
468 | 2023-10-05 09:49:05 | drummer | 3 | 134027 | 315 | 6.906 | 19407.3 |
467 | 2023-10-04 17:26:34 | drummer | 3 | 134027 | 315 | 8.360 | 16031.9 |
466 | 2023-10-01 05:21:14 | drummer | 3 | 134027 | 315 | 7.423 | 18055.6 |
465 | 2023-09-29 10:21:00 | drummer | 1 | 69583 | 5 | 1.046 | 66522.9 |
464 | 2023-09-28 12:24:01 | drummer | 3 | 134027 | 315 | 8.516 | 15738.3 |
463 | 2023-09-20 17:21:22 | drummer | 1 | 69583 | 5 | 1.033 | 67360.1 |
462 | 2023-08-14 08:53:25 | drummer | 2 | 107671 | 41 | 3.516 | 30623.2 |
461 | 2023-08-14 04:35:12 | drummer | 1 | 69583 | 5 | 1.123 | 61961.7 |
460 | 2023-07-31 16:02:02 | drummer | 3 | 134027 | 315 | 5.766 | 23244.4 |
459 | 2023-07-13 07:45:08 | drummer | 1 | 69583 | 5 | 1.266 | 54962.9 |
458 | 2023-07-02 12:08:14 | drummer | 3 | 134027 | 315 | 5.753 | 23296.9 |
457 | 2023-05-13 13:58:23 | drummer | 1 | 69583 | 5 | 1.076 | 64668.2 |
456 | 2023-04-23 17:17:05 | drummer | 2 | 107671 | 41 | 2.780 | 38730.6 |
455 | 2023-04-11 12:53:07 | drummer | 3 | 134027 | 315 | 5.626 | 23822.8 |
454 | 2023-03-18 22:11:15 | drummer | 1 | 69583 | 5 | 1.063 | 65459.1 |
453 | 2023-03-09 12:49:32 | drummer | 1 | 69583 | 5 | 1.030 | 67556.3 |
452 | 2023-02-02 16:54:49 | drummer | 3 | 134027 | 315 | 5.516 | 24297.9 |
451 | 2023-01-28 18:03:06 | drummer | 2 | 107671 | 41 | 2.720 | 39584.9 |
450 | 2023-01-23 10:17:49 | drummer | 3 | 134027 | 315 | 6.406 | 20922.1 |
449 | 2023-01-14 16:49:11 | drummer | 3 | 134027 | 315 | 5.470 | 24502.2 |
448 | 2023-01-05 23:53:29 | drummer | 1 | 69583 | 5 | 1.076 | 64668.2 |
447 | 2022-12-30 22:53:31 | drummer | 1 | 69583 | 5 | 1.110 | 62687.4 |
446 | 2022-12-17 19:17:11 | drummer | 3 | 134027 | 315 | 5.686 | 23571.4 |
445 | 2022-11-26 03:36:58 | drummer | 1 | 69583 | 5 | 1.250 | 55666.4 |
444 | 2022-11-25 10:55:41 | drummer | 1 | 69583 | 5 | 1.063 | 65459.1 |
443 | 2022-11-24 06:32:25 | drummer | 1 | 69583 | 5 | 1.030 | 67556.3 |
442 | 2022-11-20 20:23:33 | drummer | 3 | 134027 | 315 | 5.766 | 23244.4 |
441 | 2022-11-11 11:15:25 | drummer | 3 | 134027 | 315 | 6.283 | 21331.7 |
440 | 2022-11-10 15:58:45 | drummer | 2 | 107671 | 41 | 2.843 | 37872.3 |
439 | 2022-10-20 07:21:46 | drummer | 3 | 134027 | 315 | 6.153 | 21782.4 |
438 | 2022-10-08 17:01:18 | drummer | 3 | 134027 | 315 | 6.220 | 21547.7 |
437 | 2022-09-28 06:51:11 | drummer | 3 | 134027 | 315 | 6.000 | 22337.8 |
436 | 2022-09-18 10:48:32 | drummer | 1 | 69583 | 5 | 2.360 | 29484.3 |
435 | 2022-09-11 20:36:44 | drummer | 1 | 69583 | 5 | 1.140 | 61037.7 |
434 | 2022-09-01 10:38:23 | drummer | 3 | 134027 | 315 | 5.686 | 23571.4 |
433 | 2022-08-27 19:39:29 | drummer | 3 | 134027 | 315 | 5.610 | 23890.7 |
432 | 2022-08-15 04:11:07 | drummer | 1 | 69583 | 5 | 1.076 | 64668.2 |
431 | 2022-08-06 19:46:50 | drummer | 1 | 69583 | 5 | 1.096 | 63488.1 |
430 | 2022-07-30 09:56:38 | drummer | 1 | 69583 | 5 | 1.060 | 65644.3 |
429 | 2022-07-30 05:01:21 | drummer | 3 | 134027 | 315 | 5.656 | 23696.4 |
428 | 2022-07-29 12:21:12 | drummer | 1 | 69583 | 5 | 1.076 | 64668.2 |
427 | 2022-07-28 00:56:17 | drummer | 1 | 69583 | 5 | 1.080 | 64428.7 |
426 | 2022-06-30 17:12:04 | drummer | 1 | 69583 | 5 | 1.076 | 64668.2 |
425 | 2022-06-25 11:47:30 | drummer | 1 | 69583 | 5 | 1.063 | 65459.1 |
424 | 2022-06-24 23:38:27 | drummer | 1 | 69583 | 5 | 1.093 | 63662.4 |
423 | 2022-06-19 14:54:20 | drummer | 3 | 134027 | 315 | 5.936 | 22578.7 |
422 | 2022-06-12 22:09:43 | drummer | 2 | 107671 | 41 | 3.296 | 32667.2 |
421 | 2022-05-28 18:55:38 | drummer | 3 | 134027 | 315 | 5.563 | 24092.6 |
420 | 2022-05-22 01:03:57 | drummer | 3 | 134027 | 315 | 5.640 | 23763.7 |
419 | 2022-05-19 21:43:49 | drummer | 3 | 134027 | 315 | 5.843 | 22938.0 |
418 | 2022-05-16 10:35:22 | drummer | 1 | 69583 | 5 | 1.140 | 61037.7 |
417 | 2022-03-23 03:45:49 | drummer | 1 | 69583 | 5 | 1.156 | 60192.9 |
416 | 2022-02-27 05:04:13 | drummer | 1 | 69583 | 5 | 1.080 | 64428.7 |
415 | 2022-02-01 02:29:18 | drummer | 2 | 107671 | 41 | 2.966 | 36301.8 |
414 | 2022-01-17 03:41:49 | drummer | 3 | 134027 | 315 | 6.750 | 19855.9 |
413 | 2022-01-14 23:20:28 | drummer | 3 | 134027 | 315 | 5.750 | 23309.0 |
412 | 2021-12-16 00:07:52 | drummer | 3 | 134027 | 315 | 5.906 | 22693.4 |
411 | 2021-12-14 02:11:58 | drummer | 1 | 69583 | 5 | 1.420 | 49002.1 |