History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"whanged"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 300 | 2024-05-07 01:28:27 | whanged | 1 | 69583 | 5 | 1.346 | 51696.1 |
| 299 | 2024-05-01 13:58:08 | whanged | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 298 | 2024-01-06 14:25:28 | whanged | 1 | 69583 | 5 | 1.060 | 65644.3 |
| 297 | 2023-12-02 00:32:02 | whanged | 1 | 69583 | 5 | 1.140 | 61037.7 |
| 296 | 2023-11-19 18:42:29 | whanged | 1 | 69583 | 5 | 1.000 | 69583.0 |
| 295 | 2023-11-18 14:11:51 | whanged | 1 | 69583 | 5 | 1.016 | 68487.2 |
| 294 | 2023-11-11 12:24:47 | whanged | 1 | 69583 | 5 | 2.326 | 29915.3 |
| 293 | 2023-10-30 12:13:40 | whanged | 1 | 69583 | 5 | 1.280 | 54361.7 |
| 292 | 2023-10-22 02:59:15 | whanged | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 291 | 2023-10-17 21:07:00 | whanged | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 290 | 2023-09-27 04:47:03 | whanged | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 289 | 2023-09-23 22:55:42 | whanged | 1 | 69583 | 5 | 2.033 | 34226.8 |
| 288 | 2023-08-23 16:30:35 | whanged | 1 | 69583 | 5 | 1.033 | 67360.1 |
| 287 | 2023-05-26 21:10:30 | whanged | 1 | 69583 | 5 | 1.013 | 68690.0 |
| 286 | 2023-03-23 19:13:53 | whanged | 1 | 69583 | 5 | 1.013 | 68690.0 |
| 285 | 2023-01-08 03:20:41 | whanged | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 284 | 2022-10-12 05:14:03 | whanged | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 283 | 2022-05-30 14:08:57 | whanged | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 282 | 2022-05-18 14:25:30 | whanged | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 281 | 2022-03-01 02:24:05 | whanged | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 280 | 2021-10-10 18:28:39 | whanged | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 279 | 2021-09-21 17:51:22 | whanged | 1 | 69583 | 5 | 1.016 | 68487.2 |
| 278 | 2021-09-07 03:44:38 | whanged | 3 | 134027 | 489 | 5.656 | 23696.4 |
| 277 | 2021-07-21 17:22:04 | whanged | 3 | 134027 | 489 | 10.670 | 12561.1 |
| 276 | 2021-07-04 15:16:17 | whanged | 3 | 134027 | 489 | 6.690 | 20033.9 |
| 275 | 2021-06-16 23:53:54 | whanged | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 274 | 2021-06-12 01:20:12 | whanged | 3 | 134027 | 489 | 5.516 | 24297.9 |
| 273 | 2021-05-23 05:21:18 | whanged | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 272 | 2021-05-18 16:17:11 | whanged | 3 | 134027 | 489 | 6.390 | 20974.5 |
| 271 | 2021-05-14 01:12:25 | whanged | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 270 | 2021-04-27 17:25:18 | whanged | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 269 | 2021-03-27 17:38:07 | whanged | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 268 | 2021-02-17 09:30:02 | whanged | 3 | 134027 | 489 | 5.890 | 22755.0 |
| 267 | 2021-02-15 11:44:53 | whanged | 3 | 134027 | 489 | 6.513 | 20578.4 |
| 266 | 2021-01-11 01:12:03 | whanged | 1 | 69583 | 5 | 1.030 | 67556.3 |
| 265 | 2020-11-17 03:44:21 | whanged | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 264 | 2020-11-11 04:09:36 | whanged | 3 | 134027 | 489 | 5.796 | 23124.1 |
| 263 | 2020-10-31 20:57:04 | whanged | 1 | 69583 | 5 | 1.143 | 60877.5 |
| 262 | 2020-10-23 20:30:07 | whanged | 1 | 69583 | 5 | 1.030 | 67556.3 |
| 261 | 2020-10-23 08:59:53 | whanged | 1 | 69583 | 5 | 1.126 | 61796.6 |
| 260 | 2020-10-15 00:15:41 | whanged | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 259 | 2020-09-09 22:56:19 | whanged | 1 | 69583 | 5 | 1.030 | 67556.3 |
| 258 | 2020-07-18 15:16:50 | whanged | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 257 | 2020-04-19 05:09:39 | whanged | 1 | 69583 | 5 | 1.033 | 67360.1 |
| 256 | 2020-03-27 22:45:00 | whanged | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 255 | 2020-03-26 06:18:50 | whanged | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 254 | 2020-03-22 20:15:06 | whanged | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 253 | 2020-03-13 05:25:16 | whanged | 1 | 69583 | 5 | 1.030 | 67556.3 |
| 252 | 2020-02-28 18:29:26 | whanged | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 251 | 2020-02-23 14:18:48 | whanged | 3 | 134027 | 489 | 15.876 | 8442.1 |
| 250 | 2020-02-23 06:27:38 | whanged | 1 | 69583 | 5 | 2.406 | 28920.6 |
| 249 | 2020-02-22 19:51:32 | whanged | 3 | 134027 | 489 | 7.923 | 16916.2 |
| 248 | 2020-02-18 15:51:44 | whanged | 1 | 69583 | 5 | 3.970 | 17527.2 |
| 247 | 2020-02-18 13:38:12 | whanged | 1 | 69583 | 5 | 1.393 | 49951.9 |
| 246 | 2020-02-15 06:25:32 | whanged | 1 | 69583 | 5 | 2.893 | 24052.2 |
| 245 | 2020-02-12 00:31:17 | whanged | 1 | 69583 | 5 | 2.580 | 26970.2 |
| 244 | 2020-02-10 22:47:32 | whanged | 3 | 134027 | 489 | 7.123 | 18816.1 |
| 243 | 2020-02-10 14:37:07 | whanged | 1 | 69583 | 5 | 1.436 | 48456.1 |
| 242 | 2020-02-10 00:11:59 | whanged | 3 | 134027 | 489 | 14.893 | 8999.3 |
| 241 | 2020-02-09 20:31:25 | whanged | 3 | 134027 | 489 | 6.076 | 22058.4 |
| 240 | 2020-02-09 18:18:54 | whanged | 3 | 134027 | 489 | 20.080 | 6674.7 |
| 239 | 2020-02-08 22:47:26 | whanged | 3 | 134027 | 489 | 7.190 | 18640.8 |
| 238 | 2020-01-30 19:39:47 | whanged | 1 | 69583 | 5 | 1.263 | 55093.4 |
| 237 | 2020-01-28 13:57:28 | whanged | 1 | 69583 | 5 | 1.436 | 48456.1 |
| 236 | 2020-01-27 14:36:34 | whanged | 3 | 134027 | 489 | 11.203 | 11963.5 |
| 235 | 2020-01-26 13:27:44 | whanged | 1 | 69583 | 5 | 2.296 | 30306.2 |
| 234 | 2020-01-26 10:17:57 | whanged | 3 | 134027 | 489 | 5.546 | 24166.4 |
| 233 | 2020-01-25 15:44:26 | whanged | 2 | 107671 | 60 | 5.736 | 18771.1 |
| 232 | 2020-01-25 13:35:49 | whanged | 2 | 107671 | 60 | 8.393 | 12828.7 |
| 231 | 2020-01-25 00:24:47 | whanged | 2 | 107671 | 60 | 4.000 | 26917.8 |
| 230 | 2020-01-22 03:16:18 | whanged | 1 | 69583 | 5 | 3.626 | 19190.0 |
| 229 | 2020-01-20 17:44:50 | whanged | 3 | 134027 | 489 | 17.580 | 7623.8 |
| 228 | 2020-01-20 17:43:37 | whanged | 1 | 69583 | 5 | 1.343 | 51811.6 |
| 227 | 2020-01-20 17:09:22 | whanged | 3 | 134027 | 489 | 8.500 | 15767.9 |
| 226 | 2020-01-20 12:55:27 | whanged | 3 | 134027 | 489 | 15.206 | 8814.1 |
| 225 | 2020-01-20 00:28:45 | whanged | 1 | 69583 | 5 | 1.263 | 55093.4 |
| 224 | 2020-01-15 16:44:32 | whanged | 3 | 134027 | 489 | 15.216 | 8808.3 |
| 223 | 2020-01-15 15:27:47 | whanged | 3 | 134027 | 489 | 14.936 | 8973.4 |
| 222 | 2020-01-15 11:41:52 | whanged | 2 | 107671 | 60 | 7.470 | 14413.8 |
| 221 | 2020-01-15 11:41:51 | whanged | 3 | 134027 | 489 | 7.923 | 16916.2 |
| 220 | 2020-01-15 07:59:00 | whanged | 1 | 69583 | 5 | 1.283 | 54234.6 |
| 219 | 2019-12-29 11:31:35 | whanged | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 218 | 2019-12-29 07:14:04 | whanged | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 217 | 2019-12-29 05:45:49 | whanged | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 216 | 2019-12-29 00:46:05 | whanged | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 215 | 2019-12-01 15:07:49 | whanged | 1 | 69583 | 5 | 1.126 | 61796.6 |
| 214 | 2019-08-30 04:31:52 | whanged | 1 | 69583 | 5 | 1.050 | 66269.5 |
| 213 | 2019-07-25 11:55:10 | whanged | 1 | 69583 | 5 | 1.073 | 64849.0 |
| 212 | 2019-05-21 04:38:55 | whanged | 1 | 69583 | 5 | 1.183 | 58819.1 |
| 211 | 2019-03-11 16:13:07 | whanged | 1 | 69583 | 5 | 1.000 | 69583.0 |
| 210 | 2019-02-14 11:50:57 | whanged | 1 | 69583 | 5 | 1.096 | 63488.1 |
| 209 | 2019-02-07 13:31:08 | whanged | 1 | 69583 | 5 | 1.026 | 67819.7 |
| 208 | 2019-02-05 19:06:13 | whanged | 1 | 69583 | 5 | 1.003 | 69374.9 |
| 207 | 2019-02-04 01:26:41 | whanged | 1 | 69583 | 5 | 0.996 | 69862.4 |
| 206 | 2019-02-04 01:19:48 | whanged | 1 | 69583 | 5 | 1.003 | 69374.9 |
| 205 | 2019-01-30 04:52:03 | whanged | 1 | 69583 | 5 | 1.160 | 59985.3 |
| 204 | 2019-01-19 15:15:41 | whanged | 1 | 69583 | 5 | 1.010 | 68894.1 |
| 203 | 2019-01-17 21:01:34 | whanged | 1 | 69583 | 5 | 2.686 | 25905.8 |
| 202 | 2018-12-31 20:43:06 | whanged | 1 | 69583 | 5 | 1.113 | 62518.4 |
| 201 | 2018-12-26 04:34:08 | whanged | 1 | 69583 | 5 | 1.016 | 68487.2 |