History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sapient"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 296 | 2024-05-06 06:02:50 | sapient | 1 | 69583 | 4 | 1.360 | 51164.0 |
| 295 | 2024-05-01 09:50:58 | sapient | 1 | 69583 | 4 | 1.766 | 39401.5 |
| 294 | 2024-03-20 01:42:48 | sapient | 1 | 69583 | 4 | 1.296 | 53690.6 |
| 293 | 2024-02-08 21:16:50 | sapient | 3 | 134027 | 320 | 11.470 | 11685.0 |
| 292 | 2024-01-17 09:51:24 | sapient | 2 | 107671 | 20 | 3.500 | 30763.1 |
| 291 | 2024-01-10 10:26:18 | sapient | 2 | 107671 | 20 | 3.080 | 34958.1 |
| 290 | 2023-12-20 07:36:11 | sapient | 1 | 69583 | 4 | 1.266 | 54962.9 |
| 289 | 2023-12-16 23:47:45 | sapient | 3 | 134027 | 320 | 7.813 | 17154.4 |
| 288 | 2023-12-16 20:32:21 | sapient | 3 | 134027 | 320 | 7.530 | 17799.1 |
| 287 | 2023-12-15 08:25:27 | sapient | 3 | 134027 | 320 | 6.796 | 19721.5 |
| 286 | 2023-12-13 09:24:37 | sapient | 1 | 69583 | 4 | 1.403 | 49595.9 |
| 285 | 2023-12-07 15:25:27 | sapient | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 284 | 2023-11-17 05:41:55 | sapient | 1 | 69583 | 4 | 1.140 | 61037.7 |
| 283 | 2023-11-12 03:23:20 | sapient | 3 | 134027 | 320 | 6.000 | 22337.8 |
| 282 | 2023-11-11 04:48:09 | sapient | 1 | 69583 | 4 | 1.123 | 61961.7 |
| 281 | 2023-11-06 11:20:07 | sapient | 1 | 69583 | 4 | 1.280 | 54361.7 |
| 280 | 2023-11-04 15:00:03 | sapient | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 279 | 2023-11-02 16:45:24 | sapient | 2 | 107671 | 20 | 3.343 | 32207.9 |
| 278 | 2023-10-20 07:47:09 | sapient | 2 | 107671 | 20 | 3.313 | 32499.5 |
| 277 | 2023-10-14 21:40:54 | sapient | 1 | 69583 | 4 | 1.140 | 61037.7 |
| 276 | 2023-09-29 15:09:22 | sapient | 1 | 69583 | 4 | 1.123 | 61961.7 |
| 275 | 2023-09-27 16:11:02 | sapient | 1 | 69583 | 4 | 1.266 | 54962.9 |
| 274 | 2023-09-24 02:50:59 | sapient | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 273 | 2023-08-20 21:30:31 | sapient | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 272 | 2023-08-15 07:51:14 | sapient | 3 | 134027 | 320 | 6.046 | 22167.9 |
| 271 | 2023-07-31 23:35:57 | sapient | 2 | 107671 | 20 | 3.030 | 35535.0 |
| 270 | 2023-07-25 06:25:37 | sapient | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 269 | 2023-04-29 23:28:02 | sapient | 3 | 134027 | 320 | 5.906 | 22693.4 |
| 268 | 2023-04-22 03:56:34 | sapient | 1 | 69583 | 4 | 1.266 | 54962.9 |
| 267 | 2023-04-22 00:38:01 | sapient | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 266 | 2023-04-10 11:42:14 | sapient | 2 | 107671 | 20 | 2.876 | 37437.8 |
| 265 | 2023-02-13 13:21:28 | sapient | 1 | 69583 | 4 | 1.233 | 56433.9 |
| 264 | 2023-02-02 08:55:21 | sapient | 3 | 134027 | 320 | 5.876 | 22809.2 |
| 263 | 2023-01-16 18:28:32 | sapient | 3 | 134027 | 320 | 5.860 | 22871.5 |
| 262 | 2023-01-14 01:42:08 | sapient | 2 | 107671 | 20 | 2.876 | 37437.8 |
| 261 | 2022-12-25 20:45:12 | sapient | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 260 | 2022-12-11 16:27:04 | sapient | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 259 | 2022-12-02 19:27:26 | sapient | 3 | 134027 | 320 | 7.080 | 18930.4 |
| 258 | 2022-11-14 17:50:48 | sapient | 3 | 134027 | 320 | 6.766 | 19808.9 |
| 257 | 2022-11-05 15:09:12 | sapient | 3 | 134027 | 320 | 6.283 | 21331.7 |
| 256 | 2022-11-03 14:42:57 | sapient | 3 | 134027 | 320 | 8.546 | 15683.0 |
| 255 | 2022-10-21 04:15:06 | sapient | 3 | 134027 | 320 | 5.860 | 22871.5 |
| 254 | 2022-10-16 07:06:00 | sapient | 2 | 107671 | 20 | 5.766 | 18673.4 |
| 253 | 2022-10-02 15:03:40 | sapient | 3 | 134027 | 320 | 6.563 | 20421.6 |
| 252 | 2022-09-23 22:55:05 | sapient | 3 | 134027 | 320 | 6.546 | 20474.6 |
| 251 | 2022-08-30 00:40:23 | sapient | 3 | 134027 | 320 | 5.970 | 22450.1 |
| 250 | 2022-08-28 23:54:35 | sapient | 1 | 69583 | 4 | 1.126 | 61796.6 |
| 249 | 2022-08-25 16:32:59 | sapient | 1 | 69583 | 4 | 1.123 | 61961.7 |
| 248 | 2022-08-18 16:48:17 | sapient | 1 | 69583 | 4 | 1.143 | 60877.5 |
| 247 | 2022-08-15 19:24:42 | sapient | 1 | 69583 | 4 | 1.123 | 61961.7 |
| 246 | 2022-07-26 11:15:32 | sapient | 1 | 69583 | 4 | 1.233 | 56433.9 |
| 245 | 2022-06-17 07:55:32 | sapient | 3 | 134027 | 320 | 6.080 | 22043.9 |
| 244 | 2022-05-15 01:02:01 | sapient | 2 | 107671 | 20 | 2.953 | 36461.6 |
| 243 | 2022-04-18 00:49:43 | sapient | 1 | 69583 | 4 | 1.106 | 62914.1 |
| 242 | 2022-04-12 13:13:19 | sapient | 1 | 69583 | 4 | 1.326 | 52475.9 |
| 241 | 2022-04-10 08:29:34 | sapient | 1 | 69583 | 4 | 1.126 | 61796.6 |
| 240 | 2022-01-06 05:24:20 | sapient | 1 | 69583 | 4 | 1.360 | 51164.0 |
| 239 | 2021-12-23 13:31:06 | sapient | 1 | 69583 | 4 | 1.283 | 54234.6 |
| 238 | 2021-11-06 11:52:52 | sapient | 1 | 69583 | 4 | 1.466 | 47464.5 |
| 237 | 2021-10-08 19:16:28 | sapient | 1 | 69583 | 4 | 1.220 | 57035.2 |
| 236 | 2021-09-21 12:27:29 | sapient | 1 | 69583 | 4 | 1.126 | 61796.6 |
| 235 | 2021-09-14 02:04:41 | sapient | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 234 | 2021-09-06 16:11:09 | sapient | 1 | 69583 | 4 | 1.140 | 61037.7 |
| 233 | 2021-08-01 03:25:42 | sapient | 1 | 69583 | 4 | 1.233 | 56433.9 |
| 232 | 2021-07-02 08:32:38 | sapient | 1 | 69583 | 4 | 1.220 | 57035.2 |
| 231 | 2021-06-02 12:28:33 | sapient | 1 | 69583 | 4 | 1.280 | 54361.7 |
| 230 | 2021-03-26 00:41:26 | sapient | 1 | 69583 | 4 | 1.686 | 41271.1 |
| 229 | 2021-02-28 05:54:26 | sapient | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 228 | 2021-02-27 20:33:23 | sapient | 1 | 69583 | 4 | 1.126 | 61796.6 |
| 227 | 2021-01-26 20:03:07 | sapient | 1 | 69583 | 4 | 1.216 | 57222.9 |
| 226 | 2020-11-18 13:07:26 | sapient | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 225 | 2020-11-09 05:47:41 | sapient | 1 | 69583 | 4 | 1.263 | 55093.4 |
| 224 | 2020-09-06 01:21:47 | sapient | 1 | 69583 | 4 | 1.233 | 56433.9 |
| 223 | 2020-08-25 08:43:32 | sapient | 1 | 69583 | 4 | 1.156 | 60192.9 |
| 222 | 2020-08-03 11:07:12 | sapient | 1 | 69583 | 4 | 1.310 | 53116.8 |
| 221 | 2020-06-03 08:09:53 | sapient | 1 | 69583 | 4 | 1.156 | 60192.9 |
| 220 | 2020-04-25 15:12:03 | sapient | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 219 | 2020-03-28 21:38:23 | sapient | 1 | 69583 | 4 | 1.263 | 55093.4 |
| 218 | 2020-03-26 05:37:40 | sapient | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 217 | 2020-03-23 19:12:48 | sapient | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 216 | 2020-03-20 11:18:29 | sapient | 1 | 69583 | 4 | 1.233 | 56433.9 |
| 215 | 2020-03-04 18:40:33 | sapient | 1 | 69583 | 4 | 1.143 | 60877.5 |
| 214 | 2020-02-28 11:02:31 | sapient | 1 | 69583 | 4 | 1.296 | 53690.6 |
| 213 | 2020-02-23 23:22:09 | sapient | 1 | 69583 | 4 | 1.266 | 54962.9 |
| 212 | 2020-02-22 12:45:59 | sapient | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 211 | 2020-02-07 06:49:09 | sapient | 1 | 69583 | 4 | 1.296 | 53690.6 |
| 210 | 2020-02-06 11:27:54 | sapient | 1 | 69583 | 4 | 1.343 | 51811.6 |
| 209 | 2020-02-04 05:05:27 | sapient | 1 | 69583 | 4 | 1.296 | 53690.6 |
| 208 | 2020-02-02 11:29:59 | sapient | 1 | 69583 | 4 | 1.406 | 49490.0 |
| 207 | 2020-02-02 08:26:40 | sapient | 1 | 69583 | 4 | 1.906 | 36507.3 |
| 206 | 2020-01-29 05:17:26 | sapient | 1 | 69583 | 4 | 1.296 | 53690.6 |
| 205 | 2020-01-28 17:58:56 | sapient | 1 | 69583 | 4 | 1.123 | 61961.7 |
| 204 | 2020-01-24 11:02:02 | sapient | 1 | 69583 | 4 | 3.266 | 21305.3 |
| 203 | 2020-01-19 01:51:46 | sapient | 1 | 69583 | 4 | 2.126 | 32729.5 |
| 202 | 2020-01-15 18:20:48 | sapient | 1 | 69583 | 4 | 1.360 | 51164.0 |
| 201 | 2020-01-15 09:06:56 | sapient | 1 | 69583 | 4 | 1.343 | 51811.6 |
| 200 | 2020-01-12 02:37:51 | sapient | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 199 | 2020-01-07 00:15:12 | sapient | 1 | 69583 | 4 | 3.720 | 18705.1 |
| 198 | 2019-12-28 17:38:47 | sapient | 1 | 69583 | 4 | 1.300 | 53525.4 |
| 197 | 2019-12-26 23:17:02 | sapient | 1 | 69583 | 4 | 1.360 | 51164.0 |