History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spancels"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 238 | 2024-04-27 14:30:10 | spancels | 1 | 82945 | 3 | 3.906 | 21235.3 |
| 237 | 2024-04-27 08:27:43 | spancels | 3 | 146162 | 193 | 9.876 | 14799.7 |
| 236 | 2024-04-26 10:36:37 | spancels | 2 | 121059 | 22 | 3.750 | 32282.4 |
| 235 | 2024-04-26 10:36:24 | spancels | 3 | 146162 | 193 | 7.830 | 18666.9 |
| 234 | 2024-04-26 09:11:02 | spancels | 2 | 121059 | 22 | 4.390 | 27576.1 |
| 233 | 2024-04-26 09:10:46 | spancels | 3 | 146162 | 193 | 8.406 | 17387.8 |
| 232 | 2024-04-25 22:59:40 | spancels | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 231 | 2024-04-25 22:58:28 | spancels | 3 | 146162 | 193 | 8.563 | 17069.0 |
| 230 | 2024-04-25 22:58:21 | spancels | 2 | 121059 | 22 | 8.280 | 14620.7 |
| 229 | 2024-04-25 20:14:44 | spancels | 3 | 146162 | 193 | 18.406 | 7941.0 |
| 228 | 2024-04-24 22:48:11 | spancels | 3 | 146162 | 193 | 10.436 | 14005.6 |
| 227 | 2024-04-24 22:48:11 | spancels | 2 | 121059 | 22 | 4.750 | 25486.1 |
| 226 | 2024-04-24 22:47:18 | spancels | 1 | 82945 | 3 | 2.783 | 29804.2 |
| 225 | 2024-04-23 10:29:43 | spancels | 1 | 82945 | 3 | 2.936 | 28251.0 |
| 224 | 2024-04-05 21:56:45 | spancels | 1 | 82945 | 3 | 1.923 | 43133.1 |
| 223 | 2024-03-31 20:34:09 | spancels | 2 | 121059 | 22 | 3.296 | 36729.1 |
| 222 | 2024-03-31 20:34:08 | spancels | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 221 | 2024-03-31 08:40:04 | spancels | 1 | 82945 | 3 | 1.563 | 53067.8 |
| 220 | 2024-03-30 06:46:34 | spancels | 1 | 82945 | 3 | 3.330 | 24908.4 |
| 219 | 2024-03-29 19:22:40 | spancels | 2 | 121059 | 22 | 3.766 | 32145.2 |
| 218 | 2024-03-29 03:25:24 | spancels | 3 | 146162 | 193 | 15.220 | 9603.3 |
| 217 | 2024-03-26 02:56:46 | spancels | 2 | 121059 | 22 | 6.000 | 20176.5 |
| 216 | 2024-03-25 12:01:17 | spancels | 2 | 121059 | 22 | 3.686 | 32842.9 |
| 215 | 2024-03-25 12:01:05 | spancels | 3 | 146162 | 193 | 8.030 | 18202.0 |
| 214 | 2024-03-22 07:18:43 | spancels | 3 | 146162 | 193 | 9.563 | 15284.1 |
| 213 | 2024-03-22 05:06:58 | spancels | 3 | 146162 | 193 | 13.470 | 10850.9 |
| 212 | 2024-03-20 02:59:42 | spancels | 3 | 146162 | 193 | 14.906 | 9805.6 |
| 211 | 2024-03-19 15:45:19 | spancels | 3 | 146162 | 193 | 14.783 | 9887.2 |
| 210 | 2024-03-19 15:45:21 | spancels | 2 | 121059 | 22 | 4.406 | 27475.9 |
| 209 | 2024-03-19 15:37:31 | spancels | 1 | 82945 | 3 | 1.330 | 62364.7 |
| 208 | 2024-03-07 07:35:05 | spancels | 1 | 82945 | 3 | 3.360 | 24686.0 |
| 207 | 2024-03-06 14:21:29 | spancels | 1 | 82945 | 3 | 5.283 | 15700.4 |
| 206 | 2024-03-01 04:13:24 | spancels | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 205 | 2024-02-21 08:26:22 | spancels | 1 | 82945 | 3 | 2.983 | 27805.9 |
| 204 | 2024-02-20 23:28:35 | spancels | 1 | 82945 | 3 | 1.330 | 62364.7 |
| 203 | 2024-02-05 18:07:49 | spancels | 2 | 121059 | 22 | 3.656 | 33112.4 |
| 202 | 2024-02-05 18:07:17 | spancels | 3 | 146162 | 193 | 8.060 | 18134.2 |
| 201 | 2024-02-04 18:01:36 | spancels | 3 | 146162 | 193 | 8.890 | 16441.2 |
| 200 | 2024-02-04 15:04:50 | spancels | 3 | 146162 | 193 | 9.046 | 16157.6 |
| 199 | 2024-02-04 02:47:22 | spancels | 3 | 146162 | 193 | 8.983 | 16271.0 |
| 198 | 2024-02-04 02:47:26 | spancels | 2 | 121059 | 22 | 4.123 | 29361.9 |
| 197 | 2024-02-01 17:45:49 | spancels | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 196 | 2024-01-12 07:50:58 | spancels | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 195 | 2023-12-27 00:44:25 | spancels | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 194 | 2023-12-19 00:38:10 | spancels | 2 | 121059 | 22 | 3.233 | 37444.8 |
| 193 | 2023-12-16 22:14:19 | spancels | 1 | 82945 | 3 | 1.656 | 50087.6 |
| 192 | 2023-12-07 18:23:23 | spancels | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 191 | 2023-12-04 15:13:59 | spancels | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 190 | 2023-11-10 21:43:49 | spancels | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 189 | 2023-11-03 06:08:29 | spancels | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 188 | 2023-10-17 22:49:01 | spancels | 1 | 82945 | 3 | 2.873 | 28870.5 |
| 187 | 2023-09-18 16:34:11 | spancels | 2 | 121059 | 22 | 3.643 | 33230.6 |
| 186 | 2023-09-18 02:09:23 | spancels | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 185 | 2023-08-30 04:59:00 | spancels | 1 | 82945 | 3 | 1.393 | 59544.1 |
| 184 | 2023-07-07 16:12:09 | spancels | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 183 | 2023-06-17 08:33:04 | spancels | 2 | 121059 | 22 | 3.576 | 33853.2 |
| 182 | 2023-04-21 01:19:16 | spancels | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 181 | 2023-04-11 05:42:57 | spancels | 1 | 82945 | 3 | 1.283 | 64649.3 |
| 180 | 2023-03-13 03:03:12 | spancels | 2 | 121059 | 22 | 3.250 | 37248.9 |
| 179 | 2023-01-29 23:05:43 | spancels | 1 | 82945 | 3 | 1.283 | 64649.3 |
| 178 | 2022-12-17 16:10:07 | spancels | 1 | 82945 | 3 | 1.326 | 62552.8 |
| 177 | 2022-12-17 09:05:37 | spancels | 2 | 121059 | 22 | 3.623 | 33414.0 |
| 176 | 2022-11-29 05:58:16 | spancels | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 175 | 2022-08-10 11:22:03 | spancels | 2 | 121059 | 22 | 3.173 | 38152.9 |
| 174 | 2022-07-28 14:40:17 | spancels | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 173 | 2022-07-24 07:08:34 | spancels | 1 | 82945 | 3 | 1.300 | 63803.8 |
| 172 | 2022-03-10 01:38:48 | spancels | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 171 | 2022-03-06 17:05:38 | spancels | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 170 | 2021-10-30 11:23:56 | spancels | 1 | 82945 | 3 | 1.466 | 56579.1 |
| 169 | 2021-07-13 04:25:07 | spancels | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 168 | 2021-06-23 10:22:57 | spancels | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 167 | 2021-04-23 06:45:22 | spancels | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 166 | 2021-04-09 15:26:53 | spancels | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 165 | 2021-03-25 11:23:08 | spancels | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 164 | 2021-01-08 15:18:54 | spancels | 1 | 82945 | 3 | 1.326 | 62552.8 |
| 163 | 2020-12-24 01:59:47 | spancels | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 162 | 2020-12-10 06:03:31 | spancels | 1 | 82945 | 3 | 1.376 | 60279.8 |
| 161 | 2020-11-06 01:11:58 | spancels | 1 | 82945 | 3 | 1.326 | 62552.8 |
| 160 | 2020-11-01 19:59:03 | spancels | 1 | 82945 | 3 | 1.440 | 57600.7 |
| 159 | 2020-10-30 15:08:32 | spancels | 1 | 82945 | 3 | 1.403 | 59119.7 |
| 158 | 2020-10-27 01:30:54 | spancels | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 157 | 2020-10-23 23:23:11 | spancels | 1 | 82945 | 3 | 1.513 | 54821.5 |
| 156 | 2020-10-16 19:41:11 | spancels | 1 | 82945 | 3 | 1.326 | 62552.8 |
| 155 | 2020-09-20 05:08:46 | spancels | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 154 | 2020-05-31 21:44:05 | spancels | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 153 | 2020-03-22 04:33:42 | spancels | 1 | 82945 | 3 | 1.593 | 52068.4 |
| 152 | 2020-03-05 22:00:46 | spancels | 1 | 82945 | 3 | 1.890 | 43886.2 |
| 151 | 2020-02-23 08:13:29 | spancels | 1 | 82945 | 3 | 1.593 | 52068.4 |
| 150 | 2020-02-23 00:59:28 | spancels | 3 | 146162 | 193 | 8.783 | 16641.5 |
| 149 | 2020-02-22 14:03:01 | spancels | 1 | 82945 | 3 | 1.530 | 54212.4 |
| 148 | 2020-02-22 12:48:40 | spancels | 1 | 82945 | 3 | 3.076 | 26965.2 |
| 147 | 2020-02-22 11:33:29 | spancels | 1 | 82945 | 3 | 1.686 | 49196.3 |
| 146 | 2020-02-21 08:55:25 | spancels | 1 | 82945 | 3 | 4.186 | 19814.9 |
| 145 | 2020-02-16 17:06:52 | spancels | 1 | 82945 | 3 | 1.403 | 59119.7 |
| 144 | 2020-02-12 06:26:36 | spancels | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 143 | 2020-02-12 02:16:06 | spancels | 1 | 82945 | 3 | 3.093 | 26817.0 |
| 142 | 2020-02-09 20:16:33 | spancels | 3 | 146162 | 193 | 8.330 | 17546.5 |
| 141 | 2020-02-08 09:47:55 | spancels | 3 | 146162 | 193 | 8.720 | 16761.7 |
| 140 | 2020-01-31 17:01:27 | spancels | 1 | 82945 | 3 | 1.690 | 49079.9 |
| 139 | 2020-01-25 16:47:12 | spancels | 1 | 82945 | 3 | 3.233 | 25655.7 |