History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"forefront"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 339 | 2025-11-03 07:08:59 | forefront | 1 | 81242 | 2 | 1.406 | 57782.4 |
| 338 | 2025-10-27 08:43:21 | forefront | 1 | 81242 | 2 | 1.436 | 56575.2 |
| 337 | 2025-10-26 16:15:58 | forefront | 1 | 81242 | 2 | 1.440 | 56418.1 |
| 336 | 2025-10-01 09:12:29 | forefront | 4 | 165329 | 185 | 12.156 | 13600.6 |
| 335 | 2025-10-01 07:36:51 | forefront | 1 | 81242 | 2 | 1.466 | 55417.5 |
| 334 | 2025-09-18 01:58:16 | forefront | 2 | 121436 | 6 | 3.750 | 32382.9 |
| 333 | 2025-09-12 07:06:44 | forefront | 3 | 148641 | 29 | 6.733 | 22076.5 |
| 332 | 2025-09-10 05:52:35 | forefront | 1 | 81242 | 2 | 1.436 | 56575.2 |
| 331 | 2025-09-09 04:02:01 | forefront | 2 | 121436 | 6 | 3.500 | 34696.0 |
| 330 | 2025-08-09 04:24:09 | forefront | 1 | 81242 | 2 | 5.750 | 14129.0 |
| 329 | 2025-08-06 02:36:17 | forefront | 1 | 81242 | 2 | 3.173 | 25604.2 |
| 328 | 2025-08-01 05:17:09 | forefront | 1 | 81242 | 2 | 6.563 | 12378.8 |
| 327 | 2025-07-13 03:41:27 | forefront | 3 | 148641 | 29 | 7.920 | 18767.8 |
| 326 | 2025-07-10 20:05:32 | forefront | 1 | 81242 | 2 | 3.780 | 21492.6 |
| 325 | 2025-06-30 04:21:56 | forefront | 1 | 81242 | 2 | 9.780 | 8307.0 |
| 324 | 2025-06-27 09:08:25 | forefront | 3 | 148641 | 29 | 44.626 | 3330.8 |
| 323 | 2025-06-26 18:01:07 | forefront | 1 | 81242 | 2 | 7.940 | 10232.0 |
| 322 | 2025-06-26 03:08:12 | forefront | 1 | 81242 | 2 | 9.046 | 8981.0 |
| 321 | 2025-06-24 05:13:05 | forefront | 3 | 148641 | 29 | 23.236 | 6397.0 |
| 320 | 2025-06-23 15:56:50 | forefront | 1 | 81242 | 2 | 1.500 | 54161.3 |
| 319 | 2025-06-20 05:38:11 | forefront | 3 | 148641 | 29 | 28.686 | 5181.7 |
| 318 | 2025-06-12 02:17:11 | forefront | 3 | 148641 | 29 | 29.893 | 4972.4 |
| 317 | 2025-05-29 16:15:54 | forefront | 1 | 81242 | 2 | 6.643 | 12229.7 |
| 316 | 2025-05-04 04:01:21 | forefront | 1 | 81242 | 2 | 3.560 | 22820.8 |
| 315 | 2025-04-30 04:14:22 | forefront | 1 | 81242 | 2 | 4.530 | 17934.2 |
| 314 | 2025-04-24 09:11:54 | forefront | 3 | 148641 | 29 | 54.786 | 2713.1 |
| 313 | 2025-04-24 02:37:56 | forefront | 3 | 148641 | 29 | 33.863 | 4389.5 |
| 312 | 2025-04-11 08:17:41 | forefront | 3 | 148641 | 29 | 35.643 | 4170.3 |
| 311 | 2025-03-31 16:44:07 | forefront | 1 | 81242 | 2 | 7.796 | 10421.0 |
| 310 | 2025-03-23 20:38:51 | forefront | 3 | 148641 | 29 | 40.276 | 3690.6 |
| 309 | 2025-03-22 20:57:43 | forefront | 2 | 121436 | 6 | 15.753 | 7708.8 |
| 308 | 2025-03-22 02:59:53 | forefront | 1 | 81242 | 2 | 2.346 | 34630.0 |
| 307 | 2025-03-18 03:36:00 | forefront | 3 | 148641 | 29 | 37.936 | 3918.2 |
| 306 | 2025-03-08 18:07:10 | forefront | 3 | 148641 | 29 | 52.016 | 2857.6 |
| 305 | 2025-03-08 18:07:19 | forefront | 3 | 148641 | 29 | 33.050 | 4497.5 |
| 304 | 2025-03-08 18:07:09 | forefront | 2 | 121436 | 6 | 22.030 | 5512.3 |
| 303 | 2025-03-08 17:33:04 | forefront | 1 | 81242 | 2 | 1.220 | 66591.8 |
| 302 | 2025-03-04 05:49:42 | forefront | 3 | 148641 | 29 | 36.783 | 4041.0 |
| 301 | 2025-03-02 04:51:18 | forefront | 3 | 148641 | 29 | 38.033 | 3908.2 |
| 300 | 2025-02-26 10:10:02 | forefront | 1 | 81242 | 2 | 1.516 | 53589.7 |
| 299 | 2025-02-23 00:16:22 | forefront | 2 | 121436 | 6 | 18.893 | 6427.6 |
| 298 | 2025-02-11 02:54:11 | forefront | 1 | 81242 | 2 | 6.453 | 12589.8 |
| 297 | 2025-02-09 16:09:29 | forefront | 3 | 148641 | 29 | 43.583 | 3410.5 |
| 296 | 2025-02-09 16:09:29 | forefront | 2 | 121436 | 6 | 18.003 | 6745.3 |
| 295 | 2025-02-02 04:07:31 | forefront | 3 | 148641 | 29 | 51.850 | 2866.8 |
| 294 | 2025-02-02 04:07:38 | forefront | 3 | 148641 | 29 | 36.413 | 4082.1 |
| 293 | 2025-02-02 04:05:41 | forefront | 1 | 81242 | 2 | 6.733 | 12066.2 |
| 292 | 2025-01-24 23:22:10 | forefront | 1 | 81242 | 2 | 1.390 | 58447.5 |
| 291 | 2025-01-24 16:45:05 | forefront | 2 | 121436 | 6 | 25.000 | 4857.4 |
| 290 | 2025-01-20 15:12:15 | forefront | 2 | 121436 | 6 | 20.846 | 5825.4 |
| 289 | 2025-01-20 15:09:21 | forefront | 1 | 81242 | 2 | 6.343 | 12808.1 |
| 288 | 2025-01-10 15:39:01 | forefront | 3 | 148641 | 29 | 52.643 | 2823.6 |
| 287 | 2025-01-10 15:38:59 | forefront | 2 | 121436 | 6 | 15.626 | 7771.4 |
| 286 | 2025-01-06 20:46:33 | forefront | 1 | 81242 | 2 | 3.453 | 23527.9 |
| 285 | 2025-01-01 10:46:26 | forefront | 3 | 148641 | 29 | 38.563 | 3854.5 |
| 284 | 2024-12-26 04:22:29 | forefront | 3 | 148641 | 29 | 38.406 | 3870.3 |
| 283 | 2024-12-26 04:22:28 | forefront | 2 | 121436 | 6 | 18.403 | 6598.7 |
| 282 | 2024-12-16 15:49:57 | forefront | 1 | 81242 | 2 | 2.516 | 32290.1 |
| 281 | 2024-12-07 04:13:48 | forefront | 1 | 81242 | 2 | 3.313 | 24522.2 |
| 280 | 2024-12-02 03:27:27 | forefront | 3 | 148641 | 29 | 37.220 | 3993.6 |
| 279 | 2024-12-01 22:34:10 | forefront | 3 | 148641 | 29 | 32.346 | 4595.3 |
| 278 | 2024-12-01 22:33:14 | forefront | 1 | 81242 | 2 | 4.906 | 16559.7 |
| 277 | 2024-11-30 18:56:51 | forefront | 2 | 121436 | 6 | 17.893 | 6786.8 |
| 276 | 2024-11-27 21:51:11 | forefront | 1 | 81242 | 2 | 4.890 | 16613.9 |
| 275 | 2024-11-25 13:17:04 | forefront | 2 | 121436 | 6 | 19.253 | 6307.4 |
| 274 | 2024-11-13 15:06:44 | forefront | 1 | 81242 | 2 | 4.673 | 17385.4 |
| 273 | 2024-10-30 20:14:58 | forefront | 1 | 81242 | 2 | 5.046 | 16100.3 |
| 272 | 2024-10-29 19:20:16 | forefront | 2 | 121436 | 6 | 15.670 | 7749.6 |
| 271 | 2024-10-29 03:19:13 | forefront | 1 | 81242 | 2 | 1.360 | 59736.8 |
| 270 | 2024-10-20 16:34:08 | forefront | 3 | 148641 | 29 | 38.360 | 3874.9 |
| 269 | 2024-10-20 16:34:03 | forefront | 2 | 121436 | 6 | 27.313 | 4446.1 |
| 268 | 2024-10-19 16:12:07 | forefront | 1 | 81242 | 2 | 3.283 | 24746.3 |
| 267 | 2024-10-11 06:11:01 | forefront | 2 | 121436 | 6 | 17.673 | 6871.3 |
| 266 | 2024-10-10 07:02:21 | forefront | 1 | 81242 | 2 | 4.423 | 18368.1 |
| 265 | 2024-10-01 02:28:11 | forefront | 2 | 121436 | 6 | 32.566 | 3728.9 |
| 264 | 2024-09-28 08:13:21 | forefront | 2 | 121436 | 6 | 34.690 | 3500.6 |
| 263 | 2024-09-28 08:13:17 | forefront | 2 | 121436 | 6 | 22.186 | 5473.5 |
| 262 | 2024-09-26 12:59:00 | forefront | 3 | 148641 | 29 | 52.033 | 2856.7 |
| 261 | 2024-09-26 12:58:40 | forefront | 2 | 121436 | 6 | 29.706 | 4087.9 |
| 260 | 2024-09-25 20:46:50 | forefront | 3 | 148641 | 29 | 57.550 | 2582.8 |
| 259 | 2024-09-25 01:29:41 | forefront | 1 | 81242 | 2 | 6.233 | 13034.2 |
| 258 | 2024-09-18 14:52:01 | forefront | 1 | 81242 | 2 | 11.080 | 7332.3 |
| 257 | 2024-09-15 00:59:23 | forefront | 3 | 148641 | 29 | 32.893 | 4518.9 |
| 256 | 2024-08-31 20:33:02 | forefront | 1 | 81242 | 2 | 13.356 | 6082.8 |
| 255 | 2024-08-31 20:16:42 | forefront | 3 | 148641 | 29 | 38.330 | 3877.9 |
| 254 | 2024-08-24 23:40:35 | forefront | 3 | 148641 | 29 | 83.630 | 1777.4 |
| 253 | 2024-08-20 01:58:57 | forefront | 1 | 81242 | 2 | 4.546 | 17871.1 |
| 252 | 2024-08-17 02:47:50 | forefront | 2 | 121436 | 6 | 8.080 | 15029.2 |
| 251 | 2024-08-12 12:04:02 | forefront | 3 | 148641 | 29 | 105.460 | 1409.5 |
| 250 | 2024-08-12 12:04:14 | forefront | 2 | 121436 | 6 | 46.676 | 2601.7 |
| 249 | 2024-08-10 05:00:04 | forefront | 4 | 165329 | 185 | 69.560 | 2376.8 |
| 248 | 2024-08-10 05:00:06 | forefront | 3 | 148641 | 29 | 35.866 | 4144.3 |
| 247 | 2024-08-04 20:03:28 | forefront | 3 | 148641 | 29 | 14.626 | 10162.8 |
| 246 | 2024-08-04 20:03:20 | forefront | 2 | 121436 | 6 | 8.283 | 14660.9 |
| 245 | 2024-08-04 20:03:04 | forefront | 1 | 81242 | 2 | 4.060 | 20010.3 |
| 244 | 2024-07-30 22:25:57 | forefront | 3 | 148641 | 29 | 18.703 | 7947.4 |
| 243 | 2024-07-30 22:25:56 | forefront | 2 | 121436 | 6 | 15.233 | 7971.9 |
| 242 | 2024-07-28 08:50:03 | forefront | 3 | 148641 | 29 | 25.580 | 5810.8 |
| 241 | 2024-07-28 08:29:18 | forefront | 1 | 81242 | 2 | 6.736 | 12060.9 |
| 240 | 2024-07-28 08:07:08 | forefront | 3 | 148641 | 29 | 31.690 | 4690.5 |