History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"absconders"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
332 | 2024-04-21 16:51:54 | absconders | 1 | 67641 | 2 | 3.250 | 20812.6 |
331 | 2024-04-20 14:43:39 | absconders | 1 | 67641 | 2 | 2.656 | 25467.2 |
330 | 2024-04-12 15:04:43 | absconders | 4 | 161450 | 166 | 42.906 | 3762.9 |
329 | 2024-04-11 02:59:54 | absconders | 1 | 67641 | 2 | 1.076 | 62863.4 |
328 | 2024-04-09 21:52:58 | absconders | 1 | 67641 | 2 | 1.436 | 47103.8 |
327 | 2024-04-04 17:26:48 | absconders | 4 | 161450 | 166 | 46.753 | 3453.3 |
326 | 2024-04-04 17:26:49 | absconders | 3 | 140603 | 22 | 21.253 | 6615.7 |
325 | 2024-04-04 17:26:51 | absconders | 2 | 108824 | 5 | 8.826 | 12329.9 |
324 | 2024-04-04 15:29:51 | absconders | 1 | 67641 | 2 | 2.753 | 24569.9 |
323 | 2024-03-28 16:13:43 | absconders | 1 | 67641 | 2 | 1.220 | 55443.4 |
322 | 2024-03-25 16:45:07 | absconders | 2 | 108824 | 5 | 2.890 | 37655.4 |
321 | 2024-03-25 16:43:08 | absconders | 1 | 67641 | 2 | 1.156 | 58513.0 |
320 | 2024-03-22 10:21:16 | absconders | 1 | 67641 | 2 | 2.030 | 33320.7 |
319 | 2024-03-21 23:40:31 | absconders | 3 | 140603 | 22 | 17.630 | 7975.2 |
318 | 2024-03-21 23:40:21 | absconders | 2 | 108824 | 5 | 3.580 | 30397.8 |
317 | 2024-03-20 16:14:52 | absconders | 3 | 140603 | 22 | 23.203 | 6059.7 |
316 | 2024-03-20 16:14:47 | absconders | 2 | 108824 | 5 | 7.236 | 15039.2 |
315 | 2024-03-20 16:04:00 | absconders | 1 | 67641 | 2 | 1.030 | 65670.9 |
314 | 2024-03-13 02:43:31 | absconders | 4 | 161450 | 166 | 27.706 | 5827.3 |
313 | 2024-03-04 20:07:12 | absconders | 4 | 161450 | 166 | 27.000 | 5979.6 |
312 | 2024-03-02 15:34:20 | absconders | 4 | 161450 | 166 | 40.843 | 3952.9 |
311 | 2024-03-02 15:34:21 | absconders | 3 | 140603 | 22 | 9.030 | 15570.7 |
310 | 2024-03-02 15:34:20 | absconders | 2 | 108824 | 5 | 3.673 | 29628.1 |
309 | 2024-03-02 14:02:16 | absconders | 1 | 67641 | 2 | 1.250 | 54112.8 |
308 | 2024-02-27 10:36:44 | absconders | 1 | 67641 | 2 | 1.123 | 60232.4 |
307 | 2024-02-01 10:21:20 | absconders | 1 | 67641 | 2 | 1.076 | 62863.4 |
306 | 2024-02-01 10:20:20 | absconders | 1 | 67641 | 2 | 1.013 | 66773.0 |
305 | 2024-02-01 02:14:12 | absconders | 1 | 67641 | 2 | 1.093 | 61885.6 |
304 | 2024-01-28 07:33:59 | absconders | 1 | 67641 | 2 | 1.093 | 61885.6 |
303 | 2024-01-06 21:44:27 | absconders | 2 | 108824 | 5 | 2.546 | 42743.1 |
302 | 2023-12-27 16:05:31 | absconders | 4 | 161450 | 166 | 10.030 | 16096.7 |
301 | 2023-12-27 16:05:29 | absconders | 3 | 140603 | 22 | 6.343 | 22166.6 |
300 | 2023-12-27 16:05:32 | absconders | 2 | 108824 | 5 | 3.126 | 34812.5 |
299 | 2023-12-19 21:22:53 | absconders | 1 | 67641 | 2 | 1.080 | 62630.6 |
298 | 2023-12-05 23:54:10 | absconders | 1 | 67641 | 2 | 1.126 | 60071.9 |
297 | 2023-11-13 00:52:37 | absconders | 1 | 67641 | 2 | 1.156 | 58513.0 |
296 | 2023-11-07 05:16:51 | absconders | 1 | 67641 | 2 | 1.000 | 67641.0 |
295 | 2023-11-06 19:46:37 | absconders | 1 | 67641 | 2 | 1.110 | 60937.8 |
294 | 2023-10-10 23:36:37 | absconders | 2 | 108824 | 5 | 2.796 | 38921.3 |
293 | 2023-10-05 20:08:30 | absconders | 1 | 67641 | 2 | 0.983 | 68810.8 |
292 | 2023-08-19 23:26:53 | absconders | 1 | 67641 | 2 | 1.123 | 60232.4 |
291 | 2023-08-01 20:59:06 | absconders | 1 | 67641 | 2 | 1.123 | 60232.4 |
290 | 2023-07-23 00:08:17 | absconders | 2 | 108824 | 5 | 5.906 | 18426.0 |
289 | 2023-04-26 05:12:07 | absconders | 1 | 67641 | 2 | 1.000 | 67641.0 |
288 | 2023-04-01 22:36:30 | absconders | 2 | 108824 | 5 | 2.593 | 41968.4 |
287 | 2023-02-16 00:10:30 | absconders | 1 | 67641 | 2 | 1.016 | 66575.8 |
286 | 2023-01-01 06:55:14 | absconders | 2 | 108824 | 5 | 2.906 | 37448.0 |
285 | 2022-12-15 03:59:32 | absconders | 1 | 67641 | 2 | 0.986 | 68601.4 |
284 | 2022-09-02 03:06:47 | absconders | 2 | 108824 | 5 | 2.546 | 42743.1 |
283 | 2022-08-19 17:27:18 | absconders | 1 | 67641 | 2 | 0.983 | 68810.8 |
282 | 2022-04-24 17:24:06 | absconders | 1 | 67641 | 2 | 1.266 | 53428.9 |
281 | 2022-04-22 11:24:08 | absconders | 1 | 67641 | 2 | 1.030 | 65670.9 |
280 | 2021-05-15 07:25:37 | absconders | 4 | 161450 | 166 | 10.000 | 16145.0 |
279 | 2021-04-07 00:54:39 | absconders | 1 | 67641 | 2 | 1.140 | 59334.2 |
278 | 2021-04-04 14:07:08 | absconders | 1 | 67641 | 2 | 1.126 | 60071.9 |
277 | 2021-02-20 11:19:02 | absconders | 3 | 140603 | 22 | 7.080 | 19859.2 |
276 | 2021-02-14 22:05:15 | absconders | 1 | 67641 | 2 | 1.110 | 60937.8 |
275 | 2021-01-27 06:49:55 | absconders | 4 | 161450 | 166 | 9.346 | 17274.8 |
274 | 2020-12-29 17:11:10 | absconders | 3 | 140603 | 22 | 5.440 | 25846.1 |
273 | 2020-11-05 10:04:44 | absconders | 3 | 140603 | 22 | 5.656 | 24859.1 |
272 | 2020-10-28 21:01:58 | absconders | 1 | 67641 | 2 | 1.190 | 56841.2 |
271 | 2020-10-16 05:58:22 | absconders | 4 | 161450 | 166 | 9.470 | 17048.6 |
270 | 2020-10-04 14:23:13 | absconders | 1 | 67641 | 2 | 1.093 | 61885.6 |
269 | 2020-09-16 01:23:09 | absconders | 1 | 67641 | 2 | 1.093 | 61885.6 |
268 | 2020-08-28 08:37:36 | absconders | 1 | 67641 | 2 | 1.096 | 61716.2 |
267 | 2020-08-06 11:35:15 | absconders | 1 | 67641 | 2 | 1.266 | 53428.9 |
266 | 2020-07-16 04:08:53 | absconders | 1 | 67641 | 2 | 1.110 | 60937.8 |
265 | 2020-04-23 22:05:10 | absconders | 4 | 161450 | 166 | 10.890 | 14825.5 |
264 | 2020-03-26 03:26:57 | absconders | 4 | 161450 | 166 | 11.750 | 13740.4 |
263 | 2020-03-24 20:30:40 | absconders | 1 | 67641 | 2 | 1.186 | 57032.9 |
262 | 2020-03-18 00:13:43 | absconders | 1 | 67641 | 2 | 1.123 | 60232.4 |
261 | 2020-03-05 16:48:33 | absconders | 3 | 140603 | 22 | 6.483 | 21688.0 |
260 | 2020-03-04 12:46:04 | absconders | 4 | 161450 | 166 | 11.376 | 14192.2 |
259 | 2020-03-03 11:14:38 | absconders | 4 | 161450 | 166 | 11.156 | 14472.0 |
258 | 2020-03-03 11:14:20 | absconders | 3 | 140603 | 22 | 5.373 | 26168.4 |
257 | 2020-03-03 11:14:08 | absconders | 2 | 108824 | 5 | 3.060 | 35563.4 |
256 | 2020-03-03 11:14:00 | absconders | 1 | 67641 | 2 | 1.030 | 65670.9 |
255 | 2020-02-18 00:24:51 | absconders | 1 | 67641 | 2 | 1.216 | 55625.8 |
254 | 2020-02-07 23:27:16 | absconders | 1 | 67641 | 2 | 1.186 | 57032.9 |
253 | 2020-02-04 15:35:30 | absconders | 1 | 67641 | 2 | 1.236 | 54725.7 |
252 | 2020-01-30 15:17:55 | absconders | 1 | 67641 | 2 | 2.266 | 29850.4 |
251 | 2020-01-30 12:41:04 | absconders | 1 | 67641 | 2 | 1.000 | 67641.0 |
250 | 2020-01-25 17:13:36 | absconders | 1 | 67641 | 2 | 1.453 | 46552.6 |
249 | 2020-01-18 00:36:23 | absconders | 1 | 67641 | 2 | 4.560 | 14833.6 |
248 | 2020-01-04 23:33:45 | absconders | 1 | 67641 | 2 | 1.190 | 56841.2 |
247 | 2020-01-04 21:46:28 | absconders | 1 | 67641 | 2 | 1.126 | 60071.9 |
246 | 2019-12-12 09:13:36 | absconders | 1 | 67641 | 2 | 1.060 | 63812.3 |
245 | 2019-12-07 12:59:19 | absconders | 4 | 161450 | 166 | 10.470 | 15420.2 |
244 | 2019-10-26 20:55:39 | absconders | 4 | 161450 | 166 | 9.283 | 17392.0 |
243 | 2019-10-26 20:55:32 | absconders | 3 | 140603 | 22 | 5.343 | 26315.4 |
242 | 2019-10-26 20:55:28 | absconders | 2 | 108824 | 5 | 2.576 | 42245.3 |
241 | 2019-10-26 20:55:26 | absconders | 1 | 67641 | 2 | 1.000 | 67641.0 |
240 | 2019-09-10 16:09:19 | absconders | 1 | 67641 | 2 | 1.026 | 65926.9 |
239 | 2019-08-02 20:04:35 | absconders | 4 | 161450 | 166 | 11.036 | 14629.4 |
238 | 2019-08-02 20:04:27 | absconders | 3 | 140603 | 22 | 6.150 | 22862.3 |
237 | 2019-08-02 20:04:10 | absconders | 2 | 108824 | 5 | 3.103 | 35070.6 |
236 | 2019-08-02 20:04:05 | absconders | 1 | 67641 | 2 | 0.953 | 70976.9 |
235 | 2019-06-27 13:33:41 | absconders | 1 | 67641 | 2 | 1.006 | 67237.6 |
234 | 2019-06-04 19:42:37 | absconders | 1 | 67641 | 2 | 1.213 | 55763.4 |
233 | 2019-02-13 02:00:48 | absconders | 1 | 67641 | 2 | 0.953 | 70976.9 |