History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"opium"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
365 | 2024-04-06 05:59:31 | opium | 1 | 28756 | 4 | 0.513 | 56054.6 |
364 | 2024-03-31 03:37:14 | opium | 2 | 53800 | 27 | 1.796 | 29955.5 |
363 | 2024-03-31 03:37:12 | opium | 1 | 28756 | 4 | 0.530 | 54256.6 |
362 | 2024-03-31 03:36:53 | opium | 3 | 83667 | 436 | 4.690 | 17839.4 |
361 | 2024-03-31 03:35:07 | opium | 1 | 28756 | 4 | 0.543 | 52957.6 |
360 | 2024-03-30 00:57:52 | opium | 3 | 83667 | 436 | 17.906 | 4672.6 |
359 | 2024-03-29 08:36:38 | opium | 3 | 83667 | 436 | 5.530 | 15129.7 |
358 | 2024-03-29 08:36:37 | opium | 2 | 53800 | 27 | 3.923 | 13714.0 |
357 | 2024-03-29 08:36:16 | opium | 1 | 28756 | 4 | 0.686 | 41918.4 |
356 | 2024-03-07 10:04:09 | opium | 3 | 83667 | 436 | 18.033 | 4639.7 |
355 | 2024-03-07 10:04:09 | opium | 2 | 53800 | 27 | 5.450 | 9871.6 |
354 | 2024-03-07 04:40:58 | opium | 1 | 28756 | 4 | 0.516 | 55728.7 |
353 | 2024-03-01 02:07:44 | opium | 1 | 28756 | 4 | 0.530 | 54256.6 |
352 | 2024-02-28 02:47:40 | opium | 1 | 28756 | 4 | 0.550 | 52283.6 |
351 | 2024-02-05 10:28:26 | opium | 1 | 28756 | 4 | 0.500 | 57512.0 |
350 | 2024-02-03 20:06:31 | opium | 1 | 28756 | 4 | 0.486 | 59168.7 |
349 | 2024-02-03 04:58:40 | opium | 1 | 28756 | 4 | 1.703 | 16885.5 |
348 | 2024-02-03 04:50:44 | opium | 2 | 53800 | 27 | 1.986 | 27089.6 |
347 | 2024-01-31 16:25:44 | opium | 2 | 53800 | 27 | 1.703 | 31591.3 |
346 | 2024-01-31 16:25:32 | opium | 3 | 83667 | 436 | 4.033 | 20745.6 |
345 | 2024-01-31 04:56:20 | opium | 2 | 53800 | 27 | 1.703 | 31591.3 |
344 | 2024-01-31 04:56:00 | opium | 3 | 83667 | 436 | 3.423 | 24442.6 |
343 | 2024-01-29 12:44:48 | opium | 3 | 83667 | 436 | 3.436 | 24350.1 |
342 | 2024-01-29 01:11:53 | opium | 1 | 28756 | 4 | 0.500 | 57512.0 |
341 | 2024-01-29 00:47:19 | opium | 1 | 28756 | 4 | 0.420 | 68466.7 |
340 | 2024-01-17 09:18:16 | opium | 3 | 83667 | 436 | 3.766 | 22216.4 |
339 | 2024-01-12 00:23:59 | opium | 2 | 53800 | 27 | 1.720 | 31279.1 |
338 | 2024-01-07 20:38:53 | opium | 1 | 28756 | 4 | 0.453 | 63479.0 |
337 | 2024-01-05 15:08:06 | opium | 2 | 53800 | 27 | 1.656 | 32487.9 |
336 | 2024-01-05 05:40:49 | opium | 1 | 28756 | 4 | 0.470 | 61183.0 |
335 | 2023-12-15 15:54:46 | opium | 2 | 53800 | 27 | 1.580 | 34050.6 |
334 | 2023-11-25 16:44:03 | opium | 1 | 28756 | 4 | 0.500 | 57512.0 |
333 | 2023-11-17 09:16:27 | opium | 3 | 83667 | 436 | 4.326 | 19340.5 |
332 | 2023-11-15 18:25:33 | opium | 1 | 28756 | 4 | 0.436 | 65954.1 |
331 | 2023-11-14 08:24:36 | opium | 1 | 28756 | 4 | 0.436 | 65954.1 |
330 | 2023-11-11 16:36:07 | opium | 3 | 83667 | 436 | 3.623 | 23093.3 |
329 | 2023-11-08 01:56:21 | opium | 3 | 83667 | 436 | 3.766 | 22216.4 |
328 | 2023-11-07 01:08:48 | opium | 1 | 28756 | 4 | 0.483 | 59536.2 |
327 | 2023-11-02 07:30:22 | opium | 3 | 83667 | 436 | 5.046 | 16580.9 |
326 | 2023-11-02 07:30:20 | opium | 2 | 53800 | 27 | 1.513 | 35558.5 |
325 | 2023-11-02 06:22:54 | opium | 1 | 28756 | 4 | 0.500 | 57512.0 |
324 | 2023-10-30 20:35:20 | opium | 1 | 28756 | 4 | 0.533 | 53951.2 |
323 | 2023-10-23 23:57:13 | opium | 1 | 28756 | 4 | 0.516 | 55728.7 |
322 | 2023-10-18 01:50:15 | opium | 1 | 28756 | 4 | 0.530 | 54256.6 |
321 | 2023-10-17 11:53:27 | opium | 2 | 53800 | 27 | 1.550 | 34709.7 |
320 | 2023-10-16 11:14:08 | opium | 1 | 28756 | 4 | 0.513 | 56054.6 |
319 | 2023-10-04 01:24:21 | opium | 1 | 28756 | 4 | 0.440 | 65354.5 |
318 | 2023-09-26 19:20:44 | opium | 1 | 28756 | 4 | 0.483 | 59536.2 |
317 | 2023-09-14 12:13:53 | opium | 1 | 28756 | 4 | 0.513 | 56054.6 |
316 | 2023-09-06 04:06:49 | opium | 1 | 28756 | 4 | 0.440 | 65354.5 |
315 | 2023-08-23 21:23:29 | opium | 1 | 28756 | 4 | 0.483 | 59536.2 |
314 | 2023-08-12 16:16:06 | opium | 3 | 83667 | 436 | 3.890 | 21508.2 |
313 | 2023-07-28 03:45:06 | opium | 2 | 53800 | 27 | 1.406 | 38264.6 |
312 | 2023-05-25 18:47:30 | opium | 1 | 28756 | 4 | 0.500 | 57512.0 |
311 | 2023-05-13 10:42:01 | opium | 1 | 28756 | 4 | 0.436 | 65954.1 |
310 | 2023-04-25 01:21:54 | opium | 3 | 83667 | 436 | 3.203 | 26121.4 |
309 | 2023-04-05 04:29:26 | opium | 2 | 53800 | 27 | 1.343 | 40059.6 |
308 | 2023-03-19 14:03:55 | opium | 1 | 28756 | 4 | 0.440 | 65354.5 |
307 | 2023-01-29 11:42:54 | opium | 3 | 83667 | 436 | 4.046 | 20678.9 |
306 | 2023-01-20 05:40:58 | opium | 1 | 28756 | 4 | 0.436 | 65954.1 |
305 | 2023-01-09 03:06:16 | opium | 1 | 28756 | 4 | 0.986 | 29164.3 |
304 | 2023-01-05 20:35:00 | opium | 1 | 28756 | 4 | 0.436 | 65954.1 |
303 | 2023-01-01 23:48:27 | opium | 2 | 53800 | 27 | 1.356 | 39675.5 |
302 | 2022-11-28 11:49:09 | opium | 1 | 28756 | 4 | 0.453 | 63479.0 |
301 | 2022-11-09 08:05:57 | opium | 3 | 83667 | 436 | 3.313 | 25254.2 |
300 | 2022-09-27 01:56:17 | opium | 1 | 28756 | 4 | 0.486 | 59168.7 |
299 | 2022-09-21 14:59:28 | opium | 1 | 28756 | 4 | 0.423 | 67981.1 |
298 | 2022-09-05 21:47:06 | opium | 2 | 53800 | 27 | 1.356 | 39675.5 |
297 | 2022-08-26 14:31:01 | opium | 1 | 28756 | 4 | 0.513 | 56054.6 |
296 | 2022-07-10 02:39:52 | opium | 1 | 28756 | 4 | 0.500 | 57512.0 |
295 | 2022-06-25 07:53:36 | opium | 1 | 28756 | 4 | 0.453 | 63479.0 |
294 | 2022-06-14 18:16:29 | opium | 3 | 83667 | 436 | 3.470 | 24111.5 |
293 | 2022-05-22 14:27:32 | opium | 1 | 28756 | 4 | 0.500 | 57512.0 |
292 | 2022-05-19 04:46:36 | opium | 1 | 28756 | 4 | 0.533 | 53951.2 |
291 | 2022-05-15 01:52:37 | opium | 3 | 83667 | 436 | 3.296 | 25384.4 |
290 | 2022-05-09 17:36:26 | opium | 1 | 28756 | 4 | 0.736 | 39070.7 |
289 | 2022-05-07 13:30:43 | opium | 1 | 28756 | 4 | 0.453 | 63479.0 |
288 | 2022-01-27 23:33:44 | opium | 1 | 28756 | 4 | 0.456 | 63061.4 |
287 | 2022-01-26 12:54:38 | opium | 1 | 28756 | 4 | 0.530 | 54256.6 |
286 | 2022-01-12 08:44:24 | opium | 1 | 28756 | 4 | 0.436 | 65954.1 |
285 | 2022-01-12 02:43:29 | opium | 1 | 28756 | 4 | 0.513 | 56054.6 |
284 | 2021-11-29 17:09:47 | opium | 1 | 28756 | 4 | 0.470 | 61183.0 |
283 | 2021-11-23 23:59:29 | opium | 1 | 28756 | 4 | 0.530 | 54256.6 |
282 | 2021-10-24 02:48:16 | opium | 1 | 28756 | 4 | 0.483 | 59536.2 |
281 | 2021-10-22 02:27:44 | opium | 1 | 28756 | 4 | 0.470 | 61183.0 |
280 | 2021-10-11 07:20:09 | opium | 1 | 28756 | 4 | 0.436 | 65954.1 |
279 | 2021-07-09 18:02:10 | opium | 1 | 28756 | 4 | 0.453 | 63479.0 |
278 | 2021-05-28 07:35:56 | opium | 1 | 28756 | 4 | 0.513 | 56054.6 |
277 | 2021-05-03 13:34:06 | opium | 1 | 28756 | 4 | 0.513 | 56054.6 |
276 | 2021-05-02 13:14:56 | opium | 1 | 28756 | 4 | 0.500 | 57512.0 |
275 | 2021-05-01 13:47:46 | opium | 1 | 28756 | 4 | 0.533 | 53951.2 |
274 | 2021-04-30 16:10:48 | opium | 1 | 28756 | 4 | 0.483 | 59536.2 |
273 | 2021-04-05 21:27:28 | opium | 1 | 28756 | 4 | 0.453 | 63479.0 |
272 | 2021-04-03 08:47:57 | opium | 1 | 28756 | 4 | 0.483 | 59536.2 |
271 | 2021-04-01 17:02:50 | opium | 1 | 28756 | 4 | 0.436 | 65954.1 |
270 | 2021-01-15 10:23:19 | opium | 1 | 28756 | 4 | 0.486 | 59168.7 |
269 | 2020-12-24 11:18:46 | opium | 1 | 28756 | 4 | 0.436 | 65954.1 |
268 | 2020-12-16 16:44:28 | opium | 1 | 28756 | 4 | 0.436 | 65954.1 |
267 | 2020-10-31 12:52:23 | opium | 1 | 28756 | 4 | 0.440 | 65354.5 |
266 | 2020-10-29 15:38:25 | opium | 1 | 28756 | 4 | 0.453 | 63479.0 |