History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"refills"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
391 | 2024-05-01 04:57:24 | refills | 1 | 69583 | 6 | 2.093 | 33245.6 |
390 | 2024-05-01 04:53:35 | refills | 1 | 69583 | 6 | 1.360 | 51164.0 |
389 | 2024-04-25 09:13:57 | refills | 1 | 69583 | 6 | 1.280 | 54361.7 |
388 | 2024-03-29 22:48:53 | refills | 1 | 69583 | 6 | 2.796 | 24886.6 |
387 | 2024-02-29 22:09:35 | refills | 3 | 134027 | 384 | 14.063 | 9530.5 |
386 | 2024-02-28 08:24:52 | refills | 3 | 134027 | 384 | 8.780 | 15265.0 |
385 | 2024-02-28 07:10:07 | refills | 3 | 134027 | 384 | 17.313 | 7741.4 |
384 | 2024-01-26 06:55:55 | refills | 3 | 134027 | 384 | 12.643 | 10600.9 |
383 | 2024-01-19 05:08:32 | refills | 2 | 107671 | 41 | 3.406 | 31612.2 |
382 | 2024-01-19 05:04:50 | refills | 3 | 134027 | 384 | 5.906 | 22693.4 |
381 | 2023-12-31 17:26:31 | refills | 1 | 69583 | 6 | 1.126 | 61796.6 |
380 | 2023-12-25 08:43:16 | refills | 1 | 69583 | 6 | 1.313 | 52995.4 |
379 | 2023-12-06 23:37:34 | refills | 1 | 69583 | 6 | 1.123 | 61961.7 |
378 | 2023-11-22 16:22:10 | refills | 3 | 134027 | 384 | 6.030 | 22226.7 |
377 | 2023-11-16 06:39:27 | refills | 1 | 69583 | 6 | 1.110 | 62687.4 |
376 | 2023-11-05 06:13:09 | refills | 1 | 69583 | 6 | 1.140 | 61037.7 |
375 | 2023-11-02 13:33:07 | refills | 1 | 69583 | 6 | 1.266 | 54962.9 |
374 | 2023-10-23 07:58:02 | refills | 1 | 69583 | 6 | 2.376 | 29285.8 |
373 | 2023-10-21 08:39:06 | refills | 1 | 69583 | 6 | 1.250 | 55666.4 |
372 | 2023-10-15 16:14:20 | refills | 1 | 69583 | 6 | 1.200 | 57985.8 |
371 | 2023-09-29 02:04:16 | refills | 1 | 69583 | 6 | 1.266 | 54962.9 |
370 | 2023-09-14 19:24:11 | refills | 1 | 69583 | 6 | 1.126 | 61796.6 |
369 | 2023-08-22 20:48:05 | refills | 3 | 134027 | 384 | 5.983 | 22401.3 |
368 | 2023-08-16 11:45:18 | refills | 1 | 69583 | 6 | 1.093 | 63662.4 |
367 | 2023-07-18 13:20:52 | refills | 1 | 69583 | 6 | 1.106 | 62914.1 |
366 | 2023-07-14 17:16:14 | refills | 1 | 69583 | 6 | 1.096 | 63488.1 |
365 | 2023-05-13 13:02:43 | refills | 1 | 69583 | 6 | 1.110 | 62687.4 |
364 | 2023-05-08 14:37:18 | refills | 3 | 134027 | 384 | 5.810 | 23068.3 |
363 | 2023-03-23 10:29:23 | refills | 1 | 69583 | 6 | 1.080 | 64428.7 |
362 | 2023-03-09 17:55:08 | refills | 1 | 69583 | 6 | 1.110 | 62687.4 |
361 | 2023-02-15 22:25:52 | refills | 3 | 134027 | 384 | 5.830 | 22989.2 |
360 | 2022-12-29 14:46:42 | refills | 1 | 69583 | 6 | 1.076 | 64668.2 |
359 | 2022-11-29 06:23:30 | refills | 3 | 134027 | 384 | 5.750 | 23309.0 |
358 | 2022-11-22 00:03:16 | refills | 1 | 69583 | 6 | 1.283 | 54234.6 |
357 | 2022-09-17 02:11:29 | refills | 1 | 69583 | 6 | 1.140 | 61037.7 |
356 | 2022-09-01 06:15:01 | refills | 1 | 69583 | 6 | 1.250 | 55666.4 |
355 | 2022-07-29 04:12:05 | refills | 1 | 69583 | 6 | 1.233 | 56433.9 |
354 | 2022-07-25 17:56:50 | refills | 1 | 69583 | 6 | 1.373 | 50679.5 |
353 | 2022-07-06 13:47:43 | refills | 3 | 134027 | 384 | 6.060 | 22116.7 |
352 | 2022-04-26 00:16:26 | refills | 1 | 69583 | 6 | 1.106 | 62914.1 |
351 | 2022-04-23 18:05:17 | refills | 1 | 69583 | 6 | 1.093 | 63662.4 |
350 | 2022-04-03 17:29:38 | refills | 1 | 69583 | 6 | 1.233 | 56433.9 |
349 | 2022-01-17 07:22:05 | refills | 1 | 69583 | 6 | 1.093 | 63662.4 |
348 | 2022-01-15 03:43:33 | refills | 1 | 69583 | 6 | 1.220 | 57035.2 |
347 | 2021-12-16 18:35:49 | refills | 1 | 69583 | 6 | 1.220 | 57035.2 |
346 | 2021-11-08 23:09:49 | refills | 1 | 69583 | 6 | 1.080 | 64428.7 |
345 | 2021-10-09 06:53:07 | refills | 1 | 69583 | 6 | 1.110 | 62687.4 |
344 | 2021-09-28 14:34:21 | refills | 1 | 69583 | 6 | 1.173 | 59320.5 |
343 | 2021-09-11 12:48:32 | refills | 1 | 69583 | 6 | 1.936 | 35941.6 |
342 | 2021-09-02 23:40:53 | refills | 1 | 69583 | 6 | 1.093 | 63662.4 |
341 | 2021-08-29 13:58:23 | refills | 1 | 69583 | 6 | 1.186 | 58670.3 |
340 | 2021-08-19 03:27:14 | refills | 1 | 69583 | 6 | 1.203 | 57841.2 |
339 | 2021-07-13 14:52:29 | refills | 1 | 69583 | 6 | 1.080 | 64428.7 |
338 | 2021-06-12 04:27:26 | refills | 1 | 69583 | 6 | 1.466 | 47464.5 |
337 | 2021-05-29 23:55:50 | refills | 1 | 69583 | 6 | 2.563 | 27149.0 |
336 | 2021-04-02 11:17:03 | refills | 1 | 69583 | 6 | 1.203 | 57841.2 |
335 | 2021-02-27 08:36:53 | refills | 1 | 69583 | 6 | 1.076 | 64668.2 |
334 | 2021-02-11 01:23:52 | refills | 1 | 69583 | 6 | 1.123 | 61961.7 |
333 | 2021-01-31 08:50:46 | refills | 1 | 69583 | 6 | 1.233 | 56433.9 |
332 | 2020-12-06 15:13:12 | refills | 1 | 69583 | 6 | 1.110 | 62687.4 |
331 | 2020-11-22 15:47:54 | refills | 1 | 69583 | 6 | 1.093 | 63662.4 |
330 | 2020-11-19 22:22:55 | refills | 1 | 69583 | 6 | 1.110 | 62687.4 |
329 | 2020-11-06 17:45:15 | refills | 1 | 69583 | 6 | 1.263 | 55093.4 |
328 | 2020-11-01 22:59:32 | refills | 1 | 69583 | 6 | 1.186 | 58670.3 |
327 | 2020-10-26 12:29:06 | refills | 1 | 69583 | 6 | 1.110 | 62687.4 |
326 | 2020-10-24 08:48:12 | refills | 1 | 69583 | 6 | 1.170 | 59472.6 |
325 | 2020-10-17 22:20:52 | refills | 1 | 69583 | 6 | 1.126 | 61796.6 |
324 | 2020-08-15 04:26:44 | refills | 1 | 69583 | 6 | 1.123 | 61961.7 |
323 | 2020-08-12 03:38:06 | refills | 1 | 69583 | 6 | 1.153 | 60349.5 |
322 | 2020-07-29 05:00:26 | refills | 1 | 69583 | 6 | 1.153 | 60349.5 |
321 | 2020-07-10 12:36:36 | refills | 1 | 69583 | 6 | 1.203 | 57841.2 |
320 | 2020-05-11 00:06:11 | refills | 1 | 69583 | 6 | 1.126 | 61796.6 |
319 | 2020-05-01 16:02:41 | refills | 1 | 69583 | 6 | 1.170 | 59472.6 |
318 | 2020-03-25 01:43:08 | refills | 1 | 69583 | 6 | 1.266 | 54962.9 |
317 | 2020-03-20 16:53:14 | refills | 1 | 69583 | 6 | 1.263 | 55093.4 |
316 | 2020-02-29 21:50:14 | refills | 1 | 69583 | 6 | 1.360 | 51164.0 |
315 | 2020-02-25 03:49:03 | refills | 1 | 69583 | 6 | 1.093 | 63662.4 |
314 | 2020-02-24 12:14:49 | refills | 1 | 69583 | 6 | 1.360 | 51164.0 |
313 | 2020-02-18 06:15:22 | refills | 1 | 69583 | 6 | 1.123 | 61961.7 |
312 | 2020-02-17 10:48:32 | refills | 1 | 69583 | 6 | 1.250 | 55666.4 |
311 | 2020-02-16 04:23:07 | refills | 1 | 69583 | 6 | 1.093 | 63662.4 |
310 | 2020-02-12 06:06:41 | refills | 1 | 69583 | 6 | 1.436 | 48456.1 |
309 | 2020-02-12 05:52:50 | refills | 1 | 69583 | 6 | 1.390 | 50059.7 |
308 | 2020-02-09 01:24:24 | refills | 1 | 69583 | 6 | 1.093 | 63662.4 |
307 | 2020-02-08 21:08:18 | refills | 1 | 69583 | 6 | 1.360 | 51164.0 |
306 | 2020-02-08 10:05:16 | refills | 1 | 69583 | 6 | 1.170 | 59472.6 |
305 | 2020-02-08 00:57:48 | refills | 1 | 69583 | 6 | 1.843 | 37755.3 |
304 | 2020-02-05 19:59:05 | refills | 1 | 69583 | 6 | 1.420 | 49002.1 |
303 | 2020-02-05 11:47:23 | refills | 1 | 69583 | 6 | 2.750 | 25302.9 |
302 | 2020-01-31 13:41:53 | refills | 1 | 69583 | 6 | 2.763 | 25183.9 |
301 | 2020-01-29 06:43:39 | refills | 1 | 69583 | 6 | 2.623 | 26528.0 |
300 | 2020-01-28 06:05:59 | refills | 1 | 69583 | 6 | 1.283 | 54234.6 |
299 | 2020-01-24 03:17:52 | refills | 1 | 69583 | 6 | 1.326 | 52475.9 |
298 | 2020-01-17 20:47:54 | refills | 1 | 69583 | 6 | 2.826 | 24622.4 |
297 | 2020-01-14 15:04:19 | refills | 1 | 69583 | 6 | 1.296 | 53690.6 |
296 | 2020-01-08 08:51:48 | refills | 1 | 69583 | 6 | 1.330 | 52318.0 |
295 | 2020-01-07 23:27:42 | refills | 1 | 69583 | 6 | 2.813 | 24736.2 |
294 | 2020-01-01 20:08:51 | refills | 1 | 69583 | 6 | 2.766 | 25156.5 |
293 | 2019-12-29 14:55:11 | refills | 1 | 69583 | 6 | 1.373 | 50679.5 |
292 | 2019-12-27 23:44:00 | refills | 1 | 69583 | 6 | 1.233 | 56433.9 |