History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"trainee"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 373 | 2024-04-27 10:19:36 | trainee | 1 | 69583 | 4 | 1.733 | 40151.8 |
| 372 | 2024-03-31 11:50:47 | trainee | 3 | 134027 | 345 | 18.110 | 7400.7 |
| 371 | 2024-03-31 10:04:15 | trainee | 3 | 134027 | 345 | 21.486 | 6237.9 |
| 370 | 2024-03-31 09:47:42 | trainee | 3 | 134027 | 345 | 12.753 | 10509.4 |
| 369 | 2024-03-31 08:50:00 | trainee | 3 | 134027 | 345 | 7.423 | 18055.6 |
| 368 | 2024-02-06 14:54:03 | trainee | 1 | 69583 | 4 | 1.060 | 65644.3 |
| 367 | 2024-01-13 20:39:32 | trainee | 2 | 107671 | 28 | 3.436 | 31336.1 |
| 366 | 2024-01-10 22:10:23 | trainee | 3 | 134027 | 345 | 6.890 | 19452.4 |
| 365 | 2023-12-30 01:46:27 | trainee | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 364 | 2023-12-24 23:58:38 | trainee | 1 | 69583 | 4 | 1.076 | 64668.2 |
| 363 | 2023-12-11 03:40:06 | trainee | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 362 | 2023-12-03 15:29:42 | trainee | 1 | 69583 | 4 | 1.126 | 61796.6 |
| 361 | 2023-12-03 15:29:40 | trainee | 1 | 69583 | 4 | 1.156 | 60192.9 |
| 360 | 2023-12-02 04:31:41 | trainee | 1 | 69583 | 4 | 1.190 | 58473.1 |
| 359 | 2023-12-01 12:49:00 | trainee | 3 | 134027 | 345 | 6.143 | 21817.8 |
| 358 | 2023-11-28 03:04:40 | trainee | 1 | 69583 | 4 | 1.156 | 60192.9 |
| 357 | 2023-11-20 05:20:14 | trainee | 3 | 134027 | 345 | 6.533 | 20515.4 |
| 356 | 2023-11-16 22:55:39 | trainee | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 355 | 2023-11-13 11:15:28 | trainee | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 354 | 2023-11-06 19:50:28 | trainee | 1 | 69583 | 4 | 2.343 | 29698.3 |
| 353 | 2023-10-14 06:12:13 | trainee | 1 | 69583 | 4 | 1.080 | 64428.7 |
| 352 | 2023-10-01 03:20:15 | trainee | 1 | 69583 | 4 | 1.060 | 65644.3 |
| 351 | 2023-09-24 17:10:25 | trainee | 1 | 69583 | 4 | 2.250 | 30925.8 |
| 350 | 2023-09-13 10:48:38 | trainee | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 349 | 2023-09-04 05:57:22 | trainee | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 348 | 2023-08-30 02:21:18 | trainee | 3 | 134027 | 345 | 7.420 | 18062.9 |
| 347 | 2023-07-11 16:07:59 | trainee | 3 | 134027 | 345 | 5.826 | 23005.0 |
| 346 | 2023-06-28 12:17:37 | trainee | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 345 | 2023-06-10 22:00:34 | trainee | 3 | 134027 | 345 | 6.656 | 20136.3 |
| 344 | 2023-05-21 05:40:39 | trainee | 3 | 134027 | 345 | 5.983 | 22401.3 |
| 343 | 2023-05-15 10:47:52 | trainee | 3 | 134027 | 345 | 6.063 | 22105.7 |
| 342 | 2023-05-08 00:32:45 | trainee | 1 | 69583 | 4 | 1.190 | 58473.1 |
| 341 | 2023-04-05 03:30:54 | trainee | 1 | 69583 | 4 | 1.216 | 57222.9 |
| 340 | 2023-02-28 20:56:47 | trainee | 3 | 134027 | 345 | 6.236 | 21492.5 |
| 339 | 2023-02-25 09:19:17 | trainee | 3 | 134027 | 345 | 9.343 | 14345.2 |
| 338 | 2023-02-06 07:01:49 | trainee | 1 | 69583 | 4 | 1.153 | 60349.5 |
| 337 | 2023-01-18 16:22:27 | trainee | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 336 | 2023-01-08 15:54:12 | trainee | 3 | 134027 | 345 | 5.903 | 22704.9 |
| 335 | 2023-01-07 01:11:26 | trainee | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 334 | 2023-01-05 14:36:47 | trainee | 3 | 134027 | 345 | 5.826 | 23005.0 |
| 333 | 2022-12-20 21:22:47 | trainee | 1 | 69583 | 4 | 1.126 | 61796.6 |
| 332 | 2022-12-14 00:37:58 | trainee | 1 | 69583 | 4 | 1.190 | 58473.1 |
| 331 | 2022-12-12 10:54:10 | trainee | 3 | 134027 | 345 | 6.080 | 22043.9 |
| 330 | 2022-12-07 19:05:26 | trainee | 3 | 134027 | 345 | 5.766 | 23244.4 |
| 329 | 2022-11-24 14:26:44 | trainee | 3 | 134027 | 345 | 6.830 | 19623.3 |
| 328 | 2022-11-15 00:56:56 | trainee | 1 | 69583 | 4 | 1.173 | 59320.5 |
| 327 | 2022-11-08 07:20:57 | trainee | 3 | 134027 | 345 | 12.656 | 10590.0 |
| 326 | 2022-11-06 07:09:09 | trainee | 1 | 69583 | 4 | 1.190 | 58473.1 |
| 325 | 2022-10-30 13:23:17 | trainee | 3 | 134027 | 345 | 6.343 | 21129.9 |
| 324 | 2022-09-16 22:11:02 | trainee | 3 | 134027 | 345 | 6.046 | 22167.9 |
| 323 | 2022-09-05 09:21:42 | trainee | 1 | 69583 | 4 | 1.080 | 64428.7 |
| 322 | 2022-08-23 15:46:07 | trainee | 3 | 134027 | 345 | 6.313 | 21230.3 |
| 321 | 2022-08-22 17:58:45 | trainee | 3 | 134027 | 345 | 6.483 | 20673.6 |
| 320 | 2022-07-29 19:08:44 | trainee | 3 | 134027 | 345 | 5.906 | 22693.4 |
| 319 | 2022-07-20 19:14:33 | trainee | 3 | 134027 | 345 | 6.093 | 21996.9 |
| 318 | 2022-07-06 19:54:41 | trainee | 1 | 69583 | 4 | 1.060 | 65644.3 |
| 317 | 2022-04-25 20:47:19 | trainee | 1 | 69583 | 4 | 1.300 | 53525.4 |
| 316 | 2022-03-09 10:53:01 | trainee | 1 | 69583 | 4 | 1.343 | 51811.6 |
| 315 | 2022-01-02 21:08:39 | trainee | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 314 | 2021-12-30 15:52:42 | trainee | 1 | 69583 | 4 | 1.216 | 57222.9 |
| 313 | 2021-12-21 22:33:42 | trainee | 1 | 69583 | 4 | 1.140 | 61037.7 |
| 312 | 2021-12-16 10:42:03 | trainee | 1 | 69583 | 4 | 1.190 | 58473.1 |
| 311 | 2021-10-26 20:55:35 | trainee | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 310 | 2021-09-27 20:11:04 | trainee | 1 | 69583 | 4 | 1.236 | 56296.9 |
| 309 | 2021-09-13 23:02:59 | trainee | 1 | 69583 | 4 | 1.140 | 61037.7 |
| 308 | 2021-09-10 18:08:27 | trainee | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 307 | 2021-07-03 07:49:14 | trainee | 3 | 134027 | 345 | 6.313 | 21230.3 |
| 306 | 2021-06-06 14:31:02 | trainee | 1 | 69583 | 4 | 1.190 | 58473.1 |
| 305 | 2021-06-03 10:09:11 | trainee | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 304 | 2021-05-30 13:21:28 | trainee | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 303 | 2021-05-05 05:47:31 | trainee | 1 | 69583 | 4 | 1.170 | 59472.6 |
| 302 | 2021-04-03 09:18:29 | trainee | 1 | 69583 | 4 | 1.233 | 56433.9 |
| 301 | 2021-03-30 00:11:59 | trainee | 3 | 134027 | 345 | 9.470 | 14152.8 |
| 300 | 2021-03-17 07:22:46 | trainee | 3 | 134027 | 345 | 6.126 | 21878.4 |
| 299 | 2021-03-03 21:31:42 | trainee | 3 | 134027 | 345 | 10.890 | 12307.3 |
| 298 | 2021-02-28 23:22:37 | trainee | 1 | 69583 | 4 | 1.076 | 64668.2 |
| 297 | 2021-02-01 07:19:10 | trainee | 1 | 69583 | 4 | 1.343 | 51811.6 |
| 296 | 2021-01-18 06:28:57 | trainee | 1 | 69583 | 4 | 1.080 | 64428.7 |
| 295 | 2020-12-19 08:29:04 | trainee | 1 | 69583 | 4 | 1.190 | 58473.1 |
| 294 | 2020-12-14 02:32:05 | trainee | 3 | 134027 | 345 | 5.940 | 22563.5 |
| 293 | 2020-11-24 13:00:24 | trainee | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 292 | 2020-11-23 12:24:52 | trainee | 3 | 134027 | 345 | 5.890 | 22755.0 |
| 291 | 2020-11-19 20:06:50 | trainee | 3 | 134027 | 345 | 6.393 | 20964.6 |
| 290 | 2020-11-17 06:20:56 | trainee | 3 | 134027 | 345 | 6.626 | 20227.4 |
| 289 | 2020-10-29 17:03:47 | trainee | 1 | 69583 | 4 | 1.123 | 61961.7 |
| 288 | 2020-10-18 08:47:17 | trainee | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 287 | 2020-10-17 13:13:02 | trainee | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 286 | 2020-09-27 20:26:01 | trainee | 1 | 69583 | 4 | 1.080 | 64428.7 |
| 285 | 2020-08-10 08:46:26 | trainee | 1 | 69583 | 4 | 1.106 | 62914.1 |
| 284 | 2020-07-13 15:19:24 | trainee | 1 | 69583 | 4 | 1.156 | 60192.9 |
| 283 | 2020-05-09 03:06:03 | trainee | 1 | 69583 | 4 | 1.076 | 64668.2 |
| 282 | 2020-04-19 14:17:54 | trainee | 3 | 134027 | 345 | 5.890 | 22755.0 |
| 281 | 2020-04-12 08:28:26 | trainee | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 280 | 2020-03-29 20:58:08 | trainee | 1 | 69583 | 4 | 1.873 | 37150.6 |
| 279 | 2020-03-24 20:42:23 | trainee | 1 | 69583 | 4 | 1.233 | 56433.9 |
| 278 | 2020-03-22 11:01:44 | trainee | 1 | 69583 | 4 | 1.236 | 56296.9 |
| 277 | 2020-03-21 04:50:14 | trainee | 1 | 69583 | 4 | 1.296 | 53690.6 |
| 276 | 2020-02-29 07:48:25 | trainee | 1 | 69583 | 4 | 1.313 | 52995.4 |
| 275 | 2020-02-29 06:33:31 | trainee | 1 | 69583 | 4 | 2.640 | 26357.2 |
| 274 | 2020-02-27 16:13:59 | trainee | 3 | 134027 | 345 | 9.436 | 14203.8 |