History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"storefront"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 342 | 2025-08-28 21:57:14 | storefront | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 341 | 2025-07-24 01:33:37 | storefront | 1 | 67641 | 3 | 5.563 | 12159.1 |
| 340 | 2025-07-22 05:46:54 | storefront | 1 | 67641 | 3 | 4.813 | 14053.8 |
| 339 | 2025-07-14 02:51:40 | storefront | 3 | 140603 | 9 | 30.033 | 4681.6 |
| 338 | 2025-07-13 06:44:44 | storefront | 1 | 67641 | 3 | 1.220 | 55443.4 |
| 337 | 2025-07-13 05:53:51 | storefront | 1 | 67641 | 3 | 1.843 | 36701.6 |
| 336 | 2025-07-13 03:47:35 | storefront | 3 | 140603 | 9 | 6.643 | 21165.6 |
| 335 | 2025-07-13 02:06:35 | storefront | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 334 | 2025-06-29 12:36:26 | storefront | 1 | 67641 | 3 | 6.110 | 11070.5 |
| 333 | 2025-06-27 14:47:15 | storefront | 1 | 67641 | 3 | 4.483 | 15088.3 |
| 332 | 2025-06-11 21:47:01 | storefront | 3 | 140603 | 9 | 28.253 | 4976.6 |
| 331 | 2025-05-30 03:36:39 | storefront | 3 | 140603 | 9 | 6.706 | 20966.7 |
| 330 | 2025-05-25 01:50:27 | storefront | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 329 | 2025-04-30 01:14:12 | storefront | 1 | 67641 | 3 | 5.643 | 11986.7 |
| 328 | 2025-04-16 13:18:03 | storefront | 1 | 67641 | 3 | 2.703 | 25024.4 |
| 327 | 2025-04-02 07:54:29 | storefront | 1 | 67641 | 3 | 7.750 | 8727.9 |
| 326 | 2025-03-22 23:25:01 | storefront | 1 | 67641 | 3 | 7.830 | 8638.7 |
| 325 | 2025-03-22 22:24:34 | storefront | 3 | 140603 | 9 | 41.300 | 3404.4 |
| 324 | 2025-03-22 21:30:41 | storefront | 2 | 108824 | 5 | 12.093 | 8998.9 |
| 323 | 2025-03-20 11:02:17 | storefront | 1 | 67641 | 3 | 5.313 | 12731.2 |
| 322 | 2025-03-08 18:15:29 | storefront | 2 | 108824 | 5 | 18.953 | 5741.8 |
| 321 | 2025-03-08 18:12:23 | storefront | 3 | 140603 | 9 | 52.833 | 2661.3 |
| 320 | 2025-03-08 17:33:28 | storefront | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 319 | 2025-03-08 12:12:32 | storefront | 3 | 140603 | 9 | 30.093 | 4672.3 |
| 318 | 2025-03-08 12:12:34 | storefront | 2 | 108824 | 5 | 15.610 | 6971.4 |
| 317 | 2025-03-08 12:12:03 | storefront | 3 | 140603 | 9 | 31.580 | 4452.3 |
| 316 | 2025-03-08 12:08:14 | storefront | 1 | 67641 | 3 | 5.046 | 13404.9 |
| 315 | 2025-03-04 16:01:43 | storefront | 3 | 140603 | 9 | 32.693 | 4300.7 |
| 314 | 2025-02-23 00:17:22 | storefront | 3 | 140603 | 9 | 49.296 | 2852.2 |
| 313 | 2025-02-23 00:17:20 | storefront | 2 | 108824 | 5 | 23.156 | 4699.6 |
| 312 | 2025-02-09 16:10:03 | storefront | 3 | 140603 | 9 | 37.170 | 3782.7 |
| 311 | 2025-02-09 16:10:02 | storefront | 2 | 108824 | 5 | 15.030 | 7240.5 |
| 310 | 2025-02-09 16:07:42 | storefront | 1 | 67641 | 3 | 4.923 | 13739.8 |
| 309 | 2025-02-03 12:22:55 | storefront | 3 | 140603 | 9 | 45.080 | 3119.0 |
| 308 | 2025-02-02 08:37:36 | storefront | 4 | 161450 | 35 | 57.130 | 2826.0 |
| 307 | 2025-02-02 08:37:38 | storefront | 3 | 140603 | 9 | 34.376 | 4090.2 |
| 306 | 2025-02-02 08:37:40 | storefront | 2 | 108824 | 5 | 15.706 | 6928.8 |
| 305 | 2025-02-02 08:33:09 | storefront | 1 | 67641 | 3 | 3.906 | 17317.2 |
| 304 | 2025-01-30 18:34:42 | storefront | 1 | 67641 | 3 | 4.423 | 15293.0 |
| 303 | 2025-01-10 15:39:53 | storefront | 2 | 108824 | 5 | 17.516 | 6212.8 |
| 302 | 2025-01-10 15:37:28 | storefront | 1 | 67641 | 3 | 2.923 | 23141.0 |
| 301 | 2025-01-09 04:11:59 | storefront | 2 | 108824 | 5 | 15.470 | 7034.5 |
| 300 | 2025-01-09 04:10:28 | storefront | 1 | 67641 | 3 | 4.206 | 16082.0 |
| 299 | 2025-01-08 08:02:10 | storefront | 3 | 140603 | 9 | 28.753 | 4890.0 |
| 298 | 2025-01-02 14:05:45 | storefront | 3 | 140603 | 9 | 29.486 | 4768.5 |
| 297 | 2025-01-01 10:48:04 | storefront | 3 | 140603 | 9 | 60.283 | 2332.4 |
| 296 | 2025-01-01 10:48:10 | storefront | 3 | 140603 | 9 | 35.113 | 4004.3 |
| 295 | 2025-01-01 10:47:55 | storefront | 3 | 140603 | 9 | 34.330 | 4095.6 |
| 294 | 2025-01-01 10:48:16 | storefront | 2 | 108824 | 5 | 10.503 | 10361.2 |
| 293 | 2025-01-01 10:45:45 | storefront | 1 | 67641 | 3 | 5.233 | 12925.9 |
| 292 | 2024-12-26 04:26:54 | storefront | 2 | 108824 | 5 | 23.000 | 4731.5 |
| 291 | 2024-12-26 04:26:20 | storefront | 3 | 140603 | 9 | 37.483 | 3751.1 |
| 290 | 2024-12-26 04:26:07 | storefront | 3 | 140603 | 9 | 44.906 | 3131.1 |
| 289 | 2024-12-26 04:25:57 | storefront | 3 | 140603 | 9 | 23.560 | 5967.9 |
| 288 | 2024-12-26 04:21:56 | storefront | 1 | 67641 | 3 | 5.593 | 12093.9 |
| 287 | 2024-12-03 11:35:19 | storefront | 3 | 140603 | 9 | 34.626 | 4060.6 |
| 286 | 2024-12-03 11:32:57 | storefront | 1 | 67641 | 3 | 8.220 | 8228.8 |
| 285 | 2024-12-02 03:54:46 | storefront | 3 | 140603 | 9 | 34.660 | 4056.6 |
| 284 | 2024-12-02 03:54:48 | storefront | 2 | 108824 | 5 | 17.750 | 6130.9 |
| 283 | 2024-12-02 03:52:26 | storefront | 1 | 67641 | 3 | 1.076 | 62863.4 |
| 282 | 2024-12-02 03:28:20 | storefront | 4 | 161450 | 35 | 59.800 | 2699.8 |
| 281 | 2024-11-30 18:58:10 | storefront | 4 | 161450 | 35 | 78.493 | 2056.9 |
| 280 | 2024-11-30 18:58:02 | storefront | 4 | 161450 | 35 | 64.300 | 2510.9 |
| 279 | 2024-11-30 18:58:09 | storefront | 3 | 140603 | 9 | 25.800 | 5449.7 |
| 278 | 2024-11-30 18:58:19 | storefront | 2 | 108824 | 5 | 15.470 | 7034.5 |
| 277 | 2024-11-30 18:55:38 | storefront | 1 | 67641 | 3 | 5.873 | 11517.3 |
| 276 | 2024-11-25 13:18:04 | storefront | 4 | 161450 | 35 | 58.846 | 2743.6 |
| 275 | 2024-11-25 13:18:02 | storefront | 2 | 108824 | 5 | 15.050 | 7230.8 |
| 274 | 2024-11-25 13:16:24 | storefront | 1 | 67641 | 3 | 4.966 | 13620.8 |
| 273 | 2024-11-22 15:30:24 | storefront | 3 | 140603 | 9 | 21.923 | 6413.5 |
| 272 | 2024-11-21 19:23:21 | storefront | 3 | 140603 | 9 | 31.266 | 4497.0 |
| 271 | 2024-11-03 08:02:01 | storefront | 3 | 140603 | 9 | 34.033 | 4131.4 |
| 270 | 2024-11-03 07:56:23 | storefront | 1 | 67641 | 3 | 3.780 | 17894.4 |
| 269 | 2024-10-31 05:36:00 | storefront | 3 | 140603 | 9 | 33.906 | 4146.8 |
| 268 | 2024-10-31 05:35:53 | storefront | 2 | 108824 | 5 | 14.906 | 7300.7 |
| 267 | 2024-10-29 19:21:17 | storefront | 3 | 140603 | 9 | 35.800 | 3927.5 |
| 266 | 2024-10-29 19:20:41 | storefront | 4 | 161450 | 35 | 57.690 | 2798.6 |
| 265 | 2024-10-29 19:21:11 | storefront | 2 | 108824 | 5 | 18.033 | 6034.7 |
| 264 | 2024-10-29 19:20:06 | storefront | 1 | 67641 | 3 | 3.953 | 17111.3 |
| 263 | 2024-10-20 20:24:11 | storefront | 4 | 161450 | 35 | 62.796 | 2571.0 |
| 262 | 2024-10-20 20:21:45 | storefront | 1 | 67641 | 3 | 4.513 | 14988.0 |
| 261 | 2024-10-20 16:35:11 | storefront | 3 | 140603 | 9 | 24.330 | 5779.0 |
| 260 | 2024-10-20 16:34:12 | storefront | 4 | 161450 | 35 | 57.156 | 2824.7 |
| 259 | 2024-10-20 16:34:49 | storefront | 2 | 108824 | 5 | 16.503 | 6594.2 |
| 258 | 2024-10-20 16:32:46 | storefront | 1 | 67641 | 3 | 6.873 | 9841.6 |
| 257 | 2024-10-19 18:13:19 | storefront | 3 | 140603 | 9 | 29.393 | 4783.6 |
| 256 | 2024-09-28 08:15:59 | storefront | 3 | 140603 | 9 | 77.693 | 1809.7 |
| 255 | 2024-09-28 08:15:55 | storefront | 3 | 140603 | 9 | 48.503 | 2898.9 |
| 254 | 2024-09-28 08:15:55 | storefront | 3 | 140603 | 9 | 40.080 | 3508.1 |
| 253 | 2024-09-28 08:15:57 | storefront | 2 | 108824 | 5 | 26.250 | 4145.7 |
| 252 | 2024-09-28 08:10:41 | storefront | 1 | 67641 | 3 | 4.486 | 15078.2 |
| 251 | 2024-09-26 13:01:53 | storefront | 3 | 140603 | 9 | 61.510 | 2285.9 |
| 250 | 2024-09-26 13:02:00 | storefront | 2 | 108824 | 5 | 24.283 | 4481.5 |
| 249 | 2024-09-26 12:59:53 | storefront | 3 | 140603 | 9 | 52.830 | 2661.4 |
| 248 | 2024-09-26 12:58:22 | storefront | 1 | 67641 | 3 | 3.406 | 19859.4 |
| 247 | 2024-09-25 20:47:21 | storefront | 3 | 140603 | 9 | 49.453 | 2843.2 |
| 246 | 2024-09-25 20:47:13 | storefront | 2 | 108824 | 5 | 21.610 | 5035.8 |
| 245 | 2024-09-15 01:00:26 | storefront | 4 | 161450 | 35 | 115.320 | 1400.0 |
| 244 | 2024-09-15 01:01:20 | storefront | 3 | 140603 | 9 | 27.000 | 5207.5 |
| 243 | 2024-09-15 01:00:46 | storefront | 2 | 108824 | 5 | 54.470 | 1997.9 |