History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"tourists"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 377 | 2025-05-04 05:48:08 | tourists | 1 | 82945 | 6 | 7.186 | 11542.6 |
| 376 | 2025-05-02 16:23:14 | tourists | 1 | 82945 | 6 | 3.533 | 23477.2 |
| 375 | 2025-04-11 03:49:56 | tourists | 1 | 82945 | 6 | 10.970 | 7561.1 |
| 374 | 2025-04-09 14:47:11 | tourists | 3 | 146162 | 162 | 23.733 | 6158.6 |
| 373 | 2025-04-09 13:55:24 | tourists | 2 | 121059 | 19 | 18.440 | 6565.0 |
| 372 | 2025-04-08 08:06:38 | tourists | 1 | 82945 | 6 | 5.360 | 15474.8 |
| 371 | 2025-04-08 06:46:34 | tourists | 3 | 146162 | 162 | 32.783 | 4458.5 |
| 370 | 2025-04-06 18:02:25 | tourists | 3 | 146162 | 162 | 24.516 | 5961.9 |
| 369 | 2025-04-05 09:52:00 | tourists | 2 | 121059 | 19 | 3.313 | 36540.6 |
| 368 | 2025-04-02 15:31:18 | tourists | 1 | 82945 | 6 | 2.983 | 27805.9 |
| 367 | 2025-03-24 02:07:28 | tourists | 2 | 121059 | 19 | 18.063 | 6702.0 |
| 366 | 2025-03-22 03:55:11 | tourists | 2 | 121059 | 19 | 17.220 | 7030.1 |
| 365 | 2025-03-22 03:07:27 | tourists | 3 | 146162 | 162 | 37.360 | 3912.3 |
| 364 | 2025-03-20 05:17:34 | tourists | 1 | 82945 | 6 | 6.186 | 13408.5 |
| 363 | 2025-03-18 01:33:03 | tourists | 3 | 146162 | 162 | 58.940 | 2479.8 |
| 362 | 2025-03-18 01:33:02 | tourists | 2 | 121059 | 19 | 16.453 | 7357.9 |
| 361 | 2025-03-17 02:06:56 | tourists | 1 | 82945 | 6 | 3.890 | 21322.6 |
| 360 | 2025-03-12 21:11:12 | tourists | 1 | 82945 | 6 | 4.266 | 19443.3 |
| 359 | 2025-03-08 20:51:56 | tourists | 1 | 82945 | 6 | 3.516 | 23590.7 |
| 358 | 2025-03-07 12:48:43 | tourists | 3 | 146162 | 162 | 42.533 | 3436.4 |
| 357 | 2025-03-05 03:31:41 | tourists | 1 | 82945 | 6 | 6.593 | 12580.8 |
| 356 | 2025-03-04 09:09:11 | tourists | 3 | 146162 | 162 | 34.143 | 4280.9 |
| 355 | 2025-03-03 23:53:09 | tourists | 3 | 146162 | 162 | 50.423 | 2898.7 |
| 354 | 2025-03-02 22:37:59 | tourists | 1 | 82945 | 6 | 5.513 | 15045.3 |
| 353 | 2025-03-02 02:16:25 | tourists | 3 | 146162 | 162 | 36.003 | 4059.7 |
| 352 | 2025-03-02 02:16:26 | tourists | 2 | 121059 | 19 | 26.406 | 4584.5 |
| 351 | 2025-03-02 02:16:31 | tourists | 1 | 82945 | 6 | 7.283 | 11388.9 |
| 350 | 2025-02-26 09:14:40 | tourists | 1 | 82945 | 6 | 2.736 | 30316.2 |
| 349 | 2025-02-02 04:37:31 | tourists | 1 | 82945 | 6 | 6.953 | 11929.4 |
| 348 | 2025-02-01 09:03:09 | tourists | 1 | 82945 | 6 | 10.296 | 8056.0 |
| 347 | 2025-01-28 15:22:44 | tourists | 1 | 82945 | 6 | 3.486 | 23793.7 |
| 346 | 2025-01-16 15:09:39 | tourists | 1 | 82945 | 6 | 10.186 | 8143.0 |
| 345 | 2025-01-15 05:38:24 | tourists | 2 | 121059 | 19 | 18.906 | 6403.2 |
| 344 | 2025-01-15 05:03:44 | tourists | 1 | 82945 | 6 | 1.423 | 58288.8 |
| 343 | 2025-01-01 20:59:42 | tourists | 2 | 121059 | 19 | 5.390 | 22459.9 |
| 342 | 2024-12-29 08:31:19 | tourists | 1 | 82945 | 6 | 3.720 | 22297.0 |
| 341 | 2024-12-27 02:55:56 | tourists | 3 | 146162 | 162 | 54.596 | 2677.2 |
| 340 | 2024-12-27 02:49:27 | tourists | 2 | 121059 | 19 | 3.656 | 33112.4 |
| 339 | 2024-12-27 02:31:31 | tourists | 3 | 146162 | 162 | 15.813 | 9243.2 |
| 338 | 2024-12-27 00:00:18 | tourists | 3 | 146162 | 162 | 25.720 | 5682.8 |
| 337 | 2024-12-26 14:47:07 | tourists | 3 | 146162 | 162 | 32.800 | 4456.2 |
| 336 | 2024-12-26 14:47:06 | tourists | 2 | 121059 | 19 | 13.486 | 8976.6 |
| 335 | 2024-12-26 14:47:03 | tourists | 1 | 82945 | 6 | 2.500 | 33178.0 |
| 334 | 2024-12-15 01:39:33 | tourists | 1 | 82945 | 6 | 7.266 | 11415.5 |
| 333 | 2024-12-01 05:26:53 | tourists | 1 | 82945 | 6 | 3.736 | 22201.6 |
| 332 | 2024-11-29 06:15:21 | tourists | 1 | 82945 | 6 | 7.780 | 10661.3 |
| 331 | 2024-11-26 14:37:48 | tourists | 3 | 146162 | 162 | 7.686 | 19016.7 |
| 330 | 2024-11-22 13:34:08 | tourists | 3 | 146162 | 162 | 32.376 | 4514.5 |
| 329 | 2024-11-20 08:53:18 | tourists | 3 | 146162 | 162 | 6.860 | 21306.4 |
| 328 | 2024-11-20 08:53:17 | tourists | 2 | 121059 | 19 | 3.640 | 33258.0 |
| 327 | 2024-11-07 19:15:30 | tourists | 1 | 82945 | 6 | 3.593 | 23085.2 |
| 326 | 2024-10-27 17:28:20 | tourists | 1 | 82945 | 6 | 8.406 | 9867.4 |
| 325 | 2024-10-26 19:09:40 | tourists | 1 | 82945 | 6 | 1.466 | 56579.1 |
| 324 | 2024-10-25 02:40:23 | tourists | 1 | 82945 | 6 | 5.890 | 14082.3 |
| 323 | 2024-10-16 18:10:57 | tourists | 3 | 146162 | 162 | 38.266 | 3819.6 |
| 322 | 2024-10-14 21:59:38 | tourists | 2 | 121059 | 19 | 4.123 | 29361.9 |
| 321 | 2024-10-13 04:38:42 | tourists | 3 | 146162 | 162 | 39.406 | 3709.1 |
| 320 | 2024-10-12 10:09:35 | tourists | 3 | 146162 | 162 | 34.970 | 4179.6 |
| 319 | 2024-10-12 10:09:35 | tourists | 2 | 121059 | 19 | 18.796 | 6440.7 |
| 318 | 2024-10-11 18:09:27 | tourists | 3 | 146162 | 162 | 37.606 | 3886.7 |
| 317 | 2024-10-11 18:09:22 | tourists | 2 | 121059 | 19 | 13.786 | 8781.3 |
| 316 | 2024-10-07 20:03:13 | tourists | 1 | 82945 | 6 | 10.813 | 7670.9 |
| 315 | 2024-09-18 20:03:34 | tourists | 1 | 82945 | 6 | 10.263 | 8081.9 |
| 314 | 2024-09-18 01:20:04 | tourists | 1 | 82945 | 6 | 9.763 | 8495.9 |
| 313 | 2024-09-16 03:40:56 | tourists | 1 | 82945 | 6 | 16.093 | 5154.1 |
| 312 | 2024-09-07 10:06:00 | tourists | 3 | 146162 | 162 | 56.910 | 2568.3 |
| 311 | 2024-09-05 23:37:12 | tourists | 3 | 146162 | 162 | 12.186 | 11994.3 |
| 310 | 2024-09-05 13:15:27 | tourists | 1 | 82945 | 6 | 14.483 | 5727.1 |
| 309 | 2024-08-30 11:37:10 | tourists | 1 | 82945 | 6 | 1.313 | 63172.1 |
| 308 | 2024-08-20 09:36:00 | tourists | 3 | 146162 | 162 | 92.983 | 1571.9 |
| 307 | 2024-08-18 11:36:24 | tourists | 1 | 82945 | 6 | 9.423 | 8802.4 |
| 306 | 2024-08-18 11:30:41 | tourists | 3 | 146162 | 162 | 47.703 | 3064.0 |
| 305 | 2024-08-16 17:27:37 | tourists | 3 | 146162 | 162 | 58.863 | 2483.1 |
| 304 | 2024-08-16 17:27:38 | tourists | 2 | 121059 | 19 | 24.360 | 4969.6 |
| 303 | 2024-08-16 17:27:36 | tourists | 1 | 82945 | 6 | 8.610 | 9633.6 |
| 302 | 2024-08-16 16:24:09 | tourists | 1 | 82945 | 6 | 9.906 | 8373.2 |
| 301 | 2024-08-02 03:00:28 | tourists | 1 | 82945 | 6 | 3.813 | 21753.2 |
| 300 | 2024-07-29 04:06:54 | tourists | 1 | 82945 | 6 | 7.670 | 10814.2 |
| 299 | 2024-07-17 17:23:29 | tourists | 1 | 82945 | 6 | 5.593 | 14830.1 |
| 298 | 2024-07-14 11:30:27 | tourists | 1 | 82945 | 6 | 6.640 | 12491.7 |
| 297 | 2024-07-11 03:40:15 | tourists | 2 | 121059 | 19 | 23.936 | 5057.6 |
| 296 | 2024-07-11 03:40:02 | tourists | 1 | 82945 | 6 | 7.813 | 10616.3 |
| 295 | 2024-07-08 06:26:24 | tourists | 1 | 82945 | 6 | 6.750 | 12288.1 |
| 294 | 2024-07-04 10:05:41 | tourists | 3 | 146162 | 162 | 43.720 | 3343.1 |
| 293 | 2024-07-02 20:36:52 | tourists | 2 | 121059 | 19 | 3.843 | 31501.2 |
| 292 | 2024-07-02 20:36:50 | tourists | 1 | 82945 | 6 | 1.530 | 54212.4 |
| 291 | 2024-06-28 11:56:07 | tourists | 1 | 82945 | 6 | 6.703 | 12374.3 |
| 290 | 2024-06-28 09:27:31 | tourists | 3 | 146162 | 162 | 32.800 | 4456.2 |
| 289 | 2024-06-28 07:42:28 | tourists | 3 | 146162 | 162 | 24.593 | 5943.2 |
| 288 | 2024-06-27 13:55:08 | tourists | 3 | 146162 | 162 | 39.453 | 3704.7 |
| 287 | 2024-06-27 13:55:04 | tourists | 2 | 121059 | 19 | 22.563 | 5365.4 |
| 286 | 2024-06-27 07:25:13 | tourists | 1 | 82945 | 6 | 2.623 | 31622.2 |
| 285 | 2024-06-24 23:43:12 | tourists | 3 | 146162 | 162 | 22.393 | 6527.1 |
| 284 | 2024-06-24 23:43:08 | tourists | 2 | 121059 | 19 | 19.533 | 6197.7 |
| 283 | 2024-06-24 23:42:56 | tourists | 1 | 82945 | 6 | 7.593 | 10923.9 |
| 282 | 2024-06-12 23:42:48 | tourists | 1 | 82945 | 6 | 2.720 | 30494.5 |
| 281 | 2024-06-12 14:31:24 | tourists | 1 | 82945 | 6 | 7.123 | 11644.7 |
| 280 | 2024-05-13 00:27:09 | tourists | 1 | 82945 | 6 | 3.326 | 24938.4 |
| 279 | 2024-05-11 15:24:47 | tourists | 3 | 146162 | 162 | 11.373 | 12851.7 |
| 278 | 2024-05-11 15:24:46 | tourists | 2 | 121059 | 19 | 4.390 | 27576.1 |