History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"loyally"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 294 | 2024-04-27 02:35:17 | loyally | 1 | 69583 | 4 | 4.220 | 16488.9 |
| 293 | 2024-04-05 09:14:19 | loyally | 2 | 107671 | 24 | 5.313 | 20265.6 |
| 292 | 2024-04-04 23:01:30 | loyally | 3 | 134027 | 162 | 14.376 | 9323.0 |
| 291 | 2024-04-04 16:33:38 | loyally | 1 | 69583 | 4 | 2.876 | 24194.4 |
| 290 | 2024-04-04 16:18:08 | loyally | 3 | 134027 | 162 | 25.143 | 5330.6 |
| 289 | 2024-04-04 14:22:05 | loyally | 1 | 69583 | 4 | 1.143 | 60877.5 |
| 288 | 2024-04-03 10:30:10 | loyally | 2 | 107671 | 24 | 11.483 | 9376.6 |
| 287 | 2024-04-03 08:43:10 | loyally | 3 | 134027 | 162 | 6.890 | 19452.4 |
| 286 | 2024-04-03 06:20:36 | loyally | 1 | 69583 | 4 | 1.983 | 35089.8 |
| 285 | 2024-04-03 06:20:21 | loyally | 2 | 107671 | 24 | 11.450 | 9403.6 |
| 284 | 2024-04-03 06:20:19 | loyally | 3 | 134027 | 162 | 8.033 | 16684.6 |
| 283 | 2024-04-03 06:20:09 | loyally | 1 | 69583 | 4 | 1.406 | 49490.0 |
| 282 | 2024-03-30 04:19:59 | loyally | 1 | 69583 | 4 | 2.766 | 25156.5 |
| 281 | 2024-03-28 08:38:53 | loyally | 1 | 69583 | 4 | 1.140 | 61037.7 |
| 280 | 2024-03-17 08:04:55 | loyally | 1 | 69583 | 4 | 1.313 | 52995.4 |
| 279 | 2024-03-10 08:36:38 | loyally | 1 | 69583 | 4 | 2.923 | 23805.3 |
| 278 | 2023-12-25 04:22:59 | loyally | 1 | 69583 | 4 | 1.096 | 63488.1 |
| 277 | 2023-12-13 19:16:34 | loyally | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 276 | 2023-11-23 01:03:39 | loyally | 1 | 69583 | 4 | 1.033 | 67360.1 |
| 275 | 2023-11-21 19:11:32 | loyally | 1 | 69583 | 4 | 1.173 | 59320.5 |
| 274 | 2023-10-13 14:06:22 | loyally | 1 | 69583 | 4 | 1.060 | 65644.3 |
| 273 | 2023-10-12 18:04:20 | loyally | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 272 | 2023-10-09 19:06:28 | loyally | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 271 | 2023-09-29 09:39:14 | loyally | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 270 | 2023-09-27 12:21:10 | loyally | 1 | 69583 | 4 | 1.126 | 61796.6 |
| 269 | 2023-08-17 11:34:15 | loyally | 1 | 69583 | 4 | 1.080 | 64428.7 |
| 268 | 2023-08-08 00:10:43 | loyally | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 267 | 2023-05-09 09:39:06 | loyally | 1 | 69583 | 4 | 1.156 | 60192.9 |
| 266 | 2023-04-25 19:48:29 | loyally | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 265 | 2023-03-02 02:16:32 | loyally | 1 | 69583 | 4 | 1.030 | 67556.3 |
| 264 | 2022-12-29 13:11:05 | loyally | 1 | 69583 | 4 | 1.156 | 60192.9 |
| 263 | 2022-12-26 00:35:34 | loyally | 1 | 69583 | 4 | 1.033 | 67360.1 |
| 262 | 2022-09-13 20:30:24 | loyally | 1 | 69583 | 4 | 1.080 | 64428.7 |
| 261 | 2022-09-01 06:01:37 | loyally | 1 | 69583 | 4 | 1.143 | 60877.5 |
| 260 | 2022-07-15 12:34:57 | loyally | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 259 | 2022-05-05 20:43:37 | loyally | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 258 | 2022-03-08 20:26:41 | loyally | 1 | 69583 | 4 | 1.483 | 46920.4 |
| 257 | 2022-01-21 13:07:33 | loyally | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 256 | 2022-01-14 23:51:50 | loyally | 1 | 69583 | 4 | 1.156 | 60192.9 |
| 255 | 2022-01-03 03:15:13 | loyally | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 254 | 2021-12-14 11:45:53 | loyally | 1 | 69583 | 4 | 1.220 | 57035.2 |
| 253 | 2021-12-13 17:00:23 | loyally | 1 | 69583 | 4 | 1.123 | 61961.7 |
| 252 | 2021-12-12 11:06:31 | loyally | 1 | 69583 | 4 | 1.236 | 56296.9 |
| 251 | 2021-12-02 19:13:09 | loyally | 1 | 69583 | 4 | 1.206 | 57697.3 |
| 250 | 2021-12-01 20:26:02 | loyally | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 249 | 2021-11-29 20:24:06 | loyally | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 248 | 2021-10-08 17:24:22 | loyally | 1 | 69583 | 4 | 1.216 | 57222.9 |
| 247 | 2021-09-26 05:01:09 | loyally | 2 | 107671 | 24 | 2.720 | 39584.9 |
| 246 | 2021-09-25 08:31:46 | loyally | 2 | 107671 | 24 | 3.360 | 32044.9 |
| 245 | 2021-09-20 13:52:32 | loyally | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 244 | 2021-09-19 23:10:42 | loyally | 2 | 107671 | 24 | 3.343 | 32207.9 |
| 243 | 2021-09-19 22:23:02 | loyally | 1 | 69583 | 4 | 1.060 | 65644.3 |
| 242 | 2021-09-13 06:40:47 | loyally | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 241 | 2021-07-10 12:16:02 | loyally | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 240 | 2021-05-14 05:42:09 | loyally | 2 | 107671 | 24 | 3.140 | 34290.1 |
| 239 | 2021-05-11 16:23:19 | loyally | 1 | 69583 | 4 | 1.220 | 57035.2 |
| 238 | 2021-04-10 10:16:40 | loyally | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 237 | 2021-04-06 16:43:31 | loyally | 1 | 69583 | 4 | 1.126 | 61796.6 |
| 236 | 2021-04-02 12:46:33 | loyally | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 235 | 2021-03-14 11:54:07 | loyally | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 234 | 2021-02-01 21:49:47 | loyally | 1 | 69583 | 4 | 1.236 | 56296.9 |
| 233 | 2021-01-27 00:34:05 | loyally | 2 | 107671 | 24 | 3.140 | 34290.1 |
| 232 | 2020-12-21 12:23:16 | loyally | 1 | 69583 | 4 | 1.076 | 64668.2 |
| 231 | 2020-10-23 02:06:08 | loyally | 3 | 134027 | 162 | 6.000 | 22337.8 |
| 230 | 2020-10-23 00:17:22 | loyally | 1 | 69583 | 4 | 1.076 | 64668.2 |
| 229 | 2020-10-22 01:20:56 | loyally | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 228 | 2020-10-15 04:53:15 | loyally | 2 | 107671 | 24 | 2.766 | 38926.6 |
| 227 | 2020-10-11 07:30:55 | loyally | 1 | 69583 | 4 | 1.060 | 65644.3 |
| 226 | 2020-09-17 13:45:16 | loyally | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 225 | 2020-09-06 12:38:47 | loyally | 2 | 107671 | 24 | 2.796 | 38508.9 |
| 224 | 2020-06-04 20:24:50 | loyally | 1 | 69583 | 4 | 1.076 | 64668.2 |
| 223 | 2020-03-28 23:53:15 | loyally | 1 | 69583 | 4 | 1.283 | 54234.6 |
| 222 | 2020-03-28 20:19:29 | loyally | 1 | 69583 | 4 | 1.296 | 53690.6 |
| 221 | 2020-03-28 20:04:44 | loyally | 3 | 134027 | 162 | 8.186 | 16372.7 |
| 220 | 2020-03-24 15:55:29 | loyally | 1 | 69583 | 4 | 1.420 | 49002.1 |
| 219 | 2020-03-23 23:19:57 | loyally | 1 | 69583 | 4 | 1.076 | 64668.2 |
| 218 | 2020-03-21 20:21:44 | loyally | 3 | 134027 | 162 | 6.250 | 21444.3 |
| 217 | 2020-03-20 18:29:34 | loyally | 1 | 69583 | 4 | 1.343 | 51811.6 |
| 216 | 2020-03-03 15:47:43 | loyally | 3 | 134027 | 162 | 6.423 | 20866.7 |
| 215 | 2020-03-03 08:20:38 | loyally | 1 | 69583 | 4 | 1.060 | 65644.3 |
| 214 | 2020-03-02 18:47:03 | loyally | 3 | 134027 | 162 | 7.546 | 17761.3 |
| 213 | 2020-02-29 10:39:40 | loyally | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 212 | 2020-02-27 18:23:55 | loyally | 1 | 69583 | 4 | 2.783 | 25002.9 |
| 211 | 2020-02-26 05:18:35 | loyally | 1 | 69583 | 4 | 1.313 | 52995.4 |
| 210 | 2020-02-22 09:10:06 | loyally | 1 | 69583 | 4 | 1.313 | 52995.4 |
| 209 | 2020-02-11 09:29:22 | loyally | 1 | 69583 | 4 | 1.423 | 48898.8 |
| 208 | 2020-02-10 15:46:47 | loyally | 1 | 69583 | 4 | 1.423 | 48898.8 |
| 207 | 2020-02-02 04:48:45 | loyally | 1 | 69583 | 4 | 2.953 | 23563.5 |
| 206 | 2020-01-31 15:25:58 | loyally | 1 | 69583 | 4 | 1.390 | 50059.7 |
| 205 | 2020-01-28 02:07:27 | loyally | 1 | 69583 | 4 | 1.330 | 52318.0 |
| 204 | 2020-01-22 07:11:35 | loyally | 1 | 69583 | 4 | 3.533 | 19695.2 |
| 203 | 2020-01-18 11:25:20 | loyally | 3 | 134027 | 162 | 7.530 | 17799.1 |
| 202 | 2020-01-18 03:43:12 | loyally | 3 | 134027 | 162 | 12.703 | 10550.8 |
| 201 | 2020-01-17 20:26:12 | loyally | 1 | 69583 | 4 | 2.000 | 34791.5 |
| 200 | 2020-01-15 22:29:40 | loyally | 1 | 69583 | 4 | 1.343 | 51811.6 |
| 199 | 2020-01-06 18:48:35 | loyally | 1 | 69583 | 4 | 1.216 | 57222.9 |
| 198 | 2020-01-01 14:40:08 | loyally | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 197 | 2019-12-29 21:50:58 | loyally | 1 | 69583 | 4 | 1.283 | 54234.6 |
| 196 | 2019-12-26 19:29:50 | loyally | 1 | 69583 | 4 | 1.296 | 53690.6 |
| 195 | 2019-11-30 08:53:46 | loyally | 1 | 69583 | 4 | 1.250 | 55666.4 |