History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shortia"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
508 | 2024-04-27 17:31:35 | shortia | 1 | 69583 | 3 | 1.280 | 54361.7 |
507 | 2024-04-22 05:23:35 | shortia | 1 | 69583 | 3 | 1.203 | 57841.2 |
506 | 2024-04-11 05:42:12 | shortia | 2 | 107671 | 20 | 3.500 | 30763.1 |
505 | 2024-04-09 19:03:24 | shortia | 2 | 107671 | 20 | 8.093 | 13304.2 |
504 | 2024-04-09 19:03:12 | shortia | 3 | 134027 | 171 | 8.470 | 15823.7 |
503 | 2024-04-06 17:57:03 | shortia | 3 | 134027 | 171 | 17.016 | 7876.5 |
502 | 2024-04-04 07:25:00 | shortia | 3 | 134027 | 171 | 9.436 | 14203.8 |
501 | 2024-04-04 06:51:55 | shortia | 3 | 134027 | 171 | 21.233 | 6312.2 |
500 | 2024-04-04 06:51:56 | shortia | 2 | 107671 | 20 | 4.016 | 26810.5 |
499 | 2024-04-04 06:51:49 | shortia | 1 | 69583 | 3 | 2.953 | 23563.5 |
498 | 2024-03-30 09:13:54 | shortia | 2 | 107671 | 20 | 10.610 | 10148.1 |
497 | 2024-03-30 09:13:51 | shortia | 1 | 69583 | 3 | 2.983 | 23326.5 |
496 | 2024-03-28 23:47:40 | shortia | 1 | 69583 | 3 | 3.140 | 22160.2 |
495 | 2024-03-18 13:55:25 | shortia | 2 | 107671 | 20 | 7.406 | 14538.3 |
494 | 2024-03-06 13:14:06 | shortia | 3 | 134027 | 171 | 16.656 | 8046.8 |
493 | 2024-03-05 15:19:36 | shortia | 2 | 107671 | 20 | 3.250 | 33129.5 |
492 | 2024-03-05 15:19:23 | shortia | 3 | 134027 | 171 | 6.263 | 21399.8 |
491 | 2024-03-04 21:55:25 | shortia | 3 | 134027 | 171 | 15.270 | 8777.1 |
490 | 2024-03-04 08:51:22 | shortia | 3 | 134027 | 171 | 19.250 | 6962.4 |
489 | 2024-03-02 14:37:54 | shortia | 3 | 134027 | 171 | 21.390 | 6265.9 |
488 | 2024-03-02 14:37:53 | shortia | 2 | 107671 | 20 | 8.670 | 12418.8 |
487 | 2024-03-02 14:37:40 | shortia | 1 | 69583 | 3 | 2.783 | 25002.9 |
486 | 2024-02-04 19:40:07 | shortia | 3 | 134027 | 171 | 7.656 | 17506.1 |
485 | 2024-02-02 22:10:07 | shortia | 2 | 107671 | 20 | 3.406 | 31612.2 |
484 | 2024-01-31 16:39:12 | shortia | 2 | 107671 | 20 | 3.190 | 33752.7 |
483 | 2024-01-31 16:37:52 | shortia | 3 | 134027 | 171 | 6.343 | 21129.9 |
482 | 2024-01-30 05:19:24 | shortia | 3 | 134027 | 171 | 5.970 | 22450.1 |
481 | 2024-01-12 02:26:52 | shortia | 1 | 69583 | 3 | 1.106 | 62914.1 |
480 | 2023-12-26 00:09:28 | shortia | 1 | 69583 | 3 | 1.220 | 57035.2 |
479 | 2023-12-13 20:00:19 | shortia | 1 | 69583 | 3 | 1.343 | 51811.6 |
478 | 2023-12-09 15:21:12 | shortia | 1 | 69583 | 3 | 1.250 | 55666.4 |
477 | 2023-12-08 14:16:03 | shortia | 1 | 69583 | 3 | 1.093 | 63662.4 |
476 | 2023-12-08 14:16:02 | shortia | 1 | 69583 | 3 | 1.190 | 58473.1 |
475 | 2023-11-29 23:54:48 | shortia | 2 | 107671 | 20 | 3.356 | 32083.1 |
474 | 2023-11-27 11:07:03 | shortia | 2 | 107671 | 20 | 2.936 | 36672.7 |
473 | 2023-11-24 20:10:40 | shortia | 3 | 134027 | 171 | 7.080 | 18930.4 |
472 | 2023-11-23 16:51:07 | shortia | 3 | 134027 | 171 | 15.986 | 8384.0 |
471 | 2023-11-17 19:30:20 | shortia | 3 | 134027 | 171 | 9.250 | 14489.4 |
470 | 2023-11-13 14:39:36 | shortia | 3 | 134027 | 171 | 5.673 | 23625.4 |
469 | 2023-11-10 00:50:11 | shortia | 1 | 69583 | 3 | 1.140 | 61037.7 |
468 | 2023-11-07 21:10:30 | shortia | 3 | 134027 | 171 | 6.436 | 20824.6 |
467 | 2023-11-04 12:44:55 | shortia | 1 | 69583 | 3 | 1.076 | 64668.2 |
466 | 2023-10-13 13:38:19 | shortia | 1 | 69583 | 3 | 1.093 | 63662.4 |
465 | 2023-09-26 17:19:57 | shortia | 3 | 134027 | 171 | 7.423 | 18055.6 |
464 | 2023-09-26 07:31:08 | shortia | 1 | 69583 | 3 | 1.110 | 62687.4 |
463 | 2023-09-18 17:30:44 | shortia | 3 | 134027 | 171 | 6.673 | 20085.0 |
462 | 2023-09-14 03:17:48 | shortia | 1 | 69583 | 3 | 1.060 | 65644.3 |
461 | 2023-09-03 22:44:09 | shortia | 3 | 134027 | 171 | 5.656 | 23696.4 |
460 | 2023-08-29 05:35:19 | shortia | 2 | 107671 | 20 | 2.953 | 36461.6 |
459 | 2023-08-28 06:14:33 | shortia | 1 | 69583 | 3 | 1.093 | 63662.4 |
458 | 2023-08-24 20:06:24 | shortia | 3 | 134027 | 171 | 5.686 | 23571.4 |
457 | 2023-08-23 19:47:48 | shortia | 3 | 134027 | 171 | 6.690 | 20033.9 |
456 | 2023-08-22 08:47:29 | shortia | 3 | 134027 | 171 | 5.720 | 23431.3 |
455 | 2023-08-21 20:38:19 | shortia | 3 | 134027 | 171 | 5.890 | 22755.0 |
454 | 2023-08-16 19:47:05 | shortia | 1 | 69583 | 3 | 1.186 | 58670.3 |
453 | 2023-08-11 22:43:14 | shortia | 3 | 134027 | 171 | 5.860 | 22871.5 |
452 | 2023-07-09 17:41:38 | shortia | 3 | 134027 | 171 | 5.766 | 23244.4 |
451 | 2023-07-08 14:44:56 | shortia | 3 | 134027 | 171 | 5.970 | 22450.1 |
450 | 2023-07-07 18:47:12 | shortia | 3 | 134027 | 171 | 6.593 | 20328.7 |
449 | 2023-07-06 12:52:02 | shortia | 3 | 134027 | 171 | 5.810 | 23068.3 |
448 | 2023-06-23 03:05:34 | shortia | 3 | 134027 | 171 | 7.030 | 19065.0 |
447 | 2023-05-29 10:52:33 | shortia | 1 | 69583 | 3 | 1.046 | 66522.9 |
446 | 2023-05-15 17:55:08 | shortia | 2 | 107671 | 20 | 3.156 | 34116.3 |
445 | 2023-04-21 15:32:17 | shortia | 3 | 134027 | 171 | 6.546 | 20474.6 |
444 | 2023-04-21 09:37:31 | shortia | 1 | 69583 | 3 | 1.093 | 63662.4 |
443 | 2023-03-21 23:27:27 | shortia | 1 | 69583 | 3 | 1.076 | 64668.2 |
442 | 2023-02-23 22:38:05 | shortia | 2 | 107671 | 20 | 3.140 | 34290.1 |
441 | 2023-01-28 19:50:09 | shortia | 3 | 134027 | 171 | 5.623 | 23835.5 |
440 | 2023-01-24 10:15:19 | shortia | 3 | 134027 | 171 | 5.623 | 23835.5 |
439 | 2023-01-07 12:57:59 | shortia | 1 | 69583 | 3 | 1.076 | 64668.2 |
438 | 2022-12-17 23:03:15 | shortia | 1 | 69583 | 3 | 1.060 | 65644.3 |
437 | 2022-12-13 13:39:48 | shortia | 3 | 134027 | 171 | 7.143 | 18763.4 |
436 | 2022-12-05 10:06:41 | shortia | 2 | 107671 | 20 | 6.703 | 16063.1 |
435 | 2022-11-06 08:53:29 | shortia | 3 | 134027 | 171 | 5.656 | 23696.4 |
434 | 2022-09-29 16:29:54 | shortia | 1 | 69583 | 3 | 1.093 | 63662.4 |
433 | 2022-08-11 08:36:44 | shortia | 1 | 69583 | 3 | 2.420 | 28753.3 |
432 | 2022-07-19 11:04:44 | shortia | 2 | 107671 | 20 | 2.936 | 36672.7 |
431 | 2022-07-17 04:03:12 | shortia | 2 | 107671 | 20 | 2.800 | 38453.9 |
430 | 2022-05-19 03:18:33 | shortia | 3 | 134027 | 171 | 5.766 | 23244.4 |
429 | 2022-05-12 10:52:42 | shortia | 1 | 69583 | 3 | 1.670 | 41666.5 |
428 | 2022-05-09 11:59:47 | shortia | 3 | 134027 | 171 | 7.250 | 18486.5 |
427 | 2022-05-07 07:46:33 | shortia | 3 | 134027 | 171 | 5.750 | 23309.0 |
426 | 2022-04-27 20:23:27 | shortia | 3 | 134027 | 171 | 6.436 | 20824.6 |
425 | 2022-04-26 17:16:32 | shortia | 3 | 134027 | 171 | 6.203 | 21606.8 |
424 | 2022-04-25 19:17:27 | shortia | 3 | 134027 | 171 | 6.143 | 21817.8 |
423 | 2022-04-23 19:21:14 | shortia | 3 | 134027 | 171 | 11.483 | 11671.8 |
422 | 2022-04-22 20:22:33 | shortia | 3 | 134027 | 171 | 5.733 | 23378.2 |
421 | 2022-04-21 20:10:14 | shortia | 3 | 134027 | 171 | 6.813 | 19672.2 |
420 | 2022-04-20 19:47:36 | shortia | 3 | 134027 | 171 | 5.890 | 22755.0 |
419 | 2022-04-19 19:58:05 | shortia | 3 | 134027 | 171 | 6.720 | 19944.5 |
418 | 2022-04-16 21:26:53 | shortia | 3 | 134027 | 171 | 5.906 | 22693.4 |
417 | 2022-04-10 06:42:21 | shortia | 1 | 69583 | 3 | 1.206 | 57697.3 |
416 | 2022-03-08 06:20:22 | shortia | 2 | 107671 | 20 | 3.110 | 34620.9 |
415 | 2022-03-01 17:09:57 | shortia | 3 | 134027 | 171 | 6.876 | 19492.0 |
414 | 2022-02-28 19:21:30 | shortia | 3 | 134027 | 171 | 6.563 | 20421.6 |
413 | 2022-02-27 15:36:57 | shortia | 3 | 134027 | 171 | 6.110 | 21935.7 |
412 | 2022-02-26 23:03:30 | shortia | 3 | 134027 | 171 | 6.580 | 20368.8 |
411 | 2022-02-25 13:07:12 | shortia | 3 | 134027 | 171 | 8.123 | 16499.7 |
410 | 2022-02-06 22:15:42 | shortia | 1 | 69583 | 3 | 1.200 | 57985.8 |
409 | 2022-01-09 13:17:21 | shortia | 3 | 134027 | 171 | 5.846 | 22926.3 |