History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lodgers"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1215 | 2024-12-26 20:58:51 | lodgers | 1 | 69583 | 8 | 6.250 | 11133.3 |
| 1214 | 2024-12-02 11:57:39 | lodgers | 3 | 134027 | 845 | 41.643 | 3218.5 |
| 1213 | 2024-11-27 16:19:46 | lodgers | 1 | 69583 | 8 | 6.063 | 11476.7 |
| 1212 | 2024-11-27 04:16:22 | lodgers | 3 | 134027 | 845 | 21.110 | 6349.0 |
| 1211 | 2024-11-27 03:57:55 | lodgers | 3 | 134027 | 845 | 25.423 | 5271.9 |
| 1210 | 2024-11-27 03:57:56 | lodgers | 2 | 107671 | 89 | 17.736 | 6070.8 |
| 1209 | 2024-11-27 02:35:53 | lodgers | 3 | 134027 | 845 | 33.940 | 3948.9 |
| 1208 | 2024-11-27 02:35:52 | lodgers | 2 | 107671 | 89 | 15.470 | 6960.0 |
| 1207 | 2024-11-27 00:25:45 | lodgers | 1 | 69583 | 8 | 7.530 | 9240.8 |
| 1206 | 2024-11-19 00:37:21 | lodgers | 1 | 69583 | 8 | 4.250 | 16372.5 |
| 1205 | 2024-11-08 17:37:00 | lodgers | 1 | 69583 | 8 | 3.110 | 22374.0 |
| 1204 | 2024-11-06 06:33:18 | lodgers | 1 | 69583 | 8 | 7.373 | 9437.5 |
| 1203 | 2024-10-26 10:50:01 | lodgers | 3 | 134027 | 845 | 36.906 | 3631.6 |
| 1202 | 2024-10-26 08:29:24 | lodgers | 3 | 134027 | 845 | 27.220 | 4923.8 |
| 1201 | 2024-10-26 01:36:39 | lodgers | 3 | 134027 | 845 | 33.706 | 3976.4 |
| 1200 | 2024-10-25 20:40:18 | lodgers | 2 | 107671 | 89 | 12.813 | 8403.3 |
| 1199 | 2024-10-25 15:46:34 | lodgers | 3 | 134027 | 845 | 19.190 | 6984.2 |
| 1198 | 2024-10-25 15:25:05 | lodgers | 3 | 134027 | 845 | 16.096 | 8326.7 |
| 1197 | 2024-10-25 15:12:32 | lodgers | 3 | 134027 | 845 | 26.423 | 5072.4 |
| 1196 | 2024-10-25 15:12:32 | lodgers | 2 | 107671 | 89 | 10.030 | 10734.9 |
| 1195 | 2024-10-25 14:38:04 | lodgers | 2 | 107671 | 89 | 16.923 | 6362.4 |
| 1194 | 2024-10-25 14:38:01 | lodgers | 3 | 134027 | 845 | 18.940 | 7076.4 |
| 1193 | 2024-10-25 14:38:00 | lodgers | 1 | 69583 | 8 | 8.610 | 8081.6 |
| 1192 | 2024-10-25 14:21:53 | lodgers | 1 | 69583 | 8 | 5.296 | 13138.8 |
| 1191 | 2024-10-24 04:38:22 | lodgers | 1 | 69583 | 8 | 7.986 | 8713.1 |
| 1190 | 2024-10-09 02:43:10 | lodgers | 1 | 69583 | 8 | 2.480 | 28057.7 |
| 1189 | 2024-10-03 21:10:20 | lodgers | 1 | 69583 | 8 | 6.766 | 10284.2 |
| 1188 | 2024-10-02 16:55:08 | lodgers | 1 | 69583 | 8 | 11.750 | 5922.0 |
| 1187 | 2024-09-27 13:29:33 | lodgers | 1 | 69583 | 8 | 6.830 | 10187.8 |
| 1186 | 2024-09-11 22:29:30 | lodgers | 3 | 134027 | 845 | 46.796 | 2864.1 |
| 1185 | 2024-09-08 20:56:33 | lodgers | 3 | 134027 | 845 | 70.443 | 1902.6 |
| 1184 | 2024-09-08 17:27:39 | lodgers | 3 | 134027 | 845 | 27.940 | 4797.0 |
| 1183 | 2024-09-08 17:27:17 | lodgers | 2 | 107671 | 89 | 19.016 | 5662.1 |
| 1182 | 2024-09-08 17:14:01 | lodgers | 3 | 134027 | 845 | 40.473 | 3311.5 |
| 1181 | 2024-09-08 17:14:02 | lodgers | 2 | 107671 | 89 | 23.326 | 4615.9 |
| 1180 | 2024-09-08 17:13:38 | lodgers | 1 | 69583 | 8 | 1.203 | 57841.2 |
| 1179 | 2024-08-31 10:17:58 | lodgers | 1 | 69583 | 8 | 6.483 | 10733.1 |
| 1178 | 2024-08-30 17:44:51 | lodgers | 1 | 69583 | 8 | 11.530 | 6035.0 |
| 1177 | 2024-08-28 08:34:27 | lodgers | 1 | 69583 | 8 | 7.703 | 9033.2 |
| 1176 | 2024-08-22 04:42:53 | lodgers | 1 | 69583 | 8 | 9.393 | 7408.0 |
| 1175 | 2024-08-22 04:40:41 | lodgers | 1 | 69583 | 8 | 4.420 | 15742.8 |
| 1174 | 2024-08-21 03:54:01 | lodgers | 1 | 69583 | 8 | 10.236 | 6797.9 |
| 1173 | 2024-08-17 12:22:41 | lodgers | 1 | 69583 | 8 | 13.580 | 5123.9 |
| 1172 | 2024-08-13 13:04:11 | lodgers | 1 | 69583 | 8 | 9.796 | 7103.2 |
| 1171 | 2024-08-09 19:21:28 | lodgers | 1 | 69583 | 8 | 4.453 | 15626.1 |
| 1170 | 2024-07-31 22:41:00 | lodgers | 1 | 69583 | 8 | 1.950 | 35683.6 |
| 1169 | 2024-07-28 22:55:09 | lodgers | 1 | 69583 | 8 | 5.300 | 13128.9 |
| 1168 | 2024-07-16 20:00:02 | lodgers | 1 | 69583 | 8 | 7.390 | 9415.8 |
| 1167 | 2024-07-15 22:09:07 | lodgers | 1 | 69583 | 8 | 4.250 | 16372.5 |
| 1166 | 2024-07-11 02:33:23 | lodgers | 1 | 69583 | 8 | 4.266 | 16311.1 |
| 1165 | 2024-07-08 15:59:23 | lodgers | 1 | 69583 | 8 | 2.266 | 30707.4 |
| 1164 | 2024-07-01 18:53:29 | lodgers | 1 | 69583 | 8 | 2.843 | 24475.2 |
| 1163 | 2024-07-01 05:40:13 | lodgers | 2 | 107671 | 89 | 13.406 | 8031.6 |
| 1162 | 2024-07-01 01:07:03 | lodgers | 1 | 69583 | 8 | 4.593 | 15149.8 |
| 1161 | 2024-06-30 08:57:37 | lodgers | 2 | 107671 | 89 | 18.126 | 5940.1 |
| 1160 | 2024-06-30 03:22:04 | lodgers | 2 | 107671 | 89 | 7.753 | 13887.7 |
| 1159 | 2024-06-29 04:03:54 | lodgers | 2 | 107671 | 89 | 15.173 | 7096.2 |
| 1158 | 2024-06-29 04:03:48 | lodgers | 1 | 69583 | 8 | 4.126 | 16864.5 |
| 1157 | 2024-06-28 19:21:01 | lodgers | 1 | 69583 | 8 | 5.233 | 13297.0 |
| 1156 | 2024-06-24 17:04:42 | lodgers | 1 | 69583 | 8 | 5.140 | 13537.5 |
| 1155 | 2024-06-15 18:09:36 | lodgers | 3 | 134027 | 845 | 11.783 | 11374.6 |
| 1154 | 2024-06-15 16:31:44 | lodgers | 3 | 134027 | 845 | 16.966 | 7899.7 |
| 1153 | 2024-06-15 00:05:42 | lodgers | 3 | 134027 | 845 | 29.176 | 4593.7 |
| 1152 | 2024-05-28 22:23:32 | lodgers | 1 | 69583 | 8 | 2.656 | 26198.4 |
| 1151 | 2024-05-02 16:51:58 | lodgers | 1 | 69583 | 8 | 1.690 | 41173.4 |
| 1150 | 2024-05-02 13:29:32 | lodgers | 2 | 107671 | 89 | 3.263 | 32997.5 |
| 1149 | 2024-04-27 02:44:52 | lodgers | 1 | 69583 | 8 | 6.030 | 11539.5 |
| 1148 | 2024-04-24 21:47:28 | lodgers | 1 | 69583 | 8 | 1.516 | 45899.1 |
| 1147 | 2024-04-11 15:57:31 | lodgers | 1 | 69583 | 8 | 1.080 | 64428.7 |
| 1146 | 2024-04-06 07:11:23 | lodgers | 1 | 69583 | 8 | 2.220 | 31343.7 |
| 1145 | 2024-03-28 19:11:08 | lodgers | 1 | 69583 | 8 | 3.000 | 23194.3 |
| 1144 | 2024-03-20 01:56:11 | lodgers | 3 | 134027 | 845 | 9.860 | 13593.0 |
| 1143 | 2024-03-16 00:57:59 | lodgers | 3 | 134027 | 845 | 12.283 | 10911.6 |
| 1142 | 2024-03-05 19:41:59 | lodgers | 1 | 69583 | 8 | 1.216 | 57222.9 |
| 1141 | 2024-03-04 00:06:48 | lodgers | 3 | 134027 | 845 | 12.076 | 11098.6 |
| 1140 | 2024-03-02 06:42:13 | lodgers | 3 | 134027 | 845 | 20.453 | 6552.9 |
| 1139 | 2024-02-29 14:09:58 | lodgers | 1 | 69583 | 8 | 2.483 | 28023.8 |
| 1138 | 2024-02-28 14:59:16 | lodgers | 2 | 107671 | 89 | 3.953 | 27237.8 |
| 1137 | 2024-02-27 22:11:43 | lodgers | 2 | 107671 | 89 | 3.466 | 31064.9 |
| 1136 | 2024-02-27 22:11:14 | lodgers | 3 | 134027 | 845 | 7.703 | 17399.3 |
| 1135 | 2024-02-21 13:28:16 | lodgers | 3 | 134027 | 845 | 25.266 | 5304.6 |
| 1134 | 2024-02-18 14:47:17 | lodgers | 3 | 134027 | 845 | 6.390 | 20974.5 |
| 1133 | 2024-01-27 23:45:43 | lodgers | 3 | 134027 | 845 | 7.033 | 19056.9 |
| 1132 | 2024-01-26 11:57:59 | lodgers | 3 | 134027 | 845 | 7.843 | 17088.7 |
| 1131 | 2023-12-25 04:26:17 | lodgers | 1 | 69583 | 8 | 1.330 | 52318.0 |
| 1130 | 2023-12-24 06:22:21 | lodgers | 1 | 69583 | 8 | 1.080 | 64428.7 |
| 1129 | 2023-12-24 03:03:59 | lodgers | 2 | 107671 | 89 | 2.843 | 37872.3 |
| 1128 | 2023-12-14 02:48:58 | lodgers | 2 | 107671 | 89 | 4.313 | 24964.3 |
| 1127 | 2023-12-04 18:22:22 | lodgers | 3 | 134027 | 845 | 6.190 | 21652.2 |
| 1126 | 2023-11-30 05:28:53 | lodgers | 3 | 134027 | 845 | 5.986 | 22390.1 |
| 1125 | 2023-11-30 05:28:55 | lodgers | 2 | 107671 | 89 | 3.313 | 32499.5 |
| 1124 | 2023-11-27 18:34:53 | lodgers | 1 | 69583 | 8 | 1.220 | 57035.2 |
| 1123 | 2023-11-24 04:49:45 | lodgers | 1 | 69583 | 8 | 2.016 | 34515.4 |
| 1122 | 2023-11-16 23:56:45 | lodgers | 3 | 134027 | 845 | 5.690 | 23554.8 |
| 1121 | 2023-11-15 21:50:37 | lodgers | 3 | 134027 | 845 | 5.906 | 22693.4 |
| 1120 | 2023-11-12 12:03:07 | lodgers | 1 | 69583 | 8 | 1.123 | 61961.7 |
| 1119 | 2023-11-11 13:44:57 | lodgers | 3 | 134027 | 845 | 6.923 | 19359.7 |
| 1118 | 2023-11-11 13:44:58 | lodgers | 2 | 107671 | 89 | 3.456 | 31154.8 |
| 1117 | 2023-11-10 16:06:20 | lodgers | 3 | 134027 | 845 | 5.953 | 22514.2 |
| 1116 | 2023-11-10 02:05:10 | lodgers | 1 | 69583 | 8 | 1.046 | 66522.9 |