History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"settlements"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 364 | 2025-10-24 20:26:04 | settlements | 1 | 49908 | 2 | 2.203 | 22654.6 |
| 363 | 2025-09-28 10:27:36 | settlements | 1 | 49908 | 2 | 0.843 | 59202.8 |
| 362 | 2025-09-27 11:42:29 | settlements | 1 | 49908 | 2 | 0.876 | 56972.6 |
| 361 | 2025-09-22 15:48:11 | settlements | 1 | 49908 | 2 | 0.860 | 58032.6 |
| 360 | 2025-09-21 18:09:51 | settlements | 1 | 49908 | 2 | 0.920 | 54247.8 |
| 359 | 2025-09-18 09:27:16 | settlements | 3 | 121633 | 23 | 8.546 | 14232.7 |
| 358 | 2025-09-10 13:29:42 | settlements | 2 | 86808 | 5 | 3.970 | 21866.0 |
| 357 | 2025-09-08 05:30:17 | settlements | 4 | 148819 | 101 | 8.800 | 16911.3 |
| 356 | 2025-09-03 03:58:19 | settlements | 1 | 49908 | 2 | 0.860 | 58032.6 |
| 355 | 2025-08-29 13:27:50 | settlements | 1 | 49908 | 2 | 0.796 | 62698.5 |
| 354 | 2025-08-28 13:13:05 | settlements | 1 | 49908 | 2 | 0.906 | 55086.1 |
| 353 | 2025-08-27 11:17:36 | settlements | 1 | 49908 | 2 | 0.810 | 61614.8 |
| 352 | 2025-08-25 02:21:58 | settlements | 1 | 49908 | 2 | 3.906 | 12777.3 |
| 351 | 2025-08-01 17:07:53 | settlements | 1 | 49908 | 2 | 2.673 | 18671.2 |
| 350 | 2025-07-25 09:28:34 | settlements | 1 | 49908 | 2 | 1.530 | 32619.6 |
| 349 | 2025-06-24 14:23:21 | settlements | 1 | 49908 | 2 | 1.906 | 26184.7 |
| 348 | 2025-06-23 20:39:48 | settlements | 1 | 49908 | 2 | 4.236 | 11781.9 |
| 347 | 2025-06-22 09:20:59 | settlements | 1 | 49908 | 2 | 3.983 | 12530.3 |
| 346 | 2025-05-31 18:54:29 | settlements | 2 | 86808 | 5 | 8.000 | 10851.0 |
| 345 | 2025-05-28 01:56:44 | settlements | 1 | 49908 | 2 | 0.860 | 58032.6 |
| 344 | 2025-05-28 01:10:11 | settlements | 1 | 49908 | 2 | 0.860 | 58032.6 |
| 343 | 2025-05-19 20:36:11 | settlements | 1 | 49908 | 2 | 4.516 | 11051.4 |
| 342 | 2025-05-11 20:36:50 | settlements | 3 | 121633 | 23 | 6.923 | 17569.4 |
| 341 | 2025-05-11 15:38:20 | settlements | 3 | 121633 | 23 | 39.010 | 3118.0 |
| 340 | 2025-05-04 17:10:40 | settlements | 2 | 86808 | 5 | 16.203 | 5357.5 |
| 339 | 2025-05-04 13:52:44 | settlements | 4 | 148819 | 101 | 30.750 | 4839.6 |
| 338 | 2025-05-04 00:09:13 | settlements | 4 | 148819 | 101 | 59.020 | 2521.5 |
| 337 | 2025-05-03 21:55:03 | settlements | 1 | 49908 | 2 | 4.390 | 11368.6 |
| 336 | 2025-05-03 20:37:36 | settlements | 3 | 121633 | 23 | 21.423 | 5677.7 |
| 335 | 2025-05-02 07:05:41 | settlements | 4 | 148819 | 101 | 34.266 | 4343.1 |
| 334 | 2025-05-02 05:23:28 | settlements | 4 | 148819 | 101 | 38.783 | 3837.2 |
| 333 | 2025-04-30 11:56:47 | settlements | 1 | 49908 | 2 | 4.233 | 11790.2 |
| 332 | 2025-04-30 06:29:01 | settlements | 2 | 86808 | 5 | 10.940 | 7934.9 |
| 331 | 2025-04-30 05:07:02 | settlements | 4 | 148819 | 101 | 40.456 | 3678.5 |
| 330 | 2025-04-29 10:35:07 | settlements | 3 | 121633 | 23 | 4.923 | 24707.1 |
| 329 | 2025-04-24 13:18:38 | settlements | 3 | 121633 | 23 | 12.580 | 9668.8 |
| 328 | 2025-04-21 17:41:43 | settlements | 3 | 121633 | 23 | 35.206 | 3454.9 |
| 327 | 2025-04-20 12:37:00 | settlements | 1 | 49908 | 2 | 0.860 | 58032.6 |
| 326 | 2025-04-18 04:25:32 | settlements | 3 | 121633 | 23 | 22.630 | 5374.9 |
| 325 | 2025-04-16 20:44:21 | settlements | 1 | 49908 | 2 | 0.970 | 51451.5 |
| 324 | 2025-03-27 17:43:09 | settlements | 1 | 49908 | 2 | 2.733 | 18261.3 |
| 323 | 2025-03-27 14:04:40 | settlements | 1 | 49908 | 2 | 4.470 | 11165.1 |
| 322 | 2025-03-16 23:24:29 | settlements | 1 | 49908 | 2 | 3.763 | 13262.8 |
| 321 | 2025-03-13 17:45:57 | settlements | 1 | 49908 | 2 | 5.470 | 9123.9 |
| 320 | 2025-02-12 03:24:54 | settlements | 3 | 121633 | 23 | 33.156 | 3668.5 |
| 319 | 2025-02-09 13:27:39 | settlements | 3 | 121633 | 23 | 24.123 | 5042.2 |
| 318 | 2025-02-09 13:27:30 | settlements | 3 | 121633 | 23 | 23.390 | 5200.2 |
| 317 | 2025-02-09 13:27:23 | settlements | 2 | 86808 | 5 | 13.140 | 6606.4 |
| 316 | 2025-02-09 13:27:08 | settlements | 1 | 49908 | 2 | 3.643 | 13699.7 |
| 315 | 2025-02-08 23:55:33 | settlements | 3 | 121633 | 23 | 32.020 | 3798.7 |
| 314 | 2025-02-08 23:55:01 | settlements | 3 | 121633 | 23 | 27.813 | 4373.2 |
| 313 | 2025-02-08 23:53:09 | settlements | 1 | 49908 | 2 | 2.546 | 19602.5 |
| 312 | 2025-02-03 22:07:59 | settlements | 2 | 86808 | 5 | 6.013 | 14436.7 |
| 311 | 2025-01-30 07:07:53 | settlements | 2 | 86808 | 5 | 10.970 | 7913.2 |
| 310 | 2025-01-30 07:05:07 | settlements | 1 | 49908 | 2 | 2.906 | 17174.1 |
| 309 | 2025-01-22 04:00:07 | settlements | 3 | 121633 | 23 | 36.360 | 3345.2 |
| 308 | 2025-01-22 04:00:13 | settlements | 2 | 86808 | 5 | 8.906 | 9747.1 |
| 307 | 2025-01-22 03:59:39 | settlements | 1 | 49908 | 2 | 2.343 | 21300.9 |
| 306 | 2025-01-10 14:58:42 | settlements | 3 | 121633 | 23 | 24.093 | 5048.5 |
| 305 | 2025-01-04 16:29:43 | settlements | 4 | 148819 | 101 | 47.976 | 3101.9 |
| 304 | 2025-01-01 08:56:28 | settlements | 4 | 148819 | 101 | 58.630 | 2538.3 |
| 303 | 2024-12-31 16:53:06 | settlements | 4 | 148819 | 101 | 41.223 | 3610.1 |
| 302 | 2024-12-31 07:04:02 | settlements | 4 | 148819 | 101 | 50.550 | 2944.0 |
| 301 | 2024-12-31 07:04:03 | settlements | 3 | 121633 | 23 | 28.050 | 4336.3 |
| 300 | 2024-12-31 07:04:05 | settlements | 2 | 86808 | 5 | 11.376 | 7630.8 |
| 299 | 2024-12-31 07:02:11 | settlements | 1 | 49908 | 2 | 4.156 | 12008.7 |
| 298 | 2024-12-22 16:28:43 | settlements | 2 | 86808 | 5 | 17.160 | 5058.7 |
| 297 | 2024-12-22 16:27:40 | settlements | 1 | 49908 | 2 | 2.763 | 18063.0 |
| 296 | 2024-12-19 11:22:05 | settlements | 3 | 121633 | 23 | 27.203 | 4471.3 |
| 295 | 2024-12-19 11:21:52 | settlements | 2 | 86808 | 5 | 12.593 | 6893.4 |
| 294 | 2024-12-19 11:19:19 | settlements | 1 | 49908 | 2 | 4.530 | 11017.2 |
| 293 | 2024-12-18 05:15:48 | settlements | 1 | 49908 | 2 | 3.970 | 12571.3 |
| 292 | 2024-12-04 20:41:18 | settlements | 3 | 121633 | 23 | 23.733 | 5125.1 |
| 291 | 2024-12-01 17:30:14 | settlements | 4 | 148819 | 101 | 46.940 | 3170.4 |
| 290 | 2024-12-01 10:38:22 | settlements | 4 | 148819 | 101 | 48.240 | 3085.0 |
| 289 | 2024-11-30 21:52:32 | settlements | 4 | 148819 | 101 | 44.876 | 3316.2 |
| 288 | 2024-11-30 04:19:29 | settlements | 4 | 148819 | 101 | 56.720 | 2623.7 |
| 287 | 2024-11-30 04:19:32 | settlements | 3 | 121633 | 23 | 24.110 | 5044.9 |
| 286 | 2024-11-30 04:19:36 | settlements | 2 | 86808 | 5 | 12.533 | 6926.4 |
| 285 | 2024-11-30 04:18:16 | settlements | 1 | 49908 | 2 | 4.906 | 10172.8 |
| 284 | 2024-11-23 03:57:02 | settlements | 2 | 86808 | 5 | 8.203 | 10582.5 |
| 283 | 2024-11-14 22:11:28 | settlements | 2 | 86808 | 5 | 12.986 | 6684.7 |
| 282 | 2024-11-14 22:11:22 | settlements | 1 | 49908 | 2 | 4.173 | 11959.7 |
| 281 | 2024-11-12 09:37:52 | settlements | 2 | 86808 | 5 | 6.156 | 14101.4 |
| 280 | 2024-11-12 00:54:55 | settlements | 1 | 49908 | 2 | 1.030 | 48454.4 |
| 279 | 2024-10-31 11:03:08 | settlements | 1 | 49908 | 2 | 4.280 | 11660.7 |
| 278 | 2024-10-21 15:05:44 | settlements | 4 | 148819 | 101 | 49.330 | 3016.8 |
| 277 | 2024-10-21 05:05:35 | settlements | 4 | 148819 | 101 | 52.080 | 2857.5 |
| 276 | 2024-10-21 05:05:22 | settlements | 2 | 86808 | 5 | 12.313 | 7050.1 |
| 275 | 2024-10-21 05:02:21 | settlements | 1 | 49908 | 2 | 4.170 | 11968.3 |
| 274 | 2024-10-21 04:47:48 | settlements | 4 | 148819 | 101 | 71.253 | 2088.6 |
| 273 | 2024-10-20 22:46:24 | settlements | 4 | 148819 | 101 | 53.066 | 2804.4 |
| 272 | 2024-10-18 15:07:54 | settlements | 3 | 121633 | 23 | 27.626 | 4402.8 |
| 271 | 2024-10-13 20:12:59 | settlements | 3 | 121633 | 23 | 23.330 | 5213.6 |
| 270 | 2024-10-12 16:36:02 | settlements | 3 | 121633 | 23 | 27.720 | 4387.9 |
| 269 | 2024-10-09 18:05:34 | settlements | 3 | 121633 | 23 | 17.800 | 6833.3 |
| 268 | 2024-10-09 18:05:35 | settlements | 2 | 86808 | 5 | 10.486 | 8278.5 |
| 267 | 2024-10-09 17:34:19 | settlements | 1 | 49908 | 2 | 0.890 | 56076.4 |
| 266 | 2024-09-26 15:15:03 | settlements | 1 | 49908 | 2 | 6.236 | 8003.2 |
| 265 | 2024-09-14 05:00:23 | settlements | 4 | 148819 | 101 | 109.320 | 1361.3 |