History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pianist"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 281 | 2024-05-03 17:20:27 | pianist | 1 | 69583 | 3 | 2.640 | 26357.2 |
| 280 | 2024-04-28 09:00:01 | pianist | 1 | 69583 | 3 | 3.923 | 17737.2 |
| 279 | 2024-04-17 04:05:06 | pianist | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 278 | 2024-03-08 11:10:56 | pianist | 1 | 69583 | 3 | 2.063 | 33729.0 |
| 277 | 2024-01-14 20:48:44 | pianist | 3 | 134027 | 269 | 6.956 | 19267.8 |
| 276 | 2024-01-14 20:48:46 | pianist | 2 | 107671 | 19 | 3.423 | 31455.2 |
| 275 | 2024-01-09 03:07:48 | pianist | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 274 | 2024-01-01 05:56:41 | pianist | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 273 | 2023-12-17 05:23:47 | pianist | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 272 | 2023-12-10 19:45:02 | pianist | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 271 | 2023-11-17 08:00:07 | pianist | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 270 | 2023-11-05 18:03:38 | pianist | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 269 | 2023-11-02 05:22:57 | pianist | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 268 | 2023-10-22 01:51:51 | pianist | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 267 | 2023-10-11 11:49:36 | pianist | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 266 | 2023-09-26 08:17:41 | pianist | 1 | 69583 | 3 | 1.096 | 63488.1 |
| 265 | 2023-09-22 08:03:12 | pianist | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 264 | 2023-09-16 12:33:01 | pianist | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 263 | 2023-08-18 09:12:57 | pianist | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 262 | 2023-05-27 03:26:41 | pianist | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 261 | 2023-05-21 09:45:49 | pianist | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 260 | 2023-02-14 07:17:44 | pianist | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 259 | 2023-01-04 22:07:06 | pianist | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 258 | 2022-10-31 15:13:36 | pianist | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 257 | 2022-09-25 20:56:21 | pianist | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 256 | 2022-07-18 04:56:38 | pianist | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 255 | 2022-05-09 08:20:56 | pianist | 1 | 69583 | 3 | 1.516 | 45899.1 |
| 254 | 2022-03-31 03:04:07 | pianist | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 253 | 2022-01-23 22:56:09 | pianist | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 252 | 2021-12-19 20:47:32 | pianist | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 251 | 2021-12-04 00:54:01 | pianist | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 250 | 2021-09-12 15:31:13 | pianist | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 249 | 2021-07-06 17:57:06 | pianist | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 248 | 2021-06-12 11:00:15 | pianist | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 247 | 2021-04-21 08:35:07 | pianist | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 246 | 2021-03-19 20:18:33 | pianist | 3 | 134027 | 269 | 6.720 | 19944.5 |
| 245 | 2021-03-13 01:08:55 | pianist | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 244 | 2021-02-22 15:32:10 | pianist | 3 | 134027 | 269 | 6.890 | 19452.4 |
| 243 | 2021-02-02 06:54:53 | pianist | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 242 | 2021-01-06 04:19:41 | pianist | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 241 | 2020-12-09 21:15:48 | pianist | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 240 | 2020-11-18 14:06:33 | pianist | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 239 | 2020-11-12 03:15:57 | pianist | 3 | 134027 | 269 | 6.873 | 19500.5 |
| 238 | 2020-10-27 07:41:12 | pianist | 1 | 69583 | 3 | 1.423 | 48898.8 |
| 237 | 2020-10-26 13:08:49 | pianist | 3 | 134027 | 269 | 5.890 | 22755.0 |
| 236 | 2020-10-26 04:13:14 | pianist | 3 | 134027 | 269 | 6.236 | 21492.5 |
| 235 | 2020-10-21 18:35:25 | pianist | 3 | 134027 | 269 | 6.780 | 19768.0 |
| 234 | 2020-10-15 00:22:35 | pianist | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 233 | 2020-10-14 13:28:35 | pianist | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 232 | 2020-09-26 06:42:21 | pianist | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 231 | 2020-09-03 05:09:41 | pianist | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 230 | 2020-08-29 00:19:53 | pianist | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 229 | 2020-08-24 00:59:39 | pianist | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 228 | 2020-08-09 03:52:55 | pianist | 3 | 134027 | 269 | 6.203 | 21606.8 |
| 227 | 2020-05-26 04:36:27 | pianist | 1 | 69583 | 3 | 1.160 | 59985.3 |
| 226 | 2020-03-28 23:40:43 | pianist | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 225 | 2020-03-24 21:35:09 | pianist | 1 | 69583 | 3 | 1.856 | 37490.8 |
| 224 | 2020-03-23 09:03:29 | pianist | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 223 | 2020-03-20 16:30:07 | pianist | 1 | 69583 | 3 | 2.640 | 26357.2 |
| 222 | 2020-03-17 11:29:03 | pianist | 1 | 69583 | 3 | 2.563 | 27149.0 |
| 221 | 2020-03-03 01:10:17 | pianist | 3 | 134027 | 269 | 13.826 | 9693.8 |
| 220 | 2020-03-02 22:57:45 | pianist | 3 | 134027 | 269 | 15.360 | 8725.7 |
| 219 | 2020-03-01 19:38:30 | pianist | 3 | 134027 | 269 | 6.203 | 21606.8 |
| 218 | 2020-02-29 03:41:26 | pianist | 3 | 134027 | 269 | 22.080 | 6070.1 |
| 217 | 2020-02-29 01:19:20 | pianist | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 216 | 2020-02-27 10:29:04 | pianist | 3 | 134027 | 269 | 7.486 | 17903.7 |
| 215 | 2020-02-24 12:52:54 | pianist | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 214 | 2020-02-22 22:58:29 | pianist | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 213 | 2020-02-22 14:32:20 | pianist | 3 | 134027 | 269 | 9.360 | 14319.1 |
| 212 | 2020-02-22 13:27:04 | pianist | 3 | 134027 | 269 | 13.343 | 10044.7 |
| 211 | 2020-02-15 12:46:06 | pianist | 1 | 69583 | 3 | 1.483 | 46920.4 |
| 210 | 2020-02-09 10:53:34 | pianist | 1 | 69583 | 3 | 1.420 | 49002.1 |
| 209 | 2020-02-07 04:09:52 | pianist | 1 | 69583 | 3 | 2.843 | 24475.2 |
| 208 | 2020-02-06 02:15:24 | pianist | 1 | 69583 | 3 | 1.360 | 51164.0 |
| 207 | 2020-02-05 05:49:09 | pianist | 1 | 69583 | 3 | 3.813 | 18248.9 |
| 206 | 2020-02-01 10:05:40 | pianist | 1 | 69583 | 3 | 1.326 | 52475.9 |
| 205 | 2020-01-28 04:39:05 | pianist | 1 | 69583 | 3 | 2.720 | 25582.0 |
| 204 | 2020-01-23 11:47:31 | pianist | 1 | 69583 | 3 | 2.533 | 27470.6 |
| 203 | 2020-01-22 10:19:15 | pianist | 3 | 134027 | 269 | 8.530 | 15712.4 |
| 202 | 2020-01-22 04:50:31 | pianist | 3 | 134027 | 269 | 18.830 | 7117.7 |
| 201 | 2020-01-22 03:43:56 | pianist | 3 | 134027 | 269 | 11.703 | 11452.4 |
| 200 | 2020-01-22 03:43:04 | pianist | 3 | 134027 | 269 | 22.783 | 5882.8 |
| 199 | 2020-01-21 23:25:29 | pianist | 3 | 134027 | 269 | 12.063 | 11110.6 |
| 198 | 2020-01-15 19:27:01 | pianist | 1 | 69583 | 3 | 1.326 | 52475.9 |
| 197 | 2020-01-15 12:24:33 | pianist | 3 | 134027 | 269 | 7.576 | 17691.0 |
| 196 | 2020-01-15 10:57:46 | pianist | 1 | 69583 | 3 | 1.546 | 45008.4 |
| 195 | 2020-01-12 09:44:10 | pianist | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 194 | 2020-01-08 23:30:26 | pianist | 1 | 69583 | 3 | 1.343 | 51811.6 |
| 193 | 2020-01-08 09:26:18 | pianist | 1 | 69583 | 3 | 3.563 | 19529.3 |
| 192 | 2019-12-31 07:39:22 | pianist | 3 | 134027 | 269 | 7.516 | 17832.2 |
| 191 | 2019-12-29 14:56:55 | pianist | 3 | 134027 | 269 | 7.580 | 17681.7 |
| 190 | 2019-12-28 04:53:05 | pianist | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 189 | 2019-12-27 05:16:54 | pianist | 3 | 134027 | 269 | 7.750 | 17293.8 |
| 188 | 2019-12-27 03:33:49 | pianist | 1 | 69583 | 3 | 1.330 | 52318.0 |
| 187 | 2019-12-27 02:24:13 | pianist | 1 | 69583 | 3 | 1.406 | 49490.0 |
| 186 | 2019-12-26 07:19:30 | pianist | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 185 | 2019-11-30 13:51:01 | pianist | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 184 | 2019-11-20 21:55:21 | pianist | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 183 | 2019-10-28 02:48:05 | pianist | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 182 | 2019-09-22 19:35:15 | pianist | 1 | 69583 | 3 | 1.123 | 61961.7 |