History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"onshore"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 405 | 2025-10-24 21:41:03 | onshore | 1 | 69583 | 2 | 1.393 | 49951.9 |
| 404 | 2025-10-19 18:45:14 | onshore | 1 | 69583 | 2 | 5.076 | 13708.2 |
| 403 | 2025-10-18 11:46:02 | onshore | 1 | 69583 | 2 | 1.236 | 56296.9 |
| 402 | 2025-09-29 04:10:55 | onshore | 1 | 69583 | 2 | 1.220 | 57035.2 |
| 401 | 2025-09-29 04:05:18 | onshore | 1 | 69583 | 2 | 1.203 | 57841.2 |
| 400 | 2025-09-29 02:42:17 | onshore | 1 | 69583 | 2 | 1.076 | 64668.2 |
| 399 | 2025-09-28 00:49:31 | onshore | 3 | 134027 | 101 | 5.970 | 22450.1 |
| 398 | 2025-09-20 13:00:06 | onshore | 3 | 134027 | 101 | 6.140 | 21828.5 |
| 397 | 2025-09-18 21:28:35 | onshore | 1 | 69583 | 2 | 1.203 | 57841.2 |
| 396 | 2025-09-11 08:46:37 | onshore | 1 | 69583 | 2 | 1.233 | 56433.9 |
| 395 | 2025-09-11 02:05:05 | onshore | 1 | 69583 | 2 | 1.250 | 55666.4 |
| 394 | 2025-09-11 02:05:02 | onshore | 1 | 69583 | 2 | 1.250 | 55666.4 |
| 393 | 2025-09-11 00:32:57 | onshore | 1 | 69583 | 2 | 1.076 | 64668.2 |
| 392 | 2025-09-10 20:16:26 | onshore | 1 | 69583 | 2 | 1.200 | 57985.8 |
| 391 | 2025-08-29 03:27:28 | onshore | 1 | 69583 | 2 | 1.080 | 64428.7 |
| 390 | 2025-08-28 16:37:07 | onshore | 3 | 134027 | 101 | 6.923 | 19359.7 |
| 389 | 2025-08-28 03:47:40 | onshore | 3 | 134027 | 101 | 6.686 | 20045.9 |
| 388 | 2025-08-28 01:47:19 | onshore | 1 | 69583 | 2 | 1.110 | 62687.4 |
| 387 | 2025-08-27 13:21:31 | onshore | 3 | 134027 | 101 | 7.143 | 18763.4 |
| 386 | 2025-08-27 03:45:23 | onshore | 1 | 69583 | 2 | 1.236 | 56296.9 |
| 385 | 2025-07-31 15:28:46 | onshore | 1 | 69583 | 2 | 1.076 | 64668.2 |
| 384 | 2025-07-28 07:39:18 | onshore | 2 | 107671 | 9 | 7.173 | 15010.6 |
| 383 | 2025-07-27 05:27:24 | onshore | 1 | 69583 | 2 | 4.093 | 17000.5 |
| 382 | 2025-07-25 04:54:47 | onshore | 1 | 69583 | 2 | 4.920 | 14142.9 |
| 381 | 2025-07-23 03:52:15 | onshore | 1 | 69583 | 2 | 4.796 | 14508.5 |
| 380 | 2025-07-18 10:06:51 | onshore | 1 | 69583 | 2 | 2.843 | 24475.2 |
| 379 | 2025-07-17 04:23:46 | onshore | 1 | 69583 | 2 | 3.843 | 18106.4 |
| 378 | 2025-07-13 02:49:50 | onshore | 1 | 69583 | 2 | 1.216 | 57222.9 |
| 377 | 2025-07-10 20:04:29 | onshore | 3 | 134027 | 101 | 21.373 | 6270.9 |
| 376 | 2025-07-07 17:37:31 | onshore | 1 | 69583 | 2 | 6.143 | 11327.2 |
| 375 | 2025-07-04 17:14:49 | onshore | 3 | 134027 | 101 | 25.830 | 5188.8 |
| 374 | 2025-07-04 04:52:25 | onshore | 3 | 134027 | 101 | 34.456 | 3889.8 |
| 373 | 2025-07-02 20:50:01 | onshore | 3 | 134027 | 101 | 25.453 | 5265.7 |
| 372 | 2025-07-02 12:40:13 | onshore | 2 | 107671 | 9 | 15.813 | 6809.0 |
| 371 | 2025-07-01 02:16:13 | onshore | 2 | 107671 | 9 | 3.673 | 29314.2 |
| 370 | 2025-06-29 13:47:19 | onshore | 2 | 107671 | 9 | 16.360 | 6581.4 |
| 369 | 2025-06-23 22:42:10 | onshore | 1 | 69583 | 2 | 3.936 | 17678.6 |
| 368 | 2025-06-14 03:15:37 | onshore | 1 | 69583 | 2 | 8.640 | 8053.6 |
| 367 | 2025-06-06 16:51:45 | onshore | 1 | 69583 | 2 | 7.643 | 9104.1 |
| 366 | 2025-06-04 05:16:41 | onshore | 1 | 69583 | 2 | 7.500 | 9277.7 |
| 365 | 2025-05-31 13:09:19 | onshore | 1 | 69583 | 2 | 6.013 | 11572.1 |
| 364 | 2025-05-30 20:02:20 | onshore | 1 | 69583 | 2 | 5.096 | 13654.4 |
| 363 | 2025-05-25 11:48:30 | onshore | 1 | 69583 | 2 | 1.860 | 37410.2 |
| 362 | 2025-05-20 04:57:19 | onshore | 1 | 69583 | 2 | 5.266 | 13213.6 |
| 361 | 2025-05-10 02:30:50 | onshore | 1 | 69583 | 2 | 8.720 | 7979.7 |
| 360 | 2025-05-02 18:23:18 | onshore | 1 | 69583 | 2 | 1.186 | 58670.3 |
| 359 | 2025-04-30 16:39:18 | onshore | 1 | 69583 | 2 | 3.000 | 23194.3 |
| 358 | 2025-04-30 05:26:15 | onshore | 1 | 69583 | 2 | 6.080 | 11444.6 |
| 357 | 2025-04-29 16:37:59 | onshore | 1 | 69583 | 2 | 1.220 | 57035.2 |
| 356 | 2025-04-29 00:56:02 | onshore | 1 | 69583 | 2 | 5.703 | 12201.1 |
| 355 | 2025-04-22 22:00:16 | onshore | 1 | 69583 | 2 | 5.330 | 13055.0 |
| 354 | 2025-04-08 01:58:34 | onshore | 1 | 69583 | 2 | 3.296 | 21111.3 |
| 353 | 2025-04-04 04:04:37 | onshore | 1 | 69583 | 2 | 5.563 | 12508.2 |
| 352 | 2025-03-29 05:36:04 | onshore | 1 | 69583 | 2 | 6.220 | 11187.0 |
| 351 | 2025-03-23 18:59:25 | onshore | 1 | 69583 | 2 | 8.373 | 8310.4 |
| 350 | 2025-03-22 22:59:26 | onshore | 1 | 69583 | 2 | 2.873 | 24219.6 |
| 349 | 2025-03-17 15:25:51 | onshore | 1 | 69583 | 2 | 8.640 | 8053.6 |
| 348 | 2025-03-12 10:17:07 | onshore | 1 | 69583 | 2 | 2.953 | 23563.5 |
| 347 | 2025-02-24 13:23:23 | onshore | 1 | 69583 | 2 | 5.580 | 12470.1 |
| 346 | 2025-02-21 23:24:54 | onshore | 1 | 69583 | 2 | 5.750 | 12101.4 |
| 345 | 2025-02-06 13:24:30 | onshore | 3 | 134027 | 101 | 43.813 | 3059.1 |
| 344 | 2025-02-01 13:18:30 | onshore | 1 | 69583 | 2 | 5.970 | 11655.4 |
| 343 | 2025-02-01 04:50:18 | onshore | 3 | 134027 | 101 | 30.300 | 4423.3 |
| 342 | 2025-02-01 04:02:16 | onshore | 3 | 134027 | 101 | 32.143 | 4169.7 |
| 341 | 2025-02-01 04:02:17 | onshore | 2 | 107671 | 9 | 16.846 | 6391.5 |
| 340 | 2025-02-01 04:02:01 | onshore | 1 | 69583 | 2 | 7.356 | 9459.4 |
| 339 | 2025-01-16 09:40:09 | onshore | 1 | 69583 | 2 | 6.093 | 11420.2 |
| 338 | 2025-01-09 18:13:54 | onshore | 2 | 107671 | 9 | 11.860 | 9078.5 |
| 337 | 2025-01-09 10:02:46 | onshore | 2 | 107671 | 9 | 14.110 | 7630.8 |
| 336 | 2025-01-09 10:00:34 | onshore | 1 | 69583 | 2 | 5.093 | 13662.5 |
| 335 | 2025-01-01 15:58:24 | onshore | 1 | 69583 | 2 | 5.953 | 11688.7 |
| 334 | 2024-12-30 15:24:37 | onshore | 1 | 69583 | 2 | 4.720 | 14742.2 |
| 333 | 2024-12-23 14:01:04 | onshore | 3 | 134027 | 101 | 32.910 | 4072.5 |
| 332 | 2024-12-21 10:40:33 | onshore | 3 | 134027 | 101 | 40.986 | 3270.1 |
| 331 | 2024-12-19 00:53:07 | onshore | 3 | 134027 | 101 | 34.096 | 3930.9 |
| 330 | 2024-12-15 20:34:01 | onshore | 1 | 69583 | 2 | 3.470 | 20052.7 |
| 329 | 2024-12-14 21:19:06 | onshore | 3 | 134027 | 101 | 25.613 | 5232.8 |
| 328 | 2024-12-11 00:04:55 | onshore | 1 | 69583 | 2 | 6.940 | 10026.4 |
| 327 | 2024-12-10 04:58:54 | onshore | 1 | 69583 | 2 | 5.346 | 13015.9 |
| 326 | 2024-11-28 16:05:18 | onshore | 1 | 69583 | 2 | 4.533 | 15350.3 |
| 325 | 2024-11-22 09:45:27 | onshore | 3 | 134027 | 101 | 33.626 | 3985.8 |
| 324 | 2024-11-22 09:45:19 | onshore | 2 | 107671 | 9 | 13.610 | 7911.2 |
| 323 | 2024-11-19 20:40:37 | onshore | 3 | 134027 | 101 | 30.080 | 4455.7 |
| 322 | 2024-11-18 07:32:35 | onshore | 3 | 134027 | 101 | 19.766 | 6780.7 |
| 321 | 2024-11-18 07:32:36 | onshore | 2 | 107671 | 9 | 16.310 | 6601.5 |
| 320 | 2024-11-18 07:26:50 | onshore | 1 | 69583 | 2 | 1.156 | 60192.9 |
| 319 | 2024-11-13 12:41:42 | onshore | 1 | 69583 | 2 | 3.046 | 22844.1 |
| 318 | 2024-11-08 20:00:41 | onshore | 1 | 69583 | 2 | 3.280 | 21214.3 |
| 317 | 2024-10-17 14:28:29 | onshore | 3 | 134027 | 101 | 32.566 | 4115.5 |
| 316 | 2024-10-17 09:17:14 | onshore | 1 | 69583 | 2 | 5.423 | 12831.1 |
| 315 | 2024-10-14 19:43:19 | onshore | 3 | 134027 | 101 | 27.096 | 4946.4 |
| 314 | 2024-10-13 11:43:38 | onshore | 3 | 134027 | 101 | 34.063 | 3934.7 |
| 313 | 2024-10-13 11:43:34 | onshore | 2 | 107671 | 9 | 21.660 | 4971.0 |
| 312 | 2024-10-13 09:00:06 | onshore | 3 | 134027 | 101 | 35.220 | 3805.4 |
| 311 | 2024-10-13 09:00:26 | onshore | 2 | 107671 | 9 | 10.063 | 10699.7 |
| 310 | 2024-10-13 08:59:40 | onshore | 1 | 69583 | 2 | 3.953 | 17602.6 |
| 309 | 2024-10-06 01:45:21 | onshore | 1 | 69583 | 2 | 9.016 | 7717.7 |
| 308 | 2024-09-26 02:06:55 | onshore | 1 | 69583 | 2 | 9.280 | 7498.2 |
| 307 | 2024-09-09 20:35:43 | onshore | 1 | 69583 | 2 | 16.576 | 4197.8 |
| 306 | 2024-08-24 09:29:53 | onshore | 1 | 69583 | 2 | 10.673 | 6519.5 |