History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"swanny"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 284 | 2024-04-30 10:21:56 | swanny | 1 | 48755 | 3 | 2.580 | 18897.3 |
| 283 | 2024-04-27 09:46:43 | swanny | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 282 | 2024-04-10 04:06:16 | swanny | 3 | 112716 | 422 | 4.986 | 22606.5 |
| 281 | 2024-04-09 00:18:48 | swanny | 2 | 82551 | 48 | 3.110 | 26543.7 |
| 280 | 2024-04-08 16:39:28 | swanny | 3 | 112716 | 422 | 26.390 | 4271.2 |
| 279 | 2024-04-08 08:13:38 | swanny | 2 | 82551 | 48 | 4.533 | 18211.1 |
| 278 | 2024-04-08 08:13:22 | swanny | 3 | 112716 | 422 | 6.376 | 17678.2 |
| 277 | 2024-04-07 17:34:23 | swanny | 3 | 112716 | 422 | 20.206 | 5578.3 |
| 276 | 2024-04-06 06:47:37 | swanny | 3 | 112716 | 422 | 10.420 | 10817.3 |
| 275 | 2024-04-06 06:47:36 | swanny | 2 | 82551 | 48 | 3.046 | 27101.4 |
| 274 | 2024-04-06 06:47:27 | swanny | 1 | 48755 | 3 | 1.093 | 44606.6 |
| 273 | 2024-01-16 19:19:00 | swanny | 3 | 112716 | 422 | 5.376 | 20966.5 |
| 272 | 2024-01-16 19:18:59 | swanny | 2 | 82551 | 48 | 2.486 | 33206.4 |
| 271 | 2024-01-03 22:35:38 | swanny | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 270 | 2023-12-11 09:44:19 | swanny | 3 | 112716 | 422 | 4.953 | 22757.1 |
| 269 | 2023-11-26 01:11:29 | swanny | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 268 | 2023-11-17 20:16:08 | swanny | 1 | 48755 | 3 | 1.483 | 32875.9 |
| 267 | 2023-11-11 01:43:59 | swanny | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 266 | 2023-11-06 23:50:26 | swanny | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 265 | 2023-10-24 22:11:58 | swanny | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 264 | 2023-10-20 11:38:46 | swanny | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 263 | 2023-10-15 12:27:55 | swanny | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 262 | 2023-10-05 19:52:47 | swanny | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 261 | 2023-09-24 08:30:33 | swanny | 1 | 48755 | 3 | 0.783 | 62266.9 |
| 260 | 2023-09-16 13:19:40 | swanny | 2 | 82551 | 48 | 2.576 | 32046.2 |
| 259 | 2023-09-13 15:48:24 | swanny | 3 | 112716 | 422 | 5.330 | 21147.5 |
| 258 | 2023-09-10 16:38:00 | swanny | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 257 | 2023-09-07 15:04:39 | swanny | 3 | 112716 | 422 | 4.576 | 24632.0 |
| 256 | 2023-08-19 14:17:48 | swanny | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 255 | 2023-07-23 22:03:08 | swanny | 3 | 112716 | 422 | 4.780 | 23580.8 |
| 254 | 2023-05-24 04:29:07 | swanny | 3 | 112716 | 422 | 4.750 | 23729.7 |
| 253 | 2023-05-21 07:41:44 | swanny | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 252 | 2023-03-01 15:57:22 | swanny | 3 | 112716 | 422 | 4.500 | 25048.0 |
| 251 | 2023-01-03 11:33:54 | swanny | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 250 | 2022-12-09 12:13:24 | swanny | 3 | 112716 | 422 | 5.140 | 21929.2 |
| 249 | 2022-09-25 14:20:56 | swanny | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 248 | 2022-08-29 00:52:46 | swanny | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 247 | 2022-08-25 18:59:31 | swanny | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 246 | 2022-08-18 17:54:56 | swanny | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 245 | 2022-07-26 12:35:56 | swanny | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 244 | 2022-07-23 23:33:50 | swanny | 3 | 112716 | 422 | 4.860 | 23192.6 |
| 243 | 2022-07-14 00:57:06 | swanny | 2 | 82551 | 48 | 2.440 | 33832.4 |
| 242 | 2022-05-14 17:50:51 | swanny | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 241 | 2022-05-12 13:10:00 | swanny | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 240 | 2022-01-31 13:31:06 | swanny | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 239 | 2022-01-29 09:00:32 | swanny | 1 | 48755 | 3 | 0.856 | 56956.8 |
| 238 | 2021-11-25 00:09:48 | swanny | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 237 | 2021-11-24 15:47:10 | swanny | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 236 | 2021-11-24 05:15:02 | swanny | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 235 | 2021-11-23 13:19:06 | swanny | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 234 | 2021-11-23 02:16:05 | swanny | 1 | 48755 | 3 | 0.876 | 55656.4 |
| 233 | 2021-11-22 17:24:19 | swanny | 1 | 48755 | 3 | 0.966 | 50471.0 |
| 232 | 2021-11-22 12:16:50 | swanny | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 231 | 2021-10-14 21:36:27 | swanny | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 230 | 2021-10-12 17:23:21 | swanny | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 229 | 2021-10-11 20:18:29 | swanny | 1 | 48755 | 3 | 0.763 | 63899.1 |
| 228 | 2021-10-10 17:15:01 | swanny | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 227 | 2021-10-08 06:57:50 | swanny | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 226 | 2021-09-22 09:32:42 | swanny | 1 | 48755 | 3 | 1.186 | 41108.8 |
| 225 | 2021-09-21 20:39:27 | swanny | 1 | 48755 | 3 | 0.763 | 63899.1 |
| 224 | 2021-09-21 03:21:51 | swanny | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 223 | 2021-09-17 01:42:21 | swanny | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 222 | 2021-09-15 04:35:38 | swanny | 1 | 48755 | 3 | 0.856 | 56956.8 |
| 221 | 2021-05-08 14:03:15 | swanny | 1 | 48755 | 3 | 0.966 | 50471.0 |
| 220 | 2021-04-07 00:45:22 | swanny | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 219 | 2021-01-26 09:26:34 | swanny | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 218 | 2021-01-22 04:42:46 | swanny | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 217 | 2020-10-29 09:43:04 | swanny | 1 | 48755 | 3 | 1.580 | 30857.6 |
| 216 | 2020-10-07 12:16:21 | swanny | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 215 | 2020-08-30 09:20:57 | swanny | 1 | 48755 | 3 | 0.783 | 62266.9 |
| 214 | 2020-06-15 04:18:42 | swanny | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 213 | 2020-03-30 00:37:32 | swanny | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 212 | 2020-03-28 08:53:03 | swanny | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 211 | 2020-03-24 18:47:02 | swanny | 1 | 48755 | 3 | 1.393 | 35000.0 |
| 210 | 2020-03-24 04:35:00 | swanny | 1 | 48755 | 3 | 1.766 | 27607.6 |
| 209 | 2020-03-24 01:56:13 | swanny | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 208 | 2020-03-20 09:26:42 | swanny | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 207 | 2020-03-20 08:12:36 | swanny | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 206 | 2020-03-11 14:57:58 | swanny | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 205 | 2020-03-01 09:14:00 | swanny | 1 | 48755 | 3 | 1.610 | 30282.6 |
| 204 | 2020-03-01 04:43:50 | swanny | 1 | 48755 | 3 | 1.560 | 31253.2 |
| 203 | 2020-02-22 09:54:08 | swanny | 1 | 48755 | 3 | 0.983 | 49598.2 |
| 202 | 2020-02-12 15:23:22 | swanny | 1 | 48755 | 3 | 1.780 | 27390.4 |
| 201 | 2020-02-09 22:04:02 | swanny | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 200 | 2020-02-08 09:36:45 | swanny | 1 | 48755 | 3 | 2.140 | 22782.7 |
| 199 | 2020-02-04 06:03:08 | swanny | 1 | 48755 | 3 | 1.766 | 27607.6 |
| 198 | 2020-01-30 14:05:21 | swanny | 1 | 48755 | 3 | 0.903 | 53992.2 |
| 197 | 2020-01-26 05:04:19 | swanny | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 196 | 2020-01-23 00:06:44 | swanny | 1 | 48755 | 3 | 1.906 | 25579.7 |
| 195 | 2020-01-17 04:56:45 | swanny | 1 | 48755 | 3 | 1.860 | 26212.4 |
| 194 | 2020-01-15 22:05:46 | swanny | 1 | 48755 | 3 | 1.906 | 25579.7 |
| 193 | 2020-01-13 13:20:02 | swanny | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 192 | 2020-01-04 03:11:29 | swanny | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 191 | 2019-12-28 21:37:23 | swanny | 1 | 48755 | 3 | 1.826 | 26700.4 |
| 190 | 2019-12-26 20:22:56 | swanny | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 189 | 2019-12-26 17:48:42 | swanny | 1 | 48755 | 3 | 0.856 | 56956.8 |
| 188 | 2019-12-26 06:51:57 | swanny | 1 | 48755 | 3 | 1.750 | 27860.0 |
| 187 | 2019-11-27 02:18:27 | swanny | 1 | 48755 | 3 | 0.846 | 57630.0 |
| 186 | 2019-08-25 08:50:23 | swanny | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 185 | 2019-06-04 14:04:15 | swanny | 1 | 48755 | 3 | 0.910 | 53576.9 |