History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"fanlight"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
269 | 2024-04-28 20:51:51 | fanlight | 1 | 82945 | 2 | 1.780 | 46598.3 |
268 | 2024-04-07 14:30:40 | fanlight | 4 | 161609 | 351 | 38.910 | 4153.4 |
267 | 2024-04-05 20:29:20 | fanlight | 1 | 82945 | 2 | 4.423 | 18753.1 |
266 | 2024-04-05 20:03:00 | fanlight | 4 | 161609 | 351 | 14.300 | 11301.3 |
265 | 2024-04-04 05:25:13 | fanlight | 1 | 82945 | 2 | 6.640 | 12491.7 |
264 | 2024-04-04 05:16:23 | fanlight | 2 | 121059 | 8 | 8.516 | 14215.5 |
263 | 2024-04-04 05:16:11 | fanlight | 4 | 161609 | 351 | 15.343 | 10533.1 |
262 | 2024-04-04 05:16:10 | fanlight | 3 | 146162 | 59 | 8.876 | 16467.1 |
261 | 2024-04-03 16:42:13 | fanlight | 3 | 146162 | 59 | 22.470 | 6504.8 |
260 | 2024-04-03 16:42:14 | fanlight | 4 | 161609 | 351 | 18.753 | 8617.8 |
259 | 2024-04-03 16:42:09 | fanlight | 2 | 121059 | 8 | 8.796 | 13763.0 |
258 | 2024-04-03 16:42:04 | fanlight | 1 | 82945 | 2 | 3.140 | 26415.6 |
257 | 2024-03-29 19:49:28 | fanlight | 1 | 82945 | 2 | 2.716 | 30539.4 |
256 | 2024-03-25 08:09:44 | fanlight | 1 | 82945 | 2 | 1.296 | 64000.8 |
255 | 2024-03-17 12:39:58 | fanlight | 1 | 82945 | 2 | 3.296 | 25165.4 |
254 | 2024-03-12 05:00:04 | fanlight | 3 | 146162 | 59 | 16.530 | 8842.2 |
253 | 2024-03-07 08:45:32 | fanlight | 3 | 146162 | 59 | 16.830 | 8684.6 |
252 | 2024-03-06 23:46:18 | fanlight | 4 | 161609 | 351 | 37.003 | 4367.5 |
251 | 2024-03-06 14:12:32 | fanlight | 1 | 82945 | 2 | 1.640 | 50576.2 |
250 | 2024-03-06 13:53:09 | fanlight | 4 | 161609 | 351 | 17.860 | 9048.7 |
249 | 2024-03-05 15:02:57 | fanlight | 2 | 121059 | 8 | 3.846 | 31476.6 |
248 | 2024-03-05 14:58:30 | fanlight | 3 | 146162 | 59 | 8.796 | 16616.9 |
247 | 2024-03-01 05:18:15 | fanlight | 4 | 161609 | 351 | 14.080 | 11477.9 |
246 | 2024-02-29 14:47:02 | fanlight | 4 | 161609 | 351 | 18.346 | 8809.0 |
245 | 2024-02-29 14:47:10 | fanlight | 3 | 146162 | 59 | 8.313 | 17582.3 |
244 | 2024-02-29 14:46:56 | fanlight | 2 | 121059 | 8 | 3.936 | 30756.9 |
243 | 2024-02-28 16:04:14 | fanlight | 2 | 121059 | 8 | 15.173 | 7978.6 |
242 | 2024-02-28 14:21:31 | fanlight | 1 | 82945 | 2 | 3.013 | 27529.0 |
241 | 2024-02-28 11:46:00 | fanlight | 1 | 82945 | 2 | 1.546 | 53651.4 |
240 | 2024-02-18 18:59:32 | fanlight | 3 | 146162 | 59 | 8.000 | 18270.3 |
239 | 2024-02-18 18:56:03 | fanlight | 3 | 146162 | 59 | 18.016 | 8112.9 |
238 | 2024-02-10 17:04:20 | fanlight | 3 | 146162 | 59 | 69.096 | 2115.3 |
237 | 2024-02-06 03:08:06 | fanlight | 3 | 146162 | 59 | 6.580 | 22213.1 |
236 | 2024-02-04 02:51:59 | fanlight | 4 | 161609 | 351 | 25.906 | 6238.3 |
235 | 2024-01-30 20:27:47 | fanlight | 2 | 121059 | 8 | 3.656 | 33112.4 |
234 | 2024-01-30 20:25:11 | fanlight | 4 | 161609 | 351 | 14.846 | 10885.7 |
233 | 2024-01-30 20:25:07 | fanlight | 3 | 146162 | 59 | 8.486 | 17223.9 |
232 | 2024-01-30 09:05:43 | fanlight | 4 | 161609 | 351 | 12.486 | 12943.2 |
231 | 2024-01-30 09:05:51 | fanlight | 2 | 121059 | 8 | 3.690 | 32807.3 |
230 | 2024-01-30 09:05:39 | fanlight | 3 | 146162 | 59 | 6.643 | 22002.4 |
229 | 2024-01-30 09:03:31 | fanlight | 4 | 161609 | 351 | 13.033 | 12400.0 |
228 | 2024-01-30 09:03:36 | fanlight | 3 | 146162 | 59 | 7.953 | 18378.2 |
227 | 2024-01-30 09:03:39 | fanlight | 2 | 121059 | 8 | 4.080 | 29671.3 |
226 | 2024-01-25 11:50:11 | fanlight | 1 | 82945 | 2 | 1.280 | 64800.8 |
225 | 2024-01-13 05:43:50 | fanlight | 1 | 82945 | 2 | 1.593 | 52068.4 |
224 | 2024-01-03 03:50:33 | fanlight | 2 | 121059 | 8 | 3.563 | 33976.7 |
223 | 2023-12-15 06:29:39 | fanlight | 1 | 82945 | 2 | 1.453 | 57085.3 |
222 | 2023-12-08 17:21:18 | fanlight | 1 | 82945 | 2 | 1.436 | 57761.1 |
221 | 2023-11-24 22:49:34 | fanlight | 3 | 146162 | 59 | 8.690 | 16819.6 |
220 | 2023-11-20 06:36:18 | fanlight | 1 | 82945 | 2 | 1.266 | 65517.4 |
219 | 2023-11-19 07:37:29 | fanlight | 4 | 161609 | 351 | 11.466 | 14094.6 |
218 | 2023-11-17 17:38:45 | fanlight | 4 | 161609 | 351 | 10.750 | 15033.4 |
217 | 2023-11-12 19:58:49 | fanlight | 4 | 161609 | 351 | 32.580 | 4960.4 |
216 | 2023-11-06 07:06:30 | fanlight | 4 | 161609 | 351 | 15.203 | 10630.1 |
215 | 2023-11-06 07:06:27 | fanlight | 3 | 146162 | 59 | 9.923 | 14729.6 |
214 | 2023-11-05 07:27:28 | fanlight | 1 | 82945 | 2 | 1.266 | 65517.4 |
213 | 2023-10-22 09:09:26 | fanlight | 3 | 146162 | 59 | 7.750 | 18859.6 |
212 | 2023-10-22 09:09:21 | fanlight | 2 | 121059 | 8 | 3.860 | 31362.4 |
211 | 2023-10-18 16:49:59 | fanlight | 1 | 82945 | 2 | 1.296 | 64000.8 |
210 | 2023-10-17 05:20:29 | fanlight | 4 | 161609 | 351 | 15.813 | 10220.0 |
209 | 2023-10-17 03:44:47 | fanlight | 1 | 82945 | 2 | 3.106 | 26704.8 |
208 | 2023-10-16 14:39:50 | fanlight | 4 | 161609 | 351 | 11.763 | 13738.8 |
207 | 2023-10-16 14:39:49 | fanlight | 2 | 121059 | 8 | 3.673 | 32959.2 |
206 | 2023-10-16 14:39:42 | fanlight | 3 | 146162 | 59 | 7.143 | 20462.3 |
205 | 2023-10-11 00:26:02 | fanlight | 1 | 82945 | 2 | 1.266 | 65517.4 |
204 | 2023-10-07 17:07:42 | fanlight | 2 | 121059 | 8 | 3.283 | 36874.5 |
203 | 2023-09-29 15:37:51 | fanlight | 1 | 82945 | 2 | 2.686 | 30880.5 |
202 | 2023-09-11 07:28:47 | fanlight | 4 | 161609 | 351 | 26.516 | 6094.8 |
201 | 2023-09-06 21:18:52 | fanlight | 1 | 82945 | 2 | 1.263 | 65673.0 |
200 | 2023-08-27 11:54:53 | fanlight | 4 | 161609 | 351 | 11.266 | 14344.8 |
199 | 2023-08-19 16:17:03 | fanlight | 4 | 161609 | 351 | 18.750 | 8619.1 |
198 | 2023-06-16 11:13:42 | fanlight | 1 | 82945 | 2 | 1.266 | 65517.4 |
197 | 2023-06-16 04:42:58 | fanlight | 4 | 161609 | 351 | 11.656 | 13864.9 |
196 | 2023-05-13 06:08:45 | fanlight | 4 | 161609 | 351 | 10.903 | 14822.4 |
195 | 2023-05-04 22:45:25 | fanlight | 4 | 161609 | 351 | 10.970 | 14731.9 |
194 | 2023-04-01 10:28:57 | fanlight | 2 | 121059 | 8 | 3.143 | 38517.0 |
193 | 2023-03-28 11:00:04 | fanlight | 1 | 82945 | 2 | 1.266 | 65517.4 |
192 | 2023-02-24 19:29:19 | fanlight | 4 | 161609 | 351 | 10.716 | 15081.1 |
191 | 2023-02-18 11:06:45 | fanlight | 1 | 82945 | 2 | 1.390 | 59672.7 |
190 | 2023-02-14 23:18:02 | fanlight | 1 | 82945 | 2 | 1.436 | 57761.1 |
189 | 2023-02-07 21:36:56 | fanlight | 4 | 161609 | 351 | 11.576 | 13960.7 |
188 | 2023-01-27 11:39:29 | fanlight | 4 | 161609 | 351 | 11.030 | 14651.8 |
187 | 2023-01-11 23:58:48 | fanlight | 1 | 82945 | 2 | 1.233 | 67270.9 |
186 | 2023-01-03 06:10:28 | fanlight | 4 | 161609 | 351 | 11.876 | 13608.0 |
185 | 2022-12-28 17:19:51 | fanlight | 2 | 121059 | 8 | 3.593 | 33693.0 |
184 | 2022-11-20 21:26:24 | fanlight | 4 | 161609 | 351 | 10.560 | 15303.9 |
183 | 2022-10-17 16:51:44 | fanlight | 1 | 82945 | 2 | 1.313 | 63172.1 |
182 | 2022-10-10 12:17:10 | fanlight | 1 | 82945 | 2 | 1.280 | 64800.8 |
181 | 2022-09-03 21:16:38 | fanlight | 3 | 146162 | 59 | 6.233 | 23449.7 |
180 | 2022-08-29 06:08:30 | fanlight | 2 | 121059 | 8 | 3.330 | 36354.1 |
179 | 2022-06-09 02:24:37 | fanlight | 1 | 82945 | 2 | 1.250 | 66356.0 |
178 | 2022-06-07 22:08:07 | fanlight | 1 | 82945 | 2 | 1.283 | 64649.3 |
177 | 2022-06-05 11:36:52 | fanlight | 1 | 82945 | 2 | 1.530 | 54212.4 |
176 | 2022-05-16 09:43:52 | fanlight | 1 | 82945 | 2 | 1.546 | 53651.4 |
175 | 2022-04-30 18:19:40 | fanlight | 4 | 161609 | 351 | 11.170 | 14468.1 |
174 | 2022-03-02 18:00:38 | fanlight | 1 | 82945 | 2 | 1.250 | 66356.0 |
173 | 2022-01-28 19:48:53 | fanlight | 1 | 82945 | 2 | 1.450 | 57203.4 |
172 | 2021-10-30 15:41:15 | fanlight | 1 | 82945 | 2 | 1.390 | 59672.7 |
171 | 2021-10-29 14:14:45 | fanlight | 1 | 82945 | 2 | 1.280 | 64800.8 |
170 | 2021-10-27 22:42:16 | fanlight | 1 | 82945 | 2 | 1.436 | 57761.1 |