History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prelude"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
395 | 2024-04-26 06:25:04 | prelude | 2 | 107671 | 28 | 3.533 | 30475.8 |
394 | 2024-04-26 06:23:44 | prelude | 3 | 134027 | 220 | 7.736 | 17325.1 |
393 | 2024-04-24 18:47:44 | prelude | 3 | 134027 | 220 | 10.220 | 13114.2 |
392 | 2024-04-23 11:10:07 | prelude | 3 | 134027 | 220 | 17.656 | 7591.0 |
391 | 2024-04-20 16:12:03 | prelude | 3 | 134027 | 220 | 12.186 | 10998.4 |
390 | 2024-04-20 16:12:11 | prelude | 1 | 69583 | 5 | 1.376 | 50569.0 |
389 | 2024-04-20 16:12:01 | prelude | 2 | 107671 | 28 | 3.936 | 27355.4 |
388 | 2024-03-28 07:34:08 | prelude | 1 | 69583 | 5 | 1.436 | 48456.1 |
387 | 2024-03-20 23:43:28 | prelude | 3 | 134027 | 220 | 21.860 | 6131.2 |
386 | 2024-03-19 22:01:59 | prelude | 3 | 134027 | 220 | 14.626 | 9163.6 |
385 | 2024-03-18 22:20:23 | prelude | 1 | 69583 | 5 | 5.266 | 13213.6 |
384 | 2024-03-18 22:20:02 | prelude | 3 | 134027 | 220 | 15.940 | 8408.2 |
383 | 2024-03-18 22:20:01 | prelude | 2 | 107671 | 28 | 7.956 | 13533.3 |
382 | 2024-02-22 03:13:27 | prelude | 3 | 134027 | 220 | 16.330 | 8207.4 |
381 | 2024-02-21 07:57:00 | prelude | 3 | 134027 | 220 | 8.656 | 15483.7 |
380 | 2024-02-17 19:19:11 | prelude | 3 | 134027 | 220 | 6.576 | 20381.2 |
379 | 2024-02-17 19:19:11 | prelude | 2 | 107671 | 28 | 3.313 | 32499.5 |
378 | 2024-02-12 11:07:11 | prelude | 1 | 69583 | 5 | 1.156 | 60192.9 |
377 | 2024-01-05 20:40:05 | prelude | 1 | 69583 | 5 | 1.203 | 57841.2 |
376 | 2023-12-16 05:44:36 | prelude | 1 | 69583 | 5 | 1.153 | 60349.5 |
375 | 2023-12-08 22:40:01 | prelude | 1 | 69583 | 5 | 1.203 | 57841.2 |
374 | 2023-12-02 21:43:43 | prelude | 1 | 69583 | 5 | 1.063 | 65459.1 |
373 | 2023-11-19 00:58:32 | prelude | 1 | 69583 | 5 | 1.110 | 62687.4 |
372 | 2023-11-05 20:48:07 | prelude | 1 | 69583 | 5 | 1.233 | 56433.9 |
371 | 2023-10-18 09:05:18 | prelude | 1 | 69583 | 5 | 1.233 | 56433.9 |
370 | 2023-10-15 16:00:52 | prelude | 1 | 69583 | 5 | 1.140 | 61037.7 |
369 | 2023-09-26 22:58:48 | prelude | 1 | 69583 | 5 | 1.110 | 62687.4 |
368 | 2023-09-18 07:14:26 | prelude | 1 | 69583 | 5 | 1.063 | 65459.1 |
367 | 2023-09-14 20:18:57 | prelude | 1 | 69583 | 5 | 1.203 | 57841.2 |
366 | 2023-08-31 02:07:09 | prelude | 1 | 69583 | 5 | 1.076 | 64668.2 |
365 | 2023-07-09 22:58:04 | prelude | 1 | 69583 | 5 | 1.156 | 60192.9 |
364 | 2023-05-10 09:41:25 | prelude | 1 | 69583 | 5 | 1.093 | 63662.4 |
363 | 2023-05-06 21:47:34 | prelude | 1 | 69583 | 5 | 1.126 | 61796.6 |
362 | 2023-04-17 06:20:46 | prelude | 1 | 69583 | 5 | 1.313 | 52995.4 |
361 | 2023-02-09 07:54:46 | prelude | 1 | 69583 | 5 | 1.233 | 56433.9 |
360 | 2023-01-13 09:41:50 | prelude | 1 | 69583 | 5 | 1.173 | 59320.5 |
359 | 2023-01-09 15:38:16 | prelude | 1 | 69583 | 5 | 1.063 | 65459.1 |
358 | 2022-12-07 06:59:31 | prelude | 1 | 69583 | 5 | 1.080 | 64428.7 |
357 | 2022-09-07 20:52:46 | prelude | 1 | 69583 | 5 | 1.093 | 63662.4 |
356 | 2022-09-02 07:09:04 | prelude | 1 | 69583 | 5 | 1.126 | 61796.6 |
355 | 2022-08-07 00:28:58 | prelude | 1 | 69583 | 5 | 1.096 | 63488.1 |
354 | 2022-05-09 12:35:56 | prelude | 1 | 69583 | 5 | 1.156 | 60192.9 |
353 | 2022-03-31 20:41:23 | prelude | 1 | 69583 | 5 | 1.593 | 43680.5 |
352 | 2022-03-29 17:12:23 | prelude | 1 | 69583 | 5 | 1.483 | 46920.4 |
351 | 2022-01-21 11:15:58 | prelude | 1 | 69583 | 5 | 1.173 | 59320.5 |
350 | 2022-01-18 04:51:57 | prelude | 1 | 69583 | 5 | 1.200 | 57985.8 |
349 | 2022-01-14 22:00:37 | prelude | 1 | 69583 | 5 | 1.360 | 51164.0 |
348 | 2022-01-11 15:39:38 | prelude | 1 | 69583 | 5 | 1.156 | 60192.9 |
347 | 2021-12-29 05:49:37 | prelude | 1 | 69583 | 5 | 1.283 | 54234.6 |
346 | 2021-11-15 07:52:39 | prelude | 1 | 69583 | 5 | 1.266 | 54962.9 |
345 | 2021-10-02 06:27:40 | prelude | 1 | 69583 | 5 | 1.220 | 57035.2 |
344 | 2021-09-29 01:12:13 | prelude | 1 | 69583 | 5 | 1.173 | 59320.5 |
343 | 2021-06-26 00:18:17 | prelude | 1 | 69583 | 5 | 1.296 | 53690.6 |
342 | 2021-06-22 18:06:11 | prelude | 1 | 69583 | 5 | 1.093 | 63662.4 |
341 | 2021-05-25 01:20:00 | prelude | 1 | 69583 | 5 | 1.200 | 57985.8 |
340 | 2021-04-28 12:26:15 | prelude | 1 | 69583 | 5 | 1.233 | 56433.9 |
339 | 2021-03-28 08:20:19 | prelude | 1 | 69583 | 5 | 1.203 | 57841.2 |
338 | 2021-03-20 13:39:34 | prelude | 1 | 69583 | 5 | 2.546 | 27330.3 |
337 | 2021-01-11 15:24:59 | prelude | 1 | 69583 | 5 | 1.140 | 61037.7 |
336 | 2020-12-17 15:53:10 | prelude | 1 | 69583 | 5 | 1.093 | 63662.4 |
335 | 2020-11-10 16:37:45 | prelude | 1 | 69583 | 5 | 1.110 | 62687.4 |
334 | 2020-11-09 20:50:29 | prelude | 1 | 69583 | 5 | 1.140 | 61037.7 |
333 | 2020-10-21 17:08:42 | prelude | 1 | 69583 | 5 | 1.080 | 64428.7 |
332 | 2020-10-04 18:28:32 | prelude | 1 | 69583 | 5 | 1.173 | 59320.5 |
331 | 2020-09-29 15:58:16 | prelude | 1 | 69583 | 5 | 1.076 | 64668.2 |
330 | 2020-09-20 05:51:54 | prelude | 1 | 69583 | 5 | 1.156 | 60192.9 |
329 | 2020-09-13 18:25:04 | prelude | 1 | 69583 | 5 | 1.080 | 64428.7 |
328 | 2020-09-08 02:20:51 | prelude | 1 | 69583 | 5 | 1.080 | 64428.7 |
327 | 2020-06-04 19:10:12 | prelude | 1 | 69583 | 5 | 1.076 | 64668.2 |
326 | 2020-03-29 14:31:30 | prelude | 1 | 69583 | 5 | 1.203 | 57841.2 |
325 | 2020-03-25 06:58:16 | prelude | 1 | 69583 | 5 | 1.280 | 54361.7 |
324 | 2020-03-24 04:46:35 | prelude | 1 | 69583 | 5 | 1.220 | 57035.2 |
323 | 2020-03-20 19:33:38 | prelude | 1 | 69583 | 5 | 1.076 | 64668.2 |
322 | 2020-03-03 06:57:02 | prelude | 1 | 69583 | 5 | 1.236 | 56296.9 |
321 | 2020-02-29 09:19:03 | prelude | 1 | 69583 | 5 | 1.390 | 50059.7 |
320 | 2020-02-28 17:04:34 | prelude | 3 | 134027 | 220 | 21.156 | 6335.2 |
319 | 2020-02-23 22:43:43 | prelude | 3 | 134027 | 220 | 10.516 | 12745.1 |
318 | 2020-02-23 14:33:34 | prelude | 1 | 69583 | 5 | 1.203 | 57841.2 |
317 | 2020-02-23 13:11:24 | prelude | 1 | 69583 | 5 | 2.733 | 25460.3 |
316 | 2020-02-23 12:42:12 | prelude | 3 | 134027 | 220 | 13.046 | 10273.4 |
315 | 2020-02-23 08:41:34 | prelude | 1 | 69583 | 5 | 1.530 | 45479.1 |
314 | 2020-02-22 06:16:52 | prelude | 3 | 134027 | 220 | 7.500 | 17870.3 |
313 | 2020-02-21 14:23:36 | prelude | 3 | 134027 | 220 | 8.190 | 16364.7 |
312 | 2020-02-21 09:23:22 | prelude | 3 | 134027 | 220 | 24.486 | 5473.6 |
311 | 2020-02-18 15:15:09 | prelude | 1 | 69583 | 5 | 1.250 | 55666.4 |
310 | 2020-02-12 04:33:09 | prelude | 1 | 69583 | 5 | 1.280 | 54361.7 |
309 | 2020-02-10 04:03:13 | prelude | 1 | 69583 | 5 | 1.920 | 36241.1 |
308 | 2020-02-04 00:13:05 | prelude | 1 | 69583 | 5 | 3.763 | 18491.4 |
307 | 2020-01-26 21:11:49 | prelude | 1 | 69583 | 5 | 1.330 | 52318.0 |
306 | 2020-01-26 21:02:27 | prelude | 1 | 69583 | 5 | 1.283 | 54234.6 |
305 | 2020-01-25 08:05:33 | prelude | 2 | 107671 | 28 | 3.046 | 35348.3 |
304 | 2020-01-21 00:35:00 | prelude | 1 | 69583 | 5 | 2.186 | 31831.2 |
303 | 2020-01-20 14:28:35 | prelude | 1 | 69583 | 5 | 4.000 | 17395.8 |
302 | 2020-01-15 13:01:51 | prelude | 3 | 134027 | 220 | 7.190 | 18640.8 |
301 | 2020-01-15 10:55:37 | prelude | 3 | 134027 | 220 | 7.936 | 16888.5 |
300 | 2020-01-15 06:28:12 | prelude | 3 | 134027 | 220 | 11.733 | 11423.1 |
299 | 2020-01-15 06:27:32 | prelude | 2 | 107671 | 28 | 8.373 | 12859.3 |
298 | 2020-01-15 00:17:58 | prelude | 1 | 69583 | 5 | 2.093 | 33245.6 |
297 | 2020-01-06 21:40:04 | prelude | 1 | 69583 | 5 | 2.750 | 25302.9 |
296 | 2020-01-03 03:51:43 | prelude | 1 | 69583 | 5 | 1.326 | 52475.9 |