History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"enrollee"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 306 | 2024-04-24 19:29:23 | enrollee | 1 | 82945 | 4 | 4.623 | 17941.8 |
| 305 | 2024-04-12 21:42:09 | enrollee | 3 | 146162 | 56 | 8.283 | 17646.0 |
| 304 | 2024-04-12 21:42:05 | enrollee | 2 | 121059 | 8 | 4.123 | 29361.9 |
| 303 | 2024-04-10 22:40:49 | enrollee | 3 | 146162 | 56 | 16.173 | 9037.4 |
| 302 | 2024-04-09 18:14:37 | enrollee | 3 | 146162 | 56 | 16.236 | 9002.3 |
| 301 | 2024-04-09 18:14:36 | enrollee | 2 | 121059 | 8 | 8.063 | 15014.1 |
| 300 | 2024-04-09 18:14:28 | enrollee | 1 | 82945 | 4 | 3.593 | 23085.2 |
| 299 | 2024-04-03 13:42:36 | enrollee | 3 | 146162 | 56 | 10.910 | 13397.1 |
| 298 | 2024-04-01 10:04:19 | enrollee | 1 | 82945 | 4 | 4.970 | 16689.1 |
| 297 | 2024-04-01 00:32:26 | enrollee | 3 | 146162 | 56 | 7.890 | 18525.0 |
| 296 | 2024-04-01 00:32:24 | enrollee | 2 | 121059 | 8 | 3.783 | 32000.8 |
| 295 | 2024-03-31 22:04:37 | enrollee | 4 | 161609 | 449 | 20.063 | 8055.1 |
| 294 | 2024-03-30 00:45:54 | enrollee | 3 | 146162 | 56 | 24.080 | 6069.9 |
| 293 | 2024-03-30 00:45:50 | enrollee | 2 | 121059 | 8 | 5.453 | 22200.4 |
| 292 | 2024-03-30 00:05:07 | enrollee | 1 | 82945 | 4 | 1.453 | 57085.3 |
| 291 | 2024-03-28 19:17:31 | enrollee | 4 | 161609 | 449 | 35.270 | 4582.1 |
| 290 | 2024-03-28 14:40:21 | enrollee | 4 | 161609 | 449 | 11.703 | 13809.2 |
| 289 | 2024-03-25 05:13:33 | enrollee | 4 | 161609 | 449 | 14.860 | 10875.4 |
| 288 | 2024-03-21 19:22:00 | enrollee | 4 | 161609 | 449 | 20.780 | 7777.1 |
| 287 | 2024-03-20 18:56:31 | enrollee | 4 | 161609 | 449 | 24.690 | 6545.5 |
| 286 | 2024-03-10 18:39:15 | enrollee | 3 | 146162 | 56 | 15.876 | 9206.5 |
| 285 | 2024-03-10 16:22:54 | enrollee | 3 | 146162 | 56 | 20.703 | 7059.9 |
| 284 | 2024-03-09 20:10:03 | enrollee | 3 | 146162 | 56 | 17.550 | 8328.3 |
| 283 | 2024-03-09 19:08:41 | enrollee | 1 | 82945 | 4 | 2.390 | 34705.0 |
| 282 | 2024-03-08 23:28:29 | enrollee | 1 | 82945 | 4 | 1.546 | 53651.4 |
| 281 | 2024-03-08 23:28:22 | enrollee | 3 | 146162 | 56 | 8.266 | 17682.3 |
| 280 | 2024-03-08 23:28:21 | enrollee | 2 | 121059 | 8 | 3.923 | 30858.8 |
| 279 | 2024-03-08 23:28:15 | enrollee | 1 | 82945 | 4 | 3.110 | 26670.4 |
| 278 | 2024-02-28 09:49:21 | enrollee | 3 | 146162 | 56 | 24.546 | 5954.6 |
| 277 | 2024-02-28 09:49:32 | enrollee | 2 | 121059 | 8 | 12.800 | 9457.7 |
| 276 | 2024-02-28 07:44:17 | enrollee | 1 | 82945 | 4 | 3.076 | 26965.2 |
| 275 | 2024-02-27 06:17:16 | enrollee | 4 | 161609 | 449 | 29.326 | 5510.8 |
| 274 | 2024-02-26 09:25:52 | enrollee | 4 | 161609 | 449 | 15.406 | 10490.0 |
| 273 | 2024-02-26 09:25:48 | enrollee | 1 | 82945 | 4 | 1.563 | 53067.8 |
| 272 | 2024-02-08 08:22:42 | enrollee | 2 | 121059 | 8 | 9.140 | 13245.0 |
| 271 | 2024-02-08 08:07:33 | enrollee | 3 | 146162 | 56 | 7.533 | 19402.9 |
| 270 | 2024-02-07 22:19:34 | enrollee | 4 | 161609 | 449 | 15.310 | 10555.8 |
| 269 | 2024-02-07 16:42:39 | enrollee | 2 | 121059 | 8 | 3.736 | 32403.4 |
| 268 | 2024-02-07 16:42:24 | enrollee | 3 | 146162 | 56 | 9.423 | 15511.2 |
| 267 | 2024-02-07 06:19:01 | enrollee | 3 | 146162 | 56 | 7.500 | 19488.3 |
| 266 | 2024-02-07 06:18:57 | enrollee | 2 | 121059 | 8 | 3.830 | 31608.1 |
| 265 | 2024-02-07 06:18:53 | enrollee | 1 | 82945 | 4 | 1.486 | 55817.6 |
| 264 | 2024-02-06 09:44:02 | enrollee | 4 | 161609 | 449 | 12.046 | 13416.0 |
| 263 | 2024-01-26 23:23:05 | enrollee | 1 | 82945 | 4 | 1.453 | 57085.3 |
| 262 | 2024-01-25 17:31:43 | enrollee | 4 | 161609 | 449 | 14.140 | 11429.2 |
| 261 | 2024-01-20 05:47:16 | enrollee | 1 | 82945 | 4 | 1.393 | 59544.1 |
| 260 | 2024-01-18 23:42:09 | enrollee | 1 | 82945 | 4 | 1.406 | 58993.6 |
| 259 | 2024-01-08 02:14:56 | enrollee | 1 | 82945 | 4 | 1.263 | 65673.0 |
| 258 | 2024-01-07 16:38:32 | enrollee | 4 | 161609 | 449 | 10.923 | 14795.3 |
| 257 | 2023-12-15 00:45:27 | enrollee | 4 | 161609 | 449 | 13.406 | 12055.0 |
| 256 | 2023-12-15 00:45:26 | enrollee | 3 | 146162 | 56 | 7.720 | 18932.9 |
| 255 | 2023-12-15 00:45:25 | enrollee | 2 | 121059 | 8 | 3.576 | 33853.2 |
| 254 | 2023-12-01 17:41:31 | enrollee | 3 | 146162 | 56 | 7.313 | 19986.6 |
| 253 | 2023-12-01 06:10:49 | enrollee | 4 | 161609 | 449 | 11.076 | 14590.9 |
| 252 | 2023-11-13 20:54:03 | enrollee | 1 | 82945 | 4 | 1.530 | 54212.4 |
| 251 | 2023-10-28 22:30:59 | enrollee | 1 | 82945 | 4 | 1.516 | 54713.1 |
| 250 | 2023-10-10 20:36:49 | enrollee | 1 | 82945 | 4 | 1.390 | 59672.7 |
| 249 | 2023-09-01 20:00:02 | enrollee | 1 | 82945 | 4 | 1.406 | 58993.6 |
| 248 | 2023-08-31 20:25:49 | enrollee | 3 | 146162 | 56 | 8.110 | 18022.4 |
| 247 | 2023-08-30 04:53:10 | enrollee | 4 | 161609 | 449 | 12.203 | 13243.4 |
| 246 | 2023-08-02 13:58:12 | enrollee | 4 | 161609 | 449 | 11.423 | 14147.7 |
| 245 | 2023-06-12 03:44:28 | enrollee | 4 | 161609 | 449 | 10.643 | 15184.5 |
| 244 | 2023-06-10 17:36:45 | enrollee | 1 | 82945 | 4 | 1.250 | 66356.0 |
| 243 | 2023-06-04 04:10:50 | enrollee | 1 | 82945 | 4 | 1.356 | 61168.9 |
| 242 | 2023-05-29 04:46:13 | enrollee | 4 | 161609 | 449 | 12.546 | 12881.3 |
| 241 | 2023-05-18 05:03:59 | enrollee | 3 | 146162 | 56 | 6.330 | 23090.4 |
| 240 | 2023-05-17 01:41:09 | enrollee | 4 | 161609 | 449 | 10.576 | 15280.7 |
| 239 | 2023-03-26 00:48:29 | enrollee | 1 | 82945 | 4 | 1.280 | 64800.8 |
| 238 | 2023-02-25 12:11:13 | enrollee | 3 | 146162 | 56 | 7.486 | 19524.7 |
| 237 | 2023-02-24 21:24:41 | enrollee | 4 | 161609 | 449 | 12.220 | 13225.0 |
| 236 | 2023-02-24 19:21:48 | enrollee | 4 | 161609 | 449 | 10.940 | 14772.3 |
| 235 | 2023-02-19 07:22:40 | enrollee | 1 | 82945 | 4 | 1.250 | 66356.0 |
| 234 | 2023-02-04 01:47:37 | enrollee | 1 | 82945 | 4 | 1.250 | 66356.0 |
| 233 | 2023-01-11 05:29:04 | enrollee | 1 | 82945 | 4 | 1.263 | 65673.0 |
| 232 | 2023-01-04 07:13:20 | enrollee | 4 | 161609 | 449 | 11.546 | 13997.0 |
| 231 | 2023-01-04 00:25:23 | enrollee | 4 | 161609 | 449 | 10.656 | 15166.0 |
| 230 | 2022-12-19 00:07:55 | enrollee | 1 | 82945 | 4 | 1.390 | 59672.7 |
| 229 | 2022-12-09 05:46:47 | enrollee | 3 | 146162 | 56 | 6.220 | 23498.7 |
| 228 | 2022-12-06 00:56:27 | enrollee | 4 | 161609 | 449 | 11.096 | 14564.6 |
| 227 | 2022-11-25 14:26:28 | enrollee | 4 | 161609 | 449 | 12.406 | 13026.7 |
| 226 | 2022-11-20 06:24:20 | enrollee | 4 | 161609 | 449 | 13.423 | 12039.7 |
| 225 | 2022-11-13 02:07:34 | enrollee | 1 | 82945 | 4 | 1.360 | 60989.0 |
| 224 | 2022-10-30 07:11:10 | enrollee | 4 | 161609 | 449 | 10.560 | 15303.9 |
| 223 | 2022-10-29 01:05:27 | enrollee | 2 | 121059 | 8 | 3.156 | 38358.4 |
| 222 | 2022-10-27 10:09:20 | enrollee | 4 | 161609 | 449 | 11.783 | 13715.4 |
| 221 | 2022-10-26 04:45:59 | enrollee | 4 | 161609 | 449 | 11.406 | 14168.8 |
| 220 | 2022-10-22 10:57:24 | enrollee | 1 | 82945 | 4 | 1.266 | 65517.4 |
| 219 | 2022-10-13 05:21:44 | enrollee | 1 | 82945 | 4 | 1.420 | 58412.0 |
| 218 | 2022-10-04 13:02:49 | enrollee | 4 | 161609 | 449 | 18.813 | 8590.3 |
| 217 | 2022-09-27 18:01:37 | enrollee | 2 | 121059 | 8 | 3.233 | 37444.8 |
| 216 | 2022-09-27 03:57:48 | enrollee | 4 | 161609 | 449 | 10.890 | 14840.1 |
| 215 | 2022-09-13 16:27:14 | enrollee | 4 | 161609 | 449 | 11.970 | 13501.2 |
| 214 | 2022-08-21 23:22:50 | enrollee | 4 | 161609 | 449 | 11.580 | 13955.9 |
| 213 | 2022-07-26 22:20:16 | enrollee | 4 | 161609 | 449 | 14.343 | 11267.4 |
| 212 | 2022-07-22 17:54:58 | enrollee | 3 | 146162 | 56 | 6.843 | 21359.3 |
| 211 | 2022-07-18 20:55:39 | enrollee | 1 | 82945 | 4 | 1.346 | 61623.3 |
| 210 | 2022-07-16 15:37:40 | enrollee | 4 | 161609 | 449 | 10.923 | 14795.3 |
| 209 | 2022-06-29 03:06:04 | enrollee | 4 | 161609 | 449 | 11.250 | 14365.2 |
| 208 | 2022-06-25 11:51:28 | enrollee | 4 | 161609 | 449 | 10.736 | 15053.0 |
| 207 | 2022-06-24 20:04:54 | enrollee | 1 | 82945 | 4 | 1.250 | 66356.0 |