History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subcategory"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 379 | 2025-07-27 04:05:50 | subcategory | 1 | 49908 | 1 | 4.450 | 11215.3 |
| 378 | 2025-07-25 02:58:37 | subcategory | 1 | 49908 | 1 | 2.403 | 20769.0 |
| 377 | 2025-07-24 09:59:29 | subcategory | 1 | 49908 | 1 | 4.156 | 12008.7 |
| 376 | 2025-07-16 01:56:25 | subcategory | 1 | 49908 | 1 | 0.766 | 65154.0 |
| 375 | 2025-06-15 21:35:59 | subcategory | 3 | 121633 | 4 | 26.580 | 4576.1 |
| 374 | 2025-06-15 03:10:54 | subcategory | 1 | 49908 | 1 | 0.876 | 56972.6 |
| 373 | 2025-06-13 22:51:33 | subcategory | 4 | 148819 | 8 | 52.160 | 2853.1 |
| 372 | 2025-06-13 15:32:26 | subcategory | 1 | 49908 | 1 | 0.890 | 56076.4 |
| 371 | 2025-06-12 11:32:01 | subcategory | 4 | 148819 | 8 | 43.346 | 3433.3 |
| 370 | 2025-05-06 23:09:33 | subcategory | 4 | 148819 | 8 | 33.583 | 4431.4 |
| 369 | 2025-04-26 00:26:20 | subcategory | 4 | 148819 | 8 | 46.333 | 3211.9 |
| 368 | 2025-04-16 13:34:39 | subcategory | 1 | 49908 | 1 | 1.766 | 28260.5 |
| 367 | 2025-04-04 22:04:28 | subcategory | 4 | 148819 | 8 | 55.050 | 2703.3 |
| 366 | 2025-04-02 12:40:37 | subcategory | 4 | 148819 | 8 | 49.113 | 3030.1 |
| 365 | 2025-04-02 12:11:49 | subcategory | 4 | 148819 | 8 | 53.940 | 2759.0 |
| 364 | 2025-04-02 12:02:12 | subcategory | 3 | 121633 | 4 | 25.033 | 4858.9 |
| 363 | 2025-04-02 06:04:02 | subcategory | 1 | 49908 | 1 | 2.296 | 21736.9 |
| 362 | 2025-04-02 01:39:09 | subcategory | 1 | 49908 | 1 | 5.253 | 9500.9 |
| 361 | 2025-03-31 09:32:03 | subcategory | 5 | 164607 | 73 | 50.423 | 3264.5 |
| 360 | 2025-03-30 00:00:16 | subcategory | 5 | 164607 | 73 | 63.956 | 2573.8 |
| 359 | 2025-03-29 11:55:45 | subcategory | 5 | 164607 | 73 | 88.456 | 1860.9 |
| 358 | 2025-03-27 02:06:18 | subcategory | 4 | 148819 | 8 | 28.970 | 5137.0 |
| 357 | 2025-03-27 00:23:13 | subcategory | 3 | 121633 | 4 | 18.453 | 6591.5 |
| 356 | 2025-03-26 23:23:01 | subcategory | 5 | 164607 | 73 | 103.020 | 1597.8 |
| 355 | 2025-03-26 14:48:17 | subcategory | 1 | 49908 | 1 | 0.860 | 58032.6 |
| 354 | 2025-03-25 06:05:22 | subcategory | 5 | 164607 | 73 | 73.083 | 2252.3 |
| 353 | 2025-03-23 17:31:05 | subcategory | 5 | 164607 | 73 | 82.206 | 2002.4 |
| 352 | 2025-03-23 11:00:10 | subcategory | 6 | 173545 | 613 | 101.430 | 1711.0 |
| 351 | 2025-03-22 11:12:32 | subcategory | 3 | 121633 | 4 | 6.986 | 17411.0 |
| 350 | 2025-03-22 06:17:56 | subcategory | 2 | 86808 | 1 | 5.810 | 14941.1 |
| 349 | 2025-03-22 04:49:36 | subcategory | 1 | 49908 | 1 | 0.860 | 58032.6 |
| 348 | 2025-03-22 00:09:49 | subcategory | 5 | 164607 | 73 | 14.110 | 11666.0 |
| 347 | 2025-03-20 20:34:42 | subcategory | 4 | 148819 | 8 | 9.216 | 16147.9 |
| 346 | 2025-03-14 23:05:48 | subcategory | 4 | 148819 | 8 | 48.190 | 3088.2 |
| 345 | 2025-03-14 23:02:48 | subcategory | 2 | 86808 | 1 | 5.310 | 16348.0 |
| 344 | 2025-03-14 23:02:42 | subcategory | 1 | 49908 | 1 | 1.750 | 28518.9 |
| 343 | 2025-03-06 08:01:57 | subcategory | 4 | 148819 | 8 | 49.423 | 3011.1 |
| 342 | 2025-03-06 08:01:53 | subcategory | 3 | 121633 | 4 | 21.016 | 5787.6 |
| 341 | 2025-03-01 08:48:21 | subcategory | 1 | 49908 | 1 | 4.186 | 11922.6 |
| 340 | 2025-02-14 16:00:43 | subcategory | 4 | 148819 | 8 | 46.750 | 3183.3 |
| 339 | 2025-02-14 16:00:37 | subcategory | 3 | 121633 | 4 | 23.783 | 5114.3 |
| 338 | 2025-02-05 22:55:12 | subcategory | 1 | 49908 | 1 | 0.890 | 56076.4 |
| 337 | 2025-02-01 02:25:59 | subcategory | 3 | 121633 | 4 | 18.580 | 6546.4 |
| 336 | 2025-02-01 02:26:01 | subcategory | 2 | 86808 | 1 | 12.076 | 7188.5 |
| 335 | 2025-02-01 02:25:08 | subcategory | 4 | 148819 | 8 | 51.253 | 2903.6 |
| 334 | 2025-02-01 02:24:23 | subcategory | 1 | 49908 | 1 | 1.643 | 30376.1 |
| 333 | 2025-01-07 08:55:38 | subcategory | 4 | 148819 | 8 | 54.723 | 2719.5 |
| 332 | 2025-01-06 09:19:14 | subcategory | 4 | 148819 | 8 | 49.420 | 3011.3 |
| 331 | 2025-01-06 09:19:05 | subcategory | 4 | 148819 | 8 | 55.750 | 2669.4 |
| 330 | 2025-01-06 09:19:07 | subcategory | 3 | 121633 | 4 | 26.310 | 4623.1 |
| 329 | 2025-01-06 09:19:11 | subcategory | 2 | 86808 | 1 | 11.393 | 7619.4 |
| 328 | 2025-01-06 07:48:24 | subcategory | 1 | 49908 | 1 | 0.873 | 57168.4 |
| 327 | 2024-12-31 01:57:05 | subcategory | 1 | 49908 | 1 | 2.140 | 23321.5 |
| 326 | 2024-12-30 09:29:38 | subcategory | 4 | 148819 | 8 | 46.393 | 3207.8 |
| 325 | 2024-12-30 09:30:00 | subcategory | 2 | 86808 | 1 | 10.750 | 8075.2 |
| 324 | 2024-12-30 09:28:27 | subcategory | 1 | 49908 | 1 | 0.873 | 57168.4 |
| 323 | 2024-12-22 10:57:08 | subcategory | 3 | 121633 | 4 | 16.003 | 7600.6 |
| 322 | 2024-12-21 18:32:32 | subcategory | 2 | 86808 | 1 | 12.373 | 7015.9 |
| 321 | 2024-12-21 18:29:14 | subcategory | 1 | 49908 | 1 | 1.483 | 33653.4 |
| 320 | 2024-12-06 10:07:40 | subcategory | 4 | 148819 | 8 | 48.046 | 3097.4 |
| 319 | 2024-12-06 10:07:39 | subcategory | 3 | 121633 | 4 | 14.016 | 8678.2 |
| 318 | 2024-11-17 09:04:52 | subcategory | 4 | 148819 | 8 | 43.586 | 3414.4 |
| 317 | 2024-11-17 09:04:44 | subcategory | 3 | 121633 | 4 | 24.723 | 4919.8 |
| 316 | 2024-11-15 16:47:59 | subcategory | 3 | 121633 | 4 | 20.440 | 5950.7 |
| 315 | 2024-11-15 16:48:02 | subcategory | 2 | 86808 | 1 | 12.296 | 7059.9 |
| 314 | 2024-11-15 16:47:39 | subcategory | 3 | 121633 | 4 | 23.110 | 5263.2 |
| 313 | 2024-11-15 16:47:48 | subcategory | 3 | 121633 | 4 | 13.016 | 9344.9 |
| 312 | 2024-11-15 16:43:44 | subcategory | 1 | 49908 | 1 | 0.843 | 59202.8 |
| 311 | 2024-11-01 19:44:23 | subcategory | 4 | 148819 | 8 | 57.066 | 2607.8 |
| 310 | 2024-11-01 19:44:23 | subcategory | 3 | 121633 | 4 | 37.063 | 3281.8 |
| 309 | 2024-11-01 19:44:31 | subcategory | 2 | 86808 | 1 | 11.830 | 7338.0 |
| 308 | 2024-11-01 19:43:36 | subcategory | 4 | 148819 | 8 | 63.863 | 2330.3 |
| 307 | 2024-11-01 19:41:48 | subcategory | 1 | 49908 | 1 | 1.486 | 33585.5 |
| 306 | 2024-10-22 17:22:59 | subcategory | 1 | 49908 | 1 | 5.360 | 9311.2 |
| 305 | 2024-10-22 17:10:46 | subcategory | 1 | 49908 | 1 | 3.796 | 13147.5 |
| 304 | 2024-10-22 17:03:55 | subcategory | 4 | 148819 | 8 | 31.986 | 4652.6 |
| 303 | 2024-10-22 17:02:15 | subcategory | 3 | 121633 | 4 | 25.626 | 4746.5 |
| 302 | 2024-10-22 16:55:43 | subcategory | 1 | 49908 | 1 | 6.033 | 8272.5 |
| 301 | 2024-10-21 04:35:01 | subcategory | 4 | 148819 | 8 | 62.550 | 2379.2 |
| 300 | 2024-10-21 04:35:04 | subcategory | 3 | 121633 | 4 | 27.423 | 4435.4 |
| 299 | 2024-10-21 04:35:04 | subcategory | 2 | 86808 | 1 | 11.860 | 7319.4 |
| 298 | 2024-10-21 04:34:24 | subcategory | 1 | 49908 | 1 | 2.000 | 24954.0 |
| 297 | 2024-10-07 21:47:59 | subcategory | 1 | 49908 | 1 | 9.576 | 5211.8 |
| 296 | 2024-09-22 20:45:26 | subcategory | 1 | 49908 | 1 | 9.453 | 5279.6 |
| 295 | 2024-09-20 12:41:38 | subcategory | 1 | 49908 | 1 | 4.233 | 11790.2 |
| 294 | 2024-09-16 23:55:59 | subcategory | 1 | 49908 | 1 | 12.423 | 4017.4 |
| 293 | 2024-09-06 18:20:17 | subcategory | 1 | 49908 | 1 | 6.596 | 7566.4 |
| 292 | 2024-08-21 06:55:33 | subcategory | 1 | 49908 | 1 | 3.220 | 15499.4 |
| 291 | 2024-08-18 15:14:13 | subcategory | 4 | 148819 | 8 | 61.290 | 2428.1 |
| 290 | 2024-08-18 15:14:00 | subcategory | 3 | 121633 | 4 | 19.190 | 6338.4 |
| 289 | 2024-08-03 13:50:15 | subcategory | 4 | 148819 | 8 | 50.470 | 2948.7 |
| 288 | 2024-08-03 13:50:32 | subcategory | 2 | 86808 | 1 | 9.593 | 9049.1 |
| 287 | 2024-08-03 13:50:11 | subcategory | 4 | 148819 | 8 | 17.203 | 8650.8 |
| 286 | 2024-08-03 13:47:55 | subcategory | 1 | 49908 | 1 | 2.516 | 19836.2 |
| 285 | 2024-07-28 19:57:25 | subcategory | 4 | 148819 | 8 | 41.536 | 3582.9 |
| 284 | 2024-07-28 19:57:21 | subcategory | 3 | 121633 | 4 | 9.610 | 12656.9 |
| 283 | 2024-07-27 19:35:15 | subcategory | 4 | 148819 | 8 | 51.456 | 2892.2 |
| 282 | 2024-07-27 19:35:13 | subcategory | 4 | 148819 | 8 | 43.596 | 3413.6 |
| 281 | 2024-07-27 19:35:27 | subcategory | 3 | 121633 | 4 | 16.266 | 7477.7 |
| 280 | 2024-07-27 19:35:15 | subcategory | 4 | 148819 | 8 | 25.126 | 5922.9 |