History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"inspectors"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
272 | 2024-06-01 02:15:35 | inspectors | 4 | 161450 | 179 | 52.440 | 3078.8 |
271 | 2024-06-01 02:15:47 | inspectors | 2 | 108824 | 7 | 12.063 | 9021.3 |
270 | 2024-06-01 02:15:25 | inspectors | 3 | 140603 | 42 | 26.593 | 5287.2 |
269 | 2024-06-01 01:30:03 | inspectors | 1 | 67641 | 2 | 1.190 | 56841.2 |
268 | 2024-05-31 01:54:08 | inspectors | 1 | 67641 | 2 | 1.190 | 56841.2 |
267 | 2024-05-30 06:24:48 | inspectors | 1 | 67641 | 2 | 3.356 | 20155.2 |
266 | 2024-05-16 08:00:24 | inspectors | 1 | 67641 | 2 | 1.156 | 58513.0 |
265 | 2024-05-12 20:01:36 | inspectors | 2 | 108824 | 7 | 9.703 | 11215.5 |
264 | 2024-05-06 20:33:17 | inspectors | 1 | 67641 | 2 | 1.156 | 58513.0 |
263 | 2024-05-04 11:00:12 | inspectors | 1 | 67641 | 2 | 2.343 | 28869.4 |
262 | 2024-05-01 04:45:22 | inspectors | 4 | 161450 | 179 | 16.283 | 9915.2 |
261 | 2024-05-01 04:26:50 | inspectors | 3 | 140603 | 42 | 9.236 | 15223.4 |
260 | 2024-05-01 04:26:44 | inspectors | 2 | 108824 | 7 | 5.356 | 20318.1 |
259 | 2024-05-01 03:39:37 | inspectors | 1 | 67641 | 2 | 1.123 | 60232.4 |
258 | 2024-04-30 14:11:38 | inspectors | 4 | 161450 | 179 | 23.360 | 6911.4 |
257 | 2024-04-29 15:07:05 | inspectors | 1 | 67641 | 2 | 1.110 | 60937.8 |
256 | 2024-04-28 11:30:43 | inspectors | 1 | 67641 | 2 | 1.356 | 49882.7 |
255 | 2024-04-05 22:01:01 | inspectors | 1 | 67641 | 2 | 1.593 | 42461.4 |
254 | 2024-04-04 10:39:18 | inspectors | 3 | 140603 | 42 | 20.220 | 6953.7 |
253 | 2024-04-04 10:30:12 | inspectors | 1 | 67641 | 2 | 3.940 | 17167.8 |
252 | 2024-04-03 01:25:24 | inspectors | 4 | 161450 | 179 | 30.626 | 5271.7 |
251 | 2024-04-01 19:38:05 | inspectors | 4 | 161450 | 179 | 33.203 | 4862.5 |
250 | 2024-04-01 03:00:26 | inspectors | 3 | 140603 | 42 | 17.080 | 8232.0 |
249 | 2024-04-01 03:00:24 | inspectors | 2 | 108824 | 7 | 7.110 | 15305.8 |
248 | 2024-03-30 10:21:04 | inspectors | 3 | 140603 | 42 | 16.986 | 8277.6 |
247 | 2024-03-30 10:21:03 | inspectors | 2 | 108824 | 7 | 5.923 | 18373.1 |
246 | 2024-03-30 08:06:34 | inspectors | 1 | 67641 | 2 | 1.186 | 57032.9 |
245 | 2024-03-29 20:00:10 | inspectors | 4 | 161450 | 179 | 28.873 | 5591.7 |
244 | 2024-03-28 09:52:40 | inspectors | 4 | 161450 | 179 | 37.236 | 4335.9 |
243 | 2024-03-27 12:43:43 | inspectors | 3 | 140603 | 42 | 17.156 | 8195.6 |
242 | 2024-03-27 12:43:31 | inspectors | 4 | 161450 | 179 | 16.220 | 9953.8 |
241 | 2024-03-27 12:43:35 | inspectors | 2 | 108824 | 7 | 7.736 | 14067.2 |
240 | 2024-03-27 11:24:01 | inspectors | 1 | 67641 | 2 | 1.220 | 55443.4 |
239 | 2024-03-27 11:23:56 | inspectors | 1 | 67641 | 2 | 1.143 | 59178.5 |
238 | 2024-03-07 11:29:40 | inspectors | 1 | 67641 | 2 | 2.826 | 23935.2 |
237 | 2024-03-02 07:18:44 | inspectors | 1 | 67641 | 2 | 2.593 | 26086.0 |
236 | 2024-03-01 21:58:52 | inspectors | 3 | 140603 | 42 | 6.906 | 20359.5 |
235 | 2024-03-01 21:58:51 | inspectors | 2 | 108824 | 7 | 6.920 | 15726.0 |
234 | 2024-02-28 06:22:57 | inspectors | 1 | 67641 | 2 | 1.143 | 59178.5 |
233 | 2024-02-21 20:24:02 | inspectors | 3 | 140603 | 42 | 6.703 | 20976.1 |
232 | 2024-02-21 15:28:51 | inspectors | 4 | 161450 | 179 | 36.880 | 4377.7 |
231 | 2024-02-20 00:56:41 | inspectors | 4 | 161450 | 179 | 30.313 | 5326.1 |
230 | 2024-02-20 00:56:42 | inspectors | 3 | 140603 | 42 | 14.216 | 9890.5 |
229 | 2024-02-20 00:56:43 | inspectors | 2 | 108824 | 7 | 7.220 | 15072.6 |
228 | 2024-02-19 15:04:45 | inspectors | 1 | 67641 | 2 | 2.390 | 28301.7 |
227 | 2024-01-29 10:43:11 | inspectors | 1 | 67641 | 2 | 1.123 | 60232.4 |
226 | 2024-01-20 13:35:43 | inspectors | 1 | 67641 | 2 | 0.986 | 68601.4 |
225 | 2024-01-14 16:53:56 | inspectors | 1 | 67641 | 2 | 1.093 | 61885.6 |
224 | 2024-01-05 04:43:25 | inspectors | 2 | 108824 | 7 | 3.000 | 36274.7 |
223 | 2023-12-23 09:51:53 | inspectors | 4 | 161450 | 179 | 9.466 | 17055.8 |
222 | 2023-11-19 12:59:16 | inspectors | 1 | 67641 | 2 | 1.000 | 67641.0 |
221 | 2023-10-24 15:59:28 | inspectors | 1 | 67641 | 2 | 1.016 | 66575.8 |
220 | 2023-10-13 09:43:19 | inspectors | 2 | 108824 | 7 | 2.890 | 37655.4 |
219 | 2023-09-25 07:58:06 | inspectors | 4 | 161450 | 179 | 10.466 | 15426.1 |
218 | 2023-09-21 19:52:57 | inspectors | 1 | 67641 | 2 | 1.153 | 58665.2 |
217 | 2023-09-08 03:38:20 | inspectors | 1 | 67641 | 2 | 1.016 | 66575.8 |
216 | 2023-08-12 21:06:15 | inspectors | 4 | 161450 | 179 | 10.376 | 15559.9 |
215 | 2023-08-11 01:46:40 | inspectors | 4 | 161450 | 179 | 10.093 | 15996.2 |
214 | 2023-07-24 04:06:10 | inspectors | 2 | 108824 | 7 | 2.936 | 37065.4 |
213 | 2023-07-06 21:52:18 | inspectors | 4 | 161450 | 179 | 9.906 | 16298.2 |
212 | 2023-05-11 16:56:01 | inspectors | 1 | 67641 | 2 | 1.013 | 66773.0 |
211 | 2023-05-03 04:48:35 | inspectors | 4 | 161450 | 179 | 9.343 | 17280.3 |
210 | 2023-04-18 06:47:18 | inspectors | 4 | 161450 | 179 | 9.280 | 17397.6 |
209 | 2023-04-04 12:38:35 | inspectors | 2 | 108824 | 7 | 3.000 | 36274.7 |
208 | 2023-04-02 06:10:20 | inspectors | 4 | 161450 | 179 | 10.923 | 14780.7 |
207 | 2023-03-25 08:21:41 | inspectors | 4 | 161450 | 179 | 13.516 | 11945.1 |
206 | 2023-03-23 09:26:23 | inspectors | 4 | 161450 | 179 | 10.860 | 14866.5 |
205 | 2023-02-18 10:42:49 | inspectors | 1 | 67641 | 2 | 0.986 | 68601.4 |
204 | 2023-02-14 18:32:53 | inspectors | 4 | 161450 | 179 | 12.063 | 13383.9 |
203 | 2023-01-18 12:21:04 | inspectors | 1 | 67641 | 2 | 0.983 | 68810.8 |
202 | 2023-01-14 11:48:11 | inspectors | 4 | 161450 | 179 | 10.140 | 15922.1 |
201 | 2022-12-31 04:40:20 | inspectors | 2 | 108824 | 7 | 3.013 | 36118.2 |
200 | 2022-12-23 17:34:23 | inspectors | 4 | 161450 | 179 | 9.343 | 17280.3 |
199 | 2022-11-03 07:18:05 | inspectors | 4 | 161450 | 179 | 9.593 | 16830.0 |
198 | 2022-09-23 13:23:40 | inspectors | 1 | 67641 | 2 | 1.000 | 67641.0 |
197 | 2022-09-03 07:05:11 | inspectors | 2 | 108824 | 7 | 2.593 | 41968.4 |
196 | 2022-08-22 08:28:12 | inspectors | 4 | 161450 | 179 | 11.313 | 14271.2 |
195 | 2022-08-20 22:57:38 | inspectors | 1 | 67641 | 2 | 0.970 | 69733.0 |
194 | 2022-05-17 15:27:16 | inspectors | 1 | 67641 | 2 | 1.206 | 56087.1 |
193 | 2022-05-14 02:09:06 | inspectors | 1 | 67641 | 2 | 1.606 | 42117.7 |
192 | 2022-04-12 21:41:01 | inspectors | 1 | 67641 | 2 | 1.546 | 43752.3 |
191 | 2022-04-10 15:54:55 | inspectors | 1 | 67641 | 2 | 1.126 | 60071.9 |
190 | 2022-04-09 05:10:56 | inspectors | 1 | 67641 | 2 | 1.016 | 66575.8 |
189 | 2022-01-19 11:04:47 | inspectors | 1 | 67641 | 2 | 1.140 | 59334.2 |
188 | 2022-01-16 04:46:01 | inspectors | 1 | 67641 | 2 | 1.093 | 61885.6 |
187 | 2022-01-12 21:50:49 | inspectors | 1 | 67641 | 2 | 1.063 | 63632.2 |
186 | 2021-09-26 23:47:03 | inspectors | 1 | 67641 | 2 | 1.123 | 60232.4 |
185 | 2021-07-05 01:39:15 | inspectors | 4 | 161450 | 179 | 9.470 | 17048.6 |
184 | 2021-06-27 07:59:09 | inspectors | 1 | 67641 | 2 | 1.123 | 60232.4 |
183 | 2021-06-25 11:40:28 | inspectors | 3 | 140603 | 42 | 5.393 | 26071.4 |
182 | 2021-05-13 19:21:44 | inspectors | 4 | 161450 | 179 | 10.796 | 14954.6 |
181 | 2021-04-06 16:26:45 | inspectors | 3 | 140603 | 42 | 11.313 | 12428.4 |
180 | 2021-04-05 18:33:28 | inspectors | 4 | 161450 | 179 | 9.580 | 16852.8 |
179 | 2021-03-26 11:08:50 | inspectors | 1 | 67641 | 2 | 1.000 | 67641.0 |
178 | 2021-03-22 01:50:54 | inspectors | 1 | 67641 | 2 | 1.106 | 61158.2 |
177 | 2021-03-12 02:44:41 | inspectors | 4 | 161450 | 179 | 11.300 | 14287.6 |
176 | 2021-03-10 22:35:04 | inspectors | 3 | 140603 | 42 | 5.390 | 26085.9 |
175 | 2021-01-26 14:44:51 | inspectors | 4 | 161450 | 179 | 10.860 | 14866.5 |
174 | 2021-01-21 22:09:51 | inspectors | 3 | 140603 | 42 | 5.780 | 24325.8 |
173 | 2020-12-22 23:38:15 | inspectors | 3 | 140603 | 42 | 5.736 | 24512.4 |