History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lassies"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
447 | 2024-04-22 17:50:33 | lassies | 2 | 107671 | 84 | 13.296 | 8098.0 |
446 | 2024-04-21 10:46:05 | lassies | 2 | 107671 | 84 | 4.546 | 23684.8 |
445 | 2024-04-12 11:22:56 | lassies | 1 | 69583 | 9 | 1.780 | 39091.6 |
444 | 2024-03-31 23:57:37 | lassies | 3 | 134027 | 752 | 12.940 | 10357.6 |
443 | 2024-03-29 12:54:05 | lassies | 3 | 134027 | 752 | 11.453 | 11702.3 |
442 | 2024-03-29 12:38:02 | lassies | 3 | 134027 | 752 | 16.033 | 8359.4 |
441 | 2024-03-29 12:08:00 | lassies | 3 | 134027 | 752 | 12.140 | 11040.1 |
440 | 2024-02-08 03:47:47 | lassies | 1 | 69583 | 9 | 1.360 | 51164.0 |
439 | 2024-01-16 13:30:23 | lassies | 1 | 69583 | 9 | 1.140 | 61037.7 |
438 | 2024-01-06 16:27:31 | lassies | 3 | 134027 | 752 | 6.063 | 22105.7 |
437 | 2024-01-06 16:27:28 | lassies | 2 | 107671 | 84 | 2.893 | 37217.8 |
436 | 2023-12-16 06:50:06 | lassies | 2 | 107671 | 84 | 3.576 | 30109.3 |
435 | 2023-12-01 22:09:45 | lassies | 3 | 134027 | 752 | 5.876 | 22809.2 |
434 | 2023-11-19 12:03:17 | lassies | 1 | 69583 | 9 | 1.220 | 57035.2 |
433 | 2023-11-16 00:06:39 | lassies | 1 | 69583 | 9 | 1.106 | 62914.1 |
432 | 2023-11-14 18:18:59 | lassies | 1 | 69583 | 9 | 1.123 | 61961.7 |
431 | 2023-11-11 14:50:49 | lassies | 1 | 69583 | 9 | 1.076 | 64668.2 |
430 | 2023-11-06 03:23:49 | lassies | 1 | 69583 | 9 | 1.186 | 58670.3 |
429 | 2023-10-20 05:09:01 | lassies | 1 | 69583 | 9 | 4.076 | 17071.4 |
428 | 2023-10-19 20:56:04 | lassies | 1 | 69583 | 9 | 1.250 | 55666.4 |
427 | 2023-10-13 04:31:09 | lassies | 3 | 134027 | 752 | 6.280 | 21341.9 |
426 | 2023-10-13 04:21:37 | lassies | 1 | 69583 | 9 | 1.093 | 63662.4 |
425 | 2023-10-07 00:42:21 | lassies | 3 | 134027 | 752 | 12.016 | 11154.0 |
424 | 2023-10-01 06:23:55 | lassies | 3 | 134027 | 752 | 9.093 | 14739.6 |
423 | 2023-09-28 00:20:06 | lassies | 3 | 134027 | 752 | 7.236 | 18522.2 |
422 | 2023-09-28 00:20:04 | lassies | 2 | 107671 | 84 | 4.516 | 23842.1 |
421 | 2023-09-23 10:45:56 | lassies | 1 | 69583 | 9 | 1.266 | 54962.9 |
420 | 2023-09-22 06:35:10 | lassies | 1 | 69583 | 9 | 1.076 | 64668.2 |
419 | 2023-09-16 03:08:26 | lassies | 2 | 107671 | 84 | 3.403 | 31640.0 |
418 | 2023-08-31 18:02:18 | lassies | 1 | 69583 | 9 | 1.110 | 62687.4 |
417 | 2023-08-31 01:09:37 | lassies | 3 | 134027 | 752 | 5.986 | 22390.1 |
416 | 2023-07-07 00:51:05 | lassies | 1 | 69583 | 9 | 1.203 | 57841.2 |
415 | 2023-06-22 06:04:31 | lassies | 2 | 107671 | 84 | 2.940 | 36622.8 |
414 | 2023-06-04 18:01:31 | lassies | 1 | 69583 | 9 | 1.216 | 57222.9 |
413 | 2023-05-15 10:00:45 | lassies | 3 | 134027 | 752 | 5.796 | 23124.1 |
412 | 2023-03-30 12:17:44 | lassies | 1 | 69583 | 9 | 1.190 | 58473.1 |
411 | 2023-03-26 12:49:55 | lassies | 1 | 69583 | 9 | 1.076 | 64668.2 |
410 | 2023-03-18 04:06:41 | lassies | 2 | 107671 | 84 | 2.813 | 38276.2 |
409 | 2023-02-19 04:38:00 | lassies | 3 | 134027 | 752 | 5.670 | 23637.9 |
408 | 2023-02-16 14:32:42 | lassies | 2 | 107671 | 84 | 3.126 | 34443.7 |
407 | 2023-01-20 12:37:43 | lassies | 2 | 107671 | 84 | 2.796 | 38508.9 |
406 | 2023-01-10 05:46:02 | lassies | 1 | 69583 | 9 | 1.060 | 65644.3 |
405 | 2022-12-27 21:35:55 | lassies | 2 | 107671 | 84 | 2.983 | 36094.9 |
404 | 2022-12-21 16:16:20 | lassies | 1 | 69583 | 9 | 1.063 | 65459.1 |
403 | 2022-12-19 09:41:50 | lassies | 2 | 107671 | 84 | 2.830 | 38046.3 |
402 | 2022-12-06 11:51:22 | lassies | 2 | 107671 | 84 | 3.203 | 33615.7 |
401 | 2022-12-01 22:08:10 | lassies | 3 | 134027 | 752 | 5.873 | 22820.9 |
400 | 2022-11-11 13:30:20 | lassies | 2 | 107671 | 84 | 3.060 | 35186.6 |
399 | 2022-10-20 12:43:27 | lassies | 2 | 107671 | 84 | 3.313 | 32499.5 |
398 | 2022-10-13 16:30:31 | lassies | 1 | 69583 | 9 | 1.280 | 54361.7 |
397 | 2022-09-17 08:13:52 | lassies | 1 | 69583 | 9 | 1.250 | 55666.4 |
396 | 2022-09-13 22:34:50 | lassies | 2 | 107671 | 84 | 2.876 | 37437.8 |
395 | 2022-09-07 11:30:39 | lassies | 1 | 69583 | 9 | 1.200 | 57985.8 |
394 | 2022-08-13 03:51:05 | lassies | 2 | 107671 | 84 | 2.860 | 37647.2 |
393 | 2022-07-08 20:15:41 | lassies | 3 | 134027 | 752 | 5.703 | 23501.1 |
392 | 2022-05-31 00:52:54 | lassies | 1 | 69583 | 9 | 1.076 | 64668.2 |
391 | 2022-05-26 05:34:46 | lassies | 1 | 69583 | 9 | 1.080 | 64428.7 |
390 | 2022-02-16 12:14:55 | lassies | 1 | 69583 | 9 | 1.123 | 61961.7 |
389 | 2022-02-11 03:49:26 | lassies | 1 | 69583 | 9 | 1.186 | 58670.3 |
388 | 2021-12-10 21:17:59 | lassies | 1 | 69583 | 9 | 1.186 | 58670.3 |
387 | 2021-12-07 22:39:47 | lassies | 1 | 69583 | 9 | 1.220 | 57035.2 |
386 | 2021-11-13 06:39:55 | lassies | 1 | 69583 | 9 | 1.106 | 62914.1 |
385 | 2021-11-12 09:17:11 | lassies | 1 | 69583 | 9 | 1.453 | 47889.2 |
384 | 2021-11-10 04:09:53 | lassies | 1 | 69583 | 9 | 1.156 | 60192.9 |
383 | 2021-10-13 05:55:42 | lassies | 1 | 69583 | 9 | 1.220 | 57035.2 |
382 | 2021-09-13 14:07:13 | lassies | 1 | 69583 | 9 | 1.106 | 62914.1 |
381 | 2021-09-11 10:27:52 | lassies | 1 | 69583 | 9 | 1.203 | 57841.2 |
380 | 2021-08-29 04:22:27 | lassies | 1 | 69583 | 9 | 1.076 | 64668.2 |
379 | 2021-08-26 23:35:43 | lassies | 1 | 69583 | 9 | 1.140 | 61037.7 |
378 | 2021-08-07 04:41:40 | lassies | 1 | 69583 | 9 | 1.186 | 58670.3 |
377 | 2021-06-07 13:01:24 | lassies | 1 | 69583 | 9 | 1.080 | 64428.7 |
376 | 2021-05-13 19:10:24 | lassies | 1 | 69583 | 9 | 1.233 | 56433.9 |
375 | 2021-05-06 08:24:08 | lassies | 1 | 69583 | 9 | 1.266 | 54962.9 |
374 | 2021-03-16 14:52:14 | lassies | 1 | 69583 | 9 | 2.516 | 27656.2 |
373 | 2021-02-19 13:51:55 | lassies | 1 | 69583 | 9 | 1.203 | 57841.2 |
372 | 2021-01-31 00:21:45 | lassies | 1 | 69583 | 9 | 1.093 | 63662.4 |
371 | 2020-12-28 18:05:35 | lassies | 1 | 69583 | 9 | 1.106 | 62914.1 |
370 | 2020-12-01 07:40:14 | lassies | 1 | 69583 | 9 | 1.110 | 62687.4 |
369 | 2020-10-28 14:32:22 | lassies | 1 | 69583 | 9 | 1.220 | 57035.2 |
368 | 2020-10-24 06:46:40 | lassies | 1 | 69583 | 9 | 1.170 | 59472.6 |
367 | 2020-10-19 06:02:56 | lassies | 1 | 69583 | 9 | 1.093 | 63662.4 |
366 | 2020-10-07 06:27:06 | lassies | 1 | 69583 | 9 | 1.220 | 57035.2 |
365 | 2020-09-06 06:51:16 | lassies | 1 | 69583 | 9 | 1.300 | 53525.4 |
364 | 2020-08-30 16:16:58 | lassies | 1 | 69583 | 9 | 1.093 | 63662.4 |
363 | 2020-08-21 07:23:08 | lassies | 1 | 69583 | 9 | 1.123 | 61961.7 |
362 | 2020-08-08 00:25:47 | lassies | 1 | 69583 | 9 | 1.093 | 63662.4 |
361 | 2020-08-03 16:16:00 | lassies | 1 | 69583 | 9 | 1.123 | 61961.7 |
360 | 2020-07-31 14:21:02 | lassies | 1 | 69583 | 9 | 1.123 | 61961.7 |
359 | 2020-07-30 17:31:42 | lassies | 1 | 69583 | 9 | 1.263 | 55093.4 |
358 | 2020-07-20 06:06:48 | lassies | 1 | 69583 | 9 | 1.233 | 56433.9 |
357 | 2020-05-07 12:21:48 | lassies | 1 | 69583 | 9 | 1.203 | 57841.2 |
356 | 2020-05-01 13:02:36 | lassies | 1 | 69583 | 9 | 1.143 | 60877.5 |
355 | 2020-03-27 16:05:14 | lassies | 1 | 69583 | 9 | 1.280 | 54361.7 |
354 | 2020-03-25 23:36:13 | lassies | 1 | 69583 | 9 | 1.203 | 57841.2 |
353 | 2020-03-25 00:25:43 | lassies | 1 | 69583 | 9 | 1.220 | 57035.2 |
352 | 2020-03-21 23:49:03 | lassies | 1 | 69583 | 9 | 1.080 | 64428.7 |
351 | 2020-03-18 20:35:48 | lassies | 1 | 69583 | 9 | 1.110 | 62687.4 |
350 | 2020-03-05 17:46:00 | lassies | 1 | 69583 | 9 | 1.313 | 52995.4 |
349 | 2020-02-27 03:56:27 | lassies | 1 | 69583 | 9 | 1.220 | 57035.2 |
348 | 2020-02-27 01:29:58 | lassies | 1 | 69583 | 9 | 1.250 | 55666.4 |