History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"personnel"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 333 | 2026-01-02 13:25:12 | personnel | 1 | 81242 | 2 | 3.640 | 22319.2 |
| 332 | 2026-01-02 13:22:34 | personnel | 1 | 81242 | 2 | 1.470 | 55266.7 |
| 331 | 2025-12-01 19:39:32 | personnel | 1 | 81242 | 2 | 1.470 | 55266.7 |
| 330 | 2025-11-30 02:24:45 | personnel | 1 | 81242 | 2 | 1.466 | 55417.5 |
| 329 | 2025-11-28 12:53:31 | personnel | 1 | 81242 | 2 | 1.453 | 55913.3 |
| 328 | 2025-11-15 20:07:03 | personnel | 1 | 81242 | 2 | 1.513 | 53696.0 |
| 327 | 2025-11-15 16:23:11 | personnel | 1 | 81242 | 2 | 1.356 | 59913.0 |
| 326 | 2025-11-13 15:43:43 | personnel | 1 | 81242 | 2 | 1.486 | 54671.6 |
| 325 | 2025-11-06 19:18:01 | personnel | 1 | 81242 | 2 | 1.530 | 53099.3 |
| 324 | 2025-11-02 06:18:56 | personnel | 3 | 148641 | 22 | 6.580 | 22589.8 |
| 323 | 2025-11-02 05:17:49 | personnel | 1 | 81242 | 2 | 1.373 | 59171.2 |
| 322 | 2025-10-29 00:37:15 | personnel | 1 | 81242 | 2 | 1.390 | 58447.5 |
| 321 | 2025-10-27 09:43:35 | personnel | 1 | 81242 | 2 | 1.563 | 51978.2 |
| 320 | 2025-10-16 20:32:52 | personnel | 1 | 81242 | 2 | 1.813 | 44810.8 |
| 319 | 2025-10-16 03:55:34 | personnel | 1 | 81242 | 2 | 1.436 | 56575.2 |
| 318 | 2025-10-13 14:43:30 | personnel | 1 | 81242 | 2 | 1.623 | 50056.7 |
| 317 | 2025-10-07 23:02:42 | personnel | 1 | 81242 | 2 | 1.626 | 49964.3 |
| 316 | 2025-10-06 15:34:18 | personnel | 1 | 81242 | 2 | 1.373 | 59171.2 |
| 315 | 2025-09-25 23:04:01 | personnel | 1 | 81242 | 2 | 5.576 | 14569.9 |
| 314 | 2025-09-25 23:03:57 | personnel | 1 | 81242 | 2 | 6.546 | 12410.9 |
| 313 | 2025-09-25 23:03:49 | personnel | 1 | 81242 | 2 | 6.716 | 12096.8 |
| 312 | 2025-09-25 23:03:42 | personnel | 1 | 81242 | 2 | 4.923 | 16502.5 |
| 311 | 2025-09-24 13:53:51 | personnel | 1 | 81242 | 2 | 1.313 | 61875.1 |
| 310 | 2025-09-24 09:50:33 | personnel | 1 | 81242 | 2 | 1.296 | 62686.7 |
| 309 | 2025-09-17 23:32:59 | personnel | 3 | 148641 | 22 | 7.656 | 19415.0 |
| 308 | 2025-09-12 03:50:53 | personnel | 1 | 81242 | 2 | 1.500 | 54161.3 |
| 307 | 2025-09-11 14:59:48 | personnel | 1 | 81242 | 2 | 1.686 | 48186.2 |
| 306 | 2025-09-10 12:54:08 | personnel | 1 | 81242 | 2 | 1.436 | 56575.2 |
| 305 | 2025-09-09 16:01:46 | personnel | 1 | 81242 | 2 | 1.360 | 59736.8 |
| 304 | 2025-08-28 02:26:04 | personnel | 1 | 81242 | 2 | 1.516 | 53589.7 |
| 303 | 2025-08-19 13:18:14 | personnel | 1 | 81242 | 2 | 3.063 | 26523.7 |
| 302 | 2025-08-06 03:21:18 | personnel | 1 | 81242 | 2 | 6.936 | 11713.1 |
| 301 | 2025-08-05 10:52:17 | personnel | 1 | 81242 | 2 | 3.033 | 26786.0 |
| 300 | 2025-08-03 02:37:57 | personnel | 3 | 148641 | 22 | 26.346 | 5641.9 |
| 299 | 2025-08-02 22:46:06 | personnel | 3 | 148641 | 22 | 34.580 | 4298.5 |
| 298 | 2025-08-02 22:42:24 | personnel | 2 | 121436 | 4 | 9.373 | 12955.9 |
| 297 | 2025-08-01 12:41:23 | personnel | 1 | 81242 | 2 | 3.170 | 25628.4 |
| 296 | 2025-07-31 04:34:13 | personnel | 1 | 81242 | 2 | 1.516 | 53589.7 |
| 295 | 2025-07-25 02:07:48 | personnel | 3 | 148641 | 22 | 38.380 | 3872.9 |
| 294 | 2025-07-24 20:59:01 | personnel | 1 | 81242 | 2 | 3.673 | 22118.7 |
| 293 | 2025-07-21 13:06:42 | personnel | 1 | 81242 | 2 | 1.406 | 57782.4 |
| 292 | 2025-07-19 12:35:42 | personnel | 3 | 148641 | 22 | 7.326 | 20289.5 |
| 291 | 2025-07-18 23:26:42 | personnel | 1 | 81242 | 2 | 1.436 | 56575.2 |
| 290 | 2025-07-09 08:58:26 | personnel | 1 | 81242 | 2 | 2.940 | 27633.3 |
| 289 | 2025-07-08 16:28:47 | personnel | 1 | 81242 | 2 | 8.486 | 9573.7 |
| 288 | 2025-07-08 02:09:36 | personnel | 1 | 81242 | 2 | 7.013 | 11584.5 |
| 287 | 2025-07-02 03:08:54 | personnel | 1 | 81242 | 2 | 4.453 | 18244.3 |
| 286 | 2025-06-30 12:10:04 | personnel | 1 | 81242 | 2 | 4.203 | 19329.5 |
| 285 | 2025-06-16 16:40:22 | personnel | 1 | 81242 | 2 | 6.610 | 12290.8 |
| 284 | 2025-06-16 14:59:24 | personnel | 1 | 81242 | 2 | 8.393 | 9679.7 |
| 283 | 2025-06-07 03:23:32 | personnel | 3 | 148641 | 22 | 34.600 | 4296.0 |
| 282 | 2025-06-07 02:45:47 | personnel | 3 | 148641 | 22 | 29.843 | 4980.8 |
| 281 | 2025-06-07 02:41:55 | personnel | 2 | 121436 | 4 | 9.126 | 13306.6 |
| 280 | 2025-06-05 22:06:25 | personnel | 3 | 148641 | 22 | 41.253 | 3603.2 |
| 279 | 2025-06-05 20:53:13 | personnel | 1 | 81242 | 2 | 1.436 | 56575.2 |
| 278 | 2025-05-23 19:35:19 | personnel | 1 | 81242 | 2 | 5.736 | 14163.5 |
| 277 | 2025-05-04 17:09:00 | personnel | 1 | 81242 | 2 | 7.483 | 10856.9 |
| 276 | 2025-05-03 02:41:18 | personnel | 1 | 81242 | 2 | 6.220 | 13061.4 |
| 275 | 2025-05-01 16:07:27 | personnel | 1 | 81242 | 2 | 1.360 | 59736.8 |
| 274 | 2025-04-23 17:48:05 | personnel | 3 | 148641 | 22 | 9.330 | 15931.5 |
| 273 | 2025-04-23 12:23:33 | personnel | 3 | 148641 | 22 | 23.533 | 6316.3 |
| 272 | 2025-04-23 06:10:59 | personnel | 2 | 121436 | 4 | 23.393 | 5191.1 |
| 271 | 2025-04-23 05:59:19 | personnel | 3 | 148641 | 22 | 33.893 | 4385.6 |
| 270 | 2025-04-22 13:03:34 | personnel | 1 | 81242 | 2 | 2.780 | 29223.7 |
| 269 | 2025-04-08 20:21:51 | personnel | 2 | 121436 | 4 | 28.096 | 4322.2 |
| 268 | 2025-04-02 02:42:49 | personnel | 1 | 81242 | 2 | 3.470 | 23412.7 |
| 267 | 2025-03-15 20:07:12 | personnel | 1 | 81242 | 2 | 7.173 | 11326.1 |
| 266 | 2025-03-15 03:01:12 | personnel | 3 | 148641 | 22 | 40.986 | 3626.6 |
| 265 | 2025-03-15 03:01:11 | personnel | 3 | 148641 | 22 | 35.470 | 4190.6 |
| 264 | 2025-03-15 03:01:12 | personnel | 2 | 121436 | 4 | 17.550 | 6919.4 |
| 263 | 2025-03-11 10:28:23 | personnel | 1 | 81242 | 2 | 4.030 | 20159.3 |
| 262 | 2025-03-11 06:37:38 | personnel | 1 | 81242 | 2 | 7.970 | 10193.5 |
| 261 | 2025-02-21 16:33:26 | personnel | 3 | 148641 | 22 | 36.906 | 4027.6 |
| 260 | 2025-02-21 16:33:26 | personnel | 3 | 148641 | 22 | 35.786 | 4153.6 |
| 259 | 2025-02-21 16:33:26 | personnel | 2 | 121436 | 4 | 27.046 | 4490.0 |
| 258 | 2025-02-12 11:37:01 | personnel | 1 | 81242 | 2 | 7.203 | 11278.9 |
| 257 | 2025-02-09 07:55:38 | personnel | 1 | 81242 | 2 | 3.016 | 26937.0 |
| 256 | 2025-02-04 20:06:32 | personnel | 1 | 81242 | 2 | 12.220 | 6648.3 |
| 255 | 2025-01-15 02:41:07 | personnel | 1 | 81242 | 2 | 10.313 | 7877.6 |
| 254 | 2025-01-12 23:20:53 | personnel | 3 | 148641 | 22 | 41.416 | 3589.0 |
| 253 | 2025-01-12 23:20:45 | personnel | 3 | 148641 | 22 | 33.553 | 4430.0 |
| 252 | 2025-01-12 23:20:47 | personnel | 2 | 121436 | 4 | 19.176 | 6332.7 |
| 251 | 2025-01-12 23:19:19 | personnel | 1 | 81242 | 2 | 1.626 | 49964.3 |
| 250 | 2025-01-08 21:27:00 | personnel | 3 | 148641 | 22 | 47.190 | 3149.8 |
| 249 | 2025-01-08 21:27:00 | personnel | 2 | 121436 | 4 | 15.263 | 7956.2 |
| 248 | 2025-01-08 21:26:05 | personnel | 1 | 81242 | 2 | 7.106 | 11432.9 |
| 247 | 2024-12-13 19:21:15 | personnel | 3 | 148641 | 22 | 39.893 | 3726.0 |
| 246 | 2024-12-13 19:21:20 | personnel | 2 | 121436 | 4 | 19.986 | 6076.1 |
| 245 | 2024-12-13 19:20:31 | personnel | 1 | 81242 | 2 | 3.016 | 26937.0 |
| 244 | 2024-11-28 09:46:45 | personnel | 1 | 81242 | 2 | 8.720 | 9316.7 |
| 243 | 2024-11-16 00:21:55 | personnel | 1 | 81242 | 2 | 7.203 | 11278.9 |
| 242 | 2024-11-03 23:22:00 | personnel | 1 | 81242 | 2 | 1.406 | 57782.4 |
| 241 | 2024-10-15 08:20:54 | personnel | 2 | 121436 | 4 | 17.690 | 6864.7 |
| 240 | 2024-10-15 08:18:22 | personnel | 1 | 81242 | 2 | 7.250 | 11205.8 |
| 239 | 2024-10-06 03:26:48 | personnel | 2 | 121436 | 4 | 42.973 | 2825.9 |
| 238 | 2024-10-06 03:26:48 | personnel | 2 | 121436 | 4 | 39.300 | 3090.0 |
| 237 | 2024-10-06 03:26:55 | personnel | 2 | 121436 | 4 | 28.610 | 4244.5 |
| 236 | 2024-10-06 03:24:23 | personnel | 1 | 81242 | 2 | 7.936 | 10237.1 |
| 235 | 2024-09-12 17:47:17 | personnel | 1 | 81242 | 2 | 12.110 | 6708.7 |
| 234 | 2024-09-11 10:59:41 | personnel | 1 | 81242 | 2 | 13.750 | 5908.5 |