History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"deflea"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 314 | 2024-04-14 04:30:08 | deflea | 1 | 48755 | 3 | 0.966 | 50471.0 |
| 313 | 2024-04-11 07:19:36 | deflea | 3 | 112716 | 371 | 6.126 | 18399.6 |
| 312 | 2024-04-11 06:36:42 | deflea | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 311 | 2024-04-01 02:18:43 | deflea | 3 | 112716 | 371 | 11.626 | 9695.2 |
| 310 | 2024-04-01 02:18:47 | deflea | 2 | 82551 | 28 | 6.610 | 12488.8 |
| 309 | 2024-04-01 02:18:50 | deflea | 1 | 48755 | 3 | 0.970 | 50262.9 |
| 308 | 2024-04-01 02:18:36 | deflea | 1 | 48755 | 3 | 1.876 | 25988.8 |
| 307 | 2024-04-01 02:18:22 | deflea | 3 | 112716 | 371 | 11.970 | 9416.5 |
| 306 | 2024-04-01 02:18:25 | deflea | 2 | 82551 | 28 | 4.250 | 19423.8 |
| 305 | 2024-03-30 01:52:29 | deflea | 1 | 48755 | 3 | 1.890 | 25796.3 |
| 304 | 2024-03-29 01:26:12 | deflea | 1 | 48755 | 3 | 1.860 | 26212.4 |
| 303 | 2024-03-11 22:35:29 | deflea | 1 | 48755 | 3 | 2.203 | 22131.2 |
| 302 | 2024-01-28 04:49:07 | deflea | 1 | 48755 | 3 | 0.846 | 57630.0 |
| 301 | 2024-01-24 03:32:03 | deflea | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 300 | 2023-12-27 23:29:30 | deflea | 2 | 82551 | 28 | 2.376 | 34743.7 |
| 299 | 2023-12-11 12:04:34 | deflea | 3 | 112716 | 371 | 4.766 | 23650.0 |
| 298 | 2023-12-05 14:54:59 | deflea | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 297 | 2023-11-25 07:32:53 | deflea | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 296 | 2023-11-21 15:58:40 | deflea | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 295 | 2023-11-20 19:30:51 | deflea | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 294 | 2023-10-24 09:06:58 | deflea | 1 | 48755 | 3 | 1.093 | 44606.6 |
| 293 | 2023-10-24 03:04:04 | deflea | 1 | 48755 | 3 | 1.390 | 35075.5 |
| 292 | 2023-10-15 18:23:37 | deflea | 2 | 82551 | 28 | 2.736 | 30172.1 |
| 291 | 2023-10-15 04:28:58 | deflea | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 290 | 2023-10-08 12:31:07 | deflea | 2 | 82551 | 28 | 2.220 | 37185.1 |
| 289 | 2023-10-05 02:08:53 | deflea | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 288 | 2023-10-03 02:39:40 | deflea | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 287 | 2023-10-03 02:07:53 | deflea | 2 | 82551 | 28 | 2.110 | 39123.7 |
| 286 | 2023-09-29 17:58:20 | deflea | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 285 | 2023-09-28 12:54:57 | deflea | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 284 | 2023-09-11 00:33:09 | deflea | 3 | 112716 | 371 | 5.656 | 19928.6 |
| 283 | 2023-09-10 10:13:26 | deflea | 3 | 112716 | 371 | 4.546 | 24794.5 |
| 282 | 2023-09-07 07:56:10 | deflea | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 281 | 2023-07-13 09:10:57 | deflea | 2 | 82551 | 28 | 2.326 | 35490.5 |
| 280 | 2023-06-12 20:55:37 | deflea | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 279 | 2023-06-11 05:53:28 | deflea | 1 | 48755 | 3 | 0.716 | 68093.6 |
| 278 | 2023-06-02 09:42:01 | deflea | 3 | 112716 | 371 | 10.716 | 10518.5 |
| 277 | 2023-04-01 15:26:22 | deflea | 2 | 82551 | 28 | 2.296 | 35954.3 |
| 276 | 2023-03-30 07:15:32 | deflea | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 275 | 2023-03-10 10:08:37 | deflea | 3 | 112716 | 371 | 4.563 | 24702.2 |
| 274 | 2023-02-18 03:22:53 | deflea | 1 | 48755 | 3 | 0.720 | 67715.3 |
| 273 | 2023-02-14 15:30:10 | deflea | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 272 | 2023-01-12 17:01:20 | deflea | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 271 | 2022-12-28 16:26:56 | deflea | 2 | 82551 | 28 | 2.076 | 39764.5 |
| 270 | 2022-12-14 14:36:20 | deflea | 3 | 112716 | 371 | 4.580 | 24610.5 |
| 269 | 2022-10-24 19:08:20 | deflea | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 268 | 2022-10-21 15:18:30 | deflea | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 267 | 2022-10-21 05:08:06 | deflea | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 266 | 2022-08-29 20:55:23 | deflea | 2 | 82551 | 28 | 2.190 | 37694.5 |
| 265 | 2022-08-07 15:41:18 | deflea | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 264 | 2022-08-03 17:35:16 | deflea | 3 | 112716 | 371 | 4.530 | 24882.1 |
| 263 | 2022-07-05 01:29:41 | deflea | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 262 | 2022-06-11 16:59:19 | deflea | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 261 | 2022-04-10 01:37:05 | deflea | 2 | 82551 | 28 | 2.110 | 39123.7 |
| 260 | 2022-03-10 22:15:24 | deflea | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 259 | 2022-03-07 09:01:36 | deflea | 3 | 112716 | 371 | 5.516 | 20434.4 |
| 258 | 2022-02-23 13:51:25 | deflea | 1 | 48755 | 3 | 1.110 | 43923.4 |
| 257 | 2022-02-21 10:41:07 | deflea | 1 | 48755 | 3 | 1.013 | 48129.3 |
| 256 | 2021-12-06 09:57:23 | deflea | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 255 | 2021-11-24 08:22:11 | deflea | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 254 | 2021-11-20 11:05:06 | deflea | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 253 | 2021-10-30 03:06:01 | deflea | 1 | 48755 | 3 | 0.763 | 63899.1 |
| 252 | 2021-08-14 06:34:04 | deflea | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 251 | 2021-07-06 14:33:55 | deflea | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 250 | 2021-05-19 09:16:29 | deflea | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 249 | 2021-05-10 00:06:40 | deflea | 1 | 48755 | 3 | 0.950 | 51321.1 |
| 248 | 2021-02-26 03:29:59 | deflea | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 247 | 2021-02-26 01:19:09 | deflea | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 246 | 2021-02-24 19:01:29 | deflea | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 245 | 2021-02-04 12:14:03 | deflea | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 244 | 2021-01-31 19:55:50 | deflea | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 243 | 2021-01-30 00:11:24 | deflea | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 242 | 2021-01-04 02:21:39 | deflea | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 241 | 2021-01-01 19:04:29 | deflea | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 240 | 2020-12-07 01:44:14 | deflea | 1 | 48755 | 3 | 0.810 | 60191.4 |
| 239 | 2020-11-14 15:35:13 | deflea | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 238 | 2020-11-06 17:02:02 | deflea | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 237 | 2020-11-03 03:45:02 | deflea | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 236 | 2020-10-19 21:25:20 | deflea | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 235 | 2020-09-24 00:54:36 | deflea | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 234 | 2020-09-04 20:34:51 | deflea | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 233 | 2020-09-04 12:52:00 | deflea | 1 | 48755 | 3 | 0.783 | 62266.9 |
| 232 | 2020-07-31 00:41:55 | deflea | 1 | 48755 | 3 | 0.783 | 62266.9 |
| 231 | 2020-04-28 14:16:49 | deflea | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 230 | 2020-04-18 06:24:33 | deflea | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 229 | 2020-04-17 06:28:20 | deflea | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 228 | 2020-04-16 07:06:40 | deflea | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 227 | 2020-03-29 16:19:20 | deflea | 1 | 48755 | 3 | 1.640 | 29728.7 |
| 226 | 2020-03-28 08:28:02 | deflea | 1 | 48755 | 3 | 1.126 | 43299.3 |
| 225 | 2020-03-28 00:54:55 | deflea | 1 | 48755 | 3 | 0.876 | 55656.4 |
| 224 | 2020-03-24 13:43:02 | deflea | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 223 | 2020-03-24 02:35:33 | deflea | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 222 | 2020-03-20 14:46:49 | deflea | 1 | 48755 | 3 | 0.893 | 54596.9 |
| 221 | 2020-02-28 02:44:33 | deflea | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 220 | 2020-02-21 14:01:45 | deflea | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 219 | 2020-02-10 01:43:45 | deflea | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 218 | 2020-02-09 11:31:52 | deflea | 1 | 48755 | 3 | 0.923 | 52822.3 |
| 217 | 2020-02-05 22:57:28 | deflea | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 216 | 2020-02-05 11:11:32 | deflea | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 215 | 2020-01-29 06:44:12 | deflea | 1 | 48755 | 3 | 1.123 | 43415.0 |