History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"crisply"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 280 | 2024-04-03 12:06:30 | crisply | 1 | 69583 | 3 | 2.500 | 27833.2 |
| 279 | 2024-03-31 13:45:35 | crisply | 1 | 69583 | 3 | 1.656 | 42018.7 |
| 278 | 2024-03-31 10:11:52 | crisply | 1 | 69583 | 3 | 3.940 | 17660.7 |
| 277 | 2024-03-31 08:02:16 | crisply | 2 | 107671 | 22 | 7.156 | 15046.3 |
| 276 | 2024-03-31 03:26:53 | crisply | 3 | 134027 | 180 | 31.736 | 4223.2 |
| 275 | 2024-03-31 00:40:48 | crisply | 3 | 134027 | 180 | 10.580 | 12668.0 |
| 274 | 2024-03-30 21:25:57 | crisply | 3 | 134027 | 180 | 24.876 | 5387.8 |
| 273 | 2024-03-30 21:26:05 | crisply | 2 | 107671 | 22 | 10.576 | 10180.7 |
| 272 | 2024-03-30 21:25:43 | crisply | 1 | 69583 | 3 | 1.440 | 48321.5 |
| 271 | 2024-03-29 12:07:30 | crisply | 1 | 69583 | 3 | 1.640 | 42428.7 |
| 270 | 2024-02-29 15:16:20 | crisply | 1 | 69583 | 3 | 1.390 | 50059.7 |
| 269 | 2024-02-28 08:41:37 | crisply | 3 | 134027 | 180 | 11.313 | 11847.2 |
| 268 | 2024-02-28 08:41:38 | crisply | 2 | 107671 | 22 | 8.686 | 12395.9 |
| 267 | 2024-02-28 07:20:46 | crisply | 1 | 69583 | 3 | 3.170 | 21950.5 |
| 266 | 2024-02-08 04:45:55 | crisply | 2 | 107671 | 22 | 3.390 | 31761.4 |
| 265 | 2024-01-19 19:55:16 | crisply | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 264 | 2024-01-03 18:08:13 | crisply | 2 | 107671 | 22 | 3.530 | 30501.7 |
| 263 | 2024-01-02 08:55:01 | crisply | 2 | 107671 | 22 | 3.406 | 31612.2 |
| 262 | 2023-12-23 18:17:39 | crisply | 3 | 134027 | 180 | 5.800 | 23108.1 |
| 261 | 2023-11-24 10:03:29 | crisply | 1 | 69583 | 3 | 2.436 | 28564.4 |
| 260 | 2023-11-18 23:05:43 | crisply | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 259 | 2023-11-15 22:05:16 | crisply | 1 | 69583 | 3 | 1.200 | 57985.8 |
| 258 | 2023-11-13 00:52:42 | crisply | 2 | 107671 | 22 | 2.830 | 38046.3 |
| 257 | 2023-11-04 04:23:13 | crisply | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 256 | 2023-10-28 16:25:52 | crisply | 1 | 69583 | 3 | 1.096 | 63488.1 |
| 255 | 2023-10-22 01:36:19 | crisply | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 254 | 2023-10-14 22:28:20 | crisply | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 253 | 2023-10-09 09:50:39 | crisply | 3 | 134027 | 180 | 7.826 | 17125.9 |
| 252 | 2023-10-03 17:30:07 | crisply | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 251 | 2023-09-30 00:57:51 | crisply | 3 | 134027 | 180 | 7.533 | 17792.0 |
| 250 | 2023-09-28 15:41:55 | crisply | 3 | 134027 | 180 | 16.563 | 8092.0 |
| 249 | 2023-09-27 18:55:36 | crisply | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 248 | 2023-09-23 23:58:13 | crisply | 3 | 134027 | 180 | 6.060 | 22116.7 |
| 247 | 2023-09-13 12:36:39 | crisply | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 246 | 2023-09-02 13:57:52 | crisply | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 245 | 2023-08-15 14:51:18 | crisply | 2 | 107671 | 22 | 3.250 | 33129.5 |
| 244 | 2023-07-05 05:06:38 | crisply | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 243 | 2023-06-30 21:29:49 | crisply | 3 | 134027 | 180 | 6.203 | 21606.8 |
| 242 | 2023-06-08 08:15:04 | crisply | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 241 | 2023-04-30 11:47:21 | crisply | 2 | 107671 | 22 | 2.890 | 37256.4 |
| 240 | 2023-03-30 05:12:01 | crisply | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 239 | 2023-03-25 11:48:19 | crisply | 3 | 134027 | 180 | 5.936 | 22578.7 |
| 238 | 2023-03-21 17:40:01 | crisply | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 237 | 2023-02-11 22:49:04 | crisply | 3 | 134027 | 180 | 6.140 | 21828.5 |
| 236 | 2023-02-06 01:38:32 | crisply | 2 | 107671 | 22 | 2.953 | 36461.6 |
| 235 | 2023-01-12 21:37:24 | crisply | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 234 | 2022-12-24 07:45:35 | crisply | 3 | 134027 | 180 | 6.936 | 19323.4 |
| 233 | 2022-12-24 04:42:22 | crisply | 3 | 134027 | 180 | 6.813 | 19672.2 |
| 232 | 2022-12-03 14:25:58 | crisply | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 231 | 2022-11-18 04:03:47 | crisply | 2 | 107671 | 22 | 3.170 | 33965.6 |
| 230 | 2022-11-13 23:58:20 | crisply | 3 | 134027 | 180 | 6.326 | 21186.7 |
| 229 | 2022-11-09 12:03:35 | crisply | 3 | 134027 | 180 | 6.186 | 21666.2 |
| 228 | 2022-11-07 05:46:29 | crisply | 3 | 134027 | 180 | 6.593 | 20328.7 |
| 227 | 2022-11-06 13:33:19 | crisply | 3 | 134027 | 180 | 6.170 | 21722.4 |
| 226 | 2022-11-01 08:46:27 | crisply | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 225 | 2022-10-21 21:34:47 | crisply | 3 | 134027 | 180 | 5.906 | 22693.4 |
| 224 | 2022-09-29 05:12:40 | crisply | 3 | 134027 | 180 | 6.330 | 21173.3 |
| 223 | 2022-08-23 05:50:44 | crisply | 3 | 134027 | 180 | 5.750 | 23309.0 |
| 222 | 2022-08-20 20:34:31 | crisply | 3 | 134027 | 180 | 6.813 | 19672.2 |
| 221 | 2022-08-03 08:37:28 | crisply | 1 | 69583 | 3 | 1.096 | 63488.1 |
| 220 | 2022-06-21 13:14:34 | crisply | 2 | 107671 | 22 | 3.233 | 33303.7 |
| 219 | 2022-06-20 13:37:20 | crisply | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 218 | 2022-04-08 20:06:14 | crisply | 1 | 69583 | 3 | 2.046 | 34009.3 |
| 217 | 2022-03-02 04:37:17 | crisply | 1 | 69583 | 3 | 1.656 | 42018.7 |
| 216 | 2022-02-28 00:22:43 | crisply | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 215 | 2022-02-20 06:51:30 | crisply | 2 | 107671 | 22 | 2.953 | 36461.6 |
| 214 | 2021-12-27 12:02:13 | crisply | 1 | 69583 | 3 | 1.326 | 52475.9 |
| 213 | 2021-12-21 12:38:08 | crisply | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 212 | 2021-09-28 02:29:16 | crisply | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 211 | 2021-09-27 11:29:02 | crisply | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 210 | 2021-09-23 15:17:41 | crisply | 1 | 69583 | 3 | 1.263 | 55093.4 |
| 209 | 2021-09-17 13:12:50 | crisply | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 208 | 2021-09-11 17:06:05 | crisply | 1 | 69583 | 3 | 2.203 | 31585.6 |
| 207 | 2021-06-17 16:12:56 | crisply | 1 | 69583 | 3 | 1.090 | 63837.6 |
| 206 | 2021-04-27 15:47:23 | crisply | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 205 | 2021-03-27 16:17:24 | crisply | 1 | 69583 | 3 | 2.406 | 28920.6 |
| 204 | 2021-03-18 09:05:16 | crisply | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 203 | 2021-03-01 18:52:46 | crisply | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 202 | 2021-02-26 04:01:42 | crisply | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 201 | 2021-02-21 17:54:15 | crisply | 3 | 134027 | 180 | 6.486 | 20664.0 |
| 200 | 2021-02-14 08:51:09 | crisply | 3 | 134027 | 180 | 5.906 | 22693.4 |
| 199 | 2021-01-22 03:19:29 | crisply | 3 | 134027 | 180 | 5.843 | 22938.0 |
| 198 | 2020-12-23 05:48:32 | crisply | 3 | 134027 | 180 | 5.830 | 22989.2 |
| 197 | 2020-12-15 10:04:37 | crisply | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 196 | 2020-12-12 15:32:25 | crisply | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 195 | 2020-10-31 14:15:54 | crisply | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 194 | 2020-10-23 05:38:18 | crisply | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 193 | 2020-10-19 15:13:57 | crisply | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 192 | 2020-09-15 03:52:40 | crisply | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 191 | 2020-08-26 13:30:26 | crisply | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 190 | 2020-08-06 08:32:11 | crisply | 1 | 69583 | 3 | 1.096 | 63488.1 |
| 189 | 2020-06-05 22:43:01 | crisply | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 188 | 2020-06-03 00:52:50 | crisply | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 187 | 2020-03-25 07:36:26 | crisply | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 186 | 2020-03-22 07:36:54 | crisply | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 185 | 2020-03-05 16:59:27 | crisply | 1 | 69583 | 3 | 1.436 | 48456.1 |
| 184 | 2020-02-27 14:34:38 | crisply | 1 | 69583 | 3 | 1.970 | 35321.3 |
| 183 | 2020-02-27 13:55:33 | crisply | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 182 | 2020-02-23 21:49:09 | crisply | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 181 | 2020-02-23 14:10:36 | crisply | 1 | 69583 | 3 | 1.466 | 47464.5 |