History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spiritless"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
341 | 2024-05-09 19:53:02 | spiritless | 2 | 108824 | 4 | 7.236 | 15039.2 |
340 | 2024-05-06 12:23:10 | spiritless | 4 | 161450 | 266 | 23.003 | 7018.6 |
339 | 2024-05-05 06:59:24 | spiritless | 3 | 140603 | 43 | 6.360 | 22107.4 |
338 | 2024-05-04 09:53:21 | spiritless | 1 | 67641 | 1 | 2.626 | 25758.2 |
337 | 2024-05-01 01:51:05 | spiritless | 1 | 67641 | 1 | 2.360 | 28661.4 |
336 | 2024-04-30 12:37:20 | spiritless | 2 | 108824 | 4 | 4.610 | 23606.1 |
335 | 2024-04-28 10:19:48 | spiritless | 1 | 67641 | 1 | 1.266 | 53428.9 |
334 | 2024-04-27 01:45:25 | spiritless | 3 | 140603 | 43 | 24.610 | 5713.2 |
333 | 2024-04-27 00:27:32 | spiritless | 1 | 67641 | 1 | 5.203 | 13000.4 |
332 | 2024-04-26 12:31:54 | spiritless | 3 | 140603 | 43 | 25.316 | 5553.9 |
331 | 2024-04-26 12:31:58 | spiritless | 2 | 108824 | 4 | 7.563 | 14389.0 |
330 | 2024-04-26 11:07:30 | spiritless | 1 | 67641 | 1 | 1.673 | 40431.0 |
329 | 2024-04-25 21:29:08 | spiritless | 1 | 67641 | 1 | 1.313 | 51516.4 |
328 | 2024-04-20 17:28:51 | spiritless | 4 | 161450 | 266 | 42.533 | 3795.9 |
327 | 2024-04-20 17:28:50 | spiritless | 3 | 140603 | 43 | 29.816 | 4715.7 |
326 | 2024-04-20 17:28:49 | spiritless | 2 | 108824 | 4 | 4.063 | 26784.1 |
325 | 2024-04-20 14:46:08 | spiritless | 1 | 67641 | 1 | 1.703 | 39718.7 |
324 | 2024-04-04 17:19:14 | spiritless | 4 | 161450 | 266 | 37.186 | 4341.7 |
323 | 2024-03-25 17:25:16 | spiritless | 1 | 67641 | 1 | 3.580 | 18894.1 |
322 | 2024-03-25 10:06:14 | spiritless | 1 | 67641 | 1 | 1.236 | 54725.7 |
321 | 2024-03-18 07:50:03 | spiritless | 1 | 67641 | 1 | 1.263 | 53555.8 |
320 | 2024-03-13 11:59:58 | spiritless | 1 | 67641 | 1 | 2.703 | 25024.4 |
319 | 2024-03-06 23:44:23 | spiritless | 1 | 67641 | 1 | 3.263 | 20729.7 |
318 | 2024-03-01 20:38:43 | spiritless | 4 | 161450 | 266 | 17.110 | 9436.0 |
317 | 2024-02-23 01:14:36 | spiritless | 4 | 161450 | 266 | 12.296 | 13130.3 |
316 | 2024-02-23 01:14:37 | spiritless | 3 | 140603 | 43 | 7.156 | 19648.3 |
315 | 2024-02-23 01:14:38 | spiritless | 2 | 108824 | 4 | 3.563 | 30542.8 |
314 | 2024-02-14 22:38:47 | spiritless | 1 | 67641 | 1 | 1.503 | 45004.0 |
313 | 2024-02-08 08:59:39 | spiritless | 1 | 67641 | 1 | 1.186 | 57032.9 |
312 | 2024-02-05 19:22:37 | spiritless | 1 | 67641 | 1 | 1.173 | 57665.0 |
311 | 2024-02-02 15:22:08 | spiritless | 1 | 67641 | 1 | 1.046 | 64666.3 |
310 | 2024-01-11 01:37:38 | spiritless | 1 | 67641 | 1 | 1.093 | 61885.6 |
309 | 2024-01-06 04:34:33 | spiritless | 1 | 67641 | 1 | 1.123 | 60232.4 |
308 | 2024-01-05 09:40:54 | spiritless | 2 | 108824 | 4 | 3.013 | 36118.2 |
307 | 2023-12-27 23:04:09 | spiritless | 1 | 67641 | 1 | 1.000 | 67641.0 |
306 | 2023-12-27 00:05:04 | spiritless | 3 | 140603 | 43 | 5.626 | 24991.6 |
305 | 2023-12-17 05:43:00 | spiritless | 1 | 67641 | 1 | 1.080 | 62630.6 |
304 | 2023-11-08 12:02:05 | spiritless | 1 | 67641 | 1 | 1.110 | 60937.8 |
303 | 2023-11-05 13:37:22 | spiritless | 1 | 67641 | 1 | 1.016 | 66575.8 |
302 | 2023-10-29 22:05:39 | spiritless | 1 | 67641 | 1 | 1.030 | 65670.9 |
301 | 2023-10-24 07:20:13 | spiritless | 3 | 140603 | 43 | 7.123 | 19739.3 |
300 | 2023-10-12 05:25:35 | spiritless | 2 | 108824 | 4 | 3.440 | 31634.9 |
299 | 2023-09-30 00:18:27 | spiritless | 3 | 140603 | 43 | 5.860 | 23993.7 |
298 | 2023-09-25 15:31:33 | spiritless | 1 | 67641 | 1 | 3.860 | 17523.6 |
297 | 2023-09-13 22:11:37 | spiritless | 1 | 67641 | 1 | 1.156 | 58513.0 |
296 | 2023-08-23 03:57:20 | spiritless | 1 | 67641 | 1 | 1.030 | 65670.9 |
295 | 2023-07-22 08:55:25 | spiritless | 2 | 108824 | 4 | 2.626 | 41441.0 |
294 | 2023-07-20 13:29:02 | spiritless | 1 | 67641 | 1 | 1.126 | 60071.9 |
293 | 2023-07-10 15:12:39 | spiritless | 3 | 140603 | 43 | 5.673 | 24784.6 |
292 | 2023-05-24 22:59:58 | spiritless | 1 | 67641 | 1 | 1.000 | 67641.0 |
291 | 2023-04-03 03:25:23 | spiritless | 2 | 108824 | 4 | 2.983 | 36481.4 |
290 | 2023-03-27 07:39:23 | spiritless | 3 | 140603 | 43 | 6.110 | 23011.9 |
289 | 2023-03-19 15:11:59 | spiritless | 1 | 67641 | 1 | 1.063 | 63632.2 |
288 | 2023-03-05 09:19:20 | spiritless | 1 | 67641 | 1 | 1.030 | 65670.9 |
287 | 2023-03-01 22:49:56 | spiritless | 1 | 67641 | 1 | 1.016 | 66575.8 |
286 | 2023-01-06 16:01:53 | spiritless | 1 | 67641 | 1 | 0.986 | 68601.4 |
285 | 2022-12-29 19:15:42 | spiritless | 2 | 108824 | 4 | 3.140 | 34657.3 |
284 | 2022-12-23 23:30:36 | spiritless | 3 | 140603 | 43 | 5.376 | 26153.8 |
283 | 2022-10-04 15:05:55 | spiritless | 1 | 67641 | 1 | 1.016 | 66575.8 |
282 | 2022-10-03 02:01:22 | spiritless | 1 | 67641 | 1 | 1.186 | 57032.9 |
281 | 2022-09-16 07:48:19 | spiritless | 1 | 67641 | 1 | 1.110 | 60937.8 |
280 | 2022-09-13 17:19:35 | spiritless | 1 | 67641 | 1 | 1.170 | 57812.8 |
279 | 2022-08-31 22:53:06 | spiritless | 2 | 108824 | 4 | 2.640 | 41221.2 |
278 | 2022-05-15 17:00:46 | spiritless | 1 | 67641 | 1 | 1.140 | 59334.2 |
277 | 2022-05-13 12:54:52 | spiritless | 1 | 67641 | 1 | 1.080 | 62630.6 |
276 | 2022-05-07 09:23:33 | spiritless | 1 | 67641 | 1 | 1.236 | 54725.7 |
275 | 2022-04-15 04:01:59 | spiritless | 1 | 67641 | 1 | 1.126 | 60071.9 |
274 | 2022-03-19 08:52:16 | spiritless | 4 | 161450 | 266 | 9.643 | 16742.7 |
273 | 2022-03-15 22:08:27 | spiritless | 4 | 161450 | 266 | 18.126 | 8907.1 |
272 | 2022-01-08 19:03:03 | spiritless | 1 | 67641 | 1 | 1.203 | 56226.9 |
271 | 2021-12-27 23:06:17 | spiritless | 1 | 67641 | 1 | 1.110 | 60937.8 |
270 | 2021-12-24 19:34:23 | spiritless | 1 | 67641 | 1 | 1.156 | 58513.0 |
269 | 2021-12-09 16:09:15 | spiritless | 4 | 161450 | 266 | 10.483 | 15401.1 |
268 | 2021-11-13 03:13:49 | spiritless | 1 | 67641 | 1 | 1.140 | 59334.2 |
267 | 2021-11-05 21:42:07 | spiritless | 3 | 140603 | 43 | 7.656 | 18365.1 |
266 | 2021-10-31 01:52:23 | spiritless | 4 | 161450 | 266 | 9.766 | 16531.8 |
265 | 2021-10-06 21:35:14 | spiritless | 4 | 161450 | 266 | 10.936 | 14763.2 |
264 | 2021-10-02 22:17:12 | spiritless | 1 | 67641 | 1 | 1.126 | 60071.9 |
263 | 2021-08-31 11:56:41 | spiritless | 1 | 67641 | 1 | 1.186 | 57032.9 |
262 | 2021-08-27 02:43:18 | spiritless | 1 | 67641 | 1 | 1.016 | 66575.8 |
261 | 2021-08-22 12:45:21 | spiritless | 1 | 67641 | 1 | 1.156 | 58513.0 |
260 | 2021-08-13 21:51:23 | spiritless | 4 | 161450 | 266 | 9.530 | 16941.2 |
259 | 2021-08-11 07:43:42 | spiritless | 1 | 67641 | 1 | 1.140 | 59334.2 |
258 | 2021-06-07 03:21:45 | spiritless | 4 | 161450 | 266 | 10.266 | 15726.7 |
257 | 2021-06-03 22:53:05 | spiritless | 4 | 161450 | 266 | 10.220 | 15797.5 |
256 | 2021-05-12 16:13:01 | spiritless | 4 | 161450 | 266 | 11.170 | 14453.9 |
255 | 2021-05-04 21:22:53 | spiritless | 1 | 67641 | 1 | 1.203 | 56226.9 |
254 | 2021-03-24 05:53:08 | spiritless | 2 | 108824 | 4 | 2.673 | 40712.3 |
253 | 2021-03-23 04:52:16 | spiritless | 1 | 67641 | 1 | 1.190 | 56841.2 |
252 | 2021-02-25 15:21:40 | spiritless | 1 | 67641 | 1 | 1.110 | 60937.8 |
251 | 2021-02-25 09:03:23 | spiritless | 4 | 161450 | 266 | 9.610 | 16800.2 |
250 | 2021-02-01 14:23:53 | spiritless | 1 | 67641 | 1 | 1.173 | 57665.0 |
249 | 2021-01-29 02:04:09 | spiritless | 1 | 67641 | 1 | 1.080 | 62630.6 |
248 | 2021-01-26 23:05:48 | spiritless | 1 | 67641 | 1 | 2.393 | 28266.2 |
247 | 2021-01-25 17:27:04 | spiritless | 4 | 161450 | 266 | 10.080 | 16016.9 |
246 | 2021-01-06 20:42:50 | spiritless | 2 | 108824 | 4 | 2.703 | 40260.5 |
245 | 2021-01-04 23:39:01 | spiritless | 1 | 67641 | 1 | 1.140 | 59334.2 |
244 | 2020-11-17 09:50:05 | spiritless | 1 | 67641 | 1 | 1.123 | 60232.4 |
243 | 2020-11-16 21:50:38 | spiritless | 1 | 67641 | 1 | 1.076 | 62863.4 |
242 | 2020-11-15 19:35:55 | spiritless | 4 | 161450 | 266 | 9.953 | 16221.2 |