History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"preppy"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 320 | 2024-04-20 22:10:26 | preppy | 1 | 48755 | 3 | 1.610 | 30282.6 |
| 319 | 2024-04-19 15:40:47 | preppy | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 318 | 2024-04-17 07:52:18 | preppy | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 317 | 2024-04-14 09:30:16 | preppy | 3 | 112716 | 301 | 18.816 | 5990.4 |
| 316 | 2024-04-13 01:40:05 | preppy | 2 | 82551 | 32 | 2.953 | 27955.0 |
| 315 | 2024-04-13 01:40:01 | preppy | 3 | 112716 | 301 | 6.110 | 18447.8 |
| 314 | 2024-04-13 01:39:59 | preppy | 2 | 82551 | 32 | 2.733 | 30205.3 |
| 313 | 2024-04-13 01:39:57 | preppy | 1 | 48755 | 3 | 0.910 | 53576.9 |
| 312 | 2024-04-13 01:39:44 | preppy | 3 | 112716 | 301 | 6.016 | 18736.0 |
| 311 | 2024-04-11 06:14:26 | preppy | 3 | 112716 | 301 | 6.970 | 16171.6 |
| 310 | 2024-03-31 10:01:43 | preppy | 2 | 82551 | 32 | 8.220 | 10042.7 |
| 309 | 2024-03-31 10:01:38 | preppy | 3 | 112716 | 301 | 7.003 | 16095.4 |
| 308 | 2024-03-31 08:36:22 | preppy | 1 | 48755 | 3 | 1.016 | 47987.2 |
| 307 | 2024-03-29 01:39:41 | preppy | 1 | 48755 | 3 | 2.923 | 16679.8 |
| 306 | 2024-03-14 18:55:38 | preppy | 1 | 48755 | 3 | 2.940 | 16583.3 |
| 305 | 2024-02-29 18:38:26 | preppy | 2 | 82551 | 32 | 5.160 | 15998.3 |
| 304 | 2024-02-28 05:25:15 | preppy | 3 | 112716 | 301 | 22.686 | 4968.5 |
| 303 | 2024-02-27 22:48:17 | preppy | 2 | 82551 | 32 | 4.623 | 17856.6 |
| 302 | 2024-02-27 22:47:17 | preppy | 3 | 112716 | 301 | 9.360 | 12042.3 |
| 301 | 2024-02-27 22:35:17 | preppy | 1 | 48755 | 3 | 1.876 | 25988.8 |
| 300 | 2024-02-27 22:35:01 | preppy | 3 | 112716 | 301 | 8.470 | 13307.7 |
| 299 | 2024-02-27 22:34:58 | preppy | 2 | 82551 | 32 | 3.406 | 24236.9 |
| 298 | 2024-01-02 22:10:13 | preppy | 1 | 48755 | 3 | 0.840 | 58041.7 |
| 297 | 2023-12-11 10:25:15 | preppy | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 296 | 2023-12-09 18:28:18 | preppy | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 295 | 2023-12-05 11:34:07 | preppy | 3 | 112716 | 301 | 4.703 | 23966.8 |
| 294 | 2023-11-19 16:06:48 | preppy | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 293 | 2023-11-05 01:41:04 | preppy | 1 | 48755 | 3 | 0.846 | 57630.0 |
| 292 | 2023-10-22 14:50:45 | preppy | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 291 | 2023-10-19 21:59:24 | preppy | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 290 | 2023-10-13 10:06:21 | preppy | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 289 | 2023-10-05 03:55:44 | preppy | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 288 | 2023-09-24 08:29:49 | preppy | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 287 | 2023-09-21 02:55:40 | preppy | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 286 | 2023-09-12 20:29:53 | preppy | 1 | 48755 | 3 | 0.876 | 55656.4 |
| 285 | 2023-09-03 02:33:12 | preppy | 3 | 112716 | 301 | 5.093 | 22131.6 |
| 284 | 2023-08-19 03:40:34 | preppy | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 283 | 2023-05-19 03:08:45 | preppy | 3 | 112716 | 301 | 4.623 | 24381.6 |
| 282 | 2023-05-18 10:16:57 | preppy | 1 | 48755 | 3 | 0.810 | 60191.4 |
| 281 | 2023-05-13 19:27:59 | preppy | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 280 | 2023-03-07 15:57:25 | preppy | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 279 | 2023-02-23 05:44:34 | preppy | 3 | 112716 | 301 | 4.986 | 22606.5 |
| 278 | 2023-01-18 02:07:13 | preppy | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 277 | 2022-12-29 04:41:47 | preppy | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 276 | 2022-12-05 10:00:06 | preppy | 3 | 112716 | 301 | 5.310 | 21227.1 |
| 275 | 2022-09-16 22:46:49 | preppy | 1 | 48755 | 3 | 0.826 | 59025.4 |
| 274 | 2022-09-05 07:11:59 | preppy | 1 | 48755 | 3 | 0.923 | 52822.3 |
| 273 | 2022-07-19 02:04:16 | preppy | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 272 | 2022-07-01 11:56:25 | preppy | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 271 | 2022-04-15 08:47:43 | preppy | 1 | 48755 | 3 | 1.160 | 42030.2 |
| 270 | 2022-04-13 11:22:48 | preppy | 3 | 112716 | 301 | 5.626 | 20034.8 |
| 269 | 2022-03-06 10:12:16 | preppy | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 268 | 2022-03-04 05:19:40 | preppy | 1 | 48755 | 3 | 0.876 | 55656.4 |
| 267 | 2021-12-14 19:06:57 | preppy | 1 | 48755 | 3 | 0.826 | 59025.4 |
| 266 | 2021-12-11 11:29:05 | preppy | 1 | 48755 | 3 | 1.220 | 39963.1 |
| 265 | 2021-10-24 02:07:09 | preppy | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 264 | 2021-10-21 23:30:43 | preppy | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 263 | 2021-09-05 11:26:37 | preppy | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 262 | 2021-09-03 05:46:29 | preppy | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 261 | 2021-08-18 12:22:09 | preppy | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 260 | 2021-08-16 16:58:10 | preppy | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 259 | 2021-07-22 06:30:47 | preppy | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 258 | 2021-05-11 23:44:35 | preppy | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 257 | 2021-05-07 16:22:23 | preppy | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 256 | 2021-04-10 17:09:21 | preppy | 1 | 48755 | 3 | 1.516 | 32160.3 |
| 255 | 2021-03-14 17:57:04 | preppy | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 254 | 2021-01-14 22:30:59 | preppy | 1 | 48755 | 3 | 0.763 | 63899.1 |
| 253 | 2020-11-29 18:18:22 | preppy | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 252 | 2020-11-20 00:33:19 | preppy | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 251 | 2020-11-10 09:18:49 | preppy | 1 | 48755 | 3 | 1.593 | 30605.8 |
| 250 | 2020-10-31 08:54:15 | preppy | 2 | 82551 | 32 | 2.486 | 33206.4 |
| 249 | 2020-10-29 16:39:40 | preppy | 1 | 48755 | 3 | 0.783 | 62266.9 |
| 248 | 2020-10-06 06:17:15 | preppy | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 247 | 2020-09-30 10:51:56 | preppy | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 246 | 2020-09-20 11:07:36 | preppy | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 245 | 2020-08-22 16:44:40 | preppy | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 244 | 2020-07-23 10:53:19 | preppy | 1 | 48755 | 3 | 0.783 | 62266.9 |
| 243 | 2020-06-14 10:24:10 | preppy | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 242 | 2020-03-28 18:00:23 | preppy | 1 | 48755 | 3 | 1.013 | 48129.3 |
| 241 | 2020-03-24 12:01:51 | preppy | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 240 | 2020-03-24 02:50:44 | preppy | 1 | 48755 | 3 | 0.856 | 56956.8 |
| 239 | 2020-03-19 22:55:12 | preppy | 1 | 48755 | 3 | 0.846 | 57630.0 |
| 238 | 2020-03-18 23:33:11 | preppy | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 237 | 2020-03-12 16:27:06 | preppy | 1 | 48755 | 3 | 0.763 | 63899.1 |
| 236 | 2020-02-28 23:45:26 | preppy | 1 | 48755 | 3 | 0.903 | 53992.2 |
| 235 | 2020-02-27 19:51:39 | preppy | 3 | 112716 | 301 | 9.156 | 12310.6 |
| 234 | 2020-02-27 17:06:13 | preppy | 3 | 112716 | 301 | 6.876 | 16392.7 |
| 233 | 2020-02-27 14:12:19 | preppy | 3 | 112716 | 301 | 11.000 | 10246.9 |
| 232 | 2020-02-22 08:49:19 | preppy | 1 | 48755 | 3 | 1.000 | 48755.0 |
| 231 | 2020-02-17 11:58:38 | preppy | 3 | 112716 | 301 | 10.610 | 10623.6 |
| 230 | 2020-02-17 05:37:12 | preppy | 3 | 112716 | 301 | 10.266 | 10979.5 |
| 229 | 2020-02-17 01:32:20 | preppy | 3 | 112716 | 301 | 15.643 | 7205.5 |
| 228 | 2020-02-15 13:13:28 | preppy | 3 | 112716 | 301 | 12.736 | 8850.2 |
| 227 | 2020-02-12 20:42:24 | preppy | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 226 | 2020-02-09 11:34:56 | preppy | 1 | 48755 | 3 | 0.970 | 50262.9 |
| 225 | 2020-02-06 22:46:42 | preppy | 1 | 48755 | 3 | 1.890 | 25796.3 |
| 224 | 2020-02-03 15:53:45 | preppy | 1 | 48755 | 3 | 0.920 | 52994.6 |
| 223 | 2020-01-29 17:50:56 | preppy | 1 | 48755 | 3 | 2.093 | 23294.3 |
| 222 | 2020-01-23 17:56:42 | preppy | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 221 | 2020-01-17 16:36:15 | preppy | 1 | 48755 | 3 | 1.063 | 45865.5 |