History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lightered"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
306 | 2024-04-27 07:00:47 | lightered | 4 | 165329 | 473 | 37.880 | 4364.5 |
305 | 2024-04-24 17:30:16 | lightered | 1 | 81242 | 2 | 1.330 | 61084.2 |
304 | 2024-04-20 07:03:35 | lightered | 3 | 148641 | 91 | 11.626 | 12785.2 |
303 | 2024-04-19 20:15:35 | lightered | 4 | 165329 | 473 | 25.660 | 6443.1 |
302 | 2024-04-19 16:59:00 | lightered | 3 | 148641 | 91 | 18.423 | 8068.2 |
301 | 2024-04-19 04:16:47 | lightered | 4 | 165329 | 473 | 41.533 | 3980.7 |
300 | 2024-04-19 02:01:25 | lightered | 3 | 148641 | 91 | 8.716 | 17053.8 |
299 | 2024-04-19 00:47:00 | lightered | 4 | 165329 | 473 | 32.376 | 5106.5 |
298 | 2024-04-19 00:47:01 | lightered | 3 | 148641 | 91 | 18.003 | 8256.5 |
297 | 2024-04-19 00:47:01 | lightered | 2 | 121436 | 10 | 8.690 | 13974.2 |
296 | 2024-04-19 00:42:07 | lightered | 1 | 81242 | 2 | 1.360 | 59736.8 |
295 | 2024-03-31 21:03:18 | lightered | 1 | 81242 | 2 | 2.953 | 27511.7 |
294 | 2024-03-29 05:26:01 | lightered | 1 | 81242 | 2 | 2.890 | 28111.4 |
293 | 2024-03-28 08:37:58 | lightered | 1 | 81242 | 2 | 1.356 | 59913.0 |
292 | 2024-03-16 18:53:36 | lightered | 1 | 81242 | 2 | 1.373 | 59171.2 |
291 | 2024-03-12 00:32:49 | lightered | 1 | 81242 | 2 | 1.330 | 61084.2 |
290 | 2024-02-27 21:14:40 | lightered | 1 | 81242 | 2 | 1.326 | 61268.5 |
289 | 2024-02-09 09:00:20 | lightered | 2 | 121436 | 10 | 4.143 | 29311.1 |
288 | 2024-02-01 10:06:16 | lightered | 1 | 81242 | 2 | 1.390 | 58447.5 |
287 | 2024-01-28 20:18:27 | lightered | 1 | 81242 | 2 | 1.343 | 60492.9 |
286 | 2024-01-21 05:55:15 | lightered | 1 | 81242 | 2 | 1.173 | 69260.0 |
285 | 2024-01-07 04:54:12 | lightered | 1 | 81242 | 2 | 1.296 | 62686.7 |
284 | 2023-12-30 12:41:31 | lightered | 1 | 81242 | 2 | 1.343 | 60492.9 |
283 | 2023-12-29 00:42:04 | lightered | 2 | 121436 | 10 | 3.796 | 31990.5 |
282 | 2023-12-28 12:42:53 | lightered | 2 | 121436 | 10 | 3.080 | 39427.3 |
281 | 2023-12-11 13:40:01 | lightered | 3 | 148641 | 91 | 6.080 | 24447.5 |
280 | 2023-11-29 01:53:22 | lightered | 1 | 81242 | 2 | 1.186 | 68500.8 |
279 | 2023-11-27 15:43:10 | lightered | 1 | 81242 | 2 | 1.203 | 67532.8 |
278 | 2023-11-19 13:10:19 | lightered | 1 | 81242 | 2 | 1.280 | 63470.3 |
277 | 2023-11-17 19:34:29 | lightered | 1 | 81242 | 2 | 1.296 | 62686.7 |
276 | 2023-11-12 21:05:08 | lightered | 2 | 121436 | 10 | 3.080 | 39427.3 |
275 | 2023-11-04 04:16:06 | lightered | 1 | 81242 | 2 | 2.703 | 30056.2 |
274 | 2023-10-26 13:36:51 | lightered | 1 | 81242 | 2 | 1.233 | 65889.7 |
273 | 2023-09-10 16:00:47 | lightered | 3 | 148641 | 91 | 5.830 | 25495.9 |
272 | 2023-09-04 08:47:30 | lightered | 1 | 81242 | 2 | 1.220 | 66591.8 |
271 | 2023-08-21 23:21:16 | lightered | 1 | 81242 | 2 | 1.313 | 61875.1 |
270 | 2023-08-16 09:58:10 | lightered | 2 | 121436 | 10 | 3.173 | 38271.7 |
269 | 2023-06-03 04:24:47 | lightered | 3 | 148641 | 91 | 5.796 | 25645.4 |
268 | 2023-05-24 10:50:04 | lightered | 3 | 148641 | 91 | 5.780 | 25716.4 |
267 | 2023-04-30 17:03:02 | lightered | 2 | 121436 | 10 | 2.940 | 41304.8 |
266 | 2023-04-27 01:55:59 | lightered | 1 | 81242 | 2 | 1.376 | 59042.2 |
265 | 2023-04-10 22:20:55 | lightered | 3 | 148641 | 91 | 5.750 | 25850.6 |
264 | 2023-03-11 03:42:28 | lightered | 3 | 148641 | 91 | 5.670 | 26215.3 |
263 | 2023-02-05 05:40:08 | lightered | 1 | 81242 | 2 | 1.186 | 68500.8 |
262 | 2023-02-04 18:31:49 | lightered | 2 | 121436 | 10 | 2.970 | 40887.5 |
261 | 2023-01-07 07:13:57 | lightered | 1 | 81242 | 2 | 1.406 | 57782.4 |
260 | 2022-12-16 14:07:27 | lightered | 3 | 148641 | 91 | 5.763 | 25792.3 |
259 | 2022-11-20 22:52:32 | lightered | 4 | 165329 | 473 | 10.016 | 16506.5 |
258 | 2022-11-16 03:07:26 | lightered | 2 | 121436 | 10 | 3.000 | 40478.7 |
257 | 2022-09-05 15:03:47 | lightered | 1 | 81242 | 2 | 1.220 | 66591.8 |
256 | 2022-08-11 02:33:15 | lightered | 3 | 148641 | 91 | 5.860 | 25365.4 |
255 | 2022-08-08 18:26:19 | lightered | 3 | 148641 | 91 | 6.876 | 21617.4 |
254 | 2022-06-26 19:09:23 | lightered | 3 | 148641 | 91 | 6.206 | 23951.2 |
253 | 2022-06-26 19:09:03 | lightered | 2 | 121436 | 10 | 2.940 | 41304.8 |
252 | 2022-06-17 15:22:10 | lightered | 2 | 121436 | 10 | 2.936 | 41361.0 |
251 | 2022-06-16 17:33:15 | lightered | 1 | 81242 | 2 | 1.220 | 66591.8 |
250 | 2022-06-10 06:25:57 | lightered | 3 | 148641 | 91 | 6.516 | 22811.7 |
249 | 2022-06-10 06:25:38 | lightered | 2 | 121436 | 10 | 3.013 | 40304.0 |
248 | 2022-06-08 23:09:02 | lightered | 1 | 81242 | 2 | 1.250 | 64993.6 |
247 | 2022-06-02 07:24:31 | lightered | 3 | 148641 | 91 | 6.076 | 24463.6 |
246 | 2022-06-02 07:24:02 | lightered | 2 | 121436 | 10 | 2.956 | 41081.2 |
245 | 2022-05-29 06:24:07 | lightered | 1 | 81242 | 2 | 1.313 | 61875.1 |
244 | 2022-05-27 01:23:57 | lightered | 1 | 81242 | 2 | 1.173 | 69260.0 |
243 | 2022-05-24 19:24:53 | lightered | 1 | 81242 | 2 | 1.236 | 65729.8 |
242 | 2022-04-28 17:48:38 | lightered | 4 | 165329 | 473 | 12.530 | 13194.7 |
241 | 2022-04-26 03:09:37 | lightered | 1 | 81242 | 2 | 1.326 | 61268.5 |
240 | 2022-03-27 18:37:00 | lightered | 1 | 81242 | 2 | 1.373 | 59171.2 |
239 | 2022-03-09 19:01:39 | lightered | 3 | 148641 | 91 | 6.643 | 22375.6 |
238 | 2022-02-16 11:14:43 | lightered | 2 | 121436 | 10 | 3.063 | 39646.1 |
237 | 2022-02-13 06:24:07 | lightered | 1 | 81242 | 2 | 1.236 | 65729.8 |
236 | 2022-01-06 08:23:19 | lightered | 1 | 81242 | 2 | 1.220 | 66591.8 |
235 | 2022-01-03 02:49:42 | lightered | 1 | 81242 | 2 | 1.450 | 56029.0 |
234 | 2021-12-27 10:40:25 | lightered | 4 | 165329 | 473 | 11.640 | 14203.5 |
233 | 2021-12-01 08:39:16 | lightered | 3 | 148641 | 91 | 6.346 | 23422.8 |
232 | 2021-11-19 15:04:13 | lightered | 1 | 81242 | 2 | 1.720 | 47233.7 |
231 | 2021-09-20 15:43:10 | lightered | 1 | 81242 | 2 | 1.420 | 57212.7 |
230 | 2021-08-21 19:21:34 | lightered | 1 | 81242 | 2 | 1.326 | 61268.5 |
229 | 2021-07-28 13:47:58 | lightered | 1 | 81242 | 2 | 1.423 | 57092.1 |
228 | 2021-07-07 15:22:52 | lightered | 1 | 81242 | 2 | 1.236 | 65729.8 |
227 | 2021-06-14 00:58:26 | lightered | 1 | 81242 | 2 | 1.220 | 66591.8 |
226 | 2021-06-03 18:46:16 | lightered | 4 | 165329 | 473 | 20.110 | 8221.2 |
225 | 2021-05-29 12:36:14 | lightered | 1 | 81242 | 2 | 1.360 | 59736.8 |
224 | 2021-05-21 21:41:39 | lightered | 1 | 81242 | 2 | 2.720 | 29868.4 |
223 | 2021-05-19 21:49:08 | lightered | 2 | 121436 | 10 | 3.376 | 35970.4 |
222 | 2021-03-22 18:02:18 | lightered | 2 | 121436 | 10 | 3.080 | 39427.3 |
221 | 2021-03-12 09:02:51 | lightered | 4 | 165329 | 473 | 12.483 | 13244.3 |
220 | 2021-03-11 05:06:54 | lightered | 1 | 81242 | 2 | 1.313 | 61875.1 |
219 | 2021-02-03 06:59:22 | lightered | 1 | 81242 | 2 | 1.360 | 59736.8 |
218 | 2021-02-01 08:26:05 | lightered | 1 | 81242 | 2 | 1.466 | 55417.5 |
217 | 2021-02-01 04:53:07 | lightered | 2 | 121436 | 10 | 4.236 | 28667.6 |
216 | 2021-01-04 15:30:16 | lightered | 2 | 121436 | 10 | 3.096 | 39223.5 |
215 | 2020-12-24 12:33:38 | lightered | 4 | 165329 | 473 | 10.080 | 16401.7 |
214 | 2020-12-07 23:34:43 | lightered | 1 | 81242 | 2 | 1.203 | 67532.8 |
213 | 2020-11-06 23:38:28 | lightered | 2 | 121436 | 10 | 3.250 | 37364.9 |
212 | 2020-10-29 22:18:24 | lightered | 1 | 81242 | 2 | 1.220 | 66591.8 |
211 | 2020-10-28 10:37:02 | lightered | 1 | 81242 | 2 | 1.296 | 62686.7 |
210 | 2020-10-27 03:03:17 | lightered | 1 | 81242 | 2 | 1.326 | 61268.5 |
209 | 2020-10-25 01:10:14 | lightered | 4 | 165329 | 473 | 15.126 | 10930.1 |
208 | 2020-10-20 18:56:14 | lightered | 1 | 81242 | 2 | 1.420 | 57212.7 |
207 | 2020-10-20 01:11:21 | lightered | 3 | 148641 | 91 | 6.013 | 24719.9 |