History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"occupant"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 405 | 2025-10-07 11:58:05 | occupant | 2 | 121059 | 5 | 3.750 | 32282.4 |
| 404 | 2025-10-06 03:22:47 | occupant | 2 | 121059 | 5 | 3.250 | 37248.9 |
| 403 | 2025-10-03 17:19:03 | occupant | 3 | 146162 | 25 | 6.626 | 22058.9 |
| 402 | 2025-10-03 00:48:07 | occupant | 4 | 161609 | 186 | 14.563 | 11097.2 |
| 401 | 2025-10-02 16:16:30 | occupant | 1 | 82945 | 2 | 1.313 | 63172.1 |
| 400 | 2025-09-08 00:34:07 | occupant | 1 | 82945 | 2 | 1.283 | 64649.3 |
| 399 | 2025-08-18 20:42:51 | occupant | 1 | 82945 | 2 | 6.813 | 12174.5 |
| 398 | 2025-08-08 23:36:37 | occupant | 1 | 82945 | 2 | 5.906 | 14044.2 |
| 397 | 2025-08-06 00:30:44 | occupant | 3 | 146162 | 25 | 17.393 | 8403.5 |
| 396 | 2025-08-01 01:38:41 | occupant | 3 | 146162 | 25 | 21.830 | 6695.5 |
| 395 | 2025-07-23 22:17:26 | occupant | 1 | 82945 | 2 | 5.000 | 16589.0 |
| 394 | 2025-07-11 16:44:41 | occupant | 2 | 121059 | 5 | 13.593 | 8906.0 |
| 393 | 2025-07-09 20:35:07 | occupant | 1 | 82945 | 2 | 1.483 | 55930.5 |
| 392 | 2025-07-06 22:53:09 | occupant | 1 | 82945 | 2 | 6.830 | 12144.2 |
| 391 | 2025-05-30 19:31:27 | occupant | 3 | 146162 | 25 | 30.156 | 4846.9 |
| 390 | 2025-05-26 14:12:45 | occupant | 1 | 82945 | 2 | 10.236 | 8103.3 |
| 389 | 2025-05-25 20:48:16 | occupant | 1 | 82945 | 2 | 3.706 | 22381.3 |
| 388 | 2025-05-22 14:34:02 | occupant | 1 | 82945 | 2 | 5.346 | 15515.3 |
| 387 | 2025-05-22 08:48:32 | occupant | 3 | 146162 | 25 | 39.220 | 3726.7 |
| 386 | 2025-05-18 07:32:24 | occupant | 3 | 146162 | 25 | 25.436 | 5746.3 |
| 385 | 2025-05-18 01:36:19 | occupant | 2 | 121059 | 5 | 18.063 | 6702.0 |
| 384 | 2025-05-17 15:13:05 | occupant | 1 | 82945 | 2 | 1.546 | 53651.4 |
| 383 | 2025-05-17 07:12:38 | occupant | 3 | 146162 | 25 | 34.083 | 4288.4 |
| 382 | 2025-05-10 22:28:17 | occupant | 4 | 161609 | 186 | 66.030 | 2447.5 |
| 381 | 2025-05-10 20:00:01 | occupant | 4 | 161609 | 186 | 63.080 | 2562.0 |
| 380 | 2025-05-10 19:34:20 | occupant | 3 | 146162 | 25 | 29.456 | 4962.0 |
| 379 | 2025-05-10 18:18:35 | occupant | 4 | 161609 | 186 | 60.630 | 2665.5 |
| 378 | 2025-05-10 03:03:42 | occupant | 1 | 82945 | 2 | 5.956 | 13926.3 |
| 377 | 2025-05-08 07:41:02 | occupant | 4 | 161609 | 186 | 62.083 | 2603.1 |
| 376 | 2025-05-07 23:16:13 | occupant | 1 | 82945 | 2 | 8.203 | 10111.5 |
| 375 | 2025-05-07 00:28:09 | occupant | 1 | 82945 | 2 | 3.046 | 27230.8 |
| 374 | 2025-05-07 00:15:51 | occupant | 2 | 121059 | 5 | 3.920 | 30882.4 |
| 373 | 2025-05-06 22:13:09 | occupant | 3 | 146162 | 25 | 28.486 | 5131.0 |
| 372 | 2025-05-05 19:39:40 | occupant | 1 | 82945 | 2 | 1.500 | 55296.7 |
| 371 | 2025-04-24 20:51:46 | occupant | 1 | 82945 | 2 | 1.373 | 60411.5 |
| 370 | 2025-04-06 13:30:32 | occupant | 1 | 82945 | 2 | 10.233 | 8105.6 |
| 369 | 2025-03-27 02:24:28 | occupant | 2 | 121059 | 5 | 26.670 | 4539.1 |
| 368 | 2025-03-25 07:04:31 | occupant | 3 | 146162 | 25 | 36.113 | 4047.4 |
| 367 | 2025-03-24 13:39:42 | occupant | 2 | 121059 | 5 | 16.156 | 7493.1 |
| 366 | 2025-03-24 11:36:45 | occupant | 3 | 146162 | 25 | 41.956 | 3483.7 |
| 365 | 2025-03-21 21:39:13 | occupant | 1 | 82945 | 2 | 1.360 | 60989.0 |
| 364 | 2025-03-21 09:17:07 | occupant | 3 | 146162 | 25 | 25.033 | 5838.8 |
| 363 | 2025-03-21 01:50:23 | occupant | 2 | 121059 | 5 | 17.970 | 6736.7 |
| 362 | 2025-03-20 04:06:21 | occupant | 1 | 82945 | 2 | 3.483 | 23814.2 |
| 361 | 2025-03-17 17:53:28 | occupant | 1 | 82945 | 2 | 8.830 | 9393.5 |
| 360 | 2025-03-13 22:11:13 | occupant | 1 | 82945 | 2 | 7.046 | 11771.9 |
| 359 | 2025-03-12 17:08:00 | occupant | 3 | 146162 | 25 | 42.643 | 3427.6 |
| 358 | 2025-03-12 11:34:54 | occupant | 3 | 146162 | 25 | 32.923 | 4439.5 |
| 357 | 2025-03-08 14:37:47 | occupant | 3 | 146162 | 25 | 55.160 | 2649.8 |
| 356 | 2025-03-05 11:25:32 | occupant | 2 | 121059 | 5 | 8.423 | 14372.4 |
| 355 | 2025-03-05 11:18:55 | occupant | 1 | 82945 | 2 | 3.516 | 23590.7 |
| 354 | 2025-03-04 06:59:31 | occupant | 4 | 161609 | 186 | 58.056 | 2783.7 |
| 353 | 2025-03-04 00:01:16 | occupant | 4 | 161609 | 186 | 58.423 | 2766.2 |
| 352 | 2025-03-04 00:01:15 | occupant | 2 | 121059 | 5 | 18.520 | 6536.7 |
| 351 | 2025-03-03 19:56:10 | occupant | 3 | 146162 | 25 | 25.610 | 5707.2 |
| 350 | 2025-03-02 00:01:13 | occupant | 3 | 146162 | 25 | 35.656 | 4099.2 |
| 349 | 2025-02-24 17:00:14 | occupant | 4 | 161609 | 186 | 47.843 | 3377.9 |
| 348 | 2025-02-16 20:21:06 | occupant | 3 | 146162 | 25 | 28.500 | 5128.5 |
| 347 | 2025-02-13 14:15:24 | occupant | 1 | 82945 | 2 | 5.310 | 15620.5 |
| 346 | 2025-02-12 09:51:38 | occupant | 2 | 121059 | 5 | 10.173 | 11900.0 |
| 345 | 2025-02-02 18:53:45 | occupant | 3 | 146162 | 25 | 43.513 | 3359.0 |
| 344 | 2025-02-01 19:08:16 | occupant | 2 | 121059 | 5 | 22.470 | 5387.6 |
| 343 | 2025-01-29 02:39:16 | occupant | 1 | 82945 | 2 | 3.236 | 25632.0 |
| 342 | 2025-01-26 23:56:24 | occupant | 2 | 121059 | 5 | 12.686 | 9542.7 |
| 341 | 2025-01-26 22:42:52 | occupant | 4 | 161609 | 186 | 53.830 | 3002.2 |
| 340 | 2025-01-24 22:49:00 | occupant | 4 | 161609 | 186 | 53.753 | 3006.5 |
| 339 | 2025-01-24 19:06:52 | occupant | 4 | 161609 | 186 | 10.860 | 14881.1 |
| 338 | 2025-01-24 19:06:34 | occupant | 3 | 146162 | 25 | 6.903 | 21173.7 |
| 337 | 2025-01-23 02:19:52 | occupant | 3 | 146162 | 25 | 34.850 | 4194.0 |
| 336 | 2025-01-21 02:04:37 | occupant | 3 | 146162 | 25 | 18.220 | 8022.1 |
| 335 | 2025-01-14 07:59:19 | occupant | 1 | 82945 | 2 | 7.546 | 10991.9 |
| 334 | 2025-01-14 07:57:29 | occupant | 3 | 146162 | 25 | 7.313 | 19986.6 |
| 333 | 2025-01-09 21:36:02 | occupant | 2 | 121059 | 5 | 3.436 | 35232.5 |
| 332 | 2025-01-09 21:36:02 | occupant | 1 | 82945 | 2 | 1.406 | 58993.6 |
| 331 | 2024-12-26 15:35:35 | occupant | 2 | 121059 | 5 | 3.483 | 34757.1 |
| 330 | 2024-12-26 14:24:25 | occupant | 3 | 146162 | 25 | 45.800 | 3191.3 |
| 329 | 2024-12-25 19:14:30 | occupant | 2 | 121059 | 5 | 27.300 | 4434.4 |
| 328 | 2024-12-25 19:14:16 | occupant | 1 | 82945 | 2 | 9.983 | 8308.6 |
| 327 | 2024-12-25 07:10:24 | occupant | 3 | 146162 | 25 | 30.126 | 4851.7 |
| 326 | 2024-12-21 00:41:45 | occupant | 4 | 161609 | 186 | 23.876 | 6768.7 |
| 325 | 2024-12-21 00:41:48 | occupant | 3 | 146162 | 25 | 13.063 | 11189.0 |
| 324 | 2024-12-19 22:58:32 | occupant | 3 | 146162 | 25 | 7.296 | 20033.2 |
| 323 | 2024-12-19 22:58:33 | occupant | 2 | 121059 | 5 | 3.970 | 30493.5 |
| 322 | 2024-12-15 08:57:59 | occupant | 4 | 161609 | 186 | 44.720 | 3613.8 |
| 321 | 2024-12-14 23:53:37 | occupant | 1 | 82945 | 2 | 6.623 | 12523.8 |
| 320 | 2024-12-13 16:46:00 | occupant | 4 | 161609 | 186 | 57.676 | 2802.0 |
| 319 | 2024-12-11 00:23:40 | occupant | 4 | 161609 | 186 | 13.233 | 12212.6 |
| 318 | 2024-11-28 00:14:49 | occupant | 4 | 161609 | 186 | 63.770 | 2534.2 |
| 317 | 2024-11-26 00:26:57 | occupant | 1 | 82945 | 2 | 6.830 | 12144.2 |
| 316 | 2024-11-20 13:12:35 | occupant | 4 | 161609 | 186 | 58.940 | 2741.9 |
| 315 | 2024-11-20 08:24:53 | occupant | 1 | 82945 | 2 | 5.030 | 16490.1 |
| 314 | 2024-11-08 16:40:03 | occupant | 4 | 161609 | 186 | 51.393 | 3144.6 |
| 313 | 2024-11-08 04:08:31 | occupant | 4 | 161609 | 186 | 28.736 | 5623.9 |
| 312 | 2024-11-07 20:27:19 | occupant | 4 | 161609 | 186 | 11.970 | 13501.2 |
| 311 | 2024-11-07 20:27:19 | occupant | 2 | 121059 | 5 | 3.546 | 34139.6 |
| 310 | 2024-11-07 20:27:08 | occupant | 1 | 82945 | 2 | 1.330 | 62364.7 |
| 309 | 2024-11-02 12:41:26 | occupant | 1 | 82945 | 2 | 3.593 | 23085.2 |
| 308 | 2024-10-24 10:28:30 | occupant | 3 | 146162 | 25 | 17.203 | 8496.3 |
| 307 | 2024-10-20 04:11:10 | occupant | 3 | 146162 | 25 | 19.283 | 7579.8 |
| 306 | 2024-10-20 04:11:06 | occupant | 2 | 121059 | 5 | 9.670 | 12519.0 |