History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"letters"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
413 | 2024-03-03 23:58:35 | letters | 1 | 69583 | 13 | 2.483 | 28023.8 |
412 | 2024-01-25 23:24:48 | letters | 1 | 69583 | 13 | 1.250 | 55666.4 |
411 | 2023-12-24 01:56:59 | letters | 1 | 69583 | 13 | 1.060 | 65644.3 |
410 | 2023-12-10 13:33:10 | letters | 1 | 69583 | 13 | 1.373 | 50679.5 |
409 | 2023-12-09 17:37:37 | letters | 2 | 107671 | 156 | 3.250 | 33129.5 |
408 | 2023-11-30 17:34:37 | letters | 1 | 69583 | 13 | 1.140 | 61037.7 |
407 | 2023-11-29 11:12:00 | letters | 1 | 69583 | 13 | 1.233 | 56433.9 |
406 | 2023-11-28 14:54:17 | letters | 1 | 69583 | 13 | 1.233 | 56433.9 |
405 | 2023-11-27 02:02:37 | letters | 1 | 69583 | 13 | 1.360 | 51164.0 |
404 | 2023-11-20 10:52:35 | letters | 1 | 69583 | 13 | 1.220 | 57035.2 |
403 | 2023-11-11 07:24:44 | letters | 1 | 69583 | 13 | 1.063 | 65459.1 |
402 | 2023-10-30 12:05:03 | letters | 1 | 69583 | 13 | 1.330 | 52318.0 |
401 | 2023-10-20 04:44:26 | letters | 1 | 69583 | 13 | 1.063 | 65459.1 |
400 | 2023-10-17 06:12:06 | letters | 1 | 69583 | 13 | 1.280 | 54361.7 |
399 | 2023-10-04 21:57:28 | letters | 1 | 69583 | 13 | 1.093 | 63662.4 |
398 | 2023-09-24 04:15:14 | letters | 1 | 69583 | 13 | 1.046 | 66522.9 |
397 | 2023-09-23 09:58:14 | letters | 1 | 69583 | 13 | 1.060 | 65644.3 |
396 | 2023-09-07 06:08:33 | letters | 1 | 69583 | 13 | 1.140 | 61037.7 |
395 | 2023-08-11 17:07:08 | letters | 1 | 69583 | 13 | 1.233 | 56433.9 |
394 | 2023-06-11 08:24:26 | letters | 1 | 69583 | 13 | 1.203 | 57841.2 |
393 | 2023-05-04 04:28:56 | letters | 1 | 69583 | 13 | 1.156 | 60192.9 |
392 | 2023-04-30 20:48:09 | letters | 1 | 69583 | 13 | 1.186 | 58670.3 |
391 | 2023-03-30 18:18:31 | letters | 1 | 69583 | 13 | 1.140 | 61037.7 |
390 | 2023-03-20 02:38:05 | letters | 1 | 69583 | 13 | 1.060 | 65644.3 |
389 | 2023-01-29 06:03:57 | letters | 1 | 69583 | 13 | 1.063 | 65459.1 |
388 | 2023-01-14 18:11:53 | letters | 1 | 69583 | 13 | 1.063 | 65459.1 |
387 | 2022-11-04 00:23:20 | letters | 1 | 69583 | 13 | 1.173 | 59320.5 |
386 | 2022-10-22 07:09:11 | letters | 1 | 69583 | 13 | 1.030 | 67556.3 |
385 | 2022-09-19 13:29:54 | letters | 1 | 69583 | 13 | 1.220 | 57035.2 |
384 | 2022-08-23 08:32:52 | letters | 1 | 69583 | 13 | 1.140 | 61037.7 |
383 | 2022-08-15 23:52:34 | letters | 1 | 69583 | 13 | 1.156 | 60192.9 |
382 | 2022-08-14 16:15:47 | letters | 1 | 69583 | 13 | 1.030 | 67556.3 |
381 | 2022-07-30 09:38:38 | letters | 1 | 69583 | 13 | 1.046 | 66522.9 |
380 | 2022-07-29 00:28:18 | letters | 1 | 69583 | 13 | 1.143 | 60877.5 |
379 | 2022-06-28 11:31:46 | letters | 1 | 69583 | 13 | 1.046 | 66522.9 |
378 | 2022-06-23 20:46:45 | letters | 1 | 69583 | 13 | 1.046 | 66522.9 |
377 | 2022-06-21 15:37:08 | letters | 1 | 69583 | 13 | 1.110 | 62687.4 |
376 | 2022-03-11 22:09:06 | letters | 1 | 69583 | 13 | 1.186 | 58670.3 |
375 | 2022-02-24 17:21:07 | letters | 1 | 69583 | 13 | 1.266 | 54962.9 |
374 | 2022-02-22 14:07:02 | letters | 1 | 69583 | 13 | 1.390 | 50059.7 |
373 | 2021-12-13 18:46:36 | letters | 1 | 69583 | 13 | 1.250 | 55666.4 |
372 | 2021-12-05 00:53:54 | letters | 1 | 69583 | 13 | 1.190 | 58473.1 |
371 | 2021-11-23 10:58:10 | letters | 1 | 69583 | 13 | 1.266 | 54962.9 |
370 | 2021-10-21 00:12:18 | letters | 1 | 69583 | 13 | 1.076 | 64668.2 |
369 | 2021-09-23 19:58:57 | letters | 1 | 69583 | 13 | 1.093 | 63662.4 |
368 | 2021-09-04 04:56:58 | letters | 1 | 69583 | 13 | 1.063 | 65459.1 |
367 | 2021-08-24 09:15:22 | letters | 1 | 69583 | 13 | 1.110 | 62687.4 |
366 | 2021-06-03 08:41:40 | letters | 1 | 69583 | 13 | 1.063 | 65459.1 |
365 | 2021-05-31 02:55:19 | letters | 1 | 69583 | 13 | 1.530 | 45479.1 |
364 | 2021-02-27 17:05:45 | letters | 2 | 107671 | 156 | 3.343 | 32207.9 |
363 | 2021-02-24 16:57:53 | letters | 1 | 69583 | 13 | 1.063 | 65459.1 |
362 | 2020-11-19 15:48:15 | letters | 1 | 69583 | 13 | 1.250 | 55666.4 |
361 | 2020-10-30 17:25:13 | letters | 1 | 69583 | 13 | 1.186 | 58670.3 |
360 | 2020-10-26 19:04:22 | letters | 1 | 69583 | 13 | 1.076 | 64668.2 |
359 | 2020-10-15 20:39:00 | letters | 1 | 69583 | 13 | 1.076 | 64668.2 |
358 | 2020-10-06 07:17:21 | letters | 1 | 69583 | 13 | 1.186 | 58670.3 |
357 | 2020-10-03 07:17:50 | letters | 1 | 69583 | 13 | 1.063 | 65459.1 |
356 | 2020-09-04 01:10:02 | letters | 1 | 69583 | 13 | 1.076 | 64668.2 |
355 | 2020-08-30 23:01:14 | letters | 1 | 69583 | 13 | 1.156 | 60192.9 |
354 | 2020-08-28 14:03:54 | letters | 1 | 69583 | 13 | 1.216 | 57222.9 |
353 | 2020-08-25 01:08:37 | letters | 1 | 69583 | 13 | 1.076 | 64668.2 |
352 | 2020-08-16 08:13:05 | letters | 1 | 69583 | 13 | 1.220 | 57035.2 |
351 | 2020-08-16 04:48:24 | letters | 1 | 69583 | 13 | 1.186 | 58670.3 |
350 | 2020-08-13 01:13:16 | letters | 1 | 69583 | 13 | 1.093 | 63662.4 |
349 | 2020-05-21 02:05:23 | letters | 1 | 69583 | 13 | 1.143 | 60877.5 |
348 | 2020-05-15 01:31:41 | letters | 1 | 69583 | 13 | 1.093 | 63662.4 |
347 | 2020-03-27 15:04:54 | letters | 1 | 69583 | 13 | 1.266 | 54962.9 |
346 | 2020-03-26 09:48:58 | letters | 1 | 69583 | 13 | 1.703 | 40859.1 |
345 | 2020-03-26 08:54:55 | letters | 1 | 69583 | 13 | 1.296 | 53690.6 |
344 | 2020-03-24 11:40:04 | letters | 1 | 69583 | 13 | 1.233 | 56433.9 |
343 | 2020-03-22 02:03:19 | letters | 1 | 69583 | 13 | 1.156 | 60192.9 |
342 | 2020-03-19 13:35:52 | letters | 1 | 69583 | 13 | 1.280 | 54361.7 |
341 | 2020-03-18 22:35:08 | letters | 1 | 69583 | 13 | 1.220 | 57035.2 |
340 | 2020-03-13 11:28:26 | letters | 1 | 69583 | 13 | 1.110 | 62687.4 |
339 | 2020-03-04 22:56:14 | letters | 1 | 69583 | 13 | 1.173 | 59320.5 |
338 | 2020-03-01 06:06:28 | letters | 1 | 69583 | 13 | 3.470 | 20052.7 |
337 | 2020-02-29 04:40:16 | letters | 2 | 107671 | 156 | 7.126 | 15109.6 |
336 | 2020-02-29 02:31:43 | letters | 2 | 107671 | 156 | 3.736 | 28819.9 |
335 | 2020-02-28 10:25:18 | letters | 2 | 107671 | 156 | 3.826 | 28141.9 |
334 | 2020-02-28 02:27:00 | letters | 2 | 107671 | 156 | 11.783 | 9137.8 |
333 | 2020-02-27 14:37:09 | letters | 2 | 107671 | 156 | 3.893 | 27657.6 |
332 | 2020-02-21 12:18:17 | letters | 1 | 69583 | 13 | 2.670 | 26061.0 |
331 | 2020-02-17 05:42:46 | letters | 1 | 69583 | 13 | 1.123 | 61961.7 |
330 | 2020-02-12 22:56:50 | letters | 1 | 69583 | 13 | 2.813 | 24736.2 |
329 | 2020-02-12 10:11:26 | letters | 1 | 69583 | 13 | 4.656 | 14944.8 |
328 | 2020-02-03 15:48:50 | letters | 1 | 69583 | 13 | 1.390 | 50059.7 |
327 | 2020-02-02 21:58:16 | letters | 1 | 69583 | 13 | 3.390 | 20526.0 |
326 | 2020-02-01 03:12:33 | letters | 1 | 69583 | 13 | 2.483 | 28023.8 |
325 | 2020-01-30 14:45:32 | letters | 1 | 69583 | 13 | 2.593 | 26834.9 |
324 | 2020-01-26 14:48:49 | letters | 1 | 69583 | 13 | 1.343 | 51811.6 |
323 | 2020-01-26 13:00:27 | letters | 1 | 69583 | 13 | 1.346 | 51696.1 |
322 | 2020-01-23 13:49:56 | letters | 1 | 69583 | 13 | 1.593 | 43680.5 |
321 | 2020-01-14 23:13:10 | letters | 1 | 69583 | 13 | 3.686 | 18877.6 |
320 | 2020-01-14 17:42:16 | letters | 2 | 107671 | 156 | 5.376 | 20028.1 |
319 | 2020-01-14 16:15:33 | letters | 2 | 107671 | 156 | 3.563 | 30219.2 |
318 | 2020-01-14 12:51:40 | letters | 2 | 107671 | 156 | 3.343 | 32207.9 |
317 | 2020-01-14 07:51:33 | letters | 1 | 69583 | 13 | 1.096 | 63488.1 |
316 | 2020-01-11 08:31:42 | letters | 1 | 69583 | 13 | 1.330 | 52318.0 |
315 | 2020-01-04 18:29:13 | letters | 1 | 69583 | 13 | 1.216 | 57222.9 |
314 | 2019-12-27 13:36:50 | letters | 1 | 69583 | 13 | 1.283 | 54234.6 |