History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"preference"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 323 | 2025-05-30 04:15:36 | preference | 4 | 161450 | 160 | 60.800 | 2655.4 |
| 322 | 2025-05-27 20:34:32 | preference | 2 | 108824 | 8 | 4.343 | 25057.3 |
| 321 | 2025-05-27 05:16:31 | preference | 1 | 67641 | 3 | 8.610 | 7856.1 |
| 320 | 2025-05-23 12:10:16 | preference | 1 | 67641 | 3 | 1.250 | 54112.8 |
| 319 | 2025-05-19 10:59:20 | preference | 1 | 67641 | 3 | 1.190 | 56841.2 |
| 318 | 2025-05-15 19:33:12 | preference | 3 | 140603 | 38 | 6.516 | 21578.1 |
| 317 | 2025-05-15 15:58:55 | preference | 3 | 140603 | 38 | 6.356 | 22121.3 |
| 316 | 2025-05-14 12:36:03 | preference | 1 | 67641 | 3 | 4.280 | 15804.0 |
| 315 | 2025-05-06 12:55:44 | preference | 1 | 67641 | 3 | 3.530 | 19161.8 |
| 314 | 2025-05-05 13:05:15 | preference | 1 | 67641 | 3 | 1.266 | 53428.9 |
| 313 | 2025-04-26 00:57:59 | preference | 1 | 67641 | 3 | 4.686 | 14434.7 |
| 312 | 2025-04-18 13:33:40 | preference | 3 | 140603 | 38 | 33.316 | 4220.3 |
| 311 | 2025-04-18 02:12:23 | preference | 3 | 140603 | 38 | 35.016 | 4015.4 |
| 310 | 2025-04-13 01:24:53 | preference | 3 | 140603 | 38 | 5.703 | 24654.2 |
| 309 | 2025-04-10 18:09:12 | preference | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 308 | 2025-04-05 19:27:12 | preference | 1 | 67641 | 3 | 5.783 | 11696.5 |
| 307 | 2025-04-02 15:14:53 | preference | 1 | 67641 | 3 | 7.876 | 8588.2 |
| 306 | 2025-03-21 04:15:23 | preference | 3 | 140603 | 38 | 16.670 | 8434.5 |
| 305 | 2025-03-18 07:35:46 | preference | 3 | 140603 | 38 | 34.750 | 4046.1 |
| 304 | 2025-03-11 03:11:17 | preference | 3 | 140603 | 38 | 38.453 | 3656.5 |
| 303 | 2025-03-11 03:02:25 | preference | 2 | 108824 | 8 | 8.093 | 13446.7 |
| 302 | 2025-03-08 23:36:39 | preference | 3 | 140603 | 38 | 35.250 | 3988.7 |
| 301 | 2025-03-08 23:36:39 | preference | 2 | 108824 | 8 | 10.516 | 10348.4 |
| 300 | 2025-03-08 23:35:35 | preference | 1 | 67641 | 3 | 5.766 | 11731.0 |
| 299 | 2025-03-05 05:15:41 | preference | 1 | 67641 | 3 | 5.940 | 11387.4 |
| 298 | 2025-02-14 14:03:49 | preference | 1 | 67641 | 3 | 5.610 | 12057.2 |
| 297 | 2025-02-11 21:26:38 | preference | 1 | 67641 | 3 | 5.143 | 13152.1 |
| 296 | 2025-02-01 20:09:17 | preference | 1 | 67641 | 3 | 6.186 | 10934.5 |
| 295 | 2025-01-25 22:18:11 | preference | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 294 | 2025-01-18 01:11:22 | preference | 3 | 140603 | 38 | 39.016 | 3603.7 |
| 293 | 2025-01-12 02:46:16 | preference | 3 | 140603 | 38 | 30.503 | 4609.5 |
| 292 | 2025-01-12 02:42:55 | preference | 1 | 67641 | 3 | 8.486 | 7970.9 |
| 291 | 2025-01-11 18:31:19 | preference | 1 | 67641 | 3 | 6.080 | 11125.2 |
| 290 | 2025-01-10 21:31:16 | preference | 3 | 140603 | 38 | 27.736 | 5069.3 |
| 289 | 2025-01-10 16:12:06 | preference | 3 | 140603 | 38 | 37.596 | 3739.8 |
| 288 | 2024-12-31 19:13:33 | preference | 2 | 108824 | 8 | 16.126 | 6748.4 |
| 287 | 2024-12-31 19:13:21 | preference | 1 | 67641 | 3 | 3.203 | 21118.0 |
| 286 | 2024-12-18 17:58:50 | preference | 3 | 140603 | 38 | 29.940 | 4696.2 |
| 285 | 2024-12-12 19:06:13 | preference | 2 | 108824 | 8 | 12.970 | 8390.4 |
| 284 | 2024-12-12 19:03:58 | preference | 1 | 67641 | 3 | 5.156 | 13118.9 |
| 283 | 2024-12-09 19:01:24 | preference | 1 | 67641 | 3 | 5.153 | 13126.5 |
| 282 | 2024-12-06 00:25:06 | preference | 3 | 140603 | 38 | 33.300 | 4222.3 |
| 281 | 2024-12-03 12:22:39 | preference | 3 | 140603 | 38 | 17.343 | 8107.2 |
| 280 | 2024-11-27 21:55:59 | preference | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 279 | 2024-11-22 00:39:14 | preference | 1 | 67641 | 3 | 2.906 | 23276.3 |
| 278 | 2024-11-15 05:51:57 | preference | 3 | 140603 | 38 | 31.893 | 4408.6 |
| 277 | 2024-11-15 05:51:24 | preference | 2 | 108824 | 8 | 9.190 | 11841.6 |
| 276 | 2024-11-07 12:01:17 | preference | 2 | 108824 | 8 | 30.733 | 3540.9 |
| 275 | 2024-11-07 11:11:05 | preference | 1 | 67641 | 3 | 2.373 | 28504.4 |
| 274 | 2024-11-03 18:28:14 | preference | 3 | 140603 | 38 | 30.676 | 4583.5 |
| 273 | 2024-11-02 13:17:57 | preference | 3 | 140603 | 38 | 29.286 | 4801.0 |
| 272 | 2024-11-02 05:47:16 | preference | 3 | 140603 | 38 | 41.786 | 3364.8 |
| 271 | 2024-11-01 17:49:28 | preference | 4 | 161450 | 160 | 59.333 | 2721.1 |
| 270 | 2024-10-25 21:54:18 | preference | 1 | 67641 | 3 | 5.360 | 12619.6 |
| 269 | 2024-10-24 02:25:58 | preference | 4 | 161450 | 160 | 33.173 | 4866.9 |
| 268 | 2024-10-18 13:09:47 | preference | 1 | 67641 | 3 | 5.800 | 11662.2 |
| 267 | 2024-10-16 22:50:39 | preference | 3 | 140603 | 38 | 29.016 | 4845.7 |
| 266 | 2024-10-16 07:03:27 | preference | 1 | 67641 | 3 | 3.106 | 21777.5 |
| 265 | 2024-10-13 07:02:05 | preference | 3 | 140603 | 38 | 26.470 | 5311.8 |
| 264 | 2024-10-09 21:03:59 | preference | 3 | 140603 | 38 | 25.173 | 5585.5 |
| 263 | 2024-10-08 02:21:46 | preference | 2 | 108824 | 8 | 21.906 | 4967.8 |
| 262 | 2024-10-08 02:20:21 | preference | 1 | 67641 | 3 | 4.080 | 16578.7 |
| 261 | 2024-10-06 07:27:29 | preference | 3 | 140603 | 38 | 49.336 | 2849.9 |
| 260 | 2024-10-03 12:17:09 | preference | 3 | 140603 | 38 | 58.243 | 2414.1 |
| 259 | 2024-10-03 03:26:50 | preference | 3 | 140603 | 38 | 48.263 | 2913.3 |
| 258 | 2024-10-01 19:43:35 | preference | 4 | 161450 | 160 | 102.176 | 1580.1 |
| 257 | 2024-10-01 19:43:37 | preference | 3 | 140603 | 38 | 51.523 | 2728.9 |
| 256 | 2024-10-01 19:43:54 | preference | 2 | 108824 | 8 | 26.363 | 4127.9 |
| 255 | 2024-10-01 19:40:21 | preference | 1 | 67641 | 3 | 6.610 | 10233.1 |
| 254 | 2024-09-04 06:51:27 | preference | 1 | 67641 | 3 | 9.220 | 7336.3 |
| 253 | 2024-08-20 21:30:43 | preference | 1 | 67641 | 3 | 4.376 | 15457.3 |
| 252 | 2024-07-29 09:18:37 | preference | 1 | 67641 | 3 | 6.670 | 10141.1 |
| 251 | 2024-07-29 09:18:03 | preference | 1 | 67641 | 3 | 2.983 | 22675.5 |
| 250 | 2024-07-28 14:16:50 | preference | 1 | 67641 | 3 | 5.550 | 12187.6 |
| 249 | 2024-07-19 01:36:40 | preference | 2 | 108824 | 8 | 5.936 | 18332.9 |
| 248 | 2024-07-18 17:12:00 | preference | 3 | 140603 | 38 | 20.563 | 6837.7 |
| 247 | 2024-07-17 22:26:57 | preference | 2 | 108824 | 8 | 11.830 | 9199.0 |
| 246 | 2024-07-16 10:24:56 | preference | 1 | 67641 | 3 | 4.656 | 14527.7 |
| 245 | 2024-07-16 10:13:33 | preference | 1 | 67641 | 3 | 4.080 | 16578.7 |
| 244 | 2024-07-16 08:16:45 | preference | 4 | 161450 | 160 | 53.346 | 3026.5 |
| 243 | 2024-07-16 08:16:20 | preference | 3 | 140603 | 38 | 20.580 | 6832.0 |
| 242 | 2024-07-16 08:13:38 | preference | 1 | 67641 | 3 | 2.093 | 32317.7 |
| 241 | 2024-07-15 22:40:10 | preference | 4 | 161450 | 160 | 37.626 | 4290.9 |
| 240 | 2024-07-15 21:57:36 | preference | 4 | 161450 | 160 | 20.673 | 7809.7 |
| 239 | 2024-07-15 12:37:11 | preference | 3 | 140603 | 38 | 16.610 | 8465.0 |
| 238 | 2024-07-15 10:28:29 | preference | 4 | 161450 | 160 | 59.586 | 2709.5 |
| 237 | 2024-07-15 10:28:31 | preference | 3 | 140603 | 38 | 37.236 | 3776.0 |
| 236 | 2024-07-15 10:28:32 | preference | 2 | 108824 | 8 | 14.643 | 7431.8 |
| 235 | 2024-07-15 10:25:36 | preference | 1 | 67641 | 3 | 1.703 | 39718.7 |
| 234 | 2024-07-06 00:58:00 | preference | 1 | 67641 | 3 | 2.513 | 26916.4 |
| 233 | 2024-07-05 16:28:53 | preference | 1 | 67641 | 3 | 3.703 | 18266.5 |
| 232 | 2024-07-01 18:12:01 | preference | 1 | 67641 | 3 | 5.906 | 11452.9 |
| 231 | 2024-06-29 03:53:01 | preference | 1 | 67641 | 3 | 5.780 | 11702.6 |
| 230 | 2024-06-27 16:50:32 | preference | 3 | 140603 | 38 | 14.580 | 9643.6 |
| 229 | 2024-06-26 09:29:31 | preference | 3 | 140603 | 38 | 12.486 | 11260.9 |
| 228 | 2024-06-26 09:29:15 | preference | 3 | 140603 | 38 | 25.266 | 5564.9 |
| 227 | 2024-06-12 23:11:15 | preference | 3 | 140603 | 38 | 18.660 | 7535.0 |
| 226 | 2024-06-11 18:03:51 | preference | 4 | 161450 | 160 | 55.160 | 2926.9 |
| 225 | 2024-06-09 19:53:33 | preference | 4 | 161450 | 160 | 49.143 | 3285.3 |
| 224 | 2024-06-09 01:58:16 | preference | 4 | 161450 | 160 | 37.846 | 4266.0 |