History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shirts"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
460 | 2024-04-28 16:17:16 | shirts | 1 | 48755 | 12 | 0.733 | 66514.3 |
459 | 2024-03-29 18:38:20 | shirts | 1 | 48755 | 12 | 0.983 | 49598.2 |
458 | 2024-03-04 04:10:20 | shirts | 1 | 48755 | 12 | 2.970 | 16415.8 |
457 | 2024-02-27 15:02:54 | shirts | 2 | 82551 | 127 | 2.546 | 32423.8 |
456 | 2024-02-25 23:20:31 | shirts | 2 | 82551 | 127 | 2.860 | 28864.0 |
455 | 2024-02-25 23:20:25 | shirts | 1 | 48755 | 12 | 0.953 | 51159.5 |
454 | 2024-02-11 18:18:58 | shirts | 2 | 82551 | 127 | 7.750 | 10651.7 |
453 | 2024-02-11 09:49:47 | shirts | 2 | 82551 | 127 | 7.143 | 11556.9 |
452 | 2024-02-06 15:48:40 | shirts | 1 | 48755 | 12 | 0.970 | 50262.9 |
451 | 2024-02-02 20:28:03 | shirts | 1 | 48755 | 12 | 0.890 | 54780.9 |
450 | 2024-01-15 02:48:04 | shirts | 2 | 82551 | 127 | 2.673 | 30883.3 |
449 | 2024-01-10 10:58:34 | shirts | 2 | 82551 | 127 | 2.486 | 33206.4 |
448 | 2023-12-21 04:03:44 | shirts | 1 | 48755 | 12 | 0.860 | 56691.9 |
447 | 2023-12-20 04:39:29 | shirts | 1 | 48755 | 12 | 0.856 | 56956.8 |
446 | 2023-12-12 08:28:59 | shirts | 2 | 82551 | 127 | 2.330 | 35429.6 |
445 | 2023-12-09 12:04:55 | shirts | 1 | 48755 | 12 | 0.763 | 63899.1 |
444 | 2023-11-24 12:53:56 | shirts | 1 | 48755 | 12 | 0.780 | 62506.4 |
443 | 2023-11-18 03:44:28 | shirts | 1 | 48755 | 12 | 0.813 | 59969.2 |
442 | 2023-11-10 15:10:12 | shirts | 1 | 48755 | 12 | 0.936 | 52088.7 |
441 | 2023-10-31 14:48:45 | shirts | 1 | 48755 | 12 | 0.830 | 58741.0 |
440 | 2023-10-28 14:47:01 | shirts | 1 | 48755 | 12 | 0.780 | 62506.4 |
439 | 2023-10-22 11:26:02 | shirts | 2 | 82551 | 127 | 2.596 | 31799.3 |
438 | 2023-10-19 05:13:22 | shirts | 1 | 48755 | 12 | 0.860 | 56691.9 |
437 | 2023-10-17 00:11:55 | shirts | 2 | 82551 | 127 | 2.466 | 33475.7 |
436 | 2023-10-14 02:29:32 | shirts | 1 | 48755 | 12 | 1.000 | 48755.0 |
435 | 2023-10-11 12:12:36 | shirts | 1 | 48755 | 12 | 0.860 | 56691.9 |
434 | 2023-10-11 08:26:25 | shirts | 2 | 82551 | 127 | 2.576 | 32046.2 |
433 | 2023-10-09 09:56:07 | shirts | 1 | 48755 | 12 | 0.796 | 61250.0 |
432 | 2023-10-09 08:34:26 | shirts | 2 | 82551 | 127 | 2.140 | 38575.2 |
431 | 2023-10-03 15:32:42 | shirts | 1 | 48755 | 12 | 0.843 | 57835.1 |
430 | 2023-09-24 09:34:53 | shirts | 1 | 48755 | 12 | 0.810 | 60191.4 |
429 | 2023-09-14 07:29:52 | shirts | 1 | 48755 | 12 | 0.733 | 66514.3 |
428 | 2023-08-05 03:38:42 | shirts | 1 | 48755 | 12 | 0.826 | 59025.4 |
427 | 2023-07-28 10:31:48 | shirts | 2 | 82551 | 127 | 2.140 | 38575.2 |
426 | 2023-06-24 09:19:33 | shirts | 1 | 48755 | 12 | 1.716 | 28412.0 |
425 | 2023-06-21 00:05:42 | shirts | 1 | 48755 | 12 | 0.796 | 61250.0 |
424 | 2023-05-05 01:55:01 | shirts | 1 | 48755 | 12 | 0.750 | 65006.7 |
423 | 2023-04-06 14:54:49 | shirts | 2 | 82551 | 127 | 2.390 | 34540.2 |
422 | 2023-03-12 04:39:45 | shirts | 1 | 48755 | 12 | 0.750 | 65006.7 |
421 | 2023-02-26 19:46:19 | shirts | 1 | 48755 | 12 | 0.826 | 59025.4 |
420 | 2023-01-04 11:38:14 | shirts | 2 | 82551 | 127 | 2.093 | 39441.5 |
419 | 2022-12-25 00:44:36 | shirts | 1 | 48755 | 12 | 0.750 | 65006.7 |
418 | 2022-11-24 02:13:38 | shirts | 1 | 48755 | 12 | 0.750 | 65006.7 |
417 | 2022-09-12 18:16:39 | shirts | 1 | 48755 | 12 | 0.783 | 62266.9 |
416 | 2022-09-08 04:24:11 | shirts | 2 | 82551 | 127 | 2.110 | 39123.7 |
415 | 2022-08-25 05:14:16 | shirts | 1 | 48755 | 12 | 0.750 | 65006.7 |
414 | 2022-08-03 15:51:59 | shirts | 1 | 48755 | 12 | 0.780 | 62506.4 |
413 | 2022-07-29 05:29:40 | shirts | 1 | 48755 | 12 | 0.766 | 63648.8 |
412 | 2022-07-16 20:22:54 | shirts | 1 | 48755 | 12 | 0.750 | 65006.7 |
411 | 2022-04-09 03:56:36 | shirts | 1 | 48755 | 12 | 0.783 | 62266.9 |
410 | 2022-03-16 14:06:16 | shirts | 1 | 48755 | 12 | 0.983 | 49598.2 |
409 | 2021-12-25 00:17:47 | shirts | 1 | 48755 | 12 | 0.780 | 62506.4 |
408 | 2021-12-22 14:03:37 | shirts | 1 | 48755 | 12 | 0.936 | 52088.7 |
407 | 2021-12-21 19:27:17 | shirts | 1 | 48755 | 12 | 0.766 | 63648.8 |
406 | 2021-11-11 21:40:29 | shirts | 1 | 48755 | 12 | 0.826 | 59025.4 |
405 | 2021-11-01 06:12:38 | shirts | 1 | 48755 | 12 | 0.890 | 54780.9 |
404 | 2021-10-31 21:03:05 | shirts | 1 | 48755 | 12 | 0.783 | 62266.9 |
403 | 2021-10-31 13:31:06 | shirts | 1 | 48755 | 12 | 0.750 | 65006.7 |
402 | 2021-10-31 04:21:31 | shirts | 1 | 48755 | 12 | 1.750 | 27860.0 |
401 | 2021-10-30 13:41:12 | shirts | 1 | 48755 | 12 | 1.686 | 28917.6 |
400 | 2021-10-30 06:50:10 | shirts | 1 | 48755 | 12 | 0.873 | 55847.7 |
399 | 2021-10-29 20:10:38 | shirts | 1 | 48755 | 12 | 1.000 | 48755.0 |
398 | 2021-10-29 13:18:16 | shirts | 1 | 48755 | 12 | 0.810 | 60191.4 |
397 | 2021-10-29 01:53:40 | shirts | 1 | 48755 | 12 | 0.826 | 59025.4 |
396 | 2021-10-28 19:18:53 | shirts | 1 | 48755 | 12 | 0.876 | 55656.4 |
395 | 2021-10-27 22:09:59 | shirts | 1 | 48755 | 12 | 1.546 | 31536.2 |
394 | 2021-10-27 02:03:43 | shirts | 1 | 48755 | 12 | 1.486 | 32809.6 |
393 | 2021-09-26 16:07:27 | shirts | 1 | 48755 | 12 | 0.843 | 57835.1 |
392 | 2021-09-26 06:18:13 | shirts | 1 | 48755 | 12 | 0.873 | 55847.7 |
391 | 2021-09-20 21:25:23 | shirts | 1 | 48755 | 12 | 0.860 | 56691.9 |
390 | 2021-09-19 23:19:35 | shirts | 1 | 48755 | 12 | 0.906 | 53813.5 |
389 | 2021-09-17 20:49:02 | shirts | 1 | 48755 | 12 | 0.843 | 57835.1 |
388 | 2021-09-17 20:15:50 | shirts | 1 | 48755 | 12 | 0.860 | 56691.9 |
387 | 2021-08-29 03:29:30 | shirts | 1 | 48755 | 12 | 0.750 | 65006.7 |
386 | 2021-08-26 22:55:01 | shirts | 1 | 48755 | 12 | 0.750 | 65006.7 |
385 | 2021-06-18 00:03:30 | shirts | 1 | 48755 | 12 | 0.826 | 59025.4 |
384 | 2021-05-30 14:21:03 | shirts | 1 | 48755 | 12 | 0.860 | 56691.9 |
383 | 2021-04-16 08:22:01 | shirts | 1 | 48755 | 12 | 0.846 | 57630.0 |
382 | 2021-03-15 03:51:10 | shirts | 1 | 48755 | 12 | 0.766 | 63648.8 |
381 | 2021-03-11 15:39:05 | shirts | 1 | 48755 | 12 | 0.860 | 56691.9 |
380 | 2020-12-08 11:44:45 | shirts | 1 | 48755 | 12 | 0.750 | 65006.7 |
379 | 2020-11-07 17:07:03 | shirts | 2 | 82551 | 127 | 2.250 | 36689.3 |
378 | 2020-10-31 06:03:43 | shirts | 1 | 48755 | 12 | 0.843 | 57835.1 |
377 | 2020-10-17 05:28:07 | shirts | 1 | 48755 | 12 | 0.766 | 63648.8 |
376 | 2020-10-16 22:49:41 | shirts | 1 | 48755 | 12 | 0.830 | 58741.0 |
375 | 2020-10-16 14:07:35 | shirts | 1 | 48755 | 12 | 0.906 | 53813.5 |
374 | 2020-10-16 03:47:02 | shirts | 1 | 48755 | 12 | 0.780 | 62506.4 |
373 | 2020-10-15 17:37:16 | shirts | 1 | 48755 | 12 | 0.750 | 65006.7 |
372 | 2020-10-04 05:12:19 | shirts | 1 | 48755 | 12 | 0.890 | 54780.9 |
371 | 2020-09-05 10:25:41 | shirts | 1 | 48755 | 12 | 0.780 | 62506.4 |
370 | 2020-08-31 23:00:28 | shirts | 1 | 48755 | 12 | 0.766 | 63648.8 |
369 | 2020-08-07 22:05:50 | shirts | 1 | 48755 | 12 | 0.826 | 59025.4 |
368 | 2020-08-04 16:14:57 | shirts | 1 | 48755 | 12 | 0.780 | 62506.4 |
367 | 2020-07-20 01:19:15 | shirts | 1 | 48755 | 12 | 0.890 | 54780.9 |
366 | 2020-07-19 01:22:20 | shirts | 1 | 48755 | 12 | 0.826 | 59025.4 |
365 | 2020-07-15 13:31:14 | shirts | 1 | 48755 | 12 | 0.826 | 59025.4 |
364 | 2020-06-21 02:56:24 | shirts | 1 | 48755 | 12 | 1.263 | 38602.5 |
363 | 2020-06-20 02:44:40 | shirts | 1 | 48755 | 12 | 0.890 | 54780.9 |
362 | 2020-05-31 08:17:54 | shirts | 1 | 48755 | 12 | 0.783 | 62266.9 |
361 | 2020-05-31 05:06:35 | shirts | 1 | 48755 | 12 | 0.856 | 56956.8 |