History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"warfare"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 289 | 2024-04-19 14:45:41 | warfare | 2 | 107671 | 14 | 4.110 | 26197.3 |
| 288 | 2024-04-13 00:32:21 | warfare | 2 | 107671 | 14 | 6.503 | 16557.1 |
| 287 | 2024-04-13 00:32:09 | warfare | 3 | 134027 | 144 | 7.000 | 19146.7 |
| 286 | 2024-04-11 10:05:21 | warfare | 3 | 134027 | 144 | 7.046 | 19021.7 |
| 285 | 2024-04-11 08:28:11 | warfare | 2 | 107671 | 14 | 3.483 | 30913.3 |
| 284 | 2024-04-10 18:30:39 | warfare | 3 | 134027 | 144 | 33.953 | 3947.4 |
| 283 | 2024-04-09 21:36:23 | warfare | 2 | 107671 | 14 | 3.830 | 28112.5 |
| 282 | 2024-04-09 21:35:55 | warfare | 3 | 134027 | 144 | 7.656 | 17506.1 |
| 281 | 2024-04-09 04:52:43 | warfare | 3 | 134027 | 144 | 21.250 | 6307.2 |
| 280 | 2024-04-09 02:46:55 | warfare | 3 | 134027 | 144 | 16.343 | 8200.9 |
| 279 | 2024-04-09 02:47:08 | warfare | 1 | 69583 | 3 | 1.390 | 50059.7 |
| 278 | 2024-04-09 02:46:52 | warfare | 2 | 107671 | 14 | 3.950 | 27258.5 |
| 277 | 2024-04-09 02:46:40 | warfare | 1 | 69583 | 3 | 1.343 | 51811.6 |
| 276 | 2024-03-08 23:47:43 | warfare | 3 | 134027 | 144 | 8.030 | 16690.8 |
| 275 | 2024-03-08 23:47:18 | warfare | 2 | 107671 | 14 | 8.483 | 12692.6 |
| 274 | 2024-03-07 23:56:37 | warfare | 3 | 134027 | 144 | 14.656 | 9144.9 |
| 273 | 2024-03-07 23:56:33 | warfare | 2 | 107671 | 14 | 3.436 | 31336.1 |
| 272 | 2024-03-06 21:51:46 | warfare | 3 | 134027 | 144 | 9.033 | 14837.5 |
| 271 | 2024-03-06 09:40:29 | warfare | 3 | 134027 | 144 | 31.800 | 4214.7 |
| 270 | 2024-03-06 07:00:50 | warfare | 3 | 134027 | 144 | 22.233 | 6028.3 |
| 269 | 2024-03-06 07:00:48 | warfare | 2 | 107671 | 14 | 11.660 | 9234.2 |
| 268 | 2024-03-06 06:57:35 | warfare | 1 | 69583 | 3 | 2.690 | 25867.3 |
| 267 | 2024-02-27 03:01:17 | warfare | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 266 | 2024-02-06 02:31:10 | warfare | 2 | 107671 | 14 | 3.596 | 29941.9 |
| 265 | 2024-02-04 18:18:23 | warfare | 3 | 134027 | 144 | 7.766 | 17258.2 |
| 264 | 2024-02-04 12:47:34 | warfare | 3 | 134027 | 144 | 16.173 | 8287.1 |
| 263 | 2024-02-04 11:34:30 | warfare | 3 | 134027 | 144 | 14.813 | 9047.9 |
| 262 | 2024-02-04 11:34:34 | warfare | 2 | 107671 | 14 | 3.920 | 27467.1 |
| 261 | 2024-02-04 11:32:46 | warfare | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 260 | 2024-01-04 09:35:34 | warfare | 1 | 69583 | 3 | 1.483 | 46920.4 |
| 259 | 2023-12-23 22:24:49 | warfare | 3 | 134027 | 144 | 6.826 | 19634.8 |
| 258 | 2023-12-23 22:24:51 | warfare | 2 | 107671 | 14 | 3.470 | 31029.1 |
| 257 | 2023-12-12 04:18:55 | warfare | 3 | 134027 | 144 | 5.843 | 22938.0 |
| 256 | 2023-12-10 12:42:14 | warfare | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 255 | 2023-12-06 05:10:57 | warfare | 1 | 69583 | 3 | 2.110 | 32977.7 |
| 254 | 2023-12-01 18:46:57 | warfare | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 253 | 2023-10-29 22:26:41 | warfare | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 252 | 2023-09-24 17:27:37 | warfare | 3 | 134027 | 144 | 8.796 | 15237.3 |
| 251 | 2023-09-20 11:20:44 | warfare | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 250 | 2023-09-17 10:46:52 | warfare | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 249 | 2023-09-16 15:25:15 | warfare | 3 | 134027 | 144 | 13.656 | 9814.5 |
| 248 | 2023-09-10 16:31:25 | warfare | 3 | 134027 | 144 | 6.486 | 20664.0 |
| 247 | 2023-07-15 11:55:37 | warfare | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 246 | 2023-07-13 22:01:15 | warfare | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 245 | 2023-05-29 00:02:19 | warfare | 3 | 134027 | 144 | 5.640 | 23763.7 |
| 244 | 2023-04-19 07:19:40 | warfare | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 243 | 2023-03-27 18:54:21 | warfare | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 242 | 2023-03-05 08:14:00 | warfare | 3 | 134027 | 144 | 5.563 | 24092.6 |
| 241 | 2023-02-28 20:38:31 | warfare | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 240 | 2023-02-06 17:30:36 | warfare | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 239 | 2022-12-11 19:13:10 | warfare | 3 | 134027 | 144 | 5.640 | 23763.7 |
| 238 | 2022-12-05 05:35:20 | warfare | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 237 | 2022-10-10 17:07:36 | warfare | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 236 | 2022-09-06 16:50:20 | warfare | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 235 | 2022-08-01 03:07:35 | warfare | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 234 | 2022-07-28 09:53:54 | warfare | 3 | 134027 | 144 | 5.860 | 22871.5 |
| 233 | 2022-07-26 02:54:55 | warfare | 3 | 134027 | 144 | 6.046 | 22167.9 |
| 232 | 2022-05-09 22:16:37 | warfare | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 231 | 2022-03-28 15:46:39 | warfare | 1 | 69583 | 3 | 1.390 | 50059.7 |
| 230 | 2022-03-05 20:17:30 | warfare | 3 | 134027 | 144 | 5.830 | 22989.2 |
| 229 | 2022-03-03 16:10:23 | warfare | 3 | 134027 | 144 | 6.110 | 21935.7 |
| 228 | 2022-01-20 16:24:49 | warfare | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 227 | 2021-12-30 03:24:12 | warfare | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 226 | 2021-12-17 14:08:45 | warfare | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 225 | 2021-11-27 12:45:20 | warfare | 3 | 134027 | 144 | 6.860 | 19537.5 |
| 224 | 2021-10-22 17:03:07 | warfare | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 223 | 2021-10-20 14:55:47 | warfare | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 222 | 2021-09-27 07:43:41 | warfare | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 221 | 2021-09-26 14:52:51 | warfare | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 220 | 2021-09-22 08:08:27 | warfare | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 219 | 2021-09-08 09:57:25 | warfare | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 218 | 2021-08-28 02:46:43 | warfare | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 217 | 2021-08-21 18:35:44 | warfare | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 216 | 2021-07-22 01:49:11 | warfare | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 215 | 2021-07-04 02:37:02 | warfare | 2 | 107671 | 14 | 2.906 | 37051.3 |
| 214 | 2021-05-11 18:33:57 | warfare | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 213 | 2021-05-10 14:06:09 | warfare | 1 | 69583 | 3 | 2.500 | 27833.2 |
| 212 | 2021-05-07 06:02:39 | warfare | 3 | 134027 | 144 | 7.110 | 18850.5 |
| 211 | 2021-04-17 16:39:42 | warfare | 2 | 107671 | 14 | 3.280 | 32826.5 |
| 210 | 2021-04-10 12:22:20 | warfare | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 209 | 2021-01-30 03:57:41 | warfare | 2 | 107671 | 14 | 2.860 | 37647.2 |
| 208 | 2021-01-27 15:10:03 | warfare | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 207 | 2021-01-20 22:45:50 | warfare | 3 | 134027 | 144 | 5.910 | 22678.0 |
| 206 | 2021-01-02 01:35:15 | warfare | 2 | 107671 | 14 | 2.876 | 37437.8 |
| 205 | 2020-12-27 02:52:07 | warfare | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 204 | 2020-11-13 17:33:05 | warfare | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 203 | 2020-11-01 03:52:53 | warfare | 3 | 134027 | 144 | 5.983 | 22401.3 |
| 202 | 2020-10-19 13:28:28 | warfare | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 201 | 2020-10-19 03:05:09 | warfare | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 200 | 2020-10-18 10:45:00 | warfare | 3 | 134027 | 144 | 6.000 | 22337.8 |
| 199 | 2020-10-17 17:03:29 | warfare | 2 | 107671 | 14 | 2.860 | 37647.2 |
| 198 | 2020-06-16 23:43:03 | warfare | 1 | 69583 | 3 | 1.106 | 62914.1 |
| 197 | 2020-06-15 00:14:40 | warfare | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 196 | 2020-04-20 13:36:29 | warfare | 3 | 134027 | 144 | 6.016 | 22278.4 |
| 195 | 2020-04-20 13:36:23 | warfare | 2 | 107671 | 14 | 3.170 | 33965.6 |
| 194 | 2020-04-20 10:36:22 | warfare | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 193 | 2020-03-30 01:16:42 | warfare | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 192 | 2020-03-24 15:14:39 | warfare | 1 | 69583 | 3 | 1.720 | 40455.2 |
| 191 | 2020-03-24 02:45:22 | warfare | 1 | 69583 | 3 | 1.483 | 46920.4 |
| 190 | 2020-03-21 10:09:18 | warfare | 1 | 69583 | 3 | 1.186 | 58670.3 |