History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"perches"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
493 | 2024-04-26 12:19:04 | perches | 2 | 107671 | 74 | 8.393 | 12828.7 |
492 | 2024-04-26 10:47:04 | perches | 3 | 134027 | 646 | 7.393 | 18128.9 |
491 | 2024-04-25 18:24:49 | perches | 2 | 107671 | 74 | 3.673 | 29314.2 |
490 | 2024-04-25 14:09:36 | perches | 3 | 134027 | 646 | 8.000 | 16753.4 |
489 | 2024-04-24 22:40:32 | perches | 2 | 107671 | 74 | 7.750 | 13893.0 |
488 | 2024-04-24 22:38:41 | perches | 3 | 134027 | 646 | 7.860 | 17051.8 |
487 | 2024-04-23 03:51:02 | perches | 3 | 134027 | 646 | 28.893 | 4638.7 |
486 | 2024-04-22 16:37:14 | perches | 3 | 134027 | 646 | 7.500 | 17870.3 |
485 | 2024-03-31 06:01:58 | perches | 1 | 69583 | 8 | 2.703 | 25742.9 |
484 | 2024-03-07 00:06:09 | perches | 1 | 69583 | 8 | 4.280 | 16257.7 |
483 | 2024-02-11 12:37:52 | perches | 1 | 69583 | 8 | 1.280 | 54361.7 |
482 | 2024-02-07 08:39:06 | perches | 2 | 107671 | 74 | 3.123 | 34476.8 |
481 | 2024-02-07 08:38:34 | perches | 3 | 134027 | 646 | 6.843 | 19586.0 |
480 | 2024-01-27 17:15:43 | perches | 2 | 107671 | 74 | 5.326 | 20216.1 |
479 | 2024-01-27 17:15:19 | perches | 3 | 134027 | 646 | 7.453 | 17983.0 |
478 | 2024-01-27 07:42:53 | perches | 3 | 134027 | 646 | 8.610 | 15566.4 |
477 | 2024-01-18 03:58:03 | perches | 3 | 134027 | 646 | 6.860 | 19537.5 |
476 | 2024-01-18 03:58:01 | perches | 2 | 107671 | 74 | 2.983 | 36094.9 |
475 | 2023-12-21 12:42:33 | perches | 2 | 107671 | 74 | 4.330 | 24866.3 |
474 | 2023-12-15 20:06:18 | perches | 1 | 69583 | 8 | 1.220 | 57035.2 |
473 | 2023-12-12 16:04:16 | perches | 3 | 134027 | 646 | 5.766 | 23244.4 |
472 | 2023-11-29 23:48:53 | perches | 1 | 69583 | 8 | 1.110 | 62687.4 |
471 | 2023-11-29 05:58:56 | perches | 1 | 69583 | 8 | 1.266 | 54962.9 |
470 | 2023-11-28 03:06:25 | perches | 1 | 69583 | 8 | 1.123 | 61961.7 |
469 | 2023-11-23 13:36:08 | perches | 3 | 134027 | 646 | 6.280 | 21341.9 |
468 | 2023-11-23 13:36:10 | perches | 2 | 107671 | 74 | 3.313 | 32499.5 |
467 | 2023-11-17 22:13:31 | perches | 1 | 69583 | 8 | 1.216 | 57222.9 |
466 | 2023-10-21 19:21:39 | perches | 1 | 69583 | 8 | 1.173 | 59320.5 |
465 | 2023-09-28 03:47:25 | perches | 2 | 107671 | 74 | 7.813 | 13781.0 |
464 | 2023-09-26 02:26:22 | perches | 1 | 69583 | 8 | 1.203 | 57841.2 |
463 | 2023-09-20 15:30:22 | perches | 2 | 107671 | 74 | 3.203 | 33615.7 |
462 | 2023-09-18 21:45:54 | perches | 1 | 69583 | 8 | 2.423 | 28717.7 |
461 | 2023-09-14 11:46:51 | perches | 1 | 69583 | 8 | 1.250 | 55666.4 |
460 | 2023-09-11 01:20:51 | perches | 3 | 134027 | 646 | 8.186 | 16372.7 |
459 | 2023-09-09 20:15:23 | perches | 3 | 134027 | 646 | 5.873 | 22820.9 |
458 | 2023-08-13 13:04:27 | perches | 1 | 69583 | 8 | 1.126 | 61796.6 |
457 | 2023-06-28 06:33:43 | perches | 1 | 69583 | 8 | 1.080 | 64428.7 |
456 | 2023-06-26 00:33:19 | perches | 2 | 107671 | 74 | 3.000 | 35890.3 |
455 | 2023-05-21 14:21:34 | perches | 3 | 134027 | 646 | 6.546 | 20474.6 |
454 | 2023-05-02 12:11:07 | perches | 1 | 69583 | 8 | 1.186 | 58670.3 |
453 | 2023-04-06 05:38:14 | perches | 1 | 69583 | 8 | 1.156 | 60192.9 |
452 | 2023-03-19 07:04:32 | perches | 2 | 107671 | 74 | 2.846 | 37832.4 |
451 | 2023-03-01 21:30:19 | perches | 3 | 134027 | 646 | 5.763 | 23256.5 |
450 | 2023-01-20 06:02:32 | perches | 1 | 69583 | 8 | 1.060 | 65644.3 |
449 | 2023-01-20 01:06:12 | perches | 1 | 69583 | 8 | 1.076 | 64668.2 |
448 | 2023-01-17 09:01:06 | perches | 1 | 69583 | 8 | 1.216 | 57222.9 |
447 | 2023-01-03 06:06:09 | perches | 2 | 107671 | 74 | 2.860 | 37647.2 |
446 | 2022-12-19 19:13:26 | perches | 2 | 107671 | 74 | 2.830 | 38046.3 |
445 | 2022-12-09 14:07:47 | perches | 3 | 134027 | 646 | 6.796 | 19721.5 |
444 | 2022-11-24 16:47:25 | perches | 2 | 107671 | 74 | 2.890 | 37256.4 |
443 | 2022-11-16 05:39:04 | perches | 1 | 69583 | 8 | 1.110 | 62687.4 |
442 | 2022-10-26 11:03:21 | perches | 2 | 107671 | 74 | 3.280 | 32826.5 |
441 | 2022-10-09 14:33:56 | perches | 1 | 69583 | 8 | 1.076 | 64668.2 |
440 | 2022-09-07 21:30:50 | perches | 1 | 69583 | 8 | 1.203 | 57841.2 |
439 | 2022-09-06 14:10:41 | perches | 3 | 134027 | 646 | 6.860 | 19537.5 |
438 | 2022-08-25 17:13:43 | perches | 2 | 107671 | 74 | 3.343 | 32207.9 |
437 | 2022-08-14 07:27:52 | perches | 2 | 107671 | 74 | 3.220 | 33438.2 |
436 | 2022-08-07 19:43:30 | perches | 1 | 69583 | 8 | 1.203 | 57841.2 |
435 | 2022-07-30 04:22:51 | perches | 2 | 107671 | 74 | 2.906 | 37051.3 |
434 | 2022-07-22 06:55:00 | perches | 3 | 134027 | 646 | 5.843 | 22938.0 |
433 | 2022-07-17 14:48:21 | perches | 3 | 134027 | 646 | 6.063 | 22105.7 |
432 | 2022-07-05 07:05:08 | perches | 1 | 69583 | 8 | 1.093 | 63662.4 |
431 | 2022-06-26 18:25:55 | perches | 1 | 69583 | 8 | 1.093 | 63662.4 |
430 | 2022-03-13 19:38:35 | perches | 1 | 69583 | 8 | 1.123 | 61961.7 |
429 | 2022-03-05 19:38:29 | perches | 1 | 69583 | 8 | 1.106 | 62914.1 |
428 | 2021-12-18 08:49:43 | perches | 1 | 69583 | 8 | 1.140 | 61037.7 |
427 | 2021-12-03 12:23:51 | perches | 1 | 69583 | 8 | 1.200 | 57985.8 |
426 | 2021-10-27 12:11:53 | perches | 1 | 69583 | 8 | 1.233 | 56433.9 |
425 | 2021-09-17 19:53:24 | perches | 1 | 69583 | 8 | 1.076 | 64668.2 |
424 | 2021-09-15 16:16:28 | perches | 1 | 69583 | 8 | 1.296 | 53690.6 |
423 | 2021-09-02 17:11:26 | perches | 1 | 69583 | 8 | 1.186 | 58670.3 |
422 | 2021-08-24 18:13:30 | perches | 1 | 69583 | 8 | 1.266 | 54962.9 |
421 | 2021-06-03 14:43:40 | perches | 1 | 69583 | 8 | 1.266 | 54962.9 |
420 | 2021-05-29 17:37:03 | perches | 1 | 69583 | 8 | 1.810 | 38443.6 |
419 | 2021-05-13 03:36:27 | perches | 3 | 134027 | 646 | 6.873 | 19500.5 |
418 | 2021-04-12 00:10:29 | perches | 3 | 134027 | 646 | 6.766 | 19808.9 |
417 | 2021-04-07 22:38:31 | perches | 1 | 69583 | 8 | 1.203 | 57841.2 |
416 | 2021-03-16 22:10:42 | perches | 3 | 134027 | 646 | 6.216 | 21561.6 |
415 | 2021-03-12 04:30:52 | perches | 1 | 69583 | 8 | 1.110 | 62687.4 |
414 | 2021-02-26 23:33:51 | perches | 1 | 69583 | 8 | 1.080 | 64428.7 |
413 | 2021-02-18 23:11:04 | perches | 3 | 134027 | 646 | 6.796 | 19721.5 |
412 | 2021-01-29 05:12:17 | perches | 1 | 69583 | 8 | 1.156 | 60192.9 |
411 | 2021-01-22 23:32:59 | perches | 1 | 69583 | 8 | 1.280 | 54361.7 |
410 | 2020-11-22 06:36:48 | perches | 1 | 69583 | 8 | 1.126 | 61796.6 |
409 | 2020-11-01 15:29:51 | perches | 1 | 69583 | 8 | 1.283 | 54234.6 |
408 | 2020-10-08 09:30:07 | perches | 1 | 69583 | 8 | 2.626 | 26497.7 |
407 | 2020-08-30 04:48:40 | perches | 1 | 69583 | 8 | 2.266 | 30707.4 |
406 | 2020-08-25 15:12:46 | perches | 1 | 69583 | 8 | 1.123 | 61961.7 |
405 | 2020-08-17 11:44:29 | perches | 1 | 69583 | 8 | 1.143 | 60877.5 |
404 | 2020-08-14 22:32:53 | perches | 1 | 69583 | 8 | 1.250 | 55666.4 |
403 | 2020-05-28 18:11:00 | perches | 1 | 69583 | 8 | 1.080 | 64428.7 |
402 | 2020-05-15 10:24:17 | perches | 1 | 69583 | 8 | 1.233 | 56433.9 |
401 | 2020-05-13 17:24:32 | perches | 1 | 69583 | 8 | 1.123 | 61961.7 |
400 | 2020-03-28 21:13:35 | perches | 1 | 69583 | 8 | 1.220 | 57035.2 |
399 | 2020-03-28 12:50:30 | perches | 1 | 69583 | 8 | 1.250 | 55666.4 |
398 | 2020-03-23 23:36:54 | perches | 1 | 69583 | 8 | 1.173 | 59320.5 |
397 | 2020-03-22 09:23:39 | perches | 1 | 69583 | 8 | 1.266 | 54962.9 |
396 | 2020-03-20 02:04:04 | perches | 1 | 69583 | 8 | 1.250 | 55666.4 |
395 | 2020-03-01 05:56:15 | perches | 1 | 69583 | 8 | 2.640 | 26357.2 |
394 | 2020-02-25 14:59:46 | perches | 1 | 69583 | 8 | 1.280 | 54361.7 |