History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"counselors"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 330 | 2025-10-15 11:32:33 | counselors | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 329 | 2025-10-01 22:32:06 | counselors | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 328 | 2025-09-17 04:35:13 | counselors | 1 | 67641 | 3 | 1.190 | 56841.2 |
| 327 | 2025-09-01 16:31:47 | counselors | 3 | 140603 | 22 | 5.876 | 23928.4 |
| 326 | 2025-08-26 19:41:42 | counselors | 4 | 161450 | 170 | 12.236 | 13194.7 |
| 325 | 2025-08-24 18:54:04 | counselors | 4 | 161450 | 170 | 32.780 | 4925.3 |
| 324 | 2025-08-18 15:25:00 | counselors | 3 | 140603 | 22 | 6.516 | 21578.1 |
| 323 | 2025-08-18 15:17:10 | counselors | 1 | 67641 | 3 | 1.216 | 55625.8 |
| 322 | 2025-08-17 05:49:41 | counselors | 1 | 67641 | 3 | 5.563 | 12159.1 |
| 321 | 2025-08-14 05:26:18 | counselors | 4 | 161450 | 170 | 11.910 | 13555.8 |
| 320 | 2025-08-12 09:14:52 | counselors | 4 | 161450 | 170 | 25.266 | 6390.0 |
| 319 | 2025-08-09 04:01:38 | counselors | 1 | 67641 | 3 | 4.873 | 13880.8 |
| 318 | 2025-08-07 13:39:54 | counselors | 4 | 161450 | 170 | 28.796 | 5606.7 |
| 317 | 2025-07-25 07:31:20 | counselors | 1 | 67641 | 3 | 5.440 | 12434.0 |
| 316 | 2025-07-23 11:02:44 | counselors | 1 | 67641 | 3 | 4.666 | 14496.6 |
| 315 | 2025-07-22 05:25:24 | counselors | 3 | 140603 | 22 | 7.110 | 19775.4 |
| 314 | 2025-07-19 04:25:35 | counselors | 1 | 67641 | 3 | 1.143 | 59178.5 |
| 313 | 2025-07-13 00:50:02 | counselors | 1 | 67641 | 3 | 1.266 | 53428.9 |
| 312 | 2025-07-12 12:17:29 | counselors | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 311 | 2025-07-09 11:28:27 | counselors | 1 | 67641 | 3 | 1.096 | 61716.2 |
| 310 | 2025-06-26 03:24:11 | counselors | 1 | 67641 | 3 | 4.016 | 16842.9 |
| 309 | 2025-06-14 09:22:27 | counselors | 1 | 67641 | 3 | 2.936 | 23038.5 |
| 308 | 2025-06-14 02:20:36 | counselors | 1 | 67641 | 3 | 3.986 | 16969.6 |
| 307 | 2025-06-09 06:25:53 | counselors | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 306 | 2025-05-30 18:44:38 | counselors | 3 | 140603 | 22 | 6.766 | 20780.8 |
| 305 | 2025-05-30 10:08:42 | counselors | 1 | 67641 | 3 | 3.360 | 20131.3 |
| 304 | 2025-05-29 00:31:30 | counselors | 1 | 67641 | 3 | 2.976 | 22728.8 |
| 303 | 2025-05-22 03:15:56 | counselors | 1 | 67641 | 3 | 7.016 | 9641.0 |
| 302 | 2025-05-11 09:07:16 | counselors | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 301 | 2025-04-11 09:08:17 | counselors | 1 | 67641 | 3 | 6.346 | 10658.8 |
| 300 | 2025-03-26 22:47:20 | counselors | 2 | 108824 | 7 | 12.453 | 8738.8 |
| 299 | 2025-03-26 03:34:10 | counselors | 1 | 67641 | 3 | 2.360 | 28661.4 |
| 298 | 2025-03-24 12:19:12 | counselors | 1 | 67641 | 3 | 3.516 | 19238.1 |
| 297 | 2025-03-20 03:26:05 | counselors | 1 | 67641 | 3 | 3.063 | 22083.3 |
| 296 | 2025-03-13 06:35:45 | counselors | 1 | 67641 | 3 | 3.936 | 17185.2 |
| 295 | 2025-03-06 10:47:57 | counselors | 1 | 67641 | 3 | 3.550 | 19053.8 |
| 294 | 2025-02-17 03:03:25 | counselors | 1 | 67641 | 3 | 6.046 | 11187.7 |
| 293 | 2025-02-13 20:21:49 | counselors | 3 | 140603 | 22 | 30.913 | 4548.3 |
| 292 | 2025-02-13 20:17:52 | counselors | 1 | 67641 | 3 | 2.843 | 23792.1 |
| 291 | 2025-02-13 08:36:11 | counselors | 3 | 140603 | 22 | 31.546 | 4457.1 |
| 290 | 2025-02-13 08:36:25 | counselors | 2 | 108824 | 7 | 16.360 | 6651.8 |
| 289 | 2025-02-11 22:06:41 | counselors | 1 | 67641 | 3 | 3.140 | 21541.7 |
| 288 | 2025-02-10 13:33:48 | counselors | 2 | 108824 | 7 | 7.720 | 14096.4 |
| 287 | 2025-02-09 16:51:04 | counselors | 3 | 140603 | 22 | 33.703 | 4171.8 |
| 286 | 2025-02-08 02:43:57 | counselors | 3 | 140603 | 22 | 28.686 | 4901.5 |
| 285 | 2025-02-08 02:43:56 | counselors | 2 | 108824 | 7 | 16.670 | 6528.1 |
| 284 | 2025-02-05 05:39:15 | counselors | 1 | 67641 | 3 | 5.826 | 11610.2 |
| 283 | 2025-02-01 15:49:16 | counselors | 3 | 140603 | 22 | 36.033 | 3902.1 |
| 282 | 2025-02-01 15:49:22 | counselors | 2 | 108824 | 7 | 13.596 | 8004.1 |
| 281 | 2025-02-01 15:47:55 | counselors | 1 | 67641 | 3 | 5.156 | 13118.9 |
| 280 | 2025-01-23 07:16:17 | counselors | 1 | 67641 | 3 | 8.160 | 8289.3 |
| 279 | 2025-01-16 12:58:14 | counselors | 1 | 67641 | 3 | 2.326 | 29080.4 |
| 278 | 2025-01-08 05:33:15 | counselors | 3 | 140603 | 22 | 32.656 | 4305.6 |
| 277 | 2025-01-08 05:33:12 | counselors | 2 | 108824 | 7 | 12.033 | 9043.8 |
| 276 | 2025-01-01 11:26:10 | counselors | 3 | 140603 | 22 | 35.550 | 3955.1 |
| 275 | 2025-01-01 11:25:48 | counselors | 3 | 140603 | 22 | 32.393 | 4340.5 |
| 274 | 2025-01-01 11:25:57 | counselors | 2 | 108824 | 7 | 15.970 | 6814.3 |
| 273 | 2025-01-01 11:23:07 | counselors | 1 | 67641 | 3 | 2.093 | 32317.7 |
| 272 | 2024-12-30 21:21:12 | counselors | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 271 | 2024-12-30 06:25:21 | counselors | 3 | 140603 | 22 | 30.080 | 4674.3 |
| 270 | 2024-12-30 06:25:17 | counselors | 3 | 140603 | 22 | 28.160 | 4993.0 |
| 269 | 2024-12-30 06:25:20 | counselors | 2 | 108824 | 7 | 18.296 | 5948.0 |
| 268 | 2024-12-10 17:28:43 | counselors | 1 | 67641 | 3 | 5.453 | 12404.4 |
| 267 | 2024-12-04 23:56:41 | counselors | 1 | 67641 | 3 | 5.046 | 13404.9 |
| 266 | 2024-12-01 15:06:26 | counselors | 3 | 140603 | 22 | 32.126 | 4376.6 |
| 265 | 2024-12-01 15:06:13 | counselors | 3 | 140603 | 22 | 30.766 | 4570.1 |
| 264 | 2024-12-01 15:03:46 | counselors | 1 | 67641 | 3 | 1.220 | 55443.4 |
| 263 | 2024-12-01 06:54:16 | counselors | 3 | 140603 | 22 | 30.890 | 4551.7 |
| 262 | 2024-11-24 16:54:14 | counselors | 3 | 140603 | 22 | 24.046 | 5847.3 |
| 261 | 2024-11-24 16:54:05 | counselors | 2 | 108824 | 7 | 20.190 | 5390.0 |
| 260 | 2024-11-24 16:54:02 | counselors | 3 | 140603 | 22 | 22.376 | 6283.7 |
| 259 | 2024-11-22 15:35:49 | counselors | 1 | 67641 | 3 | 5.720 | 11825.3 |
| 258 | 2024-11-18 09:57:18 | counselors | 3 | 140603 | 22 | 31.766 | 4426.2 |
| 257 | 2024-11-06 15:07:19 | counselors | 2 | 108824 | 7 | 23.606 | 4610.0 |
| 256 | 2024-11-04 16:35:50 | counselors | 1 | 67641 | 3 | 3.923 | 17242.2 |
| 255 | 2024-11-01 04:49:23 | counselors | 3 | 140603 | 22 | 31.406 | 4476.9 |
| 254 | 2024-10-28 19:15:12 | counselors | 1 | 67641 | 3 | 5.986 | 11299.9 |
| 253 | 2024-10-27 00:55:53 | counselors | 1 | 67641 | 3 | 5.500 | 12298.4 |
| 252 | 2024-10-24 20:06:15 | counselors | 3 | 140603 | 22 | 38.546 | 3647.7 |
| 251 | 2024-10-24 20:06:11 | counselors | 2 | 108824 | 7 | 10.250 | 10617.0 |
| 250 | 2024-10-24 20:05:11 | counselors | 1 | 67641 | 3 | 6.250 | 10822.6 |
| 249 | 2024-10-24 17:16:54 | counselors | 3 | 140603 | 22 | 32.580 | 4315.6 |
| 248 | 2024-10-24 17:16:51 | counselors | 2 | 108824 | 7 | 10.080 | 10796.0 |
| 247 | 2024-10-24 09:26:40 | counselors | 1 | 67641 | 3 | 5.970 | 11330.2 |
| 246 | 2024-10-24 09:21:50 | counselors | 1 | 67641 | 3 | 6.063 | 11156.4 |
| 245 | 2024-10-21 00:57:29 | counselors | 3 | 140603 | 22 | 27.610 | 5092.5 |
| 244 | 2024-10-21 00:57:30 | counselors | 2 | 108824 | 7 | 14.080 | 7729.0 |
| 243 | 2024-10-21 00:56:09 | counselors | 1 | 67641 | 3 | 4.423 | 15293.0 |
| 242 | 2024-10-17 21:03:07 | counselors | 4 | 161450 | 170 | 51.893 | 3111.2 |
| 241 | 2024-10-14 12:46:55 | counselors | 4 | 161450 | 170 | 58.863 | 2742.8 |
| 240 | 2024-10-13 06:15:41 | counselors | 4 | 161450 | 170 | 56.456 | 2859.7 |
| 239 | 2024-10-11 21:12:50 | counselors | 4 | 161450 | 170 | 30.906 | 5223.9 |
| 238 | 2024-10-03 15:05:05 | counselors | 1 | 67641 | 3 | 8.323 | 8127.0 |
| 237 | 2024-09-19 18:24:28 | counselors | 1 | 67641 | 3 | 7.750 | 8727.9 |
| 236 | 2024-09-17 11:52:53 | counselors | 1 | 67641 | 3 | 10.313 | 6558.8 |
| 235 | 2024-09-14 00:10:28 | counselors | 4 | 161450 | 170 | 98.176 | 1644.5 |
| 234 | 2024-09-12 21:47:41 | counselors | 4 | 161450 | 170 | 107.833 | 1497.2 |
| 233 | 2024-09-04 13:01:45 | counselors | 4 | 161450 | 170 | 103.523 | 1559.6 |
| 232 | 2024-09-02 16:27:47 | counselors | 4 | 161450 | 170 | 112.790 | 1431.4 |
| 231 | 2024-09-02 11:53:56 | counselors | 4 | 161450 | 170 | 66.573 | 2425.2 |