History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"ectype"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 323 | 2024-05-06 22:31:03 | ectype | 2 | 82551 | 10 | 5.233 | 15775.1 |
| 322 | 2024-05-06 13:37:52 | ectype | 2 | 82551 | 10 | 4.626 | 17845.0 |
| 321 | 2024-05-06 13:34:12 | ectype | 3 | 112716 | 119 | 6.373 | 17686.5 |
| 320 | 2024-05-05 16:04:40 | ectype | 2 | 82551 | 10 | 5.140 | 16060.5 |
| 319 | 2024-05-05 16:04:37 | ectype | 3 | 112716 | 119 | 5.530 | 20382.6 |
| 318 | 2024-05-05 16:04:32 | ectype | 1 | 48755 | 3 | 0.856 | 56956.8 |
| 317 | 2024-05-05 16:04:29 | ectype | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 316 | 2024-05-05 16:04:25 | ectype | 2 | 82551 | 10 | 2.486 | 33206.4 |
| 315 | 2024-05-05 16:04:21 | ectype | 3 | 112716 | 119 | 5.453 | 20670.5 |
| 314 | 2024-04-26 00:24:39 | ectype | 1 | 48755 | 3 | 2.923 | 16679.8 |
| 313 | 2024-04-24 23:52:41 | ectype | 2 | 82551 | 10 | 2.830 | 29170.0 |
| 312 | 2024-04-08 07:06:35 | ectype | 3 | 112716 | 119 | 22.033 | 5115.8 |
| 311 | 2024-04-05 23:20:59 | ectype | 3 | 112716 | 119 | 8.860 | 12721.9 |
| 310 | 2024-04-05 10:53:08 | ectype | 3 | 112716 | 119 | 13.783 | 8177.9 |
| 309 | 2024-04-05 10:53:18 | ectype | 1 | 48755 | 3 | 1.076 | 45311.3 |
| 308 | 2024-04-05 10:53:08 | ectype | 2 | 82551 | 10 | 3.186 | 25910.5 |
| 307 | 2024-04-05 10:52:59 | ectype | 1 | 48755 | 3 | 2.030 | 24017.2 |
| 306 | 2024-04-01 01:50:51 | ectype | 1 | 48755 | 3 | 1.530 | 31866.0 |
| 305 | 2024-03-31 05:39:25 | ectype | 1 | 48755 | 3 | 0.970 | 50262.9 |
| 304 | 2024-03-31 00:46:03 | ectype | 2 | 82551 | 10 | 8.436 | 9785.6 |
| 303 | 2024-03-30 16:25:48 | ectype | 1 | 48755 | 3 | 1.953 | 24964.2 |
| 302 | 2024-03-30 16:25:47 | ectype | 2 | 82551 | 10 | 2.983 | 27673.8 |
| 301 | 2024-03-29 06:29:52 | ectype | 1 | 48755 | 3 | 2.813 | 17332.0 |
| 300 | 2024-03-29 03:45:07 | ectype | 3 | 112716 | 119 | 11.830 | 9528.0 |
| 299 | 2024-03-29 03:45:07 | ectype | 2 | 82551 | 10 | 5.393 | 15307.1 |
| 298 | 2024-03-17 10:41:08 | ectype | 1 | 48755 | 3 | 1.516 | 32160.3 |
| 297 | 2024-03-06 23:45:08 | ectype | 2 | 82551 | 10 | 12.000 | 6879.3 |
| 296 | 2024-03-06 23:24:46 | ectype | 3 | 112716 | 119 | 19.906 | 5662.4 |
| 295 | 2024-03-06 08:31:57 | ectype | 1 | 48755 | 3 | 1.826 | 26700.4 |
| 294 | 2024-03-06 08:31:43 | ectype | 3 | 112716 | 119 | 6.720 | 16773.2 |
| 293 | 2024-03-06 08:31:45 | ectype | 2 | 82551 | 10 | 2.970 | 27794.9 |
| 292 | 2024-03-06 08:31:32 | ectype | 1 | 48755 | 3 | 0.953 | 51159.5 |
| 291 | 2024-02-27 22:38:59 | ectype | 2 | 82551 | 10 | 2.780 | 29694.6 |
| 290 | 2024-02-27 22:38:57 | ectype | 1 | 48755 | 3 | 0.936 | 52088.7 |
| 289 | 2024-02-22 04:08:09 | ectype | 3 | 112716 | 119 | 8.643 | 13041.3 |
| 288 | 2024-02-20 05:40:58 | ectype | 3 | 112716 | 119 | 6.140 | 18357.7 |
| 287 | 2024-02-05 04:32:02 | ectype | 3 | 112716 | 119 | 12.436 | 9063.7 |
| 286 | 2024-02-04 18:07:07 | ectype | 3 | 112716 | 119 | 5.643 | 19974.5 |
| 285 | 2024-02-04 18:07:03 | ectype | 2 | 82551 | 10 | 2.610 | 31628.7 |
| 284 | 2024-02-04 18:06:59 | ectype | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 283 | 2024-01-26 20:41:33 | ectype | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 282 | 2024-01-10 13:09:05 | ectype | 3 | 112716 | 119 | 5.190 | 21717.9 |
| 281 | 2024-01-06 15:47:56 | ectype | 3 | 112716 | 119 | 5.216 | 21609.7 |
| 280 | 2024-01-06 15:47:53 | ectype | 2 | 82551 | 10 | 2.156 | 38289.0 |
| 279 | 2023-12-12 17:05:23 | ectype | 2 | 82551 | 10 | 2.156 | 38289.0 |
| 278 | 2023-11-29 06:55:56 | ectype | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 277 | 2023-11-24 08:03:04 | ectype | 3 | 112716 | 119 | 4.593 | 24540.8 |
| 276 | 2023-11-21 18:25:36 | ectype | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 275 | 2023-11-21 01:20:40 | ectype | 1 | 48755 | 3 | 0.953 | 51159.5 |
| 274 | 2023-11-20 02:10:12 | ectype | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 273 | 2023-11-14 15:50:10 | ectype | 1 | 48755 | 3 | 0.810 | 60191.4 |
| 272 | 2023-11-14 11:33:54 | ectype | 3 | 112716 | 119 | 4.953 | 22757.1 |
| 271 | 2023-11-05 01:40:36 | ectype | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 270 | 2023-11-04 08:37:05 | ectype | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 269 | 2023-10-21 18:38:42 | ectype | 3 | 112716 | 119 | 5.406 | 20850.2 |
| 268 | 2023-10-15 13:06:58 | ectype | 1 | 48755 | 3 | 0.826 | 59025.4 |
| 267 | 2023-10-08 01:31:34 | ectype | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 266 | 2023-09-30 01:03:41 | ectype | 3 | 112716 | 119 | 5.170 | 21801.9 |
| 265 | 2023-09-30 01:03:42 | ectype | 2 | 82551 | 10 | 2.453 | 33653.1 |
| 264 | 2023-09-24 21:35:02 | ectype | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 263 | 2023-09-15 03:59:00 | ectype | 1 | 48755 | 3 | 0.763 | 63899.1 |
| 262 | 2023-09-13 02:28:05 | ectype | 2 | 82551 | 10 | 2.216 | 37252.3 |
| 261 | 2023-09-08 08:02:08 | ectype | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 260 | 2023-08-15 18:00:17 | ectype | 3 | 112716 | 119 | 5.533 | 20371.6 |
| 259 | 2023-07-19 02:33:16 | ectype | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 258 | 2023-06-12 23:18:18 | ectype | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 257 | 2023-06-07 17:43:59 | ectype | 2 | 82551 | 10 | 2.330 | 35429.6 |
| 256 | 2023-04-27 23:59:20 | ectype | 3 | 112716 | 119 | 4.563 | 24702.2 |
| 255 | 2023-04-26 22:23:46 | ectype | 3 | 112716 | 119 | 4.623 | 24381.6 |
| 254 | 2023-03-29 23:24:35 | ectype | 1 | 48755 | 3 | 0.826 | 59025.4 |
| 253 | 2023-03-23 21:13:50 | ectype | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 252 | 2023-03-21 02:49:55 | ectype | 3 | 112716 | 119 | 4.593 | 24540.8 |
| 251 | 2023-03-15 04:55:37 | ectype | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 250 | 2023-03-10 18:47:14 | ectype | 2 | 82551 | 10 | 2.063 | 40015.0 |
| 249 | 2023-02-02 08:43:17 | ectype | 3 | 112716 | 119 | 5.466 | 20621.3 |
| 248 | 2023-02-01 21:53:58 | ectype | 1 | 48755 | 3 | 0.716 | 68093.6 |
| 247 | 2023-01-14 04:22:47 | ectype | 3 | 112716 | 119 | 4.576 | 24632.0 |
| 246 | 2023-01-12 14:30:24 | ectype | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 245 | 2022-12-17 02:56:06 | ectype | 1 | 48755 | 3 | 0.876 | 55656.4 |
| 244 | 2022-12-16 05:43:55 | ectype | 2 | 82551 | 10 | 2.080 | 39688.0 |
| 243 | 2022-12-13 18:43:35 | ectype | 3 | 112716 | 119 | 5.080 | 22188.2 |
| 242 | 2022-12-13 03:32:44 | ectype | 3 | 112716 | 119 | 4.750 | 23729.7 |
| 241 | 2022-12-11 09:58:51 | ectype | 3 | 112716 | 119 | 5.720 | 19705.6 |
| 240 | 2022-11-30 02:49:25 | ectype | 3 | 112716 | 119 | 4.983 | 22620.1 |
| 239 | 2022-11-22 11:27:53 | ectype | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 238 | 2022-11-21 06:57:41 | ectype | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 237 | 2022-11-15 14:58:21 | ectype | 3 | 112716 | 119 | 5.453 | 20670.5 |
| 236 | 2022-11-12 14:03:22 | ectype | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 235 | 2022-11-09 20:40:59 | ectype | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 234 | 2022-11-09 04:12:59 | ectype | 3 | 112716 | 119 | 4.703 | 23966.8 |
| 233 | 2022-11-05 18:24:47 | ectype | 3 | 112716 | 119 | 4.970 | 22679.3 |
| 232 | 2022-11-04 05:26:39 | ectype | 3 | 112716 | 119 | 5.360 | 21029.1 |
| 231 | 2022-10-29 04:02:45 | ectype | 1 | 48755 | 3 | 1.466 | 33257.2 |
| 230 | 2022-09-01 15:15:12 | ectype | 3 | 112716 | 119 | 4.720 | 23880.5 |
| 229 | 2022-08-31 20:25:58 | ectype | 3 | 112716 | 119 | 5.126 | 21989.1 |
| 228 | 2022-08-08 16:00:22 | ectype | 2 | 82551 | 10 | 2.110 | 39123.7 |
| 227 | 2022-08-06 05:44:06 | ectype | 2 | 82551 | 10 | 2.203 | 37472.1 |
| 226 | 2022-07-29 16:02:18 | ectype | 1 | 48755 | 3 | 0.783 | 62266.9 |
| 225 | 2022-07-26 05:50:35 | ectype | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 224 | 2022-07-23 12:08:58 | ectype | 3 | 112716 | 119 | 4.813 | 23419.1 |