History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"unsex"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1029 | 2024-04-23 13:13:43 | unsex | 3 | 83667 | 666 | 8.283 | 10101.1 |
| 1028 | 2024-04-22 21:03:02 | unsex | 3 | 83667 | 666 | 3.500 | 23904.9 |
| 1027 | 2024-04-22 06:22:11 | unsex | 3 | 83667 | 666 | 13.123 | 6375.6 |
| 1026 | 2024-04-21 23:08:48 | unsex | 3 | 83667 | 666 | 6.483 | 12905.6 |
| 1025 | 2024-04-03 08:16:22 | unsex | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1024 | 2024-03-31 15:01:58 | unsex | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 1023 | 2024-03-29 03:45:40 | unsex | 1 | 28756 | 5 | 0.563 | 51076.4 |
| 1022 | 2024-03-04 03:02:28 | unsex | 2 | 53800 | 52 | 1.420 | 37887.3 |
| 1021 | 2024-03-04 03:02:23 | unsex | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 1020 | 2024-03-03 12:31:48 | unsex | 3 | 83667 | 666 | 8.966 | 9331.6 |
| 1019 | 2024-03-01 12:51:01 | unsex | 1 | 28756 | 5 | 0.423 | 67981.1 |
| 1018 | 2024-02-28 02:13:28 | unsex | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1017 | 2024-02-05 22:47:10 | unsex | 3 | 83667 | 666 | 3.906 | 21420.1 |
| 1016 | 2024-02-05 00:59:54 | unsex | 2 | 53800 | 52 | 1.623 | 33148.5 |
| 1015 | 2024-02-05 00:59:26 | unsex | 3 | 83667 | 666 | 8.173 | 10237.0 |
| 1014 | 2024-02-04 23:56:23 | unsex | 3 | 83667 | 666 | 4.250 | 19686.4 |
| 1013 | 2024-02-03 02:57:55 | unsex | 1 | 28756 | 5 | 1.000 | 28756.0 |
| 1012 | 2024-01-28 23:12:11 | unsex | 1 | 28756 | 5 | 0.513 | 56054.6 |
| 1011 | 2024-01-28 22:40:57 | unsex | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1010 | 2024-01-23 11:01:35 | unsex | 3 | 83667 | 666 | 7.110 | 11767.5 |
| 1009 | 2024-01-21 21:20:22 | unsex | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1008 | 2024-01-21 18:05:22 | unsex | 3 | 83667 | 666 | 4.266 | 19612.5 |
| 1007 | 2024-01-20 13:51:47 | unsex | 3 | 83667 | 666 | 3.906 | 21420.1 |
| 1006 | 2024-01-19 20:40:39 | unsex | 3 | 83667 | 666 | 3.593 | 23286.1 |
| 1005 | 2024-01-18 14:13:47 | unsex | 3 | 83667 | 666 | 3.673 | 22778.9 |
| 1004 | 2024-01-17 19:03:44 | unsex | 3 | 83667 | 666 | 3.783 | 22116.6 |
| 1003 | 2024-01-09 01:35:44 | unsex | 3 | 83667 | 666 | 3.643 | 22966.5 |
| 1002 | 2024-01-09 01:35:43 | unsex | 2 | 53800 | 52 | 1.626 | 33087.3 |
| 1001 | 2024-01-05 05:29:26 | unsex | 2 | 53800 | 52 | 1.690 | 31834.3 |
| 1000 | 2024-01-05 05:29:23 | unsex | 3 | 83667 | 666 | 4.123 | 20292.7 |
| 999 | 2024-01-01 19:45:10 | unsex | 2 | 53800 | 52 | 1.343 | 40059.6 |
| 998 | 2023-12-04 17:01:28 | unsex | 1 | 28756 | 5 | 0.420 | 68466.7 |
| 997 | 2023-12-04 17:01:27 | unsex | 1 | 28756 | 5 | 0.423 | 67981.1 |
| 996 | 2023-11-23 03:41:51 | unsex | 3 | 83667 | 666 | 3.233 | 25879.1 |
| 995 | 2023-11-18 06:06:02 | unsex | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 994 | 2023-11-16 09:10:32 | unsex | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 993 | 2023-11-15 09:00:36 | unsex | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 992 | 2023-11-15 04:00:45 | unsex | 1 | 28756 | 5 | 0.423 | 67981.1 |
| 991 | 2023-11-05 20:15:25 | unsex | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 990 | 2023-10-22 19:53:48 | unsex | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 989 | 2023-10-19 02:51:39 | unsex | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 988 | 2023-10-13 19:56:02 | unsex | 1 | 28756 | 5 | 0.486 | 59168.7 |
| 987 | 2023-10-07 07:59:34 | unsex | 2 | 53800 | 52 | 1.563 | 34421.0 |
| 986 | 2023-10-04 08:46:51 | unsex | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 985 | 2023-10-01 03:10:11 | unsex | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 984 | 2023-09-30 20:09:02 | unsex | 3 | 83667 | 666 | 3.283 | 25484.9 |
| 983 | 2023-09-29 00:45:06 | unsex | 3 | 83667 | 666 | 3.450 | 24251.3 |
| 982 | 2023-09-27 03:22:49 | unsex | 3 | 83667 | 666 | 7.483 | 11180.9 |
| 981 | 2023-09-25 04:22:05 | unsex | 3 | 83667 | 666 | 4.890 | 17109.8 |
| 980 | 2023-09-23 13:04:42 | unsex | 3 | 83667 | 666 | 3.610 | 23176.5 |
| 979 | 2023-09-15 11:22:05 | unsex | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 978 | 2023-09-11 01:10:04 | unsex | 3 | 83667 | 666 | 4.763 | 17566.0 |
| 977 | 2023-09-07 22:36:04 | unsex | 3 | 83667 | 666 | 4.016 | 20833.4 |
| 976 | 2023-09-05 21:34:53 | unsex | 1 | 28756 | 5 | 0.423 | 67981.1 |
| 975 | 2023-08-23 18:43:52 | unsex | 3 | 83667 | 666 | 3.626 | 23074.2 |
| 974 | 2023-07-18 00:51:57 | unsex | 2 | 53800 | 52 | 1.546 | 34799.5 |
| 973 | 2023-07-07 05:26:36 | unsex | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 972 | 2023-06-10 01:58:16 | unsex | 1 | 28756 | 5 | 0.420 | 68466.7 |
| 971 | 2023-05-23 16:43:43 | unsex | 3 | 83667 | 666 | 3.343 | 25027.5 |
| 970 | 2023-05-10 05:13:18 | unsex | 3 | 83667 | 666 | 3.280 | 25508.2 |
| 969 | 2023-05-04 20:16:18 | unsex | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 968 | 2023-04-09 10:26:03 | unsex | 3 | 83667 | 666 | 3.656 | 22884.8 |
| 967 | 2023-04-01 12:39:25 | unsex | 2 | 53800 | 52 | 1.360 | 39558.8 |
| 966 | 2023-03-29 14:25:13 | unsex | 1 | 28756 | 5 | 0.423 | 67981.1 |
| 965 | 2023-03-18 19:09:01 | unsex | 1 | 28756 | 5 | 0.423 | 67981.1 |
| 964 | 2023-03-02 22:42:24 | unsex | 1 | 28756 | 5 | 0.423 | 67981.1 |
| 963 | 2023-02-28 05:16:58 | unsex | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 962 | 2023-02-15 10:15:16 | unsex | 3 | 83667 | 666 | 3.403 | 24586.2 |
| 961 | 2023-01-10 13:47:48 | unsex | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 960 | 2022-12-28 18:23:37 | unsex | 2 | 53800 | 52 | 1.313 | 40974.9 |
| 959 | 2022-11-27 18:39:41 | unsex | 3 | 83667 | 666 | 3.250 | 25743.7 |
| 958 | 2022-10-24 16:10:12 | unsex | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 957 | 2022-10-21 01:57:14 | unsex | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 956 | 2022-10-19 20:45:29 | unsex | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 955 | 2022-09-18 02:16:11 | unsex | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 954 | 2022-08-29 23:26:45 | unsex | 2 | 53800 | 52 | 1.346 | 39970.3 |
| 953 | 2022-08-23 07:51:07 | unsex | 1 | 28756 | 5 | 0.670 | 42919.4 |
| 952 | 2022-06-25 16:01:58 | unsex | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 951 | 2022-06-19 15:53:00 | unsex | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 950 | 2022-06-10 04:48:24 | unsex | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 949 | 2022-06-07 23:52:13 | unsex | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 948 | 2022-06-03 14:56:20 | unsex | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 947 | 2022-04-18 16:54:04 | unsex | 3 | 83667 | 666 | 6.626 | 12627.1 |
| 946 | 2022-02-15 14:57:12 | unsex | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 945 | 2022-02-11 08:39:54 | unsex | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 944 | 2022-02-07 21:10:44 | unsex | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 943 | 2021-12-23 21:08:06 | unsex | 1 | 28756 | 5 | 0.530 | 54256.6 |
| 942 | 2021-10-14 22:22:54 | unsex | 1 | 28756 | 5 | 0.466 | 61708.2 |
| 941 | 2021-09-14 20:40:36 | unsex | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 940 | 2021-07-10 04:22:20 | unsex | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 939 | 2021-06-11 21:53:29 | unsex | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 938 | 2021-05-15 00:54:51 | unsex | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 937 | 2021-05-09 21:05:13 | unsex | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 936 | 2021-04-06 08:23:06 | unsex | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 935 | 2021-04-02 04:44:01 | unsex | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 934 | 2021-02-20 17:51:04 | unsex | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 933 | 2021-02-18 15:23:58 | unsex | 3 | 83667 | 666 | 3.530 | 23701.7 |
| 932 | 2021-02-03 19:06:21 | unsex | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 931 | 2020-12-29 20:45:13 | unsex | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 930 | 2020-12-21 05:02:40 | unsex | 1 | 28756 | 5 | 0.483 | 59536.2 |