History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hallway"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 257 | 2024-03-24 17:16:40 | hallway | 2 | 107671 | 14 | 7.486 | 14383.0 |
| 256 | 2024-03-11 01:23:50 | hallway | 3 | 134027 | 145 | 19.533 | 6861.6 |
| 255 | 2024-03-09 07:09:16 | hallway | 3 | 134027 | 145 | 16.110 | 8319.5 |
| 254 | 2024-03-08 17:30:25 | hallway | 3 | 134027 | 145 | 11.316 | 11844.0 |
| 253 | 2024-03-08 17:30:30 | hallway | 2 | 107671 | 14 | 3.986 | 27012.3 |
| 252 | 2024-03-08 17:30:06 | hallway | 1 | 69583 | 3 | 2.810 | 24762.6 |
| 251 | 2024-02-28 01:35:29 | hallway | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 250 | 2024-02-03 00:13:45 | hallway | 2 | 107671 | 14 | 3.890 | 27678.9 |
| 249 | 2024-02-03 00:13:25 | hallway | 3 | 134027 | 145 | 8.766 | 15289.4 |
| 248 | 2024-02-01 20:59:41 | hallway | 2 | 107671 | 14 | 2.966 | 36301.8 |
| 247 | 2024-02-01 20:58:09 | hallway | 3 | 134027 | 145 | 6.156 | 21771.8 |
| 246 | 2024-01-31 23:09:31 | hallway | 3 | 134027 | 145 | 8.890 | 15076.2 |
| 245 | 2024-01-31 23:09:35 | hallway | 2 | 107671 | 14 | 3.640 | 29579.9 |
| 244 | 2024-01-31 23:09:27 | hallway | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 243 | 2024-01-05 08:57:14 | hallway | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 242 | 2024-01-01 00:18:51 | hallway | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 241 | 2023-12-02 05:10:11 | hallway | 2 | 107671 | 14 | 2.843 | 37872.3 |
| 240 | 2023-11-28 23:39:05 | hallway | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 239 | 2023-11-28 13:41:43 | hallway | 1 | 69583 | 3 | 2.530 | 27503.2 |
| 238 | 2023-11-22 02:34:31 | hallway | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 237 | 2023-11-19 15:24:32 | hallway | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 236 | 2023-10-29 10:44:49 | hallway | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 235 | 2023-08-31 20:08:39 | hallway | 2 | 107671 | 14 | 2.970 | 36252.9 |
| 234 | 2023-08-22 21:51:54 | hallway | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 233 | 2023-08-02 05:21:45 | hallway | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 232 | 2023-05-24 15:41:42 | hallway | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 231 | 2023-05-21 02:24:24 | hallway | 2 | 107671 | 14 | 2.890 | 37256.4 |
| 230 | 2023-04-13 19:19:06 | hallway | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 229 | 2023-03-22 00:54:10 | hallway | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 228 | 2023-03-01 15:11:32 | hallway | 2 | 107671 | 14 | 2.766 | 38926.6 |
| 227 | 2023-01-06 23:58:10 | hallway | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 226 | 2022-12-24 20:26:38 | hallway | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 225 | 2022-12-08 02:49:19 | hallway | 2 | 107671 | 14 | 2.813 | 38276.2 |
| 224 | 2022-10-06 23:30:59 | hallway | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 223 | 2022-09-01 22:01:24 | hallway | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 222 | 2022-08-24 15:13:08 | hallway | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 221 | 2022-08-07 18:45:12 | hallway | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 220 | 2022-07-20 21:44:30 | hallway | 2 | 107671 | 14 | 2.860 | 37647.2 |
| 219 | 2022-05-28 02:03:30 | hallway | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 218 | 2022-04-23 21:48:57 | hallway | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 217 | 2022-02-09 06:24:33 | hallway | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 216 | 2021-12-29 00:27:15 | hallway | 1 | 69583 | 3 | 1.876 | 37091.2 |
| 215 | 2021-11-30 23:01:11 | hallway | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 214 | 2021-10-10 10:50:26 | hallway | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 213 | 2021-09-18 16:20:24 | hallway | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 212 | 2021-09-06 07:12:05 | hallway | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 211 | 2021-08-19 17:36:50 | hallway | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 210 | 2021-06-18 20:07:41 | hallway | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 209 | 2021-05-22 06:17:18 | hallway | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 208 | 2021-03-19 17:12:00 | hallway | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 207 | 2021-01-08 08:10:24 | hallway | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 206 | 2020-12-13 04:11:47 | hallway | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 205 | 2020-12-10 01:08:34 | hallway | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 204 | 2020-11-02 04:47:12 | hallway | 3 | 134027 | 145 | 6.500 | 20619.5 |
| 203 | 2020-10-21 18:47:07 | hallway | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 202 | 2020-10-04 08:22:54 | hallway | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 201 | 2020-10-03 07:50:27 | hallway | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 200 | 2020-09-06 08:55:10 | hallway | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 199 | 2020-09-06 01:39:32 | hallway | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 198 | 2020-08-06 18:45:03 | hallway | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 197 | 2020-07-28 21:16:00 | hallway | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 196 | 2020-07-28 17:29:43 | hallway | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 195 | 2020-05-22 19:21:48 | hallway | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 194 | 2020-05-12 05:38:11 | hallway | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 193 | 2020-03-29 20:34:17 | hallway | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 192 | 2020-03-29 14:41:09 | hallway | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 191 | 2020-03-25 05:01:22 | hallway | 1 | 69583 | 3 | 1.453 | 47889.2 |
| 190 | 2020-03-24 21:33:16 | hallway | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 189 | 2020-03-20 18:33:54 | hallway | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 188 | 2020-03-02 17:17:01 | hallway | 3 | 134027 | 145 | 6.910 | 19396.1 |
| 187 | 2020-03-02 16:05:07 | hallway | 3 | 134027 | 145 | 7.813 | 17154.4 |
| 186 | 2020-03-02 10:43:23 | hallway | 3 | 134027 | 145 | 6.936 | 19323.4 |
| 185 | 2020-02-29 23:20:59 | hallway | 3 | 134027 | 145 | 8.796 | 15237.3 |
| 184 | 2020-02-29 21:11:02 | hallway | 3 | 134027 | 145 | 7.390 | 18136.3 |
| 183 | 2020-02-22 21:11:12 | hallway | 1 | 69583 | 3 | 1.330 | 52318.0 |
| 182 | 2020-02-22 20:10:33 | hallway | 1 | 69583 | 3 | 2.096 | 33198.0 |
| 181 | 2020-02-22 14:32:36 | hallway | 1 | 69583 | 3 | 1.330 | 52318.0 |
| 180 | 2020-02-19 15:50:44 | hallway | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 179 | 2020-02-13 15:07:16 | hallway | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 178 | 2020-02-06 19:54:18 | hallway | 1 | 69583 | 3 | 3.686 | 18877.6 |
| 177 | 2020-02-06 16:25:40 | hallway | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 176 | 2020-02-06 00:10:25 | hallway | 1 | 69583 | 3 | 1.330 | 52318.0 |
| 175 | 2020-02-03 16:25:18 | hallway | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 174 | 2020-01-25 17:43:15 | hallway | 1 | 69583 | 3 | 2.703 | 25742.9 |
| 173 | 2020-01-23 18:36:57 | hallway | 1 | 69583 | 3 | 4.440 | 15671.8 |
| 172 | 2020-01-19 14:48:59 | hallway | 1 | 69583 | 3 | 1.576 | 44151.6 |
| 171 | 2020-01-12 13:04:58 | hallway | 3 | 134027 | 145 | 15.593 | 8595.3 |
| 170 | 2020-01-12 07:15:11 | hallway | 3 | 134027 | 145 | 17.360 | 7720.4 |
| 169 | 2020-01-12 03:17:20 | hallway | 2 | 107671 | 14 | 3.876 | 27778.9 |
| 168 | 2020-01-12 03:16:59 | hallway | 3 | 134027 | 145 | 18.800 | 7129.1 |
| 167 | 2020-01-11 22:17:21 | hallway | 1 | 69583 | 3 | 1.390 | 50059.7 |
| 166 | 2020-01-08 23:43:40 | hallway | 1 | 69583 | 3 | 1.360 | 51164.0 |
| 165 | 2020-01-08 00:55:03 | hallway | 1 | 69583 | 3 | 2.686 | 25905.8 |
| 164 | 2020-01-06 21:41:45 | hallway | 1 | 69583 | 3 | 2.576 | 27012.0 |
| 163 | 2019-12-28 16:23:14 | hallway | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 162 | 2019-12-25 07:08:44 | hallway | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 161 | 2019-11-20 11:56:39 | hallway | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 160 | 2019-08-18 17:23:54 | hallway | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 159 | 2019-05-30 02:33:38 | hallway | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 158 | 2019-05-15 20:13:38 | hallway | 1 | 69583 | 3 | 1.113 | 62518.4 |