History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"ternary"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 336 | 2025-05-16 10:55:07 | ternary | 1 | 69583 | 1 | 2.593 | 26834.9 |
| 335 | 2025-05-13 08:07:49 | ternary | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 334 | 2025-05-13 03:01:38 | ternary | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 333 | 2025-05-04 09:34:52 | ternary | 2 | 107671 | 11 | 10.123 | 10636.3 |
| 332 | 2025-05-04 06:34:09 | ternary | 3 | 134027 | 175 | 27.406 | 4890.4 |
| 331 | 2025-05-02 21:18:25 | ternary | 3 | 134027 | 175 | 22.970 | 5834.9 |
| 330 | 2025-05-02 15:31:35 | ternary | 3 | 134027 | 175 | 19.410 | 6905.0 |
| 329 | 2025-05-01 11:04:39 | ternary | 2 | 107671 | 11 | 3.516 | 30623.2 |
| 328 | 2025-05-01 01:30:30 | ternary | 3 | 134027 | 175 | 43.940 | 3050.2 |
| 327 | 2025-04-27 06:02:30 | ternary | 1 | 69583 | 1 | 1.313 | 52995.4 |
| 326 | 2025-04-26 11:51:47 | ternary | 1 | 69583 | 1 | 5.953 | 11688.7 |
| 325 | 2025-04-26 03:23:17 | ternary | 1 | 69583 | 1 | 8.253 | 8431.2 |
| 324 | 2025-04-20 00:01:20 | ternary | 1 | 69583 | 1 | 8.663 | 8032.2 |
| 323 | 2025-04-19 10:00:58 | ternary | 1 | 69583 | 1 | 1.190 | 58473.1 |
| 322 | 2025-04-14 10:52:34 | ternary | 1 | 69583 | 1 | 5.736 | 12130.9 |
| 321 | 2025-04-08 08:16:01 | ternary | 1 | 69583 | 1 | 3.046 | 22844.1 |
| 320 | 2025-03-31 21:34:50 | ternary | 3 | 134027 | 175 | 46.066 | 2909.5 |
| 319 | 2025-03-30 23:59:52 | ternary | 3 | 134027 | 175 | 39.890 | 3359.9 |
| 318 | 2025-03-29 14:26:30 | ternary | 3 | 134027 | 175 | 22.626 | 5923.6 |
| 317 | 2025-03-29 14:14:02 | ternary | 1 | 69583 | 1 | 3.046 | 22844.1 |
| 316 | 2025-03-27 11:57:43 | ternary | 2 | 107671 | 11 | 17.580 | 6124.6 |
| 315 | 2025-03-26 13:57:18 | ternary | 1 | 69583 | 1 | 1.360 | 51164.0 |
| 314 | 2025-03-26 12:43:54 | ternary | 2 | 107671 | 11 | 17.096 | 6298.0 |
| 313 | 2025-03-26 11:12:12 | ternary | 3 | 134027 | 175 | 61.786 | 2169.2 |
| 312 | 2025-03-26 02:38:31 | ternary | 3 | 134027 | 175 | 35.173 | 3810.5 |
| 311 | 2025-03-25 07:58:08 | ternary | 3 | 134027 | 175 | 34.833 | 3847.7 |
| 310 | 2025-03-23 20:25:33 | ternary | 3 | 134027 | 175 | 19.016 | 7048.1 |
| 309 | 2025-03-20 01:50:58 | ternary | 1 | 69583 | 1 | 7.360 | 9454.2 |
| 308 | 2025-03-12 23:08:26 | ternary | 1 | 69583 | 1 | 3.890 | 17887.7 |
| 307 | 2025-03-12 00:01:27 | ternary | 1 | 69583 | 1 | 6.046 | 11508.9 |
| 306 | 2025-02-27 10:46:34 | ternary | 3 | 134027 | 175 | 37.033 | 3619.1 |
| 305 | 2025-02-24 03:36:05 | ternary | 3 | 134027 | 175 | 35.583 | 3766.6 |
| 304 | 2025-02-23 13:12:30 | ternary | 3 | 134027 | 175 | 40.516 | 3308.0 |
| 303 | 2025-02-23 13:12:26 | ternary | 2 | 107671 | 11 | 17.110 | 6292.9 |
| 302 | 2025-02-21 07:39:28 | ternary | 3 | 134027 | 175 | 30.220 | 4435.0 |
| 301 | 2025-02-21 07:39:16 | ternary | 2 | 107671 | 11 | 14.376 | 7489.6 |
| 300 | 2025-02-21 07:38:40 | ternary | 1 | 69583 | 1 | 5.906 | 11781.7 |
| 299 | 2025-02-19 22:44:21 | ternary | 1 | 69583 | 1 | 5.800 | 11997.1 |
| 298 | 2025-01-18 05:15:59 | ternary | 1 | 69583 | 1 | 4.126 | 16864.5 |
| 297 | 2024-12-18 12:07:43 | ternary | 1 | 69583 | 1 | 5.123 | 13582.5 |
| 296 | 2024-12-10 18:23:00 | ternary | 1 | 69583 | 1 | 5.843 | 11908.8 |
| 295 | 2024-11-10 15:40:30 | ternary | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 294 | 2024-10-12 18:37:10 | ternary | 2 | 107671 | 11 | 16.170 | 6658.7 |
| 293 | 2024-10-10 21:06:01 | ternary | 2 | 107671 | 11 | 16.670 | 6459.0 |
| 292 | 2024-10-10 21:05:50 | ternary | 1 | 69583 | 1 | 5.233 | 13297.0 |
| 291 | 2024-10-10 13:36:02 | ternary | 3 | 134027 | 175 | 19.440 | 6894.4 |
| 290 | 2024-10-10 02:21:34 | ternary | 3 | 134027 | 175 | 35.160 | 3811.9 |
| 289 | 2024-10-09 15:38:17 | ternary | 3 | 134027 | 175 | 44.160 | 3035.0 |
| 288 | 2024-10-09 07:50:50 | ternary | 3 | 134027 | 175 | 33.033 | 4057.4 |
| 287 | 2024-09-09 16:43:13 | ternary | 1 | 69583 | 1 | 4.670 | 14900.0 |
| 286 | 2024-09-07 03:38:54 | ternary | 3 | 134027 | 175 | 52.940 | 2531.7 |
| 285 | 2024-09-06 04:42:15 | ternary | 3 | 134027 | 175 | 79.110 | 1694.2 |
| 284 | 2024-09-05 02:30:31 | ternary | 3 | 134027 | 175 | 94.736 | 1414.7 |
| 283 | 2024-09-04 23:31:54 | ternary | 2 | 107671 | 11 | 25.830 | 4168.4 |
| 282 | 2024-09-04 23:27:46 | ternary | 3 | 134027 | 175 | 6.936 | 19323.4 |
| 281 | 2024-08-29 03:13:37 | ternary | 2 | 107671 | 11 | 26.406 | 4077.5 |
| 280 | 2024-08-29 03:13:31 | ternary | 3 | 134027 | 175 | 27.406 | 4890.4 |
| 279 | 2024-08-29 02:29:45 | ternary | 1 | 69583 | 1 | 13.703 | 5077.9 |
| 278 | 2024-08-15 09:35:45 | ternary | 1 | 69583 | 1 | 5.890 | 11813.8 |
| 277 | 2024-08-12 23:13:10 | ternary | 1 | 69583 | 1 | 4.340 | 16032.9 |
| 276 | 2024-08-12 03:27:47 | ternary | 1 | 69583 | 1 | 3.716 | 18725.2 |
| 275 | 2024-07-28 14:55:41 | ternary | 1 | 69583 | 1 | 4.076 | 17071.4 |
| 274 | 2024-07-26 19:12:57 | ternary | 1 | 69583 | 1 | 4.110 | 16930.2 |
| 273 | 2024-07-21 22:07:28 | ternary | 1 | 69583 | 1 | 4.403 | 15803.5 |
| 272 | 2024-07-10 11:20:45 | ternary | 1 | 69583 | 1 | 4.703 | 14795.4 |
| 271 | 2024-07-01 06:21:00 | ternary | 1 | 69583 | 1 | 3.453 | 20151.5 |
| 270 | 2024-06-28 05:47:08 | ternary | 1 | 69583 | 1 | 4.750 | 14649.1 |
| 269 | 2024-06-24 21:17:06 | ternary | 1 | 69583 | 1 | 6.860 | 10143.3 |
| 268 | 2024-06-11 04:29:22 | ternary | 1 | 69583 | 1 | 5.733 | 12137.3 |
| 267 | 2024-06-08 06:20:43 | ternary | 2 | 107671 | 11 | 10.733 | 10031.8 |
| 266 | 2024-06-08 06:20:12 | ternary | 1 | 69583 | 1 | 3.216 | 21636.5 |
| 265 | 2024-05-30 17:42:05 | ternary | 3 | 134027 | 175 | 11.250 | 11913.5 |
| 264 | 2024-05-29 07:17:16 | ternary | 3 | 134027 | 175 | 15.156 | 8843.2 |
| 263 | 2024-05-28 18:56:53 | ternary | 3 | 134027 | 175 | 24.096 | 5562.2 |
| 262 | 2024-05-27 15:59:11 | ternary | 3 | 134027 | 175 | 17.876 | 7497.6 |
| 261 | 2024-05-27 06:19:22 | ternary | 3 | 134027 | 175 | 13.080 | 10246.7 |
| 260 | 2024-05-27 00:27:16 | ternary | 3 | 134027 | 175 | 20.266 | 6613.4 |
| 259 | 2024-05-27 00:27:21 | ternary | 2 | 107671 | 11 | 4.126 | 26095.7 |
| 258 | 2024-05-27 00:26:23 | ternary | 1 | 69583 | 1 | 1.390 | 50059.7 |
| 257 | 2024-05-17 02:55:31 | ternary | 1 | 69583 | 1 | 1.563 | 44518.9 |
| 256 | 2024-05-12 11:49:03 | ternary | 1 | 69583 | 1 | 3.826 | 18186.9 |
| 255 | 2024-05-01 19:45:41 | ternary | 1 | 69583 | 1 | 2.640 | 26357.2 |
| 254 | 2024-04-28 22:48:17 | ternary | 1 | 69583 | 1 | 2.766 | 25156.5 |
| 253 | 2024-04-27 22:44:21 | ternary | 2 | 107671 | 11 | 6.846 | 15727.6 |
| 252 | 2024-04-26 03:24:34 | ternary | 1 | 69583 | 1 | 1.283 | 54234.6 |
| 251 | 2024-04-20 23:27:49 | ternary | 3 | 134027 | 175 | 11.280 | 11881.8 |
| 250 | 2024-04-20 23:27:52 | ternary | 2 | 107671 | 11 | 3.780 | 28484.4 |
| 249 | 2024-04-20 23:27:09 | ternary | 1 | 69583 | 1 | 4.470 | 15566.7 |
| 248 | 2024-04-16 20:13:54 | ternary | 3 | 134027 | 175 | 24.890 | 5384.8 |
| 247 | 2024-04-14 09:39:14 | ternary | 3 | 134027 | 175 | 14.000 | 9573.4 |
| 246 | 2024-04-14 09:36:52 | ternary | 3 | 134027 | 175 | 9.610 | 13946.6 |
| 245 | 2024-04-13 11:48:32 | ternary | 2 | 107671 | 11 | 3.016 | 35699.9 |
| 244 | 2024-04-13 11:47:29 | ternary | 1 | 69583 | 1 | 2.203 | 31585.6 |
| 243 | 2024-04-13 11:47:16 | ternary | 3 | 134027 | 175 | 7.046 | 19021.7 |
| 242 | 2024-04-12 21:27:00 | ternary | 3 | 134027 | 175 | 7.373 | 18178.1 |
| 241 | 2024-03-29 07:11:28 | ternary | 1 | 69583 | 1 | 1.670 | 41666.5 |
| 240 | 2024-03-20 19:20:33 | ternary | 1 | 69583 | 1 | 1.296 | 53690.6 |
| 239 | 2024-02-27 18:41:10 | ternary | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 238 | 2024-02-24 15:51:41 | ternary | 3 | 134027 | 175 | 13.546 | 9894.2 |
| 237 | 2024-02-22 06:04:01 | ternary | 3 | 134027 | 175 | 11.096 | 12078.9 |