History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"occupancies"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 362 | 2025-11-12 13:05:00 | occupancies | 3 | 121633 | 8 | 4.343 | 28006.7 |
| 361 | 2025-10-23 05:03:48 | occupancies | 1 | 49908 | 1 | 3.986 | 12520.8 |
| 360 | 2025-10-23 05:03:26 | occupancies | 1 | 49908 | 1 | 3.703 | 13477.7 |
| 359 | 2025-10-23 05:02:59 | occupancies | 1 | 49908 | 1 | 3.626 | 13763.9 |
| 358 | 2025-10-23 05:02:40 | occupancies | 1 | 49908 | 1 | 7.390 | 6753.5 |
| 357 | 2025-10-16 22:33:00 | occupancies | 1 | 49908 | 1 | 0.796 | 62698.5 |
| 356 | 2025-10-02 00:09:37 | occupancies | 1 | 49908 | 1 | 0.876 | 56972.6 |
| 355 | 2025-09-24 17:44:59 | occupancies | 2 | 86808 | 1 | 2.096 | 41416.0 |
| 354 | 2025-08-21 10:38:11 | occupancies | 4 | 148819 | 38 | 22.283 | 6678.6 |
| 353 | 2025-08-18 11:35:52 | occupancies | 3 | 121633 | 8 | 4.873 | 24960.6 |
| 352 | 2025-08-16 00:02:06 | occupancies | 1 | 49908 | 1 | 0.860 | 58032.6 |
| 351 | 2025-08-08 23:55:29 | occupancies | 1 | 49908 | 1 | 3.860 | 12929.5 |
| 350 | 2025-07-25 12:22:38 | occupancies | 1 | 49908 | 1 | 2.016 | 24756.0 |
| 349 | 2025-07-24 22:55:24 | occupancies | 1 | 49908 | 1 | 3.483 | 14329.0 |
| 348 | 2025-07-24 17:54:47 | occupancies | 1 | 49908 | 1 | 4.343 | 11491.6 |
| 347 | 2025-07-24 07:51:07 | occupancies | 1 | 49908 | 1 | 2.126 | 23475.1 |
| 346 | 2025-07-23 22:54:07 | occupancies | 1 | 49908 | 1 | 6.343 | 7868.2 |
| 345 | 2025-07-13 22:21:42 | occupancies | 1 | 49908 | 1 | 4.280 | 11660.7 |
| 344 | 2025-07-13 21:49:23 | occupancies | 1 | 49908 | 1 | 5.030 | 9922.1 |
| 343 | 2025-06-25 01:24:53 | occupancies | 4 | 148819 | 38 | 32.673 | 4554.8 |
| 342 | 2025-06-23 20:44:21 | occupancies | 1 | 49908 | 1 | 4.063 | 12283.5 |
| 341 | 2025-06-21 02:11:01 | occupancies | 4 | 148819 | 38 | 34.270 | 4342.5 |
| 340 | 2025-06-20 19:29:28 | occupancies | 4 | 148819 | 38 | 32.796 | 4537.7 |
| 339 | 2025-06-18 15:59:52 | occupancies | 4 | 148819 | 38 | 47.253 | 3149.4 |
| 338 | 2025-06-18 12:07:08 | occupancies | 3 | 121633 | 8 | 26.846 | 4530.8 |
| 337 | 2025-06-18 06:47:03 | occupancies | 2 | 86808 | 1 | 12.860 | 6750.2 |
| 336 | 2025-06-17 13:14:50 | occupancies | 1 | 49908 | 1 | 0.843 | 59202.8 |
| 335 | 2025-06-13 20:29:28 | occupancies | 1 | 49908 | 1 | 4.233 | 11790.2 |
| 334 | 2025-06-10 06:03:40 | occupancies | 1 | 49908 | 1 | 4.283 | 11652.6 |
| 333 | 2025-05-31 10:59:36 | occupancies | 1 | 49908 | 1 | 2.546 | 19602.5 |
| 332 | 2025-05-08 06:56:43 | occupancies | 1 | 49908 | 1 | 2.220 | 22481.1 |
| 331 | 2025-03-31 01:26:10 | occupancies | 3 | 121633 | 8 | 19.156 | 6349.6 |
| 330 | 2025-03-20 15:32:32 | occupancies | 1 | 49908 | 1 | 5.266 | 9477.4 |
| 329 | 2025-03-20 02:26:34 | occupancies | 1 | 49908 | 1 | 2.626 | 19005.3 |
| 328 | 2025-02-27 13:40:47 | occupancies | 1 | 49908 | 1 | 6.096 | 8187.0 |
| 327 | 2025-02-18 07:06:17 | occupancies | 4 | 148819 | 38 | 38.283 | 3887.3 |
| 326 | 2025-02-17 18:40:21 | occupancies | 4 | 148819 | 38 | 40.640 | 3661.9 |
| 325 | 2025-02-17 18:40:11 | occupancies | 3 | 121633 | 8 | 22.156 | 5489.8 |
| 324 | 2025-02-17 18:40:11 | occupancies | 2 | 86808 | 1 | 11.890 | 7300.9 |
| 323 | 2025-02-17 18:38:05 | occupancies | 1 | 49908 | 1 | 4.780 | 10441.0 |
| 322 | 2025-02-16 23:37:33 | occupancies | 4 | 148819 | 38 | 59.880 | 2485.3 |
| 321 | 2025-02-16 20:24:21 | occupancies | 4 | 148819 | 38 | 38.453 | 3870.2 |
| 320 | 2025-02-16 20:24:11 | occupancies | 2 | 86808 | 1 | 10.953 | 7925.5 |
| 319 | 2025-02-16 20:23:17 | occupancies | 4 | 148819 | 38 | 62.536 | 2379.7 |
| 318 | 2025-02-16 20:20:29 | occupancies | 1 | 49908 | 1 | 1.983 | 25167.9 |
| 317 | 2025-02-16 15:21:59 | occupancies | 3 | 121633 | 8 | 27.266 | 4461.0 |
| 316 | 2025-02-15 00:30:27 | occupancies | 1 | 49908 | 1 | 4.000 | 12477.0 |
| 315 | 2025-02-09 01:00:09 | occupancies | 3 | 121633 | 8 | 18.140 | 6705.2 |
| 314 | 2025-02-09 01:00:08 | occupancies | 2 | 86808 | 1 | 11.953 | 7262.4 |
| 313 | 2025-02-09 00:54:29 | occupancies | 1 | 49908 | 1 | 1.123 | 44441.7 |
| 312 | 2025-01-16 05:49:05 | occupancies | 1 | 49908 | 1 | 5.966 | 8365.4 |
| 311 | 2025-01-14 08:01:15 | occupancies | 3 | 121633 | 8 | 23.063 | 5273.9 |
| 310 | 2025-01-13 17:18:25 | occupancies | 4 | 148819 | 38 | 43.036 | 3458.0 |
| 309 | 2025-01-13 15:51:50 | occupancies | 4 | 148819 | 38 | 26.876 | 5537.2 |
| 308 | 2025-01-12 06:24:43 | occupancies | 4 | 148819 | 38 | 27.466 | 5418.3 |
| 307 | 2025-01-09 21:40:53 | occupancies | 1 | 49908 | 1 | 3.843 | 12986.7 |
| 306 | 2025-01-09 04:23:29 | occupancies | 3 | 121633 | 8 | 24.876 | 4889.6 |
| 305 | 2025-01-05 03:48:13 | occupancies | 4 | 148819 | 38 | 41.566 | 3580.3 |
| 304 | 2025-01-05 03:48:22 | occupancies | 3 | 121633 | 8 | 24.986 | 4868.0 |
| 303 | 2025-01-05 03:48:26 | occupancies | 2 | 86808 | 1 | 6.190 | 14023.9 |
| 302 | 2025-01-05 03:45:57 | occupancies | 1 | 49908 | 1 | 4.030 | 12384.1 |
| 301 | 2024-12-14 23:53:51 | occupancies | 4 | 148819 | 38 | 42.986 | 3462.0 |
| 300 | 2024-12-14 23:53:50 | occupancies | 2 | 86808 | 1 | 10.750 | 8075.2 |
| 299 | 2024-12-14 23:53:38 | occupancies | 1 | 49908 | 1 | 3.860 | 12929.5 |
| 298 | 2024-12-14 23:51:57 | occupancies | 3 | 121633 | 8 | 22.593 | 5383.7 |
| 297 | 2024-12-13 11:17:31 | occupancies | 4 | 148819 | 38 | 56.143 | 2650.7 |
| 296 | 2024-12-13 06:18:50 | occupancies | 3 | 121633 | 8 | 25.563 | 4758.2 |
| 295 | 2024-12-13 06:19:00 | occupancies | 2 | 86808 | 1 | 11.733 | 7398.6 |
| 294 | 2024-12-13 06:16:45 | occupancies | 1 | 49908 | 1 | 4.936 | 10111.0 |
| 293 | 2024-12-13 00:52:55 | occupancies | 4 | 148819 | 38 | 64.940 | 2291.6 |
| 292 | 2024-12-10 12:59:25 | occupancies | 4 | 148819 | 38 | 29.796 | 4994.6 |
| 291 | 2024-11-24 09:56:52 | occupancies | 4 | 148819 | 38 | 46.080 | 3229.6 |
| 290 | 2024-11-24 09:56:57 | occupancies | 2 | 86808 | 1 | 11.876 | 7309.5 |
| 289 | 2024-11-24 09:56:09 | occupancies | 1 | 49908 | 1 | 3.423 | 14580.2 |
| 288 | 2024-11-08 20:20:30 | occupancies | 1 | 49908 | 1 | 5.156 | 9679.6 |
| 287 | 2024-11-07 15:07:02 | occupancies | 3 | 121633 | 8 | 26.143 | 4652.6 |
| 286 | 2024-11-04 13:33:29 | occupancies | 3 | 121633 | 8 | 25.143 | 4837.6 |
| 285 | 2024-11-02 15:21:02 | occupancies | 3 | 121633 | 8 | 32.316 | 3763.9 |
| 284 | 2024-11-02 08:05:06 | occupancies | 4 | 148819 | 38 | 58.363 | 2549.9 |
| 283 | 2024-11-02 08:05:12 | occupancies | 3 | 121633 | 8 | 36.376 | 3343.8 |
| 282 | 2024-11-02 08:04:37 | occupancies | 4 | 148819 | 38 | 51.643 | 2881.7 |
| 281 | 2024-11-02 08:05:12 | occupancies | 2 | 86808 | 1 | 13.030 | 6662.2 |
| 280 | 2024-11-02 08:04:10 | occupancies | 1 | 49908 | 1 | 3.843 | 12986.7 |
| 279 | 2024-10-21 18:48:55 | occupancies | 1 | 49908 | 1 | 4.186 | 11922.6 |
| 278 | 2024-10-11 10:05:09 | occupancies | 1 | 49908 | 1 | 3.546 | 14074.5 |
| 277 | 2024-10-01 13:18:27 | occupancies | 1 | 49908 | 1 | 7.000 | 7129.7 |
| 276 | 2024-09-29 09:34:24 | occupancies | 1 | 49908 | 1 | 7.000 | 7129.7 |
| 275 | 2024-08-20 10:06:43 | occupancies | 1 | 49908 | 1 | 3.376 | 14783.2 |
| 274 | 2024-08-05 16:36:49 | occupancies | 1 | 49908 | 1 | 2.893 | 17251.3 |
| 273 | 2024-07-27 02:16:47 | occupancies | 1 | 49908 | 1 | 2.970 | 16804.0 |
| 272 | 2024-07-13 17:52:21 | occupancies | 1 | 49908 | 1 | 2.156 | 23148.4 |
| 271 | 2024-07-08 18:31:57 | occupancies | 2 | 86808 | 1 | 5.406 | 16057.7 |
| 270 | 2024-07-08 18:31:49 | occupancies | 3 | 121633 | 8 | 9.063 | 13420.8 |
| 269 | 2024-07-08 18:29:27 | occupancies | 1 | 49908 | 1 | 1.606 | 31076.0 |
| 268 | 2024-07-06 19:00:08 | occupancies | 1 | 49908 | 1 | 3.953 | 12625.3 |
| 267 | 2024-07-06 08:03:37 | occupancies | 1 | 49908 | 1 | 4.140 | 12055.1 |
| 266 | 2024-06-25 15:41:10 | occupancies | 4 | 148819 | 38 | 43.643 | 3409.9 |
| 265 | 2024-06-19 08:15:02 | occupancies | 4 | 148819 | 38 | 32.453 | 4585.7 |
| 264 | 2024-06-13 09:04:27 | occupancies | 2 | 86808 | 1 | 9.110 | 9528.9 |
| 263 | 2024-06-13 09:02:54 | occupancies | 1 | 49908 | 1 | 3.970 | 12571.3 |