History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"cedar"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1094 | 2024-04-20 11:55:37 | cedar | 3 | 83667 | 1017 | 14.296 | 5852.5 |
| 1093 | 2024-04-15 02:41:40 | cedar | 1 | 28756 | 5 | 1.910 | 15055.5 |
| 1092 | 2024-04-06 07:45:52 | cedar | 2 | 53800 | 65 | 1.843 | 29191.5 |
| 1091 | 2024-04-06 07:45:50 | cedar | 1 | 28756 | 5 | 0.690 | 41675.4 |
| 1090 | 2024-04-05 04:41:21 | cedar | 3 | 83667 | 1017 | 14.780 | 5660.8 |
| 1089 | 2024-03-31 16:15:05 | cedar | 1 | 28756 | 5 | 0.563 | 51076.4 |
| 1088 | 2024-03-29 02:25:03 | cedar | 2 | 53800 | 65 | 1.983 | 27130.6 |
| 1087 | 2024-03-29 02:25:01 | cedar | 1 | 28756 | 5 | 0.546 | 52666.7 |
| 1086 | 2024-03-29 02:24:38 | cedar | 3 | 83667 | 1017 | 3.936 | 21256.9 |
| 1085 | 2024-03-29 01:22:57 | cedar | 3 | 83667 | 1017 | 11.423 | 7324.4 |
| 1084 | 2024-03-29 01:22:58 | cedar | 2 | 53800 | 65 | 3.953 | 13609.9 |
| 1083 | 2024-03-29 01:12:58 | cedar | 1 | 28756 | 5 | 1.093 | 26309.2 |
| 1082 | 2024-03-07 05:26:57 | cedar | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1081 | 2024-03-01 12:42:50 | cedar | 1 | 28756 | 5 | 1.140 | 25224.6 |
| 1080 | 2024-02-27 19:40:39 | cedar | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1079 | 2024-02-03 21:24:03 | cedar | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 1078 | 2024-01-29 07:38:43 | cedar | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 1077 | 2024-01-28 19:01:45 | cedar | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 1076 | 2024-01-28 01:54:39 | cedar | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1075 | 2024-01-25 16:21:21 | cedar | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1074 | 2024-01-13 01:25:11 | cedar | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1073 | 2023-12-27 06:20:57 | cedar | 3 | 83667 | 1017 | 3.610 | 23176.5 |
| 1072 | 2023-12-18 08:48:17 | cedar | 3 | 83667 | 1017 | 3.486 | 24000.9 |
| 1071 | 2023-12-18 08:48:13 | cedar | 2 | 53800 | 65 | 1.390 | 38705.0 |
| 1070 | 2023-12-07 23:09:41 | cedar | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 1069 | 2023-12-07 23:09:40 | cedar | 1 | 28756 | 5 | 0.533 | 53951.2 |
| 1068 | 2023-11-27 19:06:53 | cedar | 3 | 83667 | 1017 | 3.486 | 24000.9 |
| 1067 | 2023-11-27 19:06:47 | cedar | 2 | 53800 | 65 | 1.390 | 38705.0 |
| 1066 | 2023-11-22 08:15:15 | cedar | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1065 | 2023-11-11 22:07:34 | cedar | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1064 | 2023-11-10 05:54:37 | cedar | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1063 | 2023-11-05 03:37:14 | cedar | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1062 | 2023-10-27 13:42:29 | cedar | 3 | 83667 | 1017 | 3.576 | 23396.8 |
| 1061 | 2023-10-24 21:19:18 | cedar | 3 | 83667 | 1017 | 3.280 | 25508.2 |
| 1060 | 2023-10-24 08:48:43 | cedar | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1059 | 2023-10-18 11:37:46 | cedar | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 1058 | 2023-10-17 16:25:39 | cedar | 3 | 83667 | 1017 | 3.356 | 24930.6 |
| 1057 | 2023-10-17 16:25:37 | cedar | 2 | 53800 | 65 | 1.360 | 39558.8 |
| 1056 | 2023-10-11 00:30:48 | cedar | 1 | 28756 | 5 | 0.440 | 65354.5 |
| 1055 | 2023-10-06 04:14:34 | cedar | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 1054 | 2023-10-05 03:27:46 | cedar | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1053 | 2023-09-19 20:40:17 | cedar | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1052 | 2023-09-19 19:33:53 | cedar | 2 | 53800 | 65 | 1.406 | 38264.6 |
| 1051 | 2023-09-19 13:32:48 | cedar | 3 | 83667 | 1017 | 3.640 | 22985.4 |
| 1050 | 2023-09-17 07:40:42 | cedar | 2 | 53800 | 65 | 1.700 | 31647.1 |
| 1049 | 2023-09-17 07:40:39 | cedar | 3 | 83667 | 1017 | 3.923 | 21327.3 |
| 1048 | 2023-09-10 17:23:02 | cedar | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1047 | 2023-09-09 08:33:47 | cedar | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1046 | 2023-08-12 06:19:44 | cedar | 3 | 83667 | 1017 | 3.856 | 21697.9 |
| 1045 | 2023-07-03 10:23:58 | cedar | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1044 | 2023-07-03 09:57:26 | cedar | 3 | 83667 | 1017 | 3.310 | 25277.0 |
| 1043 | 2023-06-29 01:15:37 | cedar | 3 | 83667 | 1017 | 3.796 | 22040.8 |
| 1042 | 2023-06-17 13:19:21 | cedar | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1041 | 2023-05-23 08:47:52 | cedar | 3 | 83667 | 1017 | 3.890 | 21508.2 |
| 1040 | 2023-05-10 22:04:45 | cedar | 3 | 83667 | 1017 | 3.280 | 25508.2 |
| 1039 | 2023-04-07 23:44:38 | cedar | 3 | 83667 | 1017 | 3.796 | 22040.8 |
| 1038 | 2023-04-03 02:31:36 | cedar | 3 | 83667 | 1017 | 3.703 | 22594.4 |
| 1037 | 2023-03-31 19:26:20 | cedar | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1036 | 2023-03-31 12:34:28 | cedar | 3 | 83667 | 1017 | 3.263 | 25641.1 |
| 1035 | 2023-03-26 23:17:55 | cedar | 1 | 28756 | 5 | 0.843 | 34111.5 |
| 1034 | 2023-03-26 21:50:03 | cedar | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 1033 | 2023-03-21 02:38:08 | cedar | 3 | 83667 | 1017 | 3.953 | 21165.4 |
| 1032 | 2023-02-09 20:00:54 | cedar | 3 | 83667 | 1017 | 3.250 | 25743.7 |
| 1031 | 2023-01-25 14:14:49 | cedar | 3 | 83667 | 1017 | 4.076 | 20526.7 |
| 1030 | 2023-01-15 14:13:22 | cedar | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1029 | 2022-12-22 10:00:49 | cedar | 3 | 83667 | 1017 | 3.920 | 21343.6 |
| 1028 | 2022-12-15 02:07:53 | cedar | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1027 | 2022-12-11 09:43:20 | cedar | 3 | 83667 | 1017 | 3.610 | 23176.5 |
| 1026 | 2022-11-07 09:31:18 | cedar | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1025 | 2022-11-05 10:24:31 | cedar | 3 | 83667 | 1017 | 3.420 | 24464.0 |
| 1024 | 2022-10-29 00:04:55 | cedar | 3 | 83667 | 1017 | 3.800 | 22017.6 |
| 1023 | 2022-10-25 00:56:57 | cedar | 3 | 83667 | 1017 | 3.893 | 21491.7 |
| 1022 | 2022-09-21 16:43:37 | cedar | 3 | 83667 | 1017 | 3.280 | 25508.2 |
| 1021 | 2022-09-11 09:55:11 | cedar | 3 | 83667 | 1017 | 3.390 | 24680.5 |
| 1020 | 2022-09-02 01:13:54 | cedar | 1 | 28756 | 5 | 0.483 | 59536.2 |
| 1019 | 2022-08-31 23:19:24 | cedar | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1018 | 2022-07-29 01:43:30 | cedar | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1017 | 2022-07-23 20:29:31 | cedar | 3 | 83667 | 1017 | 3.606 | 23202.2 |
| 1016 | 2022-07-13 07:23:28 | cedar | 3 | 83667 | 1017 | 3.313 | 25254.2 |
| 1015 | 2022-07-08 13:06:47 | cedar | 3 | 83667 | 1017 | 3.313 | 25254.2 |
| 1014 | 2022-06-29 04:14:48 | cedar | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 1013 | 2022-06-26 23:12:03 | cedar | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1012 | 2022-06-04 17:54:18 | cedar | 3 | 83667 | 1017 | 3.356 | 24930.6 |
| 1011 | 2022-05-30 06:12:22 | cedar | 3 | 83667 | 1017 | 3.296 | 25384.4 |
| 1010 | 2022-05-27 01:32:40 | cedar | 3 | 83667 | 1017 | 3.313 | 25254.2 |
| 1009 | 2022-05-26 08:50:12 | cedar | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 1008 | 2022-05-20 21:21:26 | cedar | 3 | 83667 | 1017 | 3.390 | 24680.5 |
| 1007 | 2022-04-17 16:10:51 | cedar | 3 | 83667 | 1017 | 3.343 | 25027.5 |
| 1006 | 2022-04-02 06:49:02 | cedar | 3 | 83667 | 1017 | 3.970 | 21074.8 |
| 1005 | 2022-03-06 07:24:53 | cedar | 1 | 28756 | 5 | 0.453 | 63479.0 |
| 1004 | 2022-02-18 08:37:55 | cedar | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1003 | 2021-12-18 21:41:00 | cedar | 1 | 28756 | 5 | 0.516 | 55728.7 |
| 1002 | 2021-12-16 18:53:58 | cedar | 1 | 28756 | 5 | 0.500 | 57512.0 |
| 1001 | 2021-11-13 16:32:59 | cedar | 1 | 28756 | 5 | 0.470 | 61183.0 |
| 1000 | 2021-11-08 16:22:52 | cedar | 1 | 28756 | 5 | 0.436 | 65954.1 |
| 999 | 2021-10-19 20:11:39 | cedar | 1 | 28756 | 5 | 0.450 | 63902.2 |
| 998 | 2021-10-10 19:52:46 | cedar | 3 | 83667 | 1017 | 3.830 | 21845.2 |
| 997 | 2021-10-05 22:22:17 | cedar | 3 | 83667 | 1017 | 3.750 | 22311.2 |
| 996 | 2021-09-25 00:56:41 | cedar | 3 | 83667 | 1017 | 3.530 | 23701.7 |
| 995 | 2021-09-24 18:36:32 | cedar | 1 | 28756 | 5 | 0.500 | 57512.0 |