History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"surplus"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 248 | 2024-04-05 04:42:21 | surplus | 3 | 134027 | 142 | 18.110 | 7400.7 |
| 247 | 2024-04-03 13:12:42 | surplus | 3 | 134027 | 142 | 20.440 | 6557.1 |
| 246 | 2024-04-03 13:11:29 | surplus | 2 | 107671 | 7 | 8.906 | 12089.7 |
| 245 | 2024-04-03 13:10:46 | surplus | 1 | 69583 | 1 | 3.140 | 22160.2 |
| 244 | 2024-04-03 10:05:46 | surplus | 3 | 134027 | 142 | 12.953 | 10347.2 |
| 243 | 2024-04-01 16:52:33 | surplus | 1 | 69583 | 1 | 1.500 | 46388.7 |
| 242 | 2024-03-31 10:02:35 | surplus | 3 | 134027 | 142 | 15.360 | 8725.7 |
| 241 | 2024-03-31 10:02:33 | surplus | 2 | 107671 | 7 | 10.173 | 10584.0 |
| 240 | 2024-03-31 09:19:51 | surplus | 1 | 69583 | 1 | 2.796 | 24886.6 |
| 239 | 2024-03-30 14:55:39 | surplus | 1 | 69583 | 1 | 5.360 | 12981.9 |
| 238 | 2024-03-29 01:49:03 | surplus | 1 | 69583 | 1 | 1.436 | 48456.1 |
| 237 | 2024-02-29 07:40:46 | surplus | 1 | 69583 | 1 | 1.300 | 53525.4 |
| 236 | 2024-02-09 06:32:09 | surplus | 1 | 69583 | 1 | 1.403 | 49595.9 |
| 235 | 2023-12-24 23:00:27 | surplus | 1 | 69583 | 1 | 1.156 | 60192.9 |
| 234 | 2023-12-09 16:32:45 | surplus | 1 | 69583 | 1 | 1.220 | 57035.2 |
| 233 | 2023-11-29 18:18:58 | surplus | 1 | 69583 | 1 | 1.123 | 61961.7 |
| 232 | 2023-09-17 02:57:06 | surplus | 1 | 69583 | 1 | 1.440 | 48321.5 |
| 231 | 2023-09-14 10:37:15 | surplus | 1 | 69583 | 1 | 1.250 | 55666.4 |
| 230 | 2023-06-28 07:01:59 | surplus | 1 | 69583 | 1 | 1.266 | 54962.9 |
| 229 | 2023-04-09 17:43:38 | surplus | 1 | 69583 | 1 | 1.283 | 54234.6 |
| 228 | 2023-02-01 15:51:54 | surplus | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 227 | 2022-08-29 01:43:52 | surplus | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 226 | 2022-08-21 16:23:56 | surplus | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 225 | 2022-08-18 18:56:28 | surplus | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 224 | 2022-06-17 10:29:26 | surplus | 1 | 69583 | 1 | 1.140 | 61037.7 |
| 223 | 2022-06-10 16:02:12 | surplus | 1 | 69583 | 1 | 1.266 | 54962.9 |
| 222 | 2022-06-07 13:39:57 | surplus | 1 | 69583 | 1 | 1.640 | 42428.7 |
| 221 | 2022-06-04 10:46:54 | surplus | 1 | 69583 | 1 | 1.110 | 62687.4 |
| 220 | 2022-05-04 19:08:52 | surplus | 1 | 69583 | 1 | 1.280 | 54361.7 |
| 219 | 2021-05-23 20:10:44 | surplus | 1 | 69583 | 1 | 1.283 | 54234.6 |
| 218 | 2021-03-27 00:27:28 | surplus | 1 | 69583 | 1 | 1.140 | 61037.7 |
| 217 | 2021-01-10 07:52:12 | surplus | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 216 | 2020-11-18 12:29:27 | surplus | 1 | 69583 | 1 | 1.140 | 61037.7 |
| 215 | 2020-11-10 07:09:50 | surplus | 1 | 69583 | 1 | 1.250 | 55666.4 |
| 214 | 2020-10-22 17:49:48 | surplus | 1 | 69583 | 1 | 1.280 | 54361.7 |
| 213 | 2020-04-03 03:40:01 | surplus | 1 | 69583 | 1 | 1.220 | 57035.2 |
| 212 | 2020-03-29 14:02:45 | surplus | 1 | 69583 | 1 | 1.343 | 51811.6 |
| 211 | 2020-03-21 22:55:03 | surplus | 1 | 69583 | 1 | 1.236 | 56296.9 |
| 210 | 2020-03-02 18:54:32 | surplus | 1 | 69583 | 1 | 1.296 | 53690.6 |
| 209 | 2020-03-02 16:51:07 | surplus | 1 | 69583 | 1 | 2.653 | 26228.0 |
| 208 | 2020-02-29 19:16:41 | surplus | 3 | 134027 | 142 | 8.330 | 16089.7 |
| 207 | 2020-02-23 23:09:07 | surplus | 1 | 69583 | 1 | 2.673 | 26031.8 |
| 206 | 2020-02-23 05:41:22 | surplus | 3 | 134027 | 142 | 8.903 | 15054.1 |
| 205 | 2020-02-23 04:32:18 | surplus | 3 | 134027 | 142 | 15.580 | 8602.5 |
| 204 | 2020-02-22 16:36:25 | surplus | 3 | 134027 | 142 | 6.940 | 19312.2 |
| 203 | 2020-02-19 11:02:14 | surplus | 1 | 69583 | 1 | 1.326 | 52475.9 |
| 202 | 2020-02-11 22:27:57 | surplus | 1 | 69583 | 1 | 1.373 | 50679.5 |
| 201 | 2020-02-11 17:47:41 | surplus | 1 | 69583 | 1 | 1.423 | 48898.8 |
| 200 | 2020-02-07 04:06:47 | surplus | 1 | 69583 | 1 | 1.266 | 54962.9 |
| 199 | 2020-02-04 23:31:15 | surplus | 1 | 69583 | 1 | 1.310 | 53116.8 |
| 198 | 2020-01-28 16:08:54 | surplus | 1 | 69583 | 1 | 1.126 | 61796.6 |
| 197 | 2020-01-27 12:38:05 | surplus | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 196 | 2020-01-26 13:26:52 | surplus | 1 | 69583 | 1 | 3.173 | 21929.7 |
| 195 | 2020-01-25 08:55:29 | surplus | 3 | 134027 | 142 | 9.016 | 14865.5 |
| 194 | 2020-01-25 08:11:40 | surplus | 3 | 134027 | 142 | 14.360 | 9333.4 |
| 193 | 2020-01-25 02:41:47 | surplus | 3 | 134027 | 142 | 11.500 | 11654.5 |
| 192 | 2020-01-20 21:12:04 | surplus | 1 | 69583 | 1 | 1.360 | 51164.0 |
| 191 | 2020-01-15 21:04:27 | surplus | 1 | 69583 | 1 | 1.360 | 51164.0 |
| 190 | 2020-01-09 01:21:19 | surplus | 1 | 69583 | 1 | 1.343 | 51811.6 |
| 189 | 2020-01-08 23:34:47 | surplus | 1 | 69583 | 1 | 1.390 | 50059.7 |
| 188 | 2020-01-04 21:19:39 | surplus | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 187 | 2019-12-29 21:34:55 | surplus | 1 | 69583 | 1 | 4.093 | 17000.5 |
| 186 | 2019-12-29 16:45:06 | surplus | 1 | 69583 | 1 | 1.250 | 55666.4 |
| 185 | 2019-12-23 03:30:36 | surplus | 1 | 69583 | 1 | 1.513 | 45990.1 |
| 184 | 2019-09-22 03:04:40 | surplus | 1 | 69583 | 1 | 1.273 | 54660.6 |
| 183 | 2019-06-10 02:13:11 | surplus | 1 | 69583 | 1 | 1.236 | 56296.9 |
| 182 | 2019-03-12 18:58:58 | surplus | 1 | 69583 | 1 | 1.233 | 56433.9 |
| 181 | 2019-02-23 21:52:11 | surplus | 2 | 107671 | 7 | 3.383 | 31827.1 |
| 180 | 2019-02-23 17:57:02 | surplus | 1 | 69583 | 1 | 1.100 | 63257.3 |
| 179 | 2019-02-13 04:55:47 | surplus | 1 | 69583 | 1 | 1.206 | 57697.3 |
| 178 | 2019-02-05 01:07:59 | surplus | 3 | 134027 | 142 | 7.330 | 18284.7 |
| 177 | 2019-01-30 14:57:37 | surplus | 3 | 134027 | 142 | 6.396 | 20954.8 |
| 176 | 2019-01-28 23:43:32 | surplus | 2 | 107671 | 7 | 3.156 | 34116.3 |
| 175 | 2019-01-28 23:39:59 | surplus | 1 | 69583 | 1 | 1.070 | 65030.8 |
| 174 | 2019-01-24 09:28:31 | surplus | 3 | 134027 | 142 | 6.476 | 20696.0 |
| 173 | 2019-01-23 17:46:03 | surplus | 2 | 107671 | 7 | 2.943 | 36585.5 |
| 172 | 2019-01-23 17:26:15 | surplus | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 171 | 2019-01-04 22:51:42 | surplus | 1 | 69583 | 1 | 1.070 | 65030.8 |
| 170 | 2019-01-01 01:01:01 | surplus | 1 | 69583 | 1 | 1.193 | 58326.1 |
| 169 | 2018-12-24 10:21:43 | surplus | 1 | 69583 | 1 | 1.136 | 61252.6 |
| 168 | 2018-12-22 11:06:54 | surplus | 1 | 69583 | 1 | 1.046 | 66522.9 |
| 167 | 2018-12-20 11:57:21 | surplus | 1 | 69583 | 1 | 1.060 | 65644.3 |
| 166 | 2018-12-18 13:51:07 | surplus | 1 | 69583 | 1 | 1.056 | 65893.0 |
| 165 | 2018-12-15 02:11:14 | surplus | 1 | 69583 | 1 | 1.050 | 66269.5 |
| 164 | 2018-12-07 12:55:25 | surplus | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 163 | 2018-12-03 14:15:58 | surplus | 1 | 69583 | 1 | 1.106 | 62914.1 |
| 162 | 2018-12-01 17:11:23 | surplus | 1 | 69583 | 1 | 1.143 | 60877.5 |
| 161 | 2018-11-29 18:25:13 | surplus | 1 | 69583 | 1 | 1.066 | 65274.9 |
| 160 | 2018-11-22 08:42:48 | surplus | 1 | 69583 | 1 | 1.226 | 56756.1 |
| 159 | 2018-11-18 12:01:10 | surplus | 1 | 69583 | 1 | 1.066 | 65274.9 |
| 158 | 2018-11-16 12:51:05 | surplus | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 157 | 2018-11-14 18:32:09 | surplus | 1 | 69583 | 1 | 1.150 | 60507.0 |
| 156 | 2018-11-08 18:44:13 | surplus | 1 | 69583 | 1 | 1.066 | 65274.9 |
| 155 | 2018-11-06 21:21:10 | surplus | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 154 | 2018-11-06 21:11:57 | surplus | 1 | 69583 | 1 | 1.100 | 63257.3 |
| 153 | 2018-10-20 18:43:11 | surplus | 1 | 69583 | 1 | 1.056 | 65893.0 |
| 152 | 2018-10-20 18:40:24 | surplus | 1 | 69583 | 1 | 1.030 | 67556.3 |
| 151 | 2018-10-17 07:43:05 | surplus | 1 | 69583 | 1 | 1.083 | 64250.2 |
| 150 | 2018-10-17 07:40:04 | surplus | 1 | 69583 | 1 | 1.106 | 62914.1 |
| 149 | 2018-10-13 17:06:20 | surplus | 1 | 69583 | 1 | 1.186 | 58670.3 |