History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"footlights"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
327 | 2025-07-15 23:18:08 | footlights | 1 | 67641 | 2 | 1.106 | 61158.2 |
326 | 2025-07-15 09:51:37 | footlights | 2 | 108824 | 6 | 19.813 | 5492.6 |
325 | 2025-07-15 04:54:31 | footlights | 3 | 140603 | 22 | 34.613 | 4062.1 |
324 | 2025-07-14 11:35:23 | footlights | 1 | 67641 | 2 | 4.516 | 14978.1 |
323 | 2025-07-14 02:35:25 | footlights | 1 | 67641 | 2 | 5.513 | 12269.4 |
322 | 2025-07-11 23:18:39 | footlights | 3 | 140603 | 22 | 6.500 | 21631.2 |
321 | 2025-07-11 12:26:34 | footlights | 1 | 67641 | 2 | 7.876 | 8588.2 |
320 | 2025-06-18 06:16:16 | footlights | 1 | 67641 | 2 | 3.780 | 17894.4 |
319 | 2025-06-16 10:09:13 | footlights | 1 | 67641 | 2 | 4.486 | 15078.2 |
318 | 2025-06-15 01:32:01 | footlights | 4 | 161450 | 125 | 12.623 | 12790.1 |
317 | 2025-06-13 10:50:03 | footlights | 1 | 67641 | 2 | 1.203 | 56226.9 |
316 | 2025-06-12 08:11:28 | footlights | 4 | 161450 | 125 | 61.253 | 2635.8 |
315 | 2025-06-10 14:24:45 | footlights | 4 | 161450 | 125 | 63.600 | 2538.5 |
314 | 2025-06-09 21:22:40 | footlights | 1 | 67641 | 2 | 4.033 | 16771.9 |
313 | 2025-06-05 07:42:06 | footlights | 3 | 140603 | 22 | 26.050 | 5397.4 |
312 | 2025-05-30 04:37:46 | footlights | 1 | 67641 | 2 | 1.280 | 52844.5 |
311 | 2025-05-26 11:08:26 | footlights | 1 | 67641 | 2 | 3.690 | 18330.9 |
310 | 2025-05-24 14:09:00 | footlights | 4 | 161450 | 125 | 56.550 | 2855.0 |
309 | 2025-05-22 16:36:23 | footlights | 3 | 140603 | 22 | 27.376 | 5136.0 |
308 | 2025-05-13 22:33:34 | footlights | 3 | 140603 | 22 | 26.046 | 5398.3 |
307 | 2025-05-12 20:23:00 | footlights | 1 | 67641 | 2 | 1.250 | 54112.8 |
306 | 2025-05-12 16:07:42 | footlights | 3 | 140603 | 22 | 43.673 | 3219.4 |
305 | 2025-05-05 13:32:07 | footlights | 3 | 140603 | 22 | 32.096 | 4380.7 |
304 | 2025-05-05 05:17:12 | footlights | 2 | 108824 | 6 | 6.393 | 17022.4 |
303 | 2025-05-04 01:01:14 | footlights | 1 | 67641 | 2 | 3.466 | 19515.6 |
302 | 2025-05-03 22:52:19 | footlights | 1 | 67641 | 2 | 3.150 | 21473.3 |
301 | 2025-05-02 02:28:46 | footlights | 4 | 161450 | 125 | 32.503 | 4967.2 |
300 | 2025-04-30 22:07:49 | footlights | 4 | 161450 | 125 | 71.626 | 2254.1 |
299 | 2025-04-17 07:09:13 | footlights | 4 | 161450 | 125 | 54.890 | 2941.3 |
298 | 2025-04-15 13:58:22 | footlights | 2 | 108824 | 6 | 5.873 | 18529.5 |
297 | 2025-04-14 13:52:43 | footlights | 4 | 161450 | 125 | 50.963 | 3168.0 |
296 | 2025-04-11 18:16:06 | footlights | 4 | 161450 | 125 | 47.126 | 3425.9 |
295 | 2025-04-09 23:15:54 | footlights | 3 | 140603 | 22 | 27.466 | 5119.2 |
294 | 2025-04-09 18:16:38 | footlights | 2 | 108824 | 6 | 15.720 | 6922.6 |
293 | 2025-04-09 17:53:42 | footlights | 3 | 140603 | 22 | 33.706 | 4171.5 |
292 | 2025-04-08 11:05:13 | footlights | 1 | 67641 | 2 | 5.266 | 12844.9 |
291 | 2025-03-30 13:10:49 | footlights | 3 | 140603 | 22 | 25.406 | 5534.2 |
290 | 2025-03-25 12:00:13 | footlights | 1 | 67641 | 2 | 7.250 | 9329.8 |
289 | 2025-03-22 04:06:00 | footlights | 3 | 140603 | 22 | 24.140 | 5824.5 |
288 | 2025-03-18 04:13:51 | footlights | 3 | 140603 | 22 | 32.873 | 4277.2 |
287 | 2025-03-17 10:41:12 | footlights | 3 | 140603 | 22 | 56.846 | 2473.4 |
286 | 2025-03-14 01:40:15 | footlights | 1 | 67641 | 2 | 8.030 | 8423.5 |
285 | 2025-03-13 22:26:51 | footlights | 3 | 140603 | 22 | 46.640 | 3014.6 |
284 | 2025-03-12 05:59:06 | footlights | 4 | 161450 | 125 | 67.690 | 2385.1 |
283 | 2025-03-11 20:00:35 | footlights | 4 | 161450 | 125 | 56.203 | 2872.6 |
282 | 2025-03-10 14:38:50 | footlights | 2 | 108824 | 6 | 11.436 | 9515.9 |
281 | 2025-03-10 02:54:36 | footlights | 4 | 161450 | 125 | 69.526 | 2322.2 |
280 | 2025-03-03 15:19:50 | footlights | 1 | 67641 | 2 | 5.516 | 12262.7 |
279 | 2025-02-23 04:53:39 | footlights | 1 | 67641 | 2 | 2.300 | 29409.1 |
278 | 2025-02-17 09:39:06 | footlights | 3 | 140603 | 22 | 16.190 | 8684.6 |
277 | 2025-02-17 09:39:05 | footlights | 2 | 108824 | 6 | 7.580 | 14356.7 |
276 | 2025-02-16 23:36:18 | footlights | 3 | 140603 | 22 | 35.393 | 3972.6 |
275 | 2025-02-16 23:35:55 | footlights | 2 | 108824 | 6 | 14.436 | 7538.4 |
274 | 2025-02-15 03:38:13 | footlights | 3 | 140603 | 22 | 30.393 | 4626.2 |
273 | 2025-02-15 03:38:00 | footlights | 2 | 108824 | 6 | 22.800 | 4773.0 |
272 | 2025-02-15 03:35:22 | footlights | 1 | 67641 | 2 | 3.263 | 20729.7 |
271 | 2025-01-30 16:52:36 | footlights | 4 | 161450 | 125 | 47.233 | 3418.2 |
270 | 2025-01-30 12:57:23 | footlights | 4 | 161450 | 125 | 56.550 | 2855.0 |
269 | 2025-01-30 12:32:10 | footlights | 4 | 161450 | 125 | 40.156 | 4020.6 |
268 | 2025-01-28 13:28:11 | footlights | 4 | 161450 | 125 | 60.723 | 2658.8 |
267 | 2025-01-27 07:15:38 | footlights | 2 | 108824 | 6 | 15.113 | 7200.7 |
266 | 2025-01-27 07:11:46 | footlights | 1 | 67641 | 2 | 5.860 | 11542.8 |
265 | 2025-01-16 04:33:02 | footlights | 1 | 67641 | 2 | 5.893 | 11478.2 |
264 | 2025-01-10 01:14:27 | footlights | 2 | 108824 | 6 | 17.126 | 6354.3 |
263 | 2025-01-08 10:12:14 | footlights | 2 | 108824 | 6 | 14.830 | 7338.1 |
262 | 2025-01-06 07:32:48 | footlights | 1 | 67641 | 2 | 6.893 | 9813.0 |
261 | 2025-01-02 00:56:30 | footlights | 3 | 140603 | 22 | 25.373 | 5541.4 |
260 | 2024-12-31 10:05:41 | footlights | 2 | 108824 | 6 | 23.110 | 4709.0 |
259 | 2024-12-31 10:01:47 | footlights | 1 | 67641 | 2 | 2.876 | 23519.1 |
258 | 2024-12-31 09:41:22 | footlights | 4 | 161450 | 125 | 64.143 | 2517.0 |
257 | 2024-12-30 23:49:41 | footlights | 4 | 161450 | 125 | 59.723 | 2703.3 |
256 | 2024-12-30 09:02:38 | footlights | 3 | 140603 | 22 | 27.250 | 5159.7 |
255 | 2024-12-15 04:59:00 | footlights | 1 | 67641 | 2 | 1.986 | 34058.9 |
254 | 2024-12-10 09:41:59 | footlights | 2 | 108824 | 6 | 14.343 | 7587.3 |
253 | 2024-12-07 23:24:00 | footlights | 1 | 67641 | 2 | 6.560 | 10311.1 |
252 | 2024-12-05 19:55:44 | footlights | 3 | 140603 | 22 | 30.986 | 4537.6 |
251 | 2024-12-05 19:55:16 | footlights | 2 | 108824 | 6 | 20.890 | 5209.4 |
250 | 2024-12-02 21:18:54 | footlights | 3 | 140603 | 22 | 20.016 | 7024.5 |
249 | 2024-11-29 19:22:09 | footlights | 2 | 108824 | 6 | 12.110 | 8986.3 |
248 | 2024-11-29 19:21:53 | footlights | 1 | 67641 | 2 | 5.750 | 11763.7 |
247 | 2024-11-29 19:20:37 | footlights | 3 | 140603 | 22 | 31.813 | 4419.7 |
246 | 2024-11-27 16:47:12 | footlights | 3 | 140603 | 22 | 36.923 | 3808.0 |
245 | 2024-11-27 16:47:13 | footlights | 2 | 108824 | 6 | 15.266 | 7128.5 |
244 | 2024-11-27 15:40:06 | footlights | 1 | 67641 | 2 | 1.173 | 57665.0 |
243 | 2024-11-27 07:38:17 | footlights | 4 | 161450 | 125 | 65.173 | 2477.3 |
242 | 2024-11-14 13:51:09 | footlights | 1 | 67641 | 2 | 1.123 | 60232.4 |
241 | 2024-11-07 07:45:35 | footlights | 2 | 108824 | 6 | 14.703 | 7401.5 |
240 | 2024-11-07 07:44:16 | footlights | 1 | 67641 | 2 | 1.453 | 46552.6 |
239 | 2024-10-31 23:59:26 | footlights | 3 | 140603 | 22 | 24.596 | 5716.5 |
238 | 2024-10-31 23:59:17 | footlights | 2 | 108824 | 6 | 22.220 | 4897.6 |
237 | 2024-10-30 11:02:04 | footlights | 3 | 140603 | 22 | 30.703 | 4579.5 |
236 | 2024-10-30 04:10:46 | footlights | 4 | 161450 | 125 | 64.050 | 2520.7 |
235 | 2024-10-26 04:23:34 | footlights | 3 | 140603 | 22 | 20.766 | 6770.8 |
234 | 2024-10-26 04:23:31 | footlights | 3 | 140603 | 22 | 16.783 | 8377.7 |
233 | 2024-10-26 04:23:31 | footlights | 2 | 108824 | 6 | 10.970 | 9920.1 |
232 | 2024-10-26 03:59:00 | footlights | 3 | 140603 | 22 | 31.156 | 4512.9 |
231 | 2024-10-25 17:44:19 | footlights | 4 | 161450 | 125 | 65.063 | 2481.4 |
230 | 2024-10-25 17:44:20 | footlights | 3 | 140603 | 22 | 35.206 | 3993.7 |
229 | 2024-10-25 17:44:27 | footlights | 2 | 108824 | 6 | 21.936 | 4961.0 |
228 | 2024-10-25 17:42:19 | footlights | 1 | 67641 | 2 | 5.690 | 11887.7 |