History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subarea"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 410 | 2025-10-23 13:55:14 | subarea | 2 | 107671 | 8 | 3.250 | 33129.5 |
| 409 | 2025-10-12 03:39:53 | subarea | 1 | 69583 | 2 | 1.110 | 62687.4 |
| 408 | 2025-10-07 15:00:46 | subarea | 1 | 69583 | 2 | 1.140 | 61037.7 |
| 407 | 2025-10-07 05:34:49 | subarea | 1 | 69583 | 2 | 1.190 | 58473.1 |
| 406 | 2025-09-29 15:29:37 | subarea | 1 | 69583 | 2 | 2.016 | 34515.4 |
| 405 | 2025-09-28 06:35:55 | subarea | 1 | 69583 | 2 | 1.263 | 55093.4 |
| 404 | 2025-09-27 13:32:16 | subarea | 1 | 69583 | 2 | 1.283 | 54234.6 |
| 403 | 2025-09-26 15:11:48 | subarea | 1 | 69583 | 2 | 1.160 | 59985.3 |
| 402 | 2025-09-19 01:38:29 | subarea | 1 | 69583 | 2 | 1.313 | 52995.4 |
| 401 | 2025-09-11 03:54:48 | subarea | 1 | 69583 | 2 | 1.156 | 60192.9 |
| 400 | 2025-09-06 05:56:07 | subarea | 1 | 69583 | 2 | 1.140 | 61037.7 |
| 399 | 2025-09-05 15:22:35 | subarea | 1 | 69583 | 2 | 1.140 | 61037.7 |
| 398 | 2025-08-29 16:17:56 | subarea | 1 | 69583 | 2 | 1.250 | 55666.4 |
| 397 | 2025-08-28 15:37:00 | subarea | 2 | 107671 | 8 | 3.470 | 31029.1 |
| 396 | 2025-08-28 06:11:56 | subarea | 1 | 69583 | 2 | 1.170 | 59472.6 |
| 395 | 2025-08-27 14:20:03 | subarea | 1 | 69583 | 2 | 1.236 | 56296.9 |
| 394 | 2025-08-27 13:46:58 | subarea | 1 | 69583 | 2 | 1.263 | 55093.4 |
| 393 | 2025-08-24 20:34:06 | subarea | 1 | 69583 | 2 | 4.093 | 17000.5 |
| 392 | 2025-08-21 05:12:20 | subarea | 3 | 134027 | 193 | 25.390 | 5278.7 |
| 391 | 2025-08-19 05:12:52 | subarea | 3 | 134027 | 193 | 30.266 | 4428.3 |
| 390 | 2025-08-19 05:12:51 | subarea | 3 | 134027 | 193 | 27.110 | 4943.8 |
| 389 | 2025-08-17 14:06:22 | subarea | 3 | 134027 | 193 | 23.686 | 5658.5 |
| 388 | 2025-08-17 07:52:53 | subarea | 3 | 134027 | 193 | 21.500 | 6233.8 |
| 387 | 2025-08-15 05:10:59 | subarea | 3 | 134027 | 193 | 17.643 | 7596.6 |
| 386 | 2025-08-09 04:18:07 | subarea | 1 | 69583 | 2 | 5.966 | 11663.3 |
| 385 | 2025-08-05 18:07:37 | subarea | 1 | 69583 | 2 | 6.250 | 11133.3 |
| 384 | 2025-07-24 21:10:02 | subarea | 1 | 69583 | 2 | 5.560 | 12514.9 |
| 383 | 2025-07-23 23:59:06 | subarea | 1 | 69583 | 2 | 3.673 | 18944.5 |
| 382 | 2025-07-23 04:20:44 | subarea | 1 | 69583 | 2 | 7.076 | 9833.7 |
| 381 | 2025-07-22 19:32:27 | subarea | 1 | 69583 | 2 | 6.280 | 11080.1 |
| 380 | 2025-07-22 09:32:39 | subarea | 1 | 69583 | 2 | 1.343 | 51811.6 |
| 379 | 2025-07-18 09:16:11 | subarea | 3 | 134027 | 193 | 28.313 | 4733.8 |
| 378 | 2025-07-17 03:42:59 | subarea | 3 | 134027 | 193 | 20.573 | 6514.7 |
| 377 | 2025-07-14 14:37:55 | subarea | 1 | 69583 | 2 | 3.030 | 22964.7 |
| 376 | 2025-07-14 09:32:48 | subarea | 3 | 134027 | 193 | 18.283 | 7330.7 |
| 375 | 2025-07-11 01:36:00 | subarea | 2 | 107671 | 8 | 8.436 | 12763.3 |
| 374 | 2025-07-10 18:37:04 | subarea | 3 | 134027 | 193 | 28.110 | 4767.9 |
| 373 | 2025-06-20 17:45:15 | subarea | 1 | 69583 | 2 | 3.220 | 21609.6 |
| 372 | 2025-06-20 16:33:53 | subarea | 1 | 69583 | 2 | 2.766 | 25156.5 |
| 371 | 2025-06-19 22:01:28 | subarea | 1 | 69583 | 2 | 3.106 | 22402.8 |
| 370 | 2025-06-17 04:58:38 | subarea | 1 | 69583 | 2 | 1.296 | 53690.6 |
| 369 | 2025-06-16 08:49:56 | subarea | 2 | 107671 | 8 | 8.846 | 12171.7 |
| 368 | 2025-06-15 07:03:47 | subarea | 1 | 69583 | 2 | 1.216 | 57222.9 |
| 367 | 2025-06-12 13:41:11 | subarea | 1 | 69583 | 2 | 5.843 | 11908.8 |
| 366 | 2025-06-04 15:19:21 | subarea | 1 | 69583 | 2 | 3.720 | 18705.1 |
| 365 | 2025-05-30 16:41:17 | subarea | 1 | 69583 | 2 | 1.343 | 51811.6 |
| 364 | 2025-05-20 15:06:08 | subarea | 1 | 69583 | 2 | 5.050 | 13778.8 |
| 363 | 2025-05-19 22:13:20 | subarea | 1 | 69583 | 2 | 3.140 | 22160.2 |
| 362 | 2025-05-14 14:17:36 | subarea | 3 | 134027 | 193 | 37.190 | 3603.8 |
| 361 | 2025-05-12 08:50:24 | subarea | 3 | 134027 | 193 | 38.126 | 3515.4 |
| 360 | 2025-05-10 05:16:23 | subarea | 3 | 134027 | 193 | 53.043 | 2526.8 |
| 359 | 2025-05-09 15:10:18 | subarea | 1 | 69583 | 2 | 1.266 | 54962.9 |
| 358 | 2025-05-05 06:41:54 | subarea | 1 | 69583 | 2 | 6.313 | 11022.2 |
| 357 | 2025-05-04 14:48:08 | subarea | 1 | 69583 | 2 | 4.406 | 15792.8 |
| 356 | 2025-04-21 10:51:09 | subarea | 2 | 107671 | 8 | 18.826 | 5719.3 |
| 355 | 2025-04-19 20:30:06 | subarea | 1 | 69583 | 2 | 5.343 | 13023.2 |
| 354 | 2025-04-18 14:52:21 | subarea | 1 | 69583 | 2 | 3.266 | 21305.3 |
| 353 | 2025-04-09 14:44:33 | subarea | 2 | 107671 | 8 | 16.846 | 6391.5 |
| 352 | 2025-04-08 14:05:20 | subarea | 1 | 69583 | 2 | 6.326 | 10999.5 |
| 351 | 2025-04-04 06:52:06 | subarea | 1 | 69583 | 2 | 5.733 | 12137.3 |
| 350 | 2025-03-21 12:06:18 | subarea | 2 | 107671 | 8 | 12.813 | 8403.3 |
| 349 | 2025-03-21 03:12:00 | subarea | 3 | 134027 | 193 | 39.016 | 3435.2 |
| 348 | 2025-03-19 21:20:06 | subarea | 1 | 69583 | 2 | 5.373 | 12950.5 |
| 347 | 2025-03-13 00:07:53 | subarea | 1 | 69583 | 2 | 2.810 | 24762.6 |
| 346 | 2025-03-11 18:27:02 | subarea | 3 | 134027 | 193 | 35.750 | 3749.0 |
| 345 | 2025-03-10 07:41:04 | subarea | 1 | 69583 | 2 | 5.486 | 12683.7 |
| 344 | 2025-03-07 16:19:26 | subarea | 1 | 69583 | 2 | 4.500 | 15462.9 |
| 343 | 2025-03-03 14:13:04 | subarea | 2 | 107671 | 8 | 13.483 | 7985.7 |
| 342 | 2025-02-26 08:48:28 | subarea | 3 | 134027 | 193 | 30.970 | 4327.6 |
| 341 | 2025-02-26 06:45:00 | subarea | 3 | 134027 | 193 | 20.906 | 6410.9 |
| 340 | 2025-02-26 03:13:44 | subarea | 3 | 134027 | 193 | 37.786 | 3547.0 |
| 339 | 2025-02-26 02:00:17 | subarea | 1 | 69583 | 2 | 7.156 | 9723.7 |
| 338 | 2025-02-26 01:59:51 | subarea | 3 | 134027 | 193 | 22.970 | 5834.9 |
| 337 | 2025-02-26 01:59:46 | subarea | 2 | 107671 | 8 | 13.800 | 7802.2 |
| 336 | 2025-02-24 13:13:00 | subarea | 2 | 107671 | 8 | 2.906 | 37051.3 |
| 335 | 2025-02-23 04:53:06 | subarea | 1 | 69583 | 2 | 6.033 | 11533.7 |
| 334 | 2025-02-07 12:57:42 | subarea | 1 | 69583 | 2 | 3.000 | 23194.3 |
| 333 | 2025-01-24 06:20:15 | subarea | 1 | 69583 | 2 | 7.610 | 9143.6 |
| 332 | 2025-01-14 05:14:45 | subarea | 1 | 69583 | 2 | 3.330 | 20895.8 |
| 331 | 2024-12-18 17:53:07 | subarea | 1 | 69583 | 2 | 9.063 | 7677.7 |
| 330 | 2024-12-14 11:12:50 | subarea | 1 | 69583 | 2 | 11.940 | 5827.7 |
| 329 | 2024-12-11 00:51:46 | subarea | 3 | 134027 | 193 | 35.270 | 3800.0 |
| 328 | 2024-12-10 20:29:10 | subarea | 2 | 107671 | 8 | 13.830 | 7785.3 |
| 327 | 2024-12-10 00:41:01 | subarea | 3 | 134027 | 193 | 29.003 | 4621.1 |
| 326 | 2024-12-08 16:02:51 | subarea | 3 | 134027 | 193 | 16.173 | 8287.1 |
| 325 | 2024-12-08 15:21:34 | subarea | 3 | 134027 | 193 | 44.096 | 3039.4 |
| 324 | 2024-12-08 15:21:34 | subarea | 2 | 107671 | 8 | 9.016 | 11942.2 |
| 323 | 2024-11-28 15:22:33 | subarea | 1 | 69583 | 2 | 7.953 | 8749.3 |
| 322 | 2024-11-18 17:32:36 | subarea | 1 | 69583 | 2 | 5.843 | 11908.8 |
| 321 | 2024-11-13 22:55:05 | subarea | 1 | 69583 | 2 | 3.173 | 21929.7 |
| 320 | 2024-11-08 07:32:29 | subarea | 1 | 69583 | 2 | 7.846 | 8868.6 |
| 319 | 2024-10-14 19:25:30 | subarea | 1 | 69583 | 2 | 5.373 | 12950.5 |
| 318 | 2024-10-14 02:34:34 | subarea | 1 | 69583 | 2 | 6.096 | 11414.5 |
| 317 | 2024-09-12 16:11:36 | subarea | 1 | 69583 | 2 | 11.330 | 6141.5 |
| 316 | 2024-09-04 09:38:49 | subarea | 1 | 69583 | 2 | 4.373 | 15912.0 |
| 315 | 2024-09-02 09:36:12 | subarea | 2 | 107671 | 8 | 17.876 | 6023.2 |
| 314 | 2024-09-01 12:09:14 | subarea | 3 | 134027 | 193 | 75.613 | 1772.5 |
| 313 | 2024-09-01 12:09:24 | subarea | 2 | 107671 | 8 | 36.500 | 2949.9 |
| 312 | 2024-09-01 12:09:09 | subarea | 1 | 69583 | 2 | 14.063 | 4947.9 |
| 311 | 2024-08-21 02:50:44 | subarea | 1 | 69583 | 2 | 6.440 | 10804.8 |