History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spicier"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
384 | 2024-04-05 01:11:53 | spicier | 1 | 69583 | 6 | 1.123 | 61961.7 |
383 | 2024-03-15 09:49:08 | spicier | 3 | 134027 | 533 | 23.550 | 5691.2 |
382 | 2024-03-07 10:40:41 | spicier | 3 | 134027 | 533 | 12.923 | 10371.2 |
381 | 2024-03-05 03:23:32 | spicier | 3 | 134027 | 533 | 14.766 | 9076.7 |
380 | 2024-03-04 21:56:23 | spicier | 3 | 134027 | 533 | 16.033 | 8359.4 |
379 | 2024-03-03 12:19:49 | spicier | 1 | 69583 | 6 | 2.203 | 31585.6 |
378 | 2024-03-01 22:17:18 | spicier | 3 | 134027 | 533 | 16.266 | 8239.7 |
377 | 2024-02-25 22:16:41 | spicier | 3 | 134027 | 533 | 7.563 | 17721.4 |
376 | 2024-02-25 17:04:03 | spicier | 1 | 69583 | 6 | 1.390 | 50059.7 |
375 | 2024-01-31 20:13:56 | spicier | 2 | 107671 | 53 | 3.516 | 30623.2 |
374 | 2024-01-31 20:03:12 | spicier | 3 | 134027 | 533 | 6.610 | 20276.4 |
373 | 2024-01-31 00:42:34 | spicier | 2 | 107671 | 53 | 3.766 | 28590.3 |
372 | 2024-01-31 00:42:06 | spicier | 3 | 134027 | 533 | 7.390 | 18136.3 |
371 | 2024-01-12 16:25:35 | spicier | 2 | 107671 | 53 | 3.003 | 35854.5 |
370 | 2024-01-09 14:17:38 | spicier | 3 | 134027 | 533 | 7.470 | 17942.0 |
369 | 2023-12-30 11:54:09 | spicier | 1 | 69583 | 6 | 1.106 | 62914.1 |
368 | 2023-12-27 06:21:22 | spicier | 1 | 69583 | 6 | 1.093 | 63662.4 |
367 | 2023-12-14 14:52:00 | spicier | 3 | 134027 | 533 | 6.313 | 21230.3 |
366 | 2023-12-14 14:51:59 | spicier | 2 | 107671 | 53 | 3.203 | 33615.7 |
365 | 2023-12-08 22:28:47 | spicier | 1 | 69583 | 6 | 1.080 | 64428.7 |
364 | 2023-12-08 01:04:02 | spicier | 1 | 69583 | 6 | 1.203 | 57841.2 |
363 | 2023-11-20 07:29:26 | spicier | 3 | 134027 | 533 | 6.596 | 20319.4 |
362 | 2023-11-19 21:16:35 | spicier | 1 | 69583 | 6 | 2.546 | 27330.3 |
361 | 2023-11-17 04:32:51 | spicier | 3 | 134027 | 533 | 7.016 | 19103.1 |
360 | 2023-11-17 04:32:52 | spicier | 2 | 107671 | 53 | 3.483 | 30913.3 |
359 | 2023-11-11 10:40:42 | spicier | 1 | 69583 | 6 | 1.203 | 57841.2 |
358 | 2023-10-21 13:47:34 | spicier | 1 | 69583 | 6 | 1.110 | 62687.4 |
357 | 2023-10-17 22:31:23 | spicier | 1 | 69583 | 6 | 1.093 | 63662.4 |
356 | 2023-10-17 16:08:55 | spicier | 1 | 69583 | 6 | 1.123 | 61961.7 |
355 | 2023-10-04 21:17:54 | spicier | 1 | 69583 | 6 | 1.110 | 62687.4 |
354 | 2023-09-27 19:23:55 | spicier | 1 | 69583 | 6 | 1.203 | 57841.2 |
353 | 2023-09-25 02:16:07 | spicier | 1 | 69583 | 6 | 1.186 | 58670.3 |
352 | 2023-09-22 18:45:11 | spicier | 1 | 69583 | 6 | 1.296 | 53690.6 |
351 | 2023-08-21 11:48:40 | spicier | 1 | 69583 | 6 | 1.110 | 62687.4 |
350 | 2023-08-20 06:15:41 | spicier | 3 | 134027 | 533 | 5.750 | 23309.0 |
349 | 2023-07-15 12:23:35 | spicier | 1 | 69583 | 6 | 1.170 | 59472.6 |
348 | 2023-05-04 20:54:58 | spicier | 3 | 134027 | 533 | 6.236 | 21492.5 |
347 | 2023-04-26 12:45:29 | spicier | 1 | 69583 | 6 | 1.106 | 62914.1 |
346 | 2023-04-17 01:37:17 | spicier | 1 | 69583 | 6 | 1.063 | 65459.1 |
345 | 2023-02-09 17:41:26 | spicier | 3 | 134027 | 533 | 5.670 | 23637.9 |
344 | 2023-02-09 13:05:42 | spicier | 1 | 69583 | 6 | 1.063 | 65459.1 |
343 | 2022-12-30 06:03:08 | spicier | 1 | 69583 | 6 | 1.216 | 57222.9 |
342 | 2022-12-07 12:56:31 | spicier | 1 | 69583 | 6 | 1.076 | 64668.2 |
341 | 2022-11-22 09:12:57 | spicier | 3 | 134027 | 533 | 6.873 | 19500.5 |
340 | 2022-08-29 15:29:30 | spicier | 1 | 69583 | 6 | 1.156 | 60192.9 |
339 | 2022-08-04 22:13:10 | spicier | 1 | 69583 | 6 | 1.110 | 62687.4 |
338 | 2022-07-01 02:15:15 | spicier | 2 | 107671 | 53 | 2.766 | 38926.6 |
337 | 2022-06-29 14:01:10 | spicier | 3 | 134027 | 533 | 5.736 | 23365.9 |
336 | 2022-06-27 09:58:50 | spicier | 3 | 134027 | 533 | 6.156 | 21771.8 |
335 | 2022-05-17 16:35:07 | spicier | 1 | 69583 | 6 | 1.390 | 50059.7 |
334 | 2022-04-27 13:19:24 | spicier | 3 | 134027 | 533 | 11.516 | 11638.3 |
333 | 2022-04-18 15:16:09 | spicier | 1 | 69583 | 6 | 1.656 | 42018.7 |
332 | 2022-04-01 03:30:00 | spicier | 1 | 69583 | 6 | 1.346 | 51696.1 |
331 | 2022-03-14 01:49:40 | spicier | 3 | 134027 | 533 | 5.843 | 22938.0 |
330 | 2022-02-14 12:07:59 | spicier | 2 | 107671 | 53 | 2.890 | 37256.4 |
329 | 2022-02-06 13:58:28 | spicier | 3 | 134027 | 533 | 7.466 | 17951.6 |
328 | 2022-01-04 21:49:33 | spicier | 1 | 69583 | 6 | 1.220 | 57035.2 |
327 | 2021-12-24 02:52:34 | spicier | 1 | 69583 | 6 | 1.283 | 54234.6 |
326 | 2021-11-22 16:22:31 | spicier | 1 | 69583 | 6 | 1.080 | 64428.7 |
325 | 2021-11-19 08:05:36 | spicier | 2 | 107671 | 53 | 2.840 | 37912.3 |
324 | 2021-11-05 05:19:35 | spicier | 1 | 69583 | 6 | 1.233 | 56433.9 |
323 | 2021-10-26 09:39:38 | spicier | 1 | 69583 | 6 | 1.326 | 52475.9 |
322 | 2021-10-01 05:12:06 | spicier | 1 | 69583 | 6 | 1.093 | 63662.4 |
321 | 2021-09-29 01:34:47 | spicier | 1 | 69583 | 6 | 1.076 | 64668.2 |
320 | 2021-09-09 19:15:55 | spicier | 1 | 69583 | 6 | 1.220 | 57035.2 |
319 | 2021-09-07 13:53:50 | spicier | 1 | 69583 | 6 | 1.080 | 64428.7 |
318 | 2021-09-03 23:27:07 | spicier | 1 | 69583 | 6 | 1.220 | 57035.2 |
317 | 2021-05-27 15:41:00 | spicier | 1 | 69583 | 6 | 1.093 | 63662.4 |
316 | 2021-05-18 09:21:29 | spicier | 1 | 69583 | 6 | 1.110 | 62687.4 |
315 | 2021-05-17 21:19:52 | spicier | 1 | 69583 | 6 | 1.250 | 55666.4 |
314 | 2021-05-15 07:37:04 | spicier | 2 | 107671 | 53 | 3.233 | 33303.7 |
313 | 2021-04-14 10:23:47 | spicier | 2 | 107671 | 53 | 2.873 | 37476.9 |
312 | 2021-02-21 09:07:43 | spicier | 1 | 69583 | 6 | 1.076 | 64668.2 |
311 | 2021-02-18 14:38:29 | spicier | 1 | 69583 | 6 | 1.093 | 63662.4 |
310 | 2021-01-30 07:27:30 | spicier | 1 | 69583 | 6 | 1.143 | 60877.5 |
309 | 2021-01-27 23:36:11 | spicier | 2 | 107671 | 53 | 2.893 | 37217.8 |
308 | 2021-01-03 00:42:29 | spicier | 1 | 69583 | 6 | 1.203 | 57841.2 |
307 | 2020-12-06 06:08:46 | spicier | 1 | 69583 | 6 | 1.076 | 64668.2 |
306 | 2020-11-09 13:17:34 | spicier | 1 | 69583 | 6 | 1.140 | 61037.7 |
305 | 2020-10-27 21:27:07 | spicier | 1 | 69583 | 6 | 1.186 | 58670.3 |
304 | 2020-09-22 20:54:09 | spicier | 1 | 69583 | 6 | 1.173 | 59320.5 |
303 | 2020-09-06 10:50:08 | spicier | 1 | 69583 | 6 | 1.110 | 62687.4 |
302 | 2020-08-17 16:31:08 | spicier | 1 | 69583 | 6 | 1.220 | 57035.2 |
301 | 2020-08-01 17:26:11 | spicier | 1 | 69583 | 6 | 1.330 | 52318.0 |
300 | 2020-07-31 18:57:31 | spicier | 1 | 69583 | 6 | 1.406 | 49490.0 |
299 | 2020-07-30 00:22:19 | spicier | 1 | 69583 | 6 | 1.300 | 53525.4 |
298 | 2020-05-16 10:50:26 | spicier | 1 | 69583 | 6 | 1.216 | 57222.9 |
297 | 2020-04-29 07:59:12 | spicier | 1 | 69583 | 6 | 1.123 | 61961.7 |
296 | 2020-03-21 05:14:34 | spicier | 1 | 69583 | 6 | 1.266 | 54962.9 |
295 | 2020-02-26 05:44:49 | spicier | 1 | 69583 | 6 | 1.280 | 54361.7 |
294 | 2020-02-20 08:17:44 | spicier | 1 | 69583 | 6 | 2.533 | 27470.6 |
293 | 2020-02-20 04:19:57 | spicier | 1 | 69583 | 6 | 1.140 | 61037.7 |
292 | 2020-02-18 12:21:30 | spicier | 1 | 69583 | 6 | 1.126 | 61796.6 |
291 | 2020-02-16 03:10:11 | spicier | 1 | 69583 | 6 | 1.200 | 57985.8 |
290 | 2020-02-14 14:49:46 | spicier | 1 | 69583 | 6 | 1.263 | 55093.4 |
289 | 2020-02-11 01:38:09 | spicier | 1 | 69583 | 6 | 2.780 | 25029.9 |
288 | 2020-02-10 15:59:04 | spicier | 1 | 69583 | 6 | 2.626 | 26497.7 |
287 | 2020-02-05 13:34:58 | spicier | 1 | 69583 | 6 | 1.330 | 52318.0 |
286 | 2020-01-30 07:20:52 | spicier | 1 | 69583 | 6 | 2.593 | 26834.9 |
285 | 2020-01-28 10:49:47 | spicier | 1 | 69583 | 6 | 1.330 | 52318.0 |