History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"agnates"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1108 | 2024-02-13 17:59:39 | agnates | 1 | 69583 | 5 | 1.343 | 51811.6 |
| 1107 | 2024-02-02 20:44:04 | agnates | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 1106 | 2024-01-05 07:57:06 | agnates | 3 | 134027 | 463 | 5.733 | 23378.2 |
| 1105 | 2023-12-22 09:34:38 | agnates | 3 | 134027 | 463 | 6.203 | 21606.8 |
| 1104 | 2023-12-22 09:34:36 | agnates | 2 | 107671 | 37 | 3.203 | 33615.7 |
| 1103 | 2023-12-11 11:38:00 | agnates | 1 | 69583 | 5 | 1.190 | 58473.1 |
| 1102 | 2023-11-29 13:19:22 | agnates | 1 | 69583 | 5 | 1.236 | 56296.9 |
| 1101 | 2023-11-28 03:27:56 | agnates | 1 | 69583 | 5 | 1.170 | 59472.6 |
| 1100 | 2023-11-25 19:33:20 | agnates | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 1099 | 2023-11-21 03:26:57 | agnates | 1 | 69583 | 5 | 1.343 | 51811.6 |
| 1098 | 2023-11-10 20:13:38 | agnates | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 1097 | 2023-10-29 18:00:42 | agnates | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 1096 | 2023-10-11 22:59:35 | agnates | 3 | 134027 | 463 | 5.736 | 23365.9 |
| 1095 | 2023-09-28 05:01:26 | agnates | 1 | 69583 | 5 | 1.123 | 61961.7 |
| 1094 | 2023-09-17 03:35:18 | agnates | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 1093 | 2023-09-11 08:46:04 | agnates | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 1092 | 2023-09-06 08:53:04 | agnates | 3 | 134027 | 463 | 6.513 | 20578.4 |
| 1091 | 2023-09-04 13:17:50 | agnates | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 1090 | 2023-09-01 07:00:52 | agnates | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 1089 | 2023-07-21 07:43:21 | agnates | 3 | 134027 | 463 | 5.826 | 23005.0 |
| 1088 | 2023-06-19 18:32:00 | agnates | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 1087 | 2023-05-28 19:55:24 | agnates | 1 | 69583 | 5 | 1.170 | 59472.6 |
| 1086 | 2023-04-09 02:33:57 | agnates | 3 | 134027 | 463 | 5.606 | 23907.8 |
| 1085 | 2023-04-05 11:47:52 | agnates | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 1084 | 2023-04-04 08:21:41 | agnates | 3 | 134027 | 463 | 6.156 | 21771.8 |
| 1083 | 2023-02-26 04:19:41 | agnates | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 1082 | 2023-01-24 04:46:09 | agnates | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 1081 | 2023-01-01 05:38:34 | agnates | 3 | 134027 | 463 | 5.563 | 24092.6 |
| 1080 | 2022-11-23 16:40:59 | agnates | 1 | 69583 | 5 | 1.170 | 59472.6 |
| 1079 | 2022-11-20 16:41:20 | agnates | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 1078 | 2022-09-14 08:15:56 | agnates | 1 | 69583 | 5 | 1.516 | 45899.1 |
| 1077 | 2022-09-06 01:45:02 | agnates | 3 | 134027 | 463 | 5.813 | 23056.4 |
| 1076 | 2022-09-03 05:24:35 | agnates | 3 | 134027 | 463 | 5.673 | 23625.4 |
| 1075 | 2022-09-01 16:01:54 | agnates | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 1074 | 2022-08-28 05:22:30 | agnates | 1 | 69583 | 5 | 1.190 | 58473.1 |
| 1073 | 2022-08-19 17:03:47 | agnates | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 1072 | 2022-08-14 19:59:15 | agnates | 1 | 69583 | 5 | 1.236 | 56296.9 |
| 1071 | 2022-08-06 13:07:31 | agnates | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 1070 | 2022-07-11 12:43:48 | agnates | 1 | 69583 | 5 | 1.043 | 66714.3 |
| 1069 | 2022-07-09 10:51:10 | agnates | 3 | 134027 | 463 | 6.000 | 22337.8 |
| 1068 | 2022-07-04 00:45:24 | agnates | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 1067 | 2022-05-31 05:50:02 | agnates | 3 | 134027 | 463 | 5.953 | 22514.2 |
| 1066 | 2022-05-25 17:08:54 | agnates | 3 | 134027 | 463 | 5.610 | 23890.7 |
| 1065 | 2022-05-07 04:59:10 | agnates | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 1064 | 2022-03-28 17:07:11 | agnates | 3 | 134027 | 463 | 6.656 | 20136.3 |
| 1063 | 2022-03-11 20:50:15 | agnates | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 1062 | 2022-02-02 09:19:59 | agnates | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 1061 | 2022-01-25 14:40:20 | agnates | 1 | 69583 | 5 | 1.263 | 55093.4 |
| 1060 | 2021-12-20 03:01:12 | agnates | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 1059 | 2021-12-19 02:07:49 | agnates | 1 | 69583 | 5 | 1.236 | 56296.9 |
| 1058 | 2021-12-17 05:16:38 | agnates | 3 | 134027 | 463 | 9.440 | 14197.8 |
| 1057 | 2021-12-17 03:00:45 | agnates | 2 | 107671 | 37 | 6.156 | 17490.4 |
| 1056 | 2021-12-16 20:18:37 | agnates | 2 | 107671 | 37 | 3.046 | 35348.3 |
| 1055 | 2021-12-16 07:18:34 | agnates | 2 | 107671 | 37 | 3.330 | 32333.6 |
| 1054 | 2021-12-15 16:59:05 | agnates | 2 | 107671 | 37 | 3.326 | 32372.5 |
| 1053 | 2021-12-15 01:05:32 | agnates | 2 | 107671 | 37 | 3.390 | 31761.4 |
| 1052 | 2021-12-14 15:08:08 | agnates | 2 | 107671 | 37 | 3.283 | 32796.5 |
| 1051 | 2021-12-13 11:13:29 | agnates | 3 | 134027 | 463 | 12.453 | 10762.6 |
| 1050 | 2021-12-11 12:15:50 | agnates | 2 | 107671 | 37 | 3.080 | 34958.1 |
| 1049 | 2021-12-11 02:07:47 | agnates | 2 | 107671 | 37 | 2.766 | 38926.6 |
| 1048 | 2021-12-10 15:20:26 | agnates | 2 | 107671 | 37 | 2.860 | 37647.2 |
| 1047 | 2021-12-10 03:10:28 | agnates | 2 | 107671 | 37 | 3.546 | 30364.1 |
| 1046 | 2021-12-09 11:02:15 | agnates | 2 | 107671 | 37 | 3.046 | 35348.3 |
| 1045 | 2021-12-08 14:29:05 | agnates | 2 | 107671 | 37 | 2.906 | 37051.3 |
| 1044 | 2021-12-03 16:12:43 | agnates | 3 | 134027 | 463 | 6.033 | 22215.6 |
| 1043 | 2021-11-23 21:44:16 | agnates | 2 | 107671 | 37 | 2.783 | 38688.8 |
| 1042 | 2021-11-18 03:10:22 | agnates | 1 | 69583 | 5 | 1.140 | 61037.7 |
| 1041 | 2021-11-15 17:49:23 | agnates | 2 | 107671 | 37 | 3.250 | 33129.5 |
| 1040 | 2021-11-15 04:29:01 | agnates | 2 | 107671 | 37 | 3.096 | 34777.5 |
| 1039 | 2021-11-14 17:59:34 | agnates | 2 | 107671 | 37 | 3.203 | 33615.7 |
| 1038 | 2021-11-14 03:23:49 | agnates | 2 | 107671 | 37 | 3.093 | 34811.2 |
| 1037 | 2021-11-13 18:44:33 | agnates | 2 | 107671 | 37 | 3.390 | 31761.4 |
| 1036 | 2021-11-13 04:45:59 | agnates | 2 | 107671 | 37 | 3.080 | 34958.1 |
| 1035 | 2021-11-12 18:42:37 | agnates | 2 | 107671 | 37 | 3.110 | 34620.9 |
| 1034 | 2021-11-11 21:35:53 | agnates | 2 | 107671 | 37 | 3.233 | 33303.7 |
| 1033 | 2021-11-11 10:43:01 | agnates | 2 | 107671 | 37 | 3.000 | 35890.3 |
| 1032 | 2021-11-11 00:46:01 | agnates | 2 | 107671 | 37 | 3.106 | 34665.5 |
| 1031 | 2021-11-10 13:08:50 | agnates | 1 | 69583 | 5 | 1.190 | 58473.1 |
| 1030 | 2021-11-10 04:51:56 | agnates | 1 | 69583 | 5 | 1.190 | 58473.1 |
| 1029 | 2021-11-09 21:41:41 | agnates | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 1028 | 2021-11-09 15:03:52 | agnates | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 1027 | 2021-11-08 11:57:47 | agnates | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 1026 | 2021-11-08 00:55:48 | agnates | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 1025 | 2021-11-04 14:15:50 | agnates | 2 | 107671 | 37 | 2.780 | 38730.6 |
| 1024 | 2021-11-01 16:42:53 | agnates | 1 | 69583 | 5 | 1.216 | 57222.9 |
| 1023 | 2021-10-31 16:39:30 | agnates | 3 | 134027 | 463 | 5.813 | 23056.4 |
| 1022 | 2021-10-27 04:20:47 | agnates | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 1021 | 2021-10-26 19:00:03 | agnates | 2 | 107671 | 37 | 3.813 | 28237.9 |
| 1020 | 2021-10-26 13:43:28 | agnates | 3 | 134027 | 463 | 6.156 | 21771.8 |
| 1019 | 2021-10-26 10:57:48 | agnates | 2 | 107671 | 37 | 3.216 | 33479.8 |
| 1018 | 2021-10-25 17:32:51 | agnates | 2 | 107671 | 37 | 3.140 | 34290.1 |
| 1017 | 2021-10-25 17:22:46 | agnates | 3 | 134027 | 463 | 6.720 | 19944.5 |
| 1016 | 2021-10-25 08:50:50 | agnates | 2 | 107671 | 37 | 3.436 | 31336.1 |
| 1015 | 2021-10-25 04:40:02 | agnates | 3 | 134027 | 463 | 5.953 | 22514.2 |
| 1014 | 2021-10-25 02:45:03 | agnates | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 1013 | 2021-10-24 23:46:28 | agnates | 2 | 107671 | 37 | 3.190 | 33752.7 |
| 1012 | 2021-10-24 20:19:12 | agnates | 3 | 134027 | 463 | 10.410 | 12874.8 |
| 1011 | 2021-10-24 15:52:51 | agnates | 2 | 107671 | 37 | 3.436 | 31336.1 |
| 1010 | 2021-10-24 09:29:59 | agnates | 3 | 134027 | 463 | 5.910 | 22678.0 |
| 1009 | 2021-10-24 05:22:00 | agnates | 2 | 107671 | 37 | 3.203 | 33615.7 |