History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"dickier"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
501 | 2024-04-22 17:59:10 | dickier | 1 | 69583 | 11 | 4.720 | 14742.2 |
500 | 2024-04-18 22:49:35 | dickier | 2 | 107671 | 75 | 3.406 | 31612.2 |
499 | 2024-04-18 08:24:54 | dickier | 1 | 69583 | 11 | 2.670 | 26061.0 |
498 | 2024-04-17 13:12:51 | dickier | 2 | 107671 | 75 | 3.750 | 28712.3 |
497 | 2024-04-17 13:10:21 | dickier | 3 | 134027 | 528 | 7.313 | 18327.2 |
496 | 2024-04-16 10:21:58 | dickier | 3 | 134027 | 528 | 11.253 | 11910.3 |
495 | 2024-04-15 19:14:56 | dickier | 2 | 107671 | 75 | 4.250 | 25334.4 |
494 | 2024-04-15 19:14:14 | dickier | 3 | 134027 | 528 | 8.313 | 16122.6 |
493 | 2024-04-14 12:26:48 | dickier | 3 | 134027 | 528 | 16.330 | 8207.4 |
492 | 2024-04-05 23:27:55 | dickier | 1 | 69583 | 11 | 2.453 | 28366.5 |
491 | 2024-03-28 18:02:11 | dickier | 1 | 69583 | 11 | 4.563 | 15249.4 |
490 | 2024-03-17 20:02:31 | dickier | 3 | 134027 | 528 | 24.143 | 5551.4 |
489 | 2024-03-15 20:28:11 | dickier | 2 | 107671 | 75 | 3.406 | 31612.2 |
488 | 2024-03-15 20:21:13 | dickier | 3 | 134027 | 528 | 6.796 | 19721.5 |
487 | 2024-03-15 16:12:42 | dickier | 3 | 134027 | 528 | 15.563 | 8611.9 |
486 | 2024-03-14 21:14:29 | dickier | 3 | 134027 | 528 | 8.250 | 16245.7 |
485 | 2024-03-01 10:06:33 | dickier | 2 | 107671 | 75 | 8.736 | 12325.0 |
484 | 2024-03-01 00:17:44 | dickier | 2 | 107671 | 75 | 3.216 | 33479.8 |
483 | 2024-01-29 21:50:19 | dickier | 3 | 134027 | 528 | 10.030 | 13362.6 |
482 | 2024-01-24 16:07:23 | dickier | 3 | 134027 | 528 | 5.563 | 24092.6 |
481 | 2024-01-19 20:03:08 | dickier | 3 | 134027 | 528 | 6.513 | 20578.4 |
480 | 2024-01-14 02:06:22 | dickier | 3 | 134027 | 528 | 6.626 | 20227.4 |
479 | 2024-01-14 02:06:24 | dickier | 2 | 107671 | 75 | 3.500 | 30763.1 |
478 | 2023-12-31 03:45:03 | dickier | 3 | 134027 | 528 | 11.956 | 11210.0 |
477 | 2023-12-31 03:45:02 | dickier | 2 | 107671 | 75 | 3.173 | 33933.5 |
476 | 2023-12-27 10:16:52 | dickier | 1 | 69583 | 11 | 1.060 | 65644.3 |
475 | 2023-12-25 15:20:51 | dickier | 1 | 69583 | 11 | 1.173 | 59320.5 |
474 | 2023-11-30 03:10:45 | dickier | 1 | 69583 | 11 | 1.046 | 66522.9 |
473 | 2023-11-26 20:41:10 | dickier | 1 | 69583 | 11 | 1.110 | 62687.4 |
472 | 2023-11-23 19:31:10 | dickier | 2 | 107671 | 75 | 2.733 | 39396.6 |
471 | 2023-11-22 04:39:09 | dickier | 1 | 69583 | 11 | 1.203 | 57841.2 |
470 | 2023-11-17 13:28:38 | dickier | 1 | 69583 | 11 | 1.046 | 66522.9 |
469 | 2023-11-15 11:35:33 | dickier | 1 | 69583 | 11 | 2.173 | 32021.6 |
468 | 2023-11-13 12:09:29 | dickier | 1 | 69583 | 11 | 1.046 | 66522.9 |
467 | 2023-10-31 03:59:46 | dickier | 3 | 134027 | 528 | 6.733 | 19906.0 |
466 | 2023-10-24 02:56:45 | dickier | 1 | 69583 | 11 | 1.156 | 60192.9 |
465 | 2023-10-18 17:15:51 | dickier | 1 | 69583 | 11 | 2.456 | 28331.8 |
464 | 2023-10-13 04:24:41 | dickier | 1 | 69583 | 11 | 2.436 | 28564.4 |
463 | 2023-10-04 21:23:41 | dickier | 3 | 134027 | 528 | 6.373 | 21030.4 |
462 | 2023-10-04 21:23:39 | dickier | 2 | 107671 | 75 | 3.203 | 33615.7 |
461 | 2023-10-03 09:21:22 | dickier | 1 | 69583 | 11 | 1.076 | 64668.2 |
460 | 2023-09-26 21:58:29 | dickier | 1 | 69583 | 11 | 1.186 | 58670.3 |
459 | 2023-08-24 06:34:26 | dickier | 2 | 107671 | 75 | 3.126 | 34443.7 |
458 | 2023-08-09 00:59:09 | dickier | 3 | 134027 | 528 | 5.656 | 23696.4 |
457 | 2023-08-08 11:42:23 | dickier | 1 | 69583 | 11 | 1.110 | 62687.4 |
456 | 2023-08-07 09:49:37 | dickier | 1 | 69583 | 11 | 1.063 | 65459.1 |
455 | 2023-07-19 06:00:14 | dickier | 1 | 69583 | 11 | 1.126 | 61796.6 |
454 | 2023-05-08 08:11:07 | dickier | 2 | 107671 | 75 | 2.720 | 39584.9 |
453 | 2023-05-06 18:52:47 | dickier | 1 | 69583 | 11 | 1.063 | 65459.1 |
452 | 2023-05-03 12:57:55 | dickier | 1 | 69583 | 11 | 1.063 | 65459.1 |
451 | 2023-04-20 01:16:14 | dickier | 3 | 134027 | 528 | 5.500 | 24368.5 |
450 | 2023-03-01 20:51:48 | dickier | 1 | 69583 | 11 | 1.033 | 67360.1 |
449 | 2023-02-15 23:15:08 | dickier | 2 | 107671 | 75 | 2.703 | 39833.9 |
448 | 2023-01-21 07:18:33 | dickier | 1 | 69583 | 11 | 1.046 | 66522.9 |
447 | 2023-01-20 18:22:43 | dickier | 3 | 134027 | 528 | 5.563 | 24092.6 |
446 | 2022-12-25 23:42:46 | dickier | 1 | 69583 | 11 | 1.186 | 58670.3 |
445 | 2022-11-27 02:54:52 | dickier | 2 | 107671 | 75 | 2.703 | 39833.9 |
444 | 2022-10-31 17:11:56 | dickier | 3 | 134027 | 528 | 5.550 | 24149.0 |
443 | 2022-10-07 01:10:35 | dickier | 1 | 69583 | 11 | 1.060 | 65644.3 |
442 | 2022-09-11 06:50:29 | dickier | 1 | 69583 | 11 | 1.080 | 64428.7 |
441 | 2022-09-09 05:49:57 | dickier | 1 | 69583 | 11 | 1.076 | 64668.2 |
440 | 2022-09-03 20:24:47 | dickier | 1 | 69583 | 11 | 1.046 | 66522.9 |
439 | 2022-06-20 06:57:33 | dickier | 1 | 69583 | 11 | 1.046 | 66522.9 |
438 | 2022-05-31 12:49:29 | dickier | 3 | 134027 | 528 | 6.530 | 20524.8 |
437 | 2022-04-18 04:56:06 | dickier | 1 | 69583 | 11 | 1.063 | 65459.1 |
436 | 2022-04-17 16:48:43 | dickier | 2 | 107671 | 75 | 2.736 | 39353.4 |
435 | 2022-04-16 01:23:23 | dickier | 1 | 69583 | 11 | 1.060 | 65644.3 |
434 | 2022-03-01 03:46:48 | dickier | 1 | 69583 | 11 | 1.233 | 56433.9 |
433 | 2022-02-25 17:38:26 | dickier | 1 | 69583 | 11 | 1.216 | 57222.9 |
432 | 2022-01-09 15:57:15 | dickier | 1 | 69583 | 11 | 1.220 | 57035.2 |
431 | 2021-11-17 13:23:24 | dickier | 1 | 69583 | 11 | 1.360 | 51164.0 |
430 | 2021-11-05 18:14:10 | dickier | 1 | 69583 | 11 | 1.233 | 56433.9 |
429 | 2021-09-23 04:11:25 | dickier | 1 | 69583 | 11 | 1.203 | 57841.2 |
428 | 2021-09-21 01:25:49 | dickier | 1 | 69583 | 11 | 1.096 | 63488.1 |
427 | 2021-09-20 23:28:20 | dickier | 1 | 69583 | 11 | 1.263 | 55093.4 |
426 | 2021-09-20 06:22:44 | dickier | 1 | 69583 | 11 | 1.313 | 52995.4 |
425 | 2021-09-19 20:08:33 | dickier | 1 | 69583 | 11 | 1.063 | 65459.1 |
424 | 2021-09-13 13:14:11 | dickier | 1 | 69583 | 11 | 1.156 | 60192.9 |
423 | 2021-09-01 09:51:07 | dickier | 1 | 69583 | 11 | 1.233 | 56433.9 |
422 | 2021-08-18 00:02:37 | dickier | 1 | 69583 | 11 | 1.046 | 66522.9 |
421 | 2021-08-14 16:44:19 | dickier | 1 | 69583 | 11 | 1.173 | 59320.5 |
420 | 2021-05-14 03:59:28 | dickier | 1 | 69583 | 11 | 1.173 | 59320.5 |
419 | 2021-05-14 01:07:34 | dickier | 1 | 69583 | 11 | 1.156 | 60192.9 |
418 | 2021-04-12 13:56:10 | dickier | 3 | 134027 | 528 | 6.513 | 20578.4 |
417 | 2021-02-19 21:06:36 | dickier | 1 | 69583 | 11 | 1.093 | 63662.4 |
416 | 2021-02-19 10:43:15 | dickier | 3 | 134027 | 528 | 6.530 | 20524.8 |
415 | 2021-02-10 13:50:44 | dickier | 1 | 69583 | 11 | 1.060 | 65644.3 |
414 | 2021-02-05 21:03:39 | dickier | 1 | 69583 | 11 | 2.453 | 28366.5 |
413 | 2020-12-01 13:44:19 | dickier | 1 | 69583 | 11 | 1.063 | 65459.1 |
412 | 2020-11-03 19:10:17 | dickier | 1 | 69583 | 11 | 1.110 | 62687.4 |
411 | 2020-10-25 00:14:49 | dickier | 1 | 69583 | 11 | 1.046 | 66522.9 |
410 | 2020-10-24 13:01:14 | dickier | 1 | 69583 | 11 | 1.080 | 64428.7 |
409 | 2020-10-21 04:55:15 | dickier | 2 | 107671 | 75 | 2.843 | 37872.3 |
408 | 2020-09-05 23:01:16 | dickier | 1 | 69583 | 11 | 1.030 | 67556.3 |
407 | 2020-08-29 15:36:10 | dickier | 1 | 69583 | 11 | 1.203 | 57841.2 |
406 | 2020-08-02 23:22:12 | dickier | 1 | 69583 | 11 | 1.063 | 65459.1 |
405 | 2020-08-02 10:11:48 | dickier | 1 | 69583 | 11 | 1.110 | 62687.4 |
404 | 2020-07-31 10:37:29 | dickier | 1 | 69583 | 11 | 1.126 | 61796.6 |
403 | 2020-07-30 15:43:55 | dickier | 1 | 69583 | 11 | 1.250 | 55666.4 |
402 | 2020-07-29 16:13:29 | dickier | 1 | 69583 | 11 | 1.250 | 55666.4 |