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 |
| 334 | 2025-11-26 10:45:38 | footlights | 2 | 108824 | 6 | 5.453 | 19956.7 |
| 333 | 2025-10-20 09:08:25 | footlights | 1 | 67641 | 2 | 3.220 | 21006.5 |
| 332 | 2025-08-24 10:41:28 | footlights | 1 | 67641 | 2 | 2.953 | 22905.9 |
| 331 | 2025-08-08 23:05:22 | footlights | 1 | 67641 | 2 | 3.346 | 20215.5 |
| 330 | 2025-07-24 12:02:53 | footlights | 1 | 67641 | 2 | 7.453 | 9075.7 |
| 329 | 2025-07-17 15:20:44 | footlights | 2 | 108824 | 6 | 7.576 | 14364.3 |
| 328 | 2025-07-16 14:33:14 | footlights | 2 | 108824 | 6 | 3.186 | 34156.9 |
| 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 |