History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"devices"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1177 | 2025-12-08 21:53:55 | devices | 2 | 107671 | 65 | 6.763 | 15920.6 |
| 1176 | 2025-11-26 07:14:46 | devices | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 1175 | 2025-11-26 01:22:14 | devices | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 1174 | 2025-11-22 10:24:29 | devices | 3 | 134027 | 553 | 7.096 | 18887.7 |
| 1173 | 2025-11-21 22:02:06 | devices | 1 | 69583 | 5 | 1.360 | 51164.0 |
| 1172 | 2025-11-21 15:16:06 | devices | 2 | 107671 | 65 | 3.453 | 31181.9 |
| 1171 | 2025-11-20 21:05:49 | devices | 1 | 69583 | 5 | 3.110 | 22374.0 |
| 1170 | 2025-11-20 16:40:07 | devices | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 1169 | 2025-11-19 07:39:32 | devices | 1 | 69583 | 5 | 1.200 | 57985.8 |
| 1168 | 2025-11-17 08:33:16 | devices | 1 | 69583 | 5 | 1.300 | 53525.4 |
| 1167 | 2025-11-16 23:46:57 | devices | 3 | 134027 | 553 | 16.203 | 8271.7 |
| 1166 | 2025-11-15 20:30:50 | devices | 1 | 69583 | 5 | 6.733 | 10334.6 |
| 1165 | 2025-11-10 16:29:17 | devices | 2 | 107671 | 65 | 3.440 | 31299.7 |
| 1164 | 2025-10-28 08:10:58 | devices | 2 | 107671 | 65 | 3.296 | 32667.2 |
| 1163 | 2025-10-26 17:13:49 | devices | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 1162 | 2025-10-26 03:55:55 | devices | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 1161 | 2025-10-26 02:42:15 | devices | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 1160 | 2025-10-25 05:09:47 | devices | 3 | 134027 | 553 | 6.110 | 21935.7 |
| 1159 | 2025-10-24 11:00:27 | devices | 3 | 134027 | 553 | 7.966 | 16824.9 |
| 1158 | 2025-10-22 22:23:46 | devices | 1 | 69583 | 5 | 3.000 | 23194.3 |
| 1157 | 2025-10-22 22:23:42 | devices | 1 | 69583 | 5 | 2.856 | 24363.8 |
| 1156 | 2025-10-22 22:23:35 | devices | 1 | 69583 | 5 | 8.610 | 8081.6 |
| 1155 | 2025-10-22 22:23:26 | devices | 1 | 69583 | 5 | 5.826 | 11943.5 |
| 1154 | 2025-10-19 08:05:14 | devices | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 1153 | 2025-10-18 22:03:05 | devices | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 1152 | 2025-10-18 17:06:11 | devices | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 1151 | 2025-10-18 09:25:23 | devices | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 1150 | 2025-10-12 21:27:16 | devices | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 1149 | 2025-10-12 16:03:17 | devices | 1 | 69583 | 5 | 1.200 | 57985.8 |
| 1148 | 2025-09-26 15:17:41 | devices | 3 | 134027 | 553 | 7.300 | 18359.9 |
| 1147 | 2025-09-25 09:12:51 | devices | 1 | 69583 | 5 | 3.000 | 23194.3 |
| 1146 | 2025-09-25 01:40:06 | devices | 3 | 134027 | 553 | 20.203 | 6634.0 |
| 1145 | 2025-09-23 22:15:25 | devices | 3 | 134027 | 553 | 6.796 | 19721.5 |
| 1144 | 2025-09-21 08:12:13 | devices | 1 | 69583 | 5 | 1.313 | 52995.4 |
| 1143 | 2025-09-18 13:34:41 | devices | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 1142 | 2025-09-17 17:18:20 | devices | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 1141 | 2025-09-16 10:07:00 | devices | 1 | 69583 | 5 | 1.106 | 62914.1 |
| 1140 | 2025-09-15 19:21:17 | devices | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 1139 | 2025-09-15 19:21:12 | devices | 1 | 69583 | 5 | 1.280 | 54361.7 |
| 1138 | 2025-09-12 05:20:20 | devices | 1 | 69583 | 5 | 1.283 | 54234.6 |
| 1137 | 2025-09-09 18:27:55 | devices | 1 | 69583 | 5 | 1.216 | 57222.9 |
| 1136 | 2025-09-03 16:06:25 | devices | 3 | 134027 | 553 | 6.483 | 20673.6 |
| 1135 | 2025-08-26 01:45:45 | devices | 1 | 69583 | 5 | 1.313 | 52995.4 |
| 1134 | 2025-08-25 08:17:37 | devices | 1 | 69583 | 5 | 5.750 | 12101.4 |
| 1133 | 2025-08-17 16:35:05 | devices | 1 | 69583 | 5 | 5.610 | 12403.4 |
| 1132 | 2025-08-14 15:34:35 | devices | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 1131 | 2025-08-03 02:34:31 | devices | 3 | 134027 | 553 | 17.346 | 7726.7 |
| 1130 | 2025-08-03 02:32:54 | devices | 2 | 107671 | 65 | 14.500 | 7425.6 |
| 1129 | 2025-08-01 18:56:06 | devices | 2 | 107671 | 65 | 9.280 | 11602.5 |
| 1128 | 2025-07-31 10:24:19 | devices | 1 | 69583 | 5 | 3.390 | 20526.0 |
| 1127 | 2025-07-31 00:32:00 | devices | 1 | 69583 | 5 | 2.530 | 27503.2 |
| 1126 | 2025-07-29 04:33:24 | devices | 3 | 134027 | 553 | 18.140 | 7388.5 |
| 1125 | 2025-07-28 03:07:24 | devices | 3 | 134027 | 553 | 30.410 | 4407.3 |
| 1124 | 2025-07-28 02:51:16 | devices | 2 | 107671 | 65 | 7.750 | 13893.0 |
| 1123 | 2025-07-26 13:25:34 | devices | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 1122 | 2025-07-26 02:24:57 | devices | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 1121 | 2025-07-25 22:56:33 | devices | 1 | 69583 | 5 | 3.733 | 18640.0 |
| 1120 | 2025-07-23 08:14:37 | devices | 1 | 69583 | 5 | 5.890 | 11813.8 |
| 1119 | 2025-07-23 00:24:15 | devices | 1 | 69583 | 5 | 3.280 | 21214.3 |
| 1118 | 2025-07-17 09:23:08 | devices | 1 | 69583 | 5 | 3.203 | 21724.3 |
| 1117 | 2025-07-08 07:04:20 | devices | 1 | 69583 | 5 | 8.016 | 8680.5 |
| 1116 | 2025-07-07 06:28:05 | devices | 1 | 69583 | 5 | 2.733 | 25460.3 |
| 1115 | 2025-06-29 22:29:06 | devices | 1 | 69583 | 5 | 8.766 | 7937.8 |
| 1114 | 2025-06-23 21:13:21 | devices | 1 | 69583 | 5 | 5.873 | 11847.9 |
| 1113 | 2025-06-16 08:18:12 | devices | 1 | 69583 | 5 | 6.123 | 11364.2 |
| 1112 | 2025-06-15 18:12:03 | devices | 1 | 69583 | 5 | 1.313 | 52995.4 |
| 1111 | 2025-06-15 07:50:36 | devices | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 1110 | 2025-06-07 20:04:53 | devices | 3 | 134027 | 553 | 29.270 | 4579.0 |
| 1109 | 2025-06-07 08:23:00 | devices | 3 | 134027 | 553 | 9.690 | 13831.5 |
| 1108 | 2025-06-06 09:32:49 | devices | 3 | 134027 | 553 | 26.830 | 4995.4 |
| 1107 | 2025-06-06 06:34:03 | devices | 3 | 134027 | 553 | 19.826 | 6760.2 |
| 1106 | 2025-06-04 07:48:55 | devices | 3 | 134027 | 553 | 28.020 | 4783.3 |
| 1105 | 2025-06-04 00:10:04 | devices | 1 | 69583 | 5 | 3.280 | 21214.3 |
| 1104 | 2025-06-03 23:59:48 | devices | 2 | 107671 | 65 | 14.674 | 7337.5 |
| 1103 | 2025-05-30 15:36:35 | devices | 1 | 69583 | 5 | 5.563 | 12508.2 |
| 1102 | 2025-05-24 18:34:56 | devices | 1 | 69583 | 5 | 6.423 | 10833.4 |
| 1101 | 2025-05-22 04:50:07 | devices | 1 | 69583 | 5 | 2.953 | 23563.5 |
| 1100 | 2025-05-20 09:21:17 | devices | 1 | 69583 | 5 | 5.936 | 11722.2 |
| 1099 | 2025-05-17 18:51:56 | devices | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 1098 | 2025-05-10 18:48:55 | devices | 1 | 69583 | 5 | 6.530 | 10655.9 |
| 1097 | 2025-04-29 17:39:06 | devices | 2 | 107671 | 65 | 4.703 | 22894.1 |
| 1096 | 2025-04-28 21:58:34 | devices | 1 | 69583 | 5 | 2.466 | 28217.0 |
| 1095 | 2025-04-26 11:34:01 | devices | 2 | 107671 | 65 | 17.376 | 6196.5 |
| 1094 | 2025-04-26 09:01:15 | devices | 1 | 69583 | 5 | 8.766 | 7937.8 |
| 1093 | 2025-04-25 19:49:20 | devices | 3 | 134027 | 553 | 51.096 | 2623.0 |
| 1092 | 2025-04-25 07:37:58 | devices | 3 | 134027 | 553 | 6.780 | 19768.0 |
| 1091 | 2025-04-25 07:27:09 | devices | 3 | 134027 | 553 | 20.970 | 6391.4 |
| 1090 | 2025-04-24 09:36:35 | devices | 3 | 134027 | 553 | 40.576 | 3303.1 |
| 1089 | 2025-04-23 02:37:49 | devices | 3 | 134027 | 553 | 31.046 | 4317.0 |
| 1088 | 2025-04-21 03:13:14 | devices | 1 | 69583 | 5 | 3.203 | 21724.3 |
| 1087 | 2025-04-20 18:19:16 | devices | 2 | 107671 | 65 | 3.266 | 32967.2 |
| 1086 | 2025-04-20 17:53:24 | devices | 3 | 134027 | 553 | 6.720 | 19944.5 |
| 1085 | 2025-04-19 08:12:41 | devices | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 1084 | 2025-04-15 07:56:44 | devices | 1 | 69583 | 5 | 5.783 | 12032.3 |
| 1083 | 2025-03-28 23:15:18 | devices | 1 | 69583 | 5 | 5.750 | 12101.4 |
| 1082 | 2025-03-23 10:23:02 | devices | 1 | 69583 | 5 | 4.830 | 14406.4 |
| 1081 | 2025-03-21 03:34:48 | devices | 2 | 107671 | 65 | 12.563 | 8570.5 |
| 1080 | 2025-03-21 02:14:53 | devices | 3 | 134027 | 553 | 31.243 | 4289.8 |
| 1079 | 2025-03-20 11:52:53 | devices | 3 | 134027 | 553 | 33.786 | 3966.9 |
| 1078 | 2025-03-20 04:05:54 | devices | 1 | 69583 | 5 | 7.893 | 8815.8 |