History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"piffle"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
368 | 2024-04-27 20:19:24 | piffle | 1 | 48755 | 4 | 1.016 | 47987.2 |
367 | 2024-04-27 10:35:38 | piffle | 1 | 48755 | 4 | 1.703 | 28628.9 |
366 | 2024-04-20 17:42:19 | piffle | 1 | 48755 | 4 | 2.703 | 18037.4 |
365 | 2024-03-30 19:36:57 | piffle | 3 | 112716 | 336 | 16.733 | 6736.2 |
364 | 2024-03-29 21:04:46 | piffle | 2 | 82551 | 28 | 2.623 | 31472.0 |
363 | 2024-03-29 21:04:33 | piffle | 3 | 112716 | 336 | 4.953 | 22757.1 |
362 | 2024-03-29 05:20:05 | piffle | 3 | 112716 | 336 | 12.156 | 9272.5 |
361 | 2024-03-29 05:20:07 | piffle | 2 | 82551 | 28 | 3.450 | 23927.8 |
360 | 2024-03-29 05:19:59 | piffle | 1 | 48755 | 4 | 2.030 | 24017.2 |
359 | 2024-03-29 05:19:45 | piffle | 2 | 82551 | 28 | 7.423 | 11121.0 |
358 | 2024-03-29 05:19:39 | piffle | 3 | 112716 | 336 | 8.186 | 13769.4 |
357 | 2024-03-29 05:19:34 | piffle | 1 | 48755 | 4 | 1.873 | 26030.4 |
356 | 2024-03-15 14:42:11 | piffle | 1 | 48755 | 4 | 0.843 | 57835.1 |
355 | 2024-03-06 20:59:23 | piffle | 1 | 48755 | 4 | 2.546 | 19149.6 |
354 | 2024-02-28 03:10:08 | piffle | 2 | 82551 | 28 | 3.063 | 26951.0 |
353 | 2024-02-28 03:10:03 | piffle | 1 | 48755 | 4 | 1.000 | 48755.0 |
352 | 2024-02-22 09:57:14 | piffle | 3 | 112716 | 336 | 5.313 | 21215.1 |
351 | 2024-02-22 09:57:13 | piffle | 2 | 82551 | 28 | 2.530 | 32628.9 |
350 | 2024-01-09 06:42:46 | piffle | 2 | 82551 | 28 | 2.250 | 36689.3 |
349 | 2024-01-09 01:10:51 | piffle | 3 | 112716 | 336 | 5.720 | 19705.6 |
348 | 2024-01-04 19:49:48 | piffle | 3 | 112716 | 336 | 4.690 | 24033.3 |
347 | 2024-01-04 19:49:47 | piffle | 2 | 82551 | 28 | 2.330 | 35429.6 |
346 | 2023-12-15 14:19:23 | piffle | 1 | 48755 | 4 | 0.750 | 65006.7 |
345 | 2023-11-19 13:49:42 | piffle | 1 | 48755 | 4 | 0.826 | 59025.4 |
344 | 2023-11-17 02:39:10 | piffle | 1 | 48755 | 4 | 0.783 | 62266.9 |
343 | 2023-11-16 01:46:44 | piffle | 3 | 112716 | 336 | 5.643 | 19974.5 |
342 | 2023-11-16 01:46:46 | piffle | 2 | 82551 | 28 | 2.580 | 31996.5 |
341 | 2023-11-14 00:54:09 | piffle | 1 | 48755 | 4 | 0.876 | 55656.4 |
340 | 2023-11-06 20:04:52 | piffle | 1 | 48755 | 4 | 0.750 | 65006.7 |
339 | 2023-10-21 11:01:54 | piffle | 1 | 48755 | 4 | 0.796 | 61250.0 |
338 | 2023-10-19 00:33:32 | piffle | 1 | 48755 | 4 | 0.860 | 56691.9 |
337 | 2023-10-16 21:01:25 | piffle | 1 | 48755 | 4 | 1.766 | 27607.6 |
336 | 2023-10-05 01:16:37 | piffle | 1 | 48755 | 4 | 0.830 | 58741.0 |
335 | 2023-10-02 18:23:46 | piffle | 1 | 48755 | 4 | 0.830 | 58741.0 |
334 | 2023-09-27 07:19:39 | piffle | 3 | 112716 | 336 | 5.063 | 22262.7 |
333 | 2023-09-27 07:19:41 | piffle | 2 | 82551 | 28 | 2.406 | 34310.5 |
332 | 2023-09-25 23:02:56 | piffle | 1 | 48755 | 4 | 0.813 | 59969.2 |
331 | 2023-09-12 19:09:52 | piffle | 1 | 48755 | 4 | 0.860 | 56691.9 |
330 | 2023-07-31 13:17:08 | piffle | 1 | 48755 | 4 | 0.733 | 66514.3 |
329 | 2023-07-22 09:20:41 | piffle | 1 | 48755 | 4 | 0.873 | 55847.7 |
328 | 2023-04-28 11:21:57 | piffle | 1 | 48755 | 4 | 0.826 | 59025.4 |
327 | 2023-04-03 07:14:46 | piffle | 1 | 48755 | 4 | 0.813 | 59969.2 |
326 | 2023-02-20 01:45:35 | piffle | 1 | 48755 | 4 | 0.733 | 66514.3 |
325 | 2022-12-16 23:35:13 | piffle | 1 | 48755 | 4 | 0.720 | 67715.3 |
324 | 2022-12-08 13:20:54 | piffle | 1 | 48755 | 4 | 1.703 | 28628.9 |
323 | 2022-08-29 02:09:34 | piffle | 1 | 48755 | 4 | 0.733 | 66514.3 |
322 | 2022-08-08 08:34:54 | piffle | 1 | 48755 | 4 | 0.763 | 63899.1 |
321 | 2022-04-13 19:04:23 | piffle | 1 | 48755 | 4 | 1.203 | 40527.8 |
320 | 2022-04-07 02:33:29 | piffle | 1 | 48755 | 4 | 0.843 | 57835.1 |
319 | 2022-01-11 16:09:03 | piffle | 1 | 48755 | 4 | 0.796 | 61250.0 |
318 | 2021-12-16 17:30:03 | piffle | 1 | 48755 | 4 | 0.783 | 62266.9 |
317 | 2021-11-09 17:11:22 | piffle | 1 | 48755 | 4 | 0.920 | 52994.6 |
316 | 2021-11-07 19:31:58 | piffle | 1 | 48755 | 4 | 0.843 | 57835.1 |
315 | 2021-09-27 07:46:01 | piffle | 1 | 48755 | 4 | 1.673 | 29142.3 |
314 | 2021-09-25 04:46:22 | piffle | 1 | 48755 | 4 | 0.843 | 57835.1 |
313 | 2021-09-05 18:42:22 | piffle | 1 | 48755 | 4 | 0.813 | 59969.2 |
312 | 2021-09-02 22:57:25 | piffle | 1 | 48755 | 4 | 0.826 | 59025.4 |
311 | 2021-06-22 03:48:35 | piffle | 1 | 48755 | 4 | 0.733 | 66514.3 |
310 | 2021-06-02 21:30:54 | piffle | 1 | 48755 | 4 | 1.030 | 47335.0 |
309 | 2021-05-29 23:11:45 | piffle | 1 | 48755 | 4 | 0.890 | 54780.9 |
308 | 2021-04-07 04:29:12 | piffle | 1 | 48755 | 4 | 0.843 | 57835.1 |
307 | 2021-03-11 09:53:21 | piffle | 1 | 48755 | 4 | 0.796 | 61250.0 |
306 | 2021-02-27 07:28:03 | piffle | 1 | 48755 | 4 | 0.750 | 65006.7 |
305 | 2021-01-26 23:06:41 | piffle | 3 | 112716 | 336 | 5.326 | 21163.3 |
304 | 2021-01-22 07:18:20 | piffle | 1 | 48755 | 4 | 0.750 | 65006.7 |
303 | 2020-12-26 02:27:05 | piffle | 2 | 82551 | 28 | 2.126 | 38829.3 |
302 | 2020-11-22 15:09:53 | piffle | 1 | 48755 | 4 | 0.766 | 63648.8 |
301 | 2020-11-07 09:26:02 | piffle | 3 | 112716 | 336 | 4.736 | 23799.8 |
300 | 2020-10-07 04:47:42 | piffle | 1 | 48755 | 4 | 0.750 | 65006.7 |
299 | 2020-08-30 07:22:04 | piffle | 1 | 48755 | 4 | 0.830 | 58741.0 |
298 | 2020-08-21 11:19:03 | piffle | 1 | 48755 | 4 | 0.843 | 57835.1 |
297 | 2020-08-06 01:28:04 | piffle | 1 | 48755 | 4 | 1.110 | 43923.4 |
296 | 2020-08-02 20:02:03 | piffle | 1 | 48755 | 4 | 0.830 | 58741.0 |
295 | 2020-05-20 03:28:50 | piffle | 1 | 48755 | 4 | 0.733 | 66514.3 |
294 | 2020-04-28 04:28:33 | piffle | 1 | 48755 | 4 | 0.856 | 56956.8 |
293 | 2020-03-29 00:02:01 | piffle | 1 | 48755 | 4 | 1.766 | 27607.6 |
292 | 2020-03-24 19:01:10 | piffle | 1 | 48755 | 4 | 0.750 | 65006.7 |
291 | 2020-03-24 03:52:32 | piffle | 1 | 48755 | 4 | 0.906 | 53813.5 |
290 | 2020-03-20 11:05:39 | piffle | 1 | 48755 | 4 | 0.780 | 62506.4 |
289 | 2020-02-29 16:41:33 | piffle | 1 | 48755 | 4 | 1.843 | 26454.2 |
288 | 2020-02-26 21:38:30 | piffle | 3 | 112716 | 336 | 6.266 | 17988.5 |
287 | 2020-02-26 04:33:23 | piffle | 1 | 48755 | 4 | 0.890 | 54780.9 |
286 | 2020-02-18 15:08:08 | piffle | 1 | 48755 | 4 | 1.923 | 25353.6 |
285 | 2020-02-17 09:38:08 | piffle | 1 | 48755 | 4 | 0.860 | 56691.9 |
284 | 2020-02-17 04:45:09 | piffle | 1 | 48755 | 4 | 1.003 | 48609.2 |
283 | 2020-02-14 09:19:28 | piffle | 3 | 112716 | 336 | 6.436 | 17513.4 |
282 | 2020-02-14 06:53:27 | piffle | 3 | 112716 | 336 | 18.140 | 6213.7 |
281 | 2020-02-14 05:16:00 | piffle | 3 | 112716 | 336 | 11.376 | 9908.2 |
280 | 2020-02-13 21:44:42 | piffle | 3 | 112716 | 336 | 4.986 | 22606.5 |
279 | 2020-02-13 15:07:37 | piffle | 3 | 112716 | 336 | 11.140 | 10118.1 |
278 | 2020-02-13 09:04:46 | piffle | 3 | 112716 | 336 | 9.373 | 12025.6 |
277 | 2020-02-07 17:09:10 | piffle | 1 | 48755 | 4 | 0.843 | 57835.1 |
276 | 2020-02-07 09:54:44 | piffle | 1 | 48755 | 4 | 1.846 | 26411.2 |
275 | 2020-02-05 06:00:15 | piffle | 1 | 48755 | 4 | 0.923 | 52822.3 |
274 | 2020-02-03 16:29:43 | piffle | 1 | 48755 | 4 | 0.860 | 56691.9 |
273 | 2020-01-28 22:40:42 | piffle | 1 | 48755 | 4 | 0.923 | 52822.3 |
272 | 2020-01-24 09:10:35 | piffle | 1 | 48755 | 4 | 0.873 | 55847.7 |
271 | 2020-01-15 23:29:52 | piffle | 1 | 48755 | 4 | 0.983 | 49598.2 |
270 | 2020-01-15 12:20:39 | piffle | 1 | 48755 | 4 | 0.903 | 53992.2 |
269 | 2020-01-15 11:14:04 | piffle | 1 | 48755 | 4 | 2.906 | 16777.4 |