History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"scarves"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
511 | 2024-04-21 16:14:10 | scarves | 1 | 69583 | 4 | 1.373 | 50679.5 |
510 | 2024-04-13 15:57:51 | scarves | 3 | 134027 | 738 | 13.063 | 10260.0 |
509 | 2024-04-13 15:40:16 | scarves | 3 | 134027 | 738 | 7.500 | 17870.3 |
508 | 2024-04-08 05:57:54 | scarves | 1 | 69583 | 4 | 1.236 | 56296.9 |
507 | 2024-03-08 23:52:11 | scarves | 3 | 134027 | 738 | 22.813 | 5875.0 |
506 | 2024-03-08 06:49:29 | scarves | 3 | 134027 | 738 | 17.030 | 7870.1 |
505 | 2024-03-08 00:15:01 | scarves | 1 | 69583 | 4 | 1.236 | 56296.9 |
504 | 2024-03-07 23:37:24 | scarves | 3 | 134027 | 738 | 7.440 | 18014.4 |
503 | 2024-03-07 04:12:55 | scarves | 3 | 134027 | 738 | 14.033 | 9550.8 |
502 | 2024-03-07 04:12:55 | scarves | 2 | 107671 | 81 | 10.580 | 10176.8 |
501 | 2024-03-06 21:13:57 | scarves | 1 | 69583 | 4 | 1.203 | 57841.2 |
500 | 2024-03-03 23:59:51 | scarves | 1 | 69583 | 4 | 1.970 | 35321.3 |
499 | 2024-01-19 03:29:15 | scarves | 3 | 134027 | 738 | 6.236 | 21492.5 |
498 | 2024-01-19 03:29:17 | scarves | 2 | 107671 | 81 | 3.406 | 31612.2 |
497 | 2024-01-14 06:52:52 | scarves | 1 | 69583 | 4 | 1.096 | 63488.1 |
496 | 2023-12-27 18:59:48 | scarves | 1 | 69583 | 4 | 1.123 | 61961.7 |
495 | 2023-12-12 15:54:13 | scarves | 3 | 134027 | 738 | 6.750 | 19855.9 |
494 | 2023-12-08 17:30:25 | scarves | 3 | 134027 | 738 | 6.296 | 21287.6 |
493 | 2023-12-08 17:30:26 | scarves | 2 | 107671 | 81 | 3.376 | 31893.1 |
492 | 2023-11-24 18:56:19 | scarves | 1 | 69583 | 4 | 1.200 | 57985.8 |
491 | 2023-11-18 03:59:49 | scarves | 1 | 69583 | 4 | 1.233 | 56433.9 |
490 | 2023-11-11 06:13:51 | scarves | 1 | 69583 | 4 | 1.233 | 56433.9 |
489 | 2023-11-09 06:15:36 | scarves | 1 | 69583 | 4 | 1.060 | 65644.3 |
488 | 2023-10-26 05:26:20 | scarves | 1 | 69583 | 4 | 2.390 | 29114.2 |
487 | 2023-10-25 02:51:57 | scarves | 1 | 69583 | 4 | 1.093 | 63662.4 |
486 | 2023-10-15 14:55:06 | scarves | 1 | 69583 | 4 | 1.220 | 57035.2 |
485 | 2023-10-15 14:41:34 | scarves | 1 | 69583 | 4 | 1.190 | 58473.1 |
484 | 2023-10-06 03:06:37 | scarves | 3 | 134027 | 738 | 7.186 | 18651.1 |
483 | 2023-10-01 18:44:19 | scarves | 3 | 134027 | 738 | 7.046 | 19021.7 |
482 | 2023-09-28 07:41:25 | scarves | 1 | 69583 | 4 | 1.233 | 56433.9 |
481 | 2023-09-27 08:07:25 | scarves | 3 | 134027 | 738 | 6.736 | 19897.1 |
480 | 2023-09-23 08:14:09 | scarves | 1 | 69583 | 4 | 1.203 | 57841.2 |
479 | 2023-09-11 03:09:19 | scarves | 3 | 134027 | 738 | 6.470 | 20715.1 |
478 | 2023-08-23 16:43:34 | scarves | 3 | 134027 | 738 | 5.953 | 22514.2 |
477 | 2023-08-12 10:22:41 | scarves | 1 | 69583 | 4 | 1.080 | 64428.7 |
476 | 2023-07-11 01:48:41 | scarves | 3 | 134027 | 738 | 6.250 | 21444.3 |
475 | 2023-07-02 01:37:05 | scarves | 1 | 69583 | 4 | 1.126 | 61796.6 |
474 | 2023-06-04 14:09:38 | scarves | 3 | 134027 | 738 | 5.763 | 23256.5 |
473 | 2023-06-03 19:56:39 | scarves | 1 | 69583 | 4 | 1.060 | 65644.3 |
472 | 2023-05-11 12:18:11 | scarves | 1 | 69583 | 4 | 2.310 | 30122.5 |
471 | 2023-03-15 16:29:47 | scarves | 1 | 69583 | 4 | 1.263 | 55093.4 |
470 | 2023-03-12 20:05:13 | scarves | 3 | 134027 | 738 | 5.940 | 22563.5 |
469 | 2023-03-05 18:32:15 | scarves | 1 | 69583 | 4 | 1.076 | 64668.2 |
468 | 2022-12-27 22:42:58 | scarves | 1 | 69583 | 4 | 1.076 | 64668.2 |
467 | 2022-12-17 08:45:23 | scarves | 3 | 134027 | 738 | 6.516 | 20568.9 |
466 | 2022-11-20 20:18:49 | scarves | 1 | 69583 | 4 | 1.230 | 56571.5 |
465 | 2022-09-16 02:20:50 | scarves | 1 | 69583 | 4 | 1.093 | 63662.4 |
464 | 2022-09-10 22:18:07 | scarves | 1 | 69583 | 4 | 1.063 | 65459.1 |
463 | 2022-09-01 18:38:49 | scarves | 1 | 69583 | 4 | 1.186 | 58670.3 |
462 | 2022-08-11 01:24:42 | scarves | 3 | 134027 | 738 | 5.970 | 22450.1 |
461 | 2022-07-29 04:23:25 | scarves | 1 | 69583 | 4 | 1.076 | 64668.2 |
460 | 2022-07-24 10:45:38 | scarves | 1 | 69583 | 4 | 1.123 | 61961.7 |
459 | 2022-07-18 01:29:42 | scarves | 1 | 69583 | 4 | 1.060 | 65644.3 |
458 | 2022-07-13 19:31:39 | scarves | 1 | 69583 | 4 | 1.080 | 64428.7 |
457 | 2022-07-03 16:32:40 | scarves | 1 | 69583 | 4 | 1.110 | 62687.4 |
456 | 2022-07-03 06:04:37 | scarves | 1 | 69583 | 4 | 1.063 | 65459.1 |
455 | 2022-06-09 02:12:01 | scarves | 1 | 69583 | 4 | 1.096 | 63488.1 |
454 | 2022-03-16 07:24:13 | scarves | 1 | 69583 | 4 | 1.190 | 58473.1 |
453 | 2022-03-12 20:42:04 | scarves | 1 | 69583 | 4 | 1.186 | 58670.3 |
452 | 2022-03-11 21:26:04 | scarves | 1 | 69583 | 4 | 1.140 | 61037.7 |
451 | 2021-12-20 00:20:41 | scarves | 1 | 69583 | 4 | 1.143 | 60877.5 |
450 | 2021-11-25 20:05:05 | scarves | 1 | 69583 | 4 | 1.313 | 52995.4 |
449 | 2021-10-29 02:54:04 | scarves | 1 | 69583 | 4 | 1.203 | 57841.2 |
448 | 2021-10-02 07:57:33 | scarves | 1 | 69583 | 4 | 1.080 | 64428.7 |
447 | 2021-09-30 04:48:59 | scarves | 1 | 69583 | 4 | 1.203 | 57841.2 |
446 | 2021-08-12 21:15:50 | scarves | 1 | 69583 | 4 | 1.250 | 55666.4 |
445 | 2021-05-14 18:57:58 | scarves | 2 | 107671 | 81 | 3.080 | 34958.1 |
444 | 2021-05-12 04:09:13 | scarves | 1 | 69583 | 4 | 1.263 | 55093.4 |
443 | 2021-05-05 12:25:14 | scarves | 1 | 69583 | 4 | 1.096 | 63488.1 |
442 | 2021-04-03 16:18:43 | scarves | 1 | 69583 | 4 | 1.186 | 58670.3 |
441 | 2021-03-17 14:17:48 | scarves | 2 | 107671 | 81 | 3.233 | 33303.7 |
440 | 2021-02-20 12:24:13 | scarves | 2 | 107671 | 81 | 3.046 | 35348.3 |
439 | 2021-02-12 11:41:14 | scarves | 1 | 69583 | 4 | 1.110 | 62687.4 |
438 | 2021-02-12 01:24:35 | scarves | 1 | 69583 | 4 | 1.173 | 59320.5 |
437 | 2021-02-07 20:37:27 | scarves | 1 | 69583 | 4 | 1.236 | 56296.9 |
436 | 2021-02-02 21:25:18 | scarves | 1 | 69583 | 4 | 1.096 | 63488.1 |
435 | 2020-12-29 18:23:31 | scarves | 2 | 107671 | 81 | 3.016 | 35699.9 |
434 | 2020-11-10 05:44:05 | scarves | 2 | 107671 | 81 | 3.186 | 33795.0 |
433 | 2020-11-02 05:04:40 | scarves | 1 | 69583 | 4 | 1.170 | 59472.6 |
432 | 2020-11-01 00:30:42 | scarves | 1 | 69583 | 4 | 1.596 | 43598.4 |
431 | 2020-10-29 07:11:28 | scarves | 1 | 69583 | 4 | 2.530 | 27503.2 |
430 | 2020-10-28 02:38:14 | scarves | 1 | 69583 | 4 | 1.123 | 61961.7 |
429 | 2020-08-01 22:10:57 | scarves | 1 | 69583 | 4 | 1.156 | 60192.9 |
428 | 2020-04-30 10:57:06 | scarves | 1 | 69583 | 4 | 1.186 | 58670.3 |
427 | 2020-03-25 01:54:30 | scarves | 1 | 69583 | 4 | 1.310 | 53116.8 |
426 | 2020-03-20 17:11:40 | scarves | 1 | 69583 | 4 | 1.063 | 65459.1 |
425 | 2020-02-28 05:45:24 | scarves | 1 | 69583 | 4 | 1.453 | 47889.2 |
424 | 2020-02-27 12:44:35 | scarves | 1 | 69583 | 4 | 2.763 | 25183.9 |
423 | 2020-02-14 17:02:18 | scarves | 1 | 69583 | 4 | 2.716 | 25619.7 |
422 | 2020-02-09 14:26:30 | scarves | 1 | 69583 | 4 | 2.080 | 33453.4 |
421 | 2020-02-07 23:42:38 | scarves | 1 | 69583 | 4 | 1.203 | 57841.2 |
420 | 2020-02-07 17:28:40 | scarves | 1 | 69583 | 4 | 1.560 | 44604.5 |
419 | 2020-02-03 18:49:45 | scarves | 1 | 69583 | 4 | 1.453 | 47889.2 |
418 | 2020-02-01 12:17:20 | scarves | 1 | 69583 | 4 | 2.956 | 23539.6 |
417 | 2020-01-30 20:40:55 | scarves | 1 | 69583 | 4 | 1.326 | 52475.9 |
416 | 2020-01-29 11:43:16 | scarves | 1 | 69583 | 4 | 2.466 | 28217.0 |
415 | 2020-01-23 11:15:44 | scarves | 1 | 69583 | 4 | 1.686 | 41271.1 |
414 | 2020-01-17 09:27:37 | scarves | 1 | 69583 | 4 | 2.593 | 26834.9 |
413 | 2020-01-16 07:38:48 | scarves | 1 | 69583 | 4 | 1.220 | 57035.2 |
412 | 2020-01-13 13:53:39 | scarves | 2 | 107671 | 81 | 3.330 | 32333.6 |