History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"panoply"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 269 | 2024-04-27 09:03:43 | panoply | 1 | 69583 | 1 | 1.236 | 56296.9 |
| 268 | 2024-04-24 22:38:43 | panoply | 2 | 107671 | 3 | 3.876 | 27778.9 |
| 267 | 2024-04-20 16:10:24 | panoply | 2 | 107671 | 3 | 4.550 | 23664.0 |
| 266 | 2024-04-20 16:10:24 | panoply | 1 | 69583 | 1 | 1.313 | 52995.4 |
| 265 | 2024-04-18 23:21:28 | panoply | 3 | 134027 | 103 | 15.313 | 8752.5 |
| 264 | 2024-04-18 02:07:37 | panoply | 3 | 134027 | 103 | 24.816 | 5400.8 |
| 263 | 2024-04-18 01:55:28 | panoply | 3 | 134027 | 103 | 18.610 | 7201.9 |
| 262 | 2024-04-17 13:43:49 | panoply | 2 | 107671 | 3 | 9.596 | 11220.4 |
| 261 | 2024-04-17 13:35:36 | panoply | 3 | 134027 | 103 | 7.626 | 17575.0 |
| 260 | 2024-04-16 08:22:29 | panoply | 3 | 134027 | 103 | 7.296 | 18369.9 |
| 259 | 2024-04-16 08:22:29 | panoply | 2 | 107671 | 3 | 5.983 | 17996.2 |
| 258 | 2024-04-16 08:22:26 | panoply | 1 | 69583 | 1 | 1.296 | 53690.6 |
| 257 | 2024-04-09 05:16:15 | panoply | 1 | 69583 | 1 | 1.656 | 42018.7 |
| 256 | 2024-04-06 04:18:19 | panoply | 1 | 69583 | 1 | 4.126 | 16864.5 |
| 255 | 2024-04-04 04:04:05 | panoply | 3 | 134027 | 103 | 22.000 | 6092.1 |
| 254 | 2024-04-04 04:04:05 | panoply | 2 | 107671 | 3 | 12.593 | 8550.1 |
| 253 | 2024-04-04 03:46:28 | panoply | 1 | 69583 | 1 | 1.313 | 52995.4 |
| 252 | 2024-03-18 22:29:04 | panoply | 3 | 134027 | 103 | 8.233 | 16279.2 |
| 251 | 2024-03-18 22:29:02 | panoply | 2 | 107671 | 3 | 7.826 | 13758.1 |
| 250 | 2024-03-18 22:28:50 | panoply | 1 | 69583 | 1 | 1.453 | 47889.2 |
| 249 | 2024-03-13 04:32:06 | panoply | 3 | 134027 | 103 | 13.640 | 9826.0 |
| 248 | 2024-03-12 08:35:58 | panoply | 3 | 134027 | 103 | 9.283 | 14437.9 |
| 247 | 2024-03-10 23:00:01 | panoply | 3 | 134027 | 103 | 7.423 | 18055.6 |
| 246 | 2024-03-10 22:59:46 | panoply | 2 | 107671 | 3 | 6.956 | 15478.9 |
| 245 | 2024-03-06 06:11:37 | panoply | 1 | 69583 | 1 | 4.390 | 15850.3 |
| 244 | 2024-03-06 06:11:15 | panoply | 2 | 107671 | 3 | 7.906 | 13618.9 |
| 243 | 2024-03-06 06:11:00 | panoply | 1 | 69583 | 1 | 2.516 | 27656.2 |
| 242 | 2024-03-04 21:12:37 | panoply | 3 | 134027 | 103 | 21.893 | 6121.9 |
| 241 | 2024-03-04 21:12:38 | panoply | 2 | 107671 | 3 | 10.796 | 9973.2 |
| 240 | 2024-03-04 21:07:53 | panoply | 1 | 69583 | 1 | 1.373 | 50679.5 |
| 239 | 2024-03-04 20:23:07 | panoply | 1 | 69583 | 1 | 1.440 | 48321.5 |
| 238 | 2024-02-09 18:54:47 | panoply | 3 | 134027 | 103 | 7.690 | 17428.7 |
| 237 | 2024-02-09 18:54:48 | panoply | 2 | 107671 | 3 | 5.843 | 18427.3 |
| 236 | 2024-02-07 15:20:46 | panoply | 2 | 107671 | 3 | 2.920 | 36873.6 |
| 235 | 2024-02-07 15:19:22 | panoply | 3 | 134027 | 103 | 7.796 | 17191.8 |
| 234 | 2024-02-05 17:09:37 | panoply | 3 | 134027 | 103 | 7.623 | 17581.9 |
| 233 | 2024-02-05 17:09:34 | panoply | 2 | 107671 | 3 | 3.670 | 29338.1 |
| 232 | 2024-02-05 17:09:29 | panoply | 1 | 69583 | 1 | 1.296 | 53690.6 |
| 231 | 2024-01-06 14:20:26 | panoply | 1 | 69583 | 1 | 1.126 | 61796.6 |
| 230 | 2023-12-28 12:16:35 | panoply | 1 | 69583 | 1 | 2.593 | 26834.9 |
| 229 | 2023-12-23 22:18:43 | panoply | 1 | 69583 | 1 | 1.156 | 60192.9 |
| 228 | 2023-11-22 18:34:31 | panoply | 1 | 69583 | 1 | 1.123 | 61961.7 |
| 227 | 2023-11-20 02:47:11 | panoply | 1 | 69583 | 1 | 1.220 | 57035.2 |
| 226 | 2023-10-28 06:12:49 | panoply | 1 | 69583 | 1 | 1.110 | 62687.4 |
| 225 | 2023-10-16 04:23:37 | panoply | 1 | 69583 | 1 | 1.096 | 63488.1 |
| 224 | 2023-09-27 15:24:35 | panoply | 1 | 69583 | 1 | 1.096 | 63488.1 |
| 223 | 2023-08-12 00:30:31 | panoply | 1 | 69583 | 1 | 1.216 | 57222.9 |
| 222 | 2023-07-11 11:01:17 | panoply | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 221 | 2023-05-10 13:17:59 | panoply | 1 | 69583 | 1 | 1.733 | 40151.8 |
| 220 | 2023-03-07 10:43:10 | panoply | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 219 | 2023-03-05 06:49:03 | panoply | 1 | 69583 | 1 | 1.220 | 57035.2 |
| 218 | 2022-12-27 09:52:01 | panoply | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 217 | 2022-11-26 19:48:24 | panoply | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 216 | 2022-11-22 12:57:52 | panoply | 1 | 69583 | 1 | 1.143 | 60877.5 |
| 215 | 2022-10-25 01:43:34 | panoply | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 214 | 2022-09-13 06:08:21 | panoply | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 213 | 2022-07-18 19:42:03 | panoply | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 212 | 2022-06-20 02:20:30 | panoply | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 211 | 2022-02-01 05:58:03 | panoply | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 210 | 2021-10-02 11:27:08 | panoply | 1 | 69583 | 1 | 1.530 | 45479.1 |
| 209 | 2021-09-29 06:08:22 | panoply | 1 | 69583 | 1 | 1.236 | 56296.9 |
| 208 | 2021-06-22 22:52:04 | panoply | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 207 | 2021-06-19 18:13:08 | panoply | 1 | 69583 | 1 | 1.140 | 61037.7 |
| 206 | 2021-05-20 09:53:19 | panoply | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 205 | 2021-03-17 05:02:06 | panoply | 1 | 69583 | 1 | 1.233 | 56433.9 |
| 204 | 2021-02-21 11:16:43 | panoply | 2 | 107671 | 3 | 2.906 | 37051.3 |
| 203 | 2020-12-10 15:47:13 | panoply | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 202 | 2020-12-06 11:31:12 | panoply | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 201 | 2020-11-08 15:44:34 | panoply | 1 | 69583 | 1 | 1.266 | 54962.9 |
| 200 | 2020-10-26 18:29:01 | panoply | 1 | 69583 | 1 | 1.126 | 61796.6 |
| 199 | 2020-10-26 15:04:04 | panoply | 1 | 69583 | 1 | 1.123 | 61961.7 |
| 198 | 2020-08-31 12:33:46 | panoply | 1 | 69583 | 1 | 1.156 | 60192.9 |
| 197 | 2020-05-20 16:13:15 | panoply | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 196 | 2020-03-28 15:34:37 | panoply | 1 | 69583 | 1 | 2.516 | 27656.2 |
| 195 | 2020-03-28 03:11:55 | panoply | 1 | 69583 | 1 | 1.206 | 57697.3 |
| 194 | 2020-03-22 18:51:19 | panoply | 1 | 69583 | 1 | 1.360 | 51164.0 |
| 193 | 2020-03-05 15:34:03 | panoply | 1 | 69583 | 1 | 1.376 | 50569.0 |
| 192 | 2020-02-25 21:57:05 | panoply | 1 | 69583 | 1 | 1.406 | 49490.0 |
| 191 | 2020-02-24 21:01:13 | panoply | 1 | 69583 | 1 | 1.250 | 55666.4 |
| 190 | 2020-02-14 12:25:53 | panoply | 1 | 69583 | 1 | 1.450 | 47988.3 |
| 189 | 2020-02-08 21:31:30 | panoply | 1 | 69583 | 1 | 1.440 | 48321.5 |
| 188 | 2020-02-08 21:21:23 | panoply | 1 | 69583 | 1 | 2.936 | 23699.9 |
| 187 | 2020-02-08 05:04:24 | panoply | 1 | 69583 | 1 | 1.233 | 56433.9 |
| 186 | 2020-02-07 12:51:27 | panoply | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 185 | 2020-01-29 01:49:26 | panoply | 1 | 69583 | 1 | 1.126 | 61796.6 |
| 184 | 2020-01-25 13:13:44 | panoply | 1 | 69583 | 1 | 2.016 | 34515.4 |
| 183 | 2020-01-22 19:13:47 | panoply | 1 | 69583 | 1 | 2.906 | 23944.6 |
| 182 | 2020-01-21 21:39:44 | panoply | 1 | 69583 | 1 | 1.110 | 62687.4 |
| 181 | 2020-01-13 05:04:46 | panoply | 1 | 69583 | 1 | 2.250 | 30925.8 |
| 180 | 2020-01-08 21:51:15 | panoply | 1 | 69583 | 1 | 2.640 | 26357.2 |
| 179 | 2020-01-08 01:28:08 | panoply | 1 | 69583 | 1 | 1.330 | 52318.0 |
| 178 | 2019-12-31 06:09:52 | panoply | 1 | 69583 | 1 | 1.390 | 50059.7 |
| 177 | 2019-12-25 10:00:28 | panoply | 1 | 69583 | 1 | 1.110 | 62687.4 |
| 176 | 2019-11-08 10:40:40 | panoply | 1 | 69583 | 1 | 1.156 | 60192.9 |
| 175 | 2019-08-10 07:38:03 | panoply | 1 | 69583 | 1 | 1.033 | 67360.1 |
| 174 | 2019-05-01 00:12:01 | panoply | 1 | 69583 | 1 | 1.210 | 57506.6 |
| 173 | 2019-04-04 19:35:50 | panoply | 1 | 69583 | 1 | 1.100 | 63257.3 |
| 172 | 2019-02-05 09:28:05 | panoply | 3 | 134027 | 103 | 6.080 | 22043.9 |
| 171 | 2019-02-05 09:13:47 | panoply | 1 | 69583 | 1 | 1.183 | 58819.1 |
| 170 | 2019-01-09 13:23:31 | panoply | 1 | 69583 | 1 | 1.106 | 62914.1 |