History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"occupants"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 352 | 2025-12-23 11:52:16 | occupants | 3 | 148641 | 19 | 5.970 | 24898.0 |
| 351 | 2025-11-22 17:43:48 | occupants | 3 | 148641 | 19 | 10.033 | 14815.2 |
| 350 | 2025-11-16 11:41:10 | occupants | 2 | 121436 | 4 | 3.470 | 34996.0 |
| 349 | 2025-11-07 08:18:46 | occupants | 1 | 81242 | 2 | 2.403 | 33808.6 |
| 348 | 2025-11-04 04:55:59 | occupants | 1 | 81242 | 2 | 1.280 | 63470.3 |
| 347 | 2025-10-31 10:15:08 | occupants | 3 | 148641 | 19 | 6.763 | 21978.6 |
| 346 | 2025-10-24 18:08:41 | occupants | 3 | 148641 | 19 | 6.186 | 24028.6 |
| 345 | 2025-10-13 06:34:58 | occupants | 2 | 121436 | 4 | 3.186 | 38115.5 |
| 344 | 2025-10-13 00:32:04 | occupants | 2 | 121436 | 4 | 3.280 | 37023.2 |
| 343 | 2025-08-21 16:53:11 | occupants | 1 | 81242 | 2 | 3.796 | 21402.0 |
| 342 | 2025-08-10 16:34:53 | occupants | 1 | 81242 | 2 | 2.560 | 31735.2 |
| 341 | 2025-07-11 05:57:36 | occupants | 1 | 81242 | 2 | 4.343 | 18706.4 |
| 340 | 2025-07-11 01:43:11 | occupants | 1 | 81242 | 2 | 5.953 | 13647.2 |
| 339 | 2025-06-23 13:34:09 | occupants | 1 | 81242 | 2 | 1.280 | 63470.3 |
| 338 | 2025-06-12 07:00:03 | occupants | 1 | 81242 | 2 | 8.203 | 9903.9 |
| 337 | 2025-06-11 21:44:31 | occupants | 1 | 81242 | 2 | 5.843 | 13904.2 |
| 336 | 2025-06-08 17:41:40 | occupants | 1 | 81242 | 2 | 6.576 | 12354.3 |
| 335 | 2025-05-22 00:56:22 | occupants | 1 | 81242 | 2 | 3.623 | 22424.0 |
| 334 | 2025-05-20 09:22:04 | occupants | 3 | 148641 | 19 | 40.606 | 3660.6 |
| 333 | 2025-05-18 13:15:36 | occupants | 3 | 148641 | 19 | 35.563 | 4179.7 |
| 332 | 2025-05-10 13:16:20 | occupants | 1 | 81242 | 2 | 3.220 | 25230.4 |
| 331 | 2025-05-08 15:10:28 | occupants | 1 | 81242 | 2 | 2.953 | 27511.7 |
| 330 | 2025-05-04 18:26:17 | occupants | 2 | 121436 | 4 | 19.500 | 6227.5 |
| 329 | 2025-04-27 05:40:23 | occupants | 3 | 148641 | 19 | 12.546 | 11847.7 |
| 328 | 2025-04-27 02:26:34 | occupants | 2 | 121436 | 4 | 8.873 | 13686.0 |
| 327 | 2025-04-26 15:39:28 | occupants | 3 | 148641 | 19 | 33.750 | 4404.2 |
| 326 | 2025-04-25 17:10:44 | occupants | 1 | 81242 | 2 | 1.343 | 60492.9 |
| 325 | 2025-04-23 06:34:14 | occupants | 1 | 81242 | 2 | 6.343 | 12808.1 |
| 324 | 2025-04-16 05:36:41 | occupants | 1 | 81242 | 2 | 3.500 | 23212.0 |
| 323 | 2025-04-15 20:37:26 | occupants | 3 | 148641 | 19 | 21.156 | 7026.0 |
| 322 | 2025-04-07 00:49:14 | occupants | 1 | 81242 | 2 | 10.406 | 7807.2 |
| 321 | 2025-03-27 01:49:57 | occupants | 3 | 148641 | 19 | 33.626 | 4420.4 |
| 320 | 2025-03-27 00:27:14 | occupants | 2 | 121436 | 4 | 18.453 | 6580.8 |
| 319 | 2025-03-25 02:08:40 | occupants | 3 | 148641 | 19 | 34.050 | 4365.4 |
| 318 | 2025-03-24 12:13:29 | occupants | 2 | 121436 | 4 | 18.656 | 6509.2 |
| 317 | 2025-03-24 09:41:26 | occupants | 3 | 148641 | 19 | 44.533 | 3337.8 |
| 316 | 2025-03-22 19:08:48 | occupants | 1 | 81242 | 2 | 1.356 | 59913.0 |
| 315 | 2025-03-21 11:09:30 | occupants | 3 | 148641 | 19 | 17.503 | 8492.3 |
| 314 | 2025-03-21 10:32:04 | occupants | 2 | 121436 | 4 | 21.080 | 5760.7 |
| 313 | 2025-03-20 11:28:52 | occupants | 1 | 81242 | 2 | 7.453 | 10900.6 |
| 312 | 2025-03-20 08:08:19 | occupants | 1 | 81242 | 2 | 3.000 | 27080.7 |
| 311 | 2025-03-11 06:13:58 | occupants | 3 | 148641 | 19 | 32.970 | 4508.4 |
| 310 | 2025-03-11 06:13:45 | occupants | 2 | 121436 | 4 | 16.390 | 7409.2 |
| 309 | 2025-03-10 22:06:25 | occupants | 3 | 148641 | 19 | 21.300 | 6978.5 |
| 308 | 2025-03-05 11:36:49 | occupants | 3 | 148641 | 19 | 35.956 | 4134.0 |
| 307 | 2025-03-05 11:36:21 | occupants | 3 | 148641 | 19 | 45.236 | 3285.9 |
| 306 | 2025-03-05 11:36:49 | occupants | 2 | 121436 | 4 | 15.810 | 7681.0 |
| 305 | 2025-03-05 11:19:04 | occupants | 1 | 81242 | 2 | 3.483 | 23325.3 |
| 304 | 2025-03-04 00:02:10 | occupants | 3 | 148641 | 19 | 32.066 | 4635.5 |
| 303 | 2025-03-04 00:02:06 | occupants | 2 | 121436 | 4 | 15.046 | 8071.0 |
| 302 | 2025-02-18 06:59:06 | occupants | 3 | 148641 | 19 | 34.906 | 4258.3 |
| 301 | 2025-02-12 09:53:07 | occupants | 3 | 148641 | 19 | 29.280 | 5076.5 |
| 300 | 2025-02-12 09:53:09 | occupants | 2 | 121436 | 4 | 17.250 | 7039.8 |
| 299 | 2025-02-12 09:51:24 | occupants | 1 | 81242 | 2 | 6.326 | 12842.6 |
| 298 | 2025-02-06 20:35:20 | occupants | 3 | 148641 | 19 | 51.143 | 2906.4 |
| 297 | 2025-02-05 15:43:56 | occupants | 3 | 148641 | 19 | 31.250 | 4756.5 |
| 296 | 2025-02-04 04:55:41 | occupants | 3 | 148641 | 19 | 34.786 | 4273.0 |
| 295 | 2025-01-26 23:58:12 | occupants | 1 | 81242 | 2 | 3.873 | 20976.5 |
| 294 | 2024-12-26 15:35:31 | occupants | 1 | 81242 | 2 | 1.250 | 64993.6 |
| 293 | 2024-12-25 19:17:53 | occupants | 3 | 148641 | 19 | 34.406 | 4320.2 |
| 292 | 2024-12-25 19:17:58 | occupants | 2 | 121436 | 4 | 12.643 | 9605.0 |
| 291 | 2024-12-25 19:16:29 | occupants | 3 | 148641 | 19 | 31.080 | 4782.5 |
| 290 | 2024-12-25 19:13:19 | occupants | 1 | 81242 | 2 | 3.063 | 26523.7 |
| 289 | 2024-12-24 18:25:15 | occupants | 2 | 121436 | 4 | 26.566 | 4571.1 |
| 288 | 2024-12-24 18:24:14 | occupants | 1 | 81242 | 2 | 4.920 | 16512.6 |
| 287 | 2024-12-20 00:31:15 | occupants | 2 | 121436 | 4 | 24.300 | 4997.4 |
| 286 | 2024-12-20 00:30:55 | occupants | 3 | 148641 | 19 | 41.970 | 3541.6 |
| 285 | 2024-12-19 23:03:55 | occupants | 1 | 81242 | 2 | 6.263 | 12971.7 |
| 284 | 2024-12-08 03:45:55 | occupants | 3 | 148641 | 19 | 47.813 | 3108.8 |
| 283 | 2024-11-26 00:40:20 | occupants | 3 | 148641 | 19 | 17.143 | 8670.7 |
| 282 | 2024-11-26 00:40:20 | occupants | 2 | 121436 | 4 | 8.140 | 14918.4 |
| 281 | 2024-11-26 00:20:26 | occupants | 1 | 81242 | 2 | 1.436 | 56575.2 |
| 280 | 2024-11-24 09:56:22 | occupants | 3 | 148641 | 19 | 34.420 | 4318.4 |
| 279 | 2024-11-20 08:24:41 | occupants | 1 | 81242 | 2 | 7.110 | 11426.4 |
| 278 | 2024-11-07 20:27:18 | occupants | 1 | 81242 | 2 | 1.220 | 66591.8 |
| 277 | 2024-11-05 19:30:43 | occupants | 1 | 81242 | 2 | 6.533 | 12435.6 |
| 276 | 2024-11-02 08:04:36 | occupants | 3 | 148641 | 19 | 35.733 | 4159.8 |
| 275 | 2024-10-25 21:10:35 | occupants | 3 | 148641 | 19 | 33.050 | 4497.5 |
| 274 | 2024-10-20 04:15:23 | occupants | 3 | 148641 | 19 | 33.346 | 4457.5 |
| 273 | 2024-10-20 04:15:32 | occupants | 2 | 121436 | 4 | 8.453 | 14366.0 |
| 272 | 2024-10-20 04:15:17 | occupants | 3 | 148641 | 19 | 18.360 | 8095.9 |
| 271 | 2024-10-20 04:11:01 | occupants | 1 | 81242 | 2 | 1.423 | 57092.1 |
| 270 | 2024-09-18 23:34:47 | occupants | 2 | 121436 | 4 | 25.783 | 4709.9 |
| 269 | 2024-09-18 21:04:49 | occupants | 1 | 81242 | 2 | 10.533 | 7713.1 |
| 268 | 2024-09-18 15:32:15 | occupants | 3 | 148641 | 19 | 43.050 | 3452.8 |
| 267 | 2024-09-18 15:31:34 | occupants | 2 | 121436 | 4 | 42.750 | 2840.6 |
| 266 | 2024-09-17 19:38:07 | occupants | 1 | 81242 | 2 | 10.033 | 8097.5 |
| 265 | 2024-09-13 05:33:40 | occupants | 1 | 81242 | 2 | 10.470 | 7759.5 |
| 264 | 2024-09-12 05:39:49 | occupants | 1 | 81242 | 2 | 8.436 | 9630.4 |
| 263 | 2024-08-21 04:08:48 | occupants | 1 | 81242 | 2 | 8.906 | 9122.2 |
| 262 | 2024-08-12 14:27:43 | occupants | 1 | 81242 | 2 | 9.733 | 8347.1 |
| 261 | 2024-08-11 08:38:46 | occupants | 1 | 81242 | 2 | 6.390 | 12713.9 |
| 260 | 2024-08-09 09:59:55 | occupants | 4 | 165329 | 136 | 61.223 | 2700.4 |
| 259 | 2024-08-09 09:59:56 | occupants | 3 | 148641 | 19 | 30.893 | 4811.5 |
| 258 | 2024-08-09 09:59:59 | occupants | 2 | 121436 | 4 | 18.720 | 6487.0 |
| 257 | 2024-08-09 09:57:12 | occupants | 1 | 81242 | 2 | 3.110 | 26122.8 |
| 256 | 2024-08-06 19:14:50 | occupants | 2 | 121436 | 4 | 18.126 | 6699.5 |
| 255 | 2024-08-06 19:12:56 | occupants | 1 | 81242 | 2 | 1.550 | 52414.2 |
| 254 | 2024-08-05 16:06:32 | occupants | 2 | 121436 | 4 | 18.453 | 6580.8 |
| 253 | 2024-08-05 16:05:13 | occupants | 1 | 81242 | 2 | 5.080 | 15992.5 |