History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"colleague"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 312 | 2025-11-01 07:25:11 | colleague | 1 | 81242 | 2 | 1.420 | 57212.7 |
| 311 | 2025-10-23 21:32:42 | colleague | 1 | 81242 | 2 | 1.326 | 61268.5 |
| 310 | 2025-09-28 13:06:08 | colleague | 1 | 81242 | 2 | 1.310 | 62016.8 |
| 309 | 2025-09-17 01:36:43 | colleague | 4 | 165329 | 145 | 13.813 | 11969.1 |
| 308 | 2025-09-09 00:44:03 | colleague | 1 | 81242 | 2 | 1.326 | 61268.5 |
| 307 | 2025-08-25 13:34:19 | colleague | 1 | 81242 | 2 | 5.080 | 15992.5 |
| 306 | 2025-08-19 01:22:11 | colleague | 4 | 165329 | 145 | 34.330 | 4815.9 |
| 305 | 2025-08-13 23:06:43 | colleague | 1 | 81242 | 2 | 1.486 | 54671.6 |
| 304 | 2025-08-09 04:27:48 | colleague | 1 | 81242 | 2 | 6.703 | 12120.2 |
| 303 | 2025-08-05 13:14:23 | colleague | 3 | 148641 | 20 | 22.843 | 6507.1 |
| 302 | 2025-08-01 06:01:53 | colleague | 3 | 148641 | 20 | 43.846 | 3390.1 |
| 301 | 2025-08-01 01:16:57 | colleague | 4 | 165329 | 145 | 61.723 | 2678.6 |
| 300 | 2025-07-31 04:58:30 | colleague | 1 | 81242 | 2 | 1.436 | 56575.2 |
| 299 | 2025-07-25 09:45:28 | colleague | 1 | 81242 | 2 | 3.360 | 24179.2 |
| 298 | 2025-07-25 08:18:23 | colleague | 3 | 148641 | 20 | 27.673 | 5371.3 |
| 297 | 2025-07-22 05:10:53 | colleague | 3 | 148641 | 20 | 7.030 | 21143.8 |
| 296 | 2025-07-14 23:17:43 | colleague | 4 | 165329 | 145 | 82.036 | 2015.3 |
| 295 | 2025-07-11 23:35:54 | colleague | 4 | 165329 | 145 | 66.723 | 2477.8 |
| 294 | 2025-07-09 20:24:14 | colleague | 2 | 121436 | 6 | 12.720 | 9546.9 |
| 293 | 2025-07-08 07:10:18 | colleague | 1 | 81242 | 2 | 10.470 | 7759.5 |
| 292 | 2025-06-29 17:47:41 | colleague | 1 | 81242 | 2 | 1.296 | 62686.7 |
| 291 | 2025-06-26 02:56:40 | colleague | 1 | 81242 | 2 | 6.843 | 11872.3 |
| 290 | 2025-06-18 04:19:12 | colleague | 1 | 81242 | 2 | 6.936 | 11713.1 |
| 289 | 2025-06-14 04:42:02 | colleague | 1 | 81242 | 2 | 3.280 | 24768.9 |
| 288 | 2025-05-22 14:03:35 | colleague | 2 | 121436 | 6 | 17.596 | 6901.3 |
| 287 | 2025-05-22 02:56:01 | colleague | 1 | 81242 | 2 | 4.296 | 18911.1 |
| 286 | 2025-05-08 20:13:29 | colleague | 1 | 81242 | 2 | 8.953 | 9074.3 |
| 285 | 2025-05-06 01:02:36 | colleague | 4 | 165329 | 145 | 48.906 | 3380.5 |
| 284 | 2025-05-02 05:15:48 | colleague | 3 | 148641 | 20 | 27.250 | 5454.7 |
| 283 | 2025-05-02 01:20:59 | colleague | 4 | 165329 | 145 | 72.643 | 2275.9 |
| 282 | 2025-05-02 00:38:13 | colleague | 2 | 121436 | 6 | 25.203 | 4818.3 |
| 281 | 2025-05-01 09:47:20 | colleague | 1 | 81242 | 2 | 1.486 | 54671.6 |
| 280 | 2025-04-19 13:39:26 | colleague | 1 | 81242 | 2 | 1.533 | 52995.4 |
| 279 | 2025-04-18 02:38:35 | colleague | 1 | 81242 | 2 | 5.310 | 15299.8 |
| 278 | 2025-03-27 09:13:14 | colleague | 3 | 148641 | 20 | 20.470 | 7261.4 |
| 277 | 2025-03-26 02:20:15 | colleague | 1 | 81242 | 2 | 2.330 | 34867.8 |
| 276 | 2025-03-13 09:29:32 | colleague | 1 | 81242 | 2 | 6.673 | 12174.7 |
| 275 | 2025-03-12 16:51:04 | colleague | 3 | 148641 | 20 | 34.376 | 4324.0 |
| 274 | 2025-03-01 06:21:51 | colleague | 3 | 148641 | 20 | 36.703 | 4049.8 |
| 273 | 2025-03-01 06:21:47 | colleague | 2 | 121436 | 6 | 17.930 | 6772.8 |
| 272 | 2025-02-28 20:57:30 | colleague | 3 | 148641 | 20 | 46.706 | 3182.5 |
| 271 | 2025-02-28 15:13:50 | colleague | 1 | 81242 | 2 | 9.610 | 8453.9 |
| 270 | 2025-02-26 15:57:01 | colleague | 3 | 148641 | 20 | 39.990 | 3717.0 |
| 269 | 2025-02-26 15:55:33 | colleague | 2 | 121436 | 6 | 4.030 | 30133.0 |
| 268 | 2025-02-25 11:39:18 | colleague | 1 | 81242 | 2 | 1.360 | 59736.8 |
| 267 | 2025-02-10 02:14:00 | colleague | 1 | 81242 | 2 | 4.940 | 16445.7 |
| 266 | 2025-02-06 14:35:30 | colleague | 1 | 81242 | 2 | 7.410 | 10963.8 |
| 265 | 2025-02-04 04:12:24 | colleague | 2 | 121436 | 6 | 17.423 | 6969.9 |
| 264 | 2025-01-29 10:32:30 | colleague | 4 | 165329 | 145 | 68.300 | 2420.6 |
| 263 | 2025-01-29 09:42:32 | colleague | 4 | 165329 | 145 | 58.550 | 2823.7 |
| 262 | 2025-01-29 01:46:20 | colleague | 4 | 165329 | 145 | 64.346 | 2569.4 |
| 261 | 2025-01-29 01:46:20 | colleague | 2 | 121436 | 6 | 26.283 | 4620.3 |
| 260 | 2025-01-29 01:45:22 | colleague | 1 | 81242 | 2 | 7.110 | 11426.4 |
| 259 | 2025-01-23 22:56:20 | colleague | 3 | 148641 | 20 | 19.236 | 7727.2 |
| 258 | 2025-01-21 21:21:58 | colleague | 3 | 148641 | 20 | 37.596 | 3953.6 |
| 257 | 2025-01-12 22:27:06 | colleague | 3 | 148641 | 20 | 28.453 | 5224.1 |
| 256 | 2025-01-12 22:27:18 | colleague | 2 | 121436 | 6 | 12.330 | 9848.8 |
| 255 | 2025-01-12 22:26:17 | colleague | 3 | 148641 | 20 | 39.736 | 3740.7 |
| 254 | 2025-01-12 22:26:05 | colleague | 1 | 81242 | 2 | 10.453 | 7772.1 |
| 253 | 2024-12-22 20:54:35 | colleague | 3 | 148641 | 20 | 34.126 | 4355.7 |
| 252 | 2024-12-20 00:28:02 | colleague | 2 | 121436 | 6 | 25.436 | 4774.2 |
| 251 | 2024-12-20 00:27:36 | colleague | 3 | 148641 | 20 | 49.050 | 3030.4 |
| 250 | 2024-12-20 00:27:35 | colleague | 3 | 148641 | 20 | 42.580 | 3490.9 |
| 249 | 2024-12-19 23:11:16 | colleague | 1 | 81242 | 2 | 1.313 | 61875.1 |
| 248 | 2024-12-10 21:50:48 | colleague | 2 | 121436 | 6 | 9.330 | 13015.6 |
| 247 | 2024-12-10 17:56:49 | colleague | 1 | 81242 | 2 | 2.673 | 30393.6 |
| 246 | 2024-12-10 04:01:38 | colleague | 1 | 81242 | 2 | 1.500 | 54161.3 |
| 245 | 2024-12-02 08:21:16 | colleague | 1 | 81242 | 2 | 4.186 | 19408.0 |
| 244 | 2024-11-19 10:18:24 | colleague | 3 | 148641 | 20 | 39.580 | 3755.5 |
| 243 | 2024-11-14 20:04:16 | colleague | 3 | 148641 | 20 | 46.200 | 3217.3 |
| 241 | 2024-11-14 20:04:16 | colleague | 3 | 148641 | 20 | 45.826 | 3243.6 |
| 240 | 2024-11-12 12:09:42 | colleague | 3 | 148641 | 20 | 40.066 | 3709.9 |
| 239 | 2024-11-12 12:09:37 | colleague | 3 | 148641 | 20 | 40.516 | 3668.7 |
| 238 | 2024-11-12 12:03:41 | colleague | 2 | 121436 | 6 | 9.406 | 12910.5 |
| 237 | 2024-11-12 04:48:25 | colleague | 1 | 81242 | 2 | 1.423 | 57092.1 |
| 236 | 2024-11-06 00:43:37 | colleague | 1 | 81242 | 2 | 6.500 | 12498.8 |
| 235 | 2024-10-26 08:43:06 | colleague | 1 | 81242 | 2 | 6.893 | 11786.2 |
| 234 | 2024-10-16 16:44:53 | colleague | 1 | 81242 | 2 | 5.923 | 13716.4 |
| 233 | 2024-10-10 19:12:36 | colleague | 1 | 81242 | 2 | 3.393 | 23944.0 |
| 232 | 2024-10-10 05:04:04 | colleague | 1 | 81242 | 2 | 6.643 | 12229.7 |
| 231 | 2024-09-09 22:04:00 | colleague | 1 | 81242 | 2 | 6.610 | 12290.8 |
| 230 | 2024-09-08 06:36:55 | colleague | 1 | 81242 | 2 | 15.800 | 5141.9 |
| 229 | 2024-08-30 01:11:20 | colleague | 2 | 121436 | 6 | 48.736 | 2491.7 |
| 228 | 2024-08-30 00:39:11 | colleague | 2 | 121436 | 6 | 38.143 | 3183.7 |
| 227 | 2024-08-23 13:18:12 | colleague | 2 | 121436 | 6 | 39.643 | 3063.2 |
| 226 | 2024-08-23 13:17:53 | colleague | 3 | 148641 | 20 | 49.660 | 2993.2 |
| 225 | 2024-08-05 09:43:35 | colleague | 1 | 81242 | 2 | 6.050 | 13428.4 |
| 224 | 2024-07-31 03:21:11 | colleague | 1 | 81242 | 2 | 4.453 | 18244.3 |
| 223 | 2024-07-29 20:43:49 | colleague | 1 | 81242 | 2 | 5.266 | 15427.6 |
| 222 | 2024-07-25 03:24:34 | colleague | 3 | 148641 | 20 | 31.986 | 4647.1 |
| 221 | 2024-07-23 12:04:02 | colleague | 3 | 148641 | 20 | 19.876 | 7478.4 |
| 220 | 2024-07-18 12:38:59 | colleague | 3 | 148641 | 20 | 13.703 | 10847.3 |
| 219 | 2024-07-16 09:13:39 | colleague | 3 | 148641 | 20 | 39.770 | 3737.5 |
| 218 | 2024-07-13 16:23:00 | colleague | 3 | 148641 | 20 | 34.923 | 4256.2 |
| 217 | 2024-07-13 16:22:46 | colleague | 2 | 121436 | 6 | 13.593 | 8933.7 |
| 216 | 2024-07-08 00:43:16 | colleague | 1 | 81242 | 2 | 2.780 | 29223.7 |
| 215 | 2024-07-04 13:05:07 | colleague | 1 | 81242 | 2 | 6.343 | 12808.1 |
| 214 | 2024-07-03 11:02:15 | colleague | 1 | 81242 | 2 | 4.970 | 16346.5 |
| 213 | 2024-06-21 16:33:17 | colleague | 1 | 81242 | 2 | 2.813 | 28880.9 |