History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"footrest"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 243 | 2024-04-27 21:27:29 | footrest | 3 | 146162 | 147 | 25.080 | 5827.8 |
| 242 | 2024-04-27 09:37:31 | footrest | 2 | 121059 | 16 | 4.250 | 28484.5 |
| 241 | 2024-04-25 22:15:40 | footrest | 3 | 146162 | 147 | 28.503 | 5128.0 |
| 240 | 2024-04-24 19:53:26 | footrest | 3 | 146162 | 147 | 21.800 | 6704.7 |
| 239 | 2024-04-23 15:35:46 | footrest | 3 | 146162 | 147 | 13.190 | 11081.3 |
| 238 | 2024-04-20 23:14:16 | footrest | 2 | 121059 | 16 | 16.173 | 7485.3 |
| 237 | 2024-04-20 23:14:15 | footrest | 3 | 146162 | 147 | 16.766 | 8717.8 |
| 236 | 2024-04-20 23:14:10 | footrest | 1 | 82945 | 3 | 1.546 | 53651.4 |
| 235 | 2024-04-06 18:46:39 | footrest | 1 | 82945 | 3 | 4.356 | 19041.6 |
| 234 | 2024-03-31 00:45:59 | footrest | 1 | 82945 | 3 | 2.626 | 31586.1 |
| 233 | 2024-03-28 12:59:00 | footrest | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 232 | 2024-03-18 04:59:04 | footrest | 2 | 121059 | 16 | 7.343 | 16486.3 |
| 231 | 2024-03-18 04:58:51 | footrest | 1 | 82945 | 3 | 1.533 | 54106.3 |
| 230 | 2024-03-08 00:52:08 | footrest | 3 | 146162 | 147 | 28.236 | 5176.4 |
| 229 | 2024-03-08 00:52:15 | footrest | 2 | 121059 | 16 | 11.796 | 10262.7 |
| 228 | 2024-03-08 00:51:33 | footrest | 1 | 82945 | 3 | 3.220 | 25759.3 |
| 227 | 2024-03-04 02:07:36 | footrest | 2 | 121059 | 16 | 3.686 | 32842.9 |
| 226 | 2024-03-04 02:06:20 | footrest | 3 | 146162 | 147 | 7.906 | 18487.5 |
| 225 | 2024-03-03 23:53:10 | footrest | 3 | 146162 | 147 | 18.500 | 7900.6 |
| 224 | 2024-02-29 01:18:24 | footrest | 3 | 146162 | 147 | 6.250 | 23385.9 |
| 223 | 2024-02-28 18:23:04 | footrest | 3 | 146162 | 147 | 7.593 | 19249.6 |
| 222 | 2024-02-28 18:22:34 | footrest | 2 | 121059 | 16 | 3.796 | 31891.2 |
| 221 | 2024-02-28 15:55:39 | footrest | 3 | 146162 | 147 | 30.470 | 4796.9 |
| 220 | 2024-02-28 15:55:40 | footrest | 2 | 121059 | 16 | 11.860 | 10207.3 |
| 219 | 2024-02-28 14:31:10 | footrest | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 218 | 2024-02-28 02:43:51 | footrest | 1 | 82945 | 3 | 3.923 | 21143.3 |
| 217 | 2024-02-14 17:42:33 | footrest | 1 | 82945 | 3 | 1.890 | 43886.2 |
| 216 | 2024-01-28 18:45:38 | footrest | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 215 | 2024-01-05 23:29:15 | footrest | 1 | 82945 | 3 | 1.513 | 54821.5 |
| 214 | 2023-12-04 10:59:17 | footrest | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 213 | 2023-11-22 09:05:08 | footrest | 1 | 82945 | 3 | 1.263 | 65673.0 |
| 212 | 2023-11-21 13:52:19 | footrest | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 211 | 2023-11-11 21:01:20 | footrest | 1 | 82945 | 3 | 1.376 | 60279.8 |
| 210 | 2023-09-12 05:06:15 | footrest | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 209 | 2023-09-09 15:08:02 | footrest | 1 | 82945 | 3 | 1.263 | 65673.0 |
| 208 | 2023-07-31 18:51:44 | footrest | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 207 | 2023-06-16 05:35:36 | footrest | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 206 | 2023-04-12 08:50:54 | footrest | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 205 | 2023-04-02 02:49:32 | footrest | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 204 | 2023-01-14 17:08:46 | footrest | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 203 | 2022-12-27 02:15:54 | footrest | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 202 | 2022-11-09 00:46:16 | footrest | 1 | 82945 | 3 | 1.376 | 60279.8 |
| 201 | 2022-08-26 20:47:23 | footrest | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 200 | 2022-06-30 08:33:45 | footrest | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 199 | 2022-06-28 02:57:14 | footrest | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 198 | 2022-04-22 13:16:45 | footrest | 1 | 82945 | 3 | 1.263 | 65673.0 |
| 197 | 2022-02-28 22:30:49 | footrest | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 196 | 2022-02-26 18:36:41 | footrest | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 195 | 2022-01-09 14:55:29 | footrest | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 194 | 2021-12-13 15:50:05 | footrest | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 193 | 2021-12-11 13:49:43 | footrest | 1 | 82945 | 3 | 3.016 | 27501.7 |
| 192 | 2021-11-02 03:11:30 | footrest | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 191 | 2021-09-30 05:20:33 | footrest | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 190 | 2021-06-30 19:30:41 | footrest | 1 | 82945 | 3 | 1.403 | 59119.7 |
| 189 | 2021-05-31 03:51:24 | footrest | 1 | 82945 | 3 | 1.393 | 59544.1 |
| 188 | 2021-05-05 22:41:45 | footrest | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 187 | 2021-03-30 17:48:58 | footrest | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 186 | 2021-02-12 09:23:04 | footrest | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 185 | 2020-12-22 03:36:38 | footrest | 2 | 121059 | 16 | 3.310 | 36573.7 |
| 184 | 2020-12-19 03:55:51 | footrest | 1 | 82945 | 3 | 1.356 | 61168.9 |
| 183 | 2020-11-14 04:20:12 | footrest | 2 | 121059 | 16 | 3.140 | 38553.8 |
| 182 | 2020-10-04 19:56:17 | footrest | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 181 | 2020-09-15 00:45:15 | footrest | 1 | 82945 | 3 | 1.330 | 62364.7 |
| 180 | 2020-09-13 22:36:42 | footrest | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 179 | 2020-08-24 20:46:22 | footrest | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 178 | 2020-08-15 11:48:21 | footrest | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 177 | 2020-07-30 18:15:51 | footrest | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 176 | 2020-06-05 19:39:28 | footrest | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 175 | 2020-06-02 21:43:52 | footrest | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 174 | 2020-05-20 12:23:50 | footrest | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 173 | 2020-03-24 08:48:10 | footrest | 1 | 82945 | 3 | 1.530 | 54212.4 |
| 172 | 2020-02-27 11:05:53 | footrest | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 171 | 2020-02-27 04:43:31 | footrest | 1 | 82945 | 3 | 3.640 | 22787.1 |
| 170 | 2020-02-21 09:51:41 | footrest | 1 | 82945 | 3 | 1.623 | 51106.0 |
| 169 | 2020-02-20 03:06:13 | footrest | 1 | 82945 | 3 | 2.876 | 28840.4 |
| 168 | 2020-02-20 00:43:17 | footrest | 1 | 82945 | 3 | 1.580 | 52496.8 |
| 167 | 2020-02-19 14:20:00 | footrest | 1 | 82945 | 3 | 2.453 | 33813.7 |
| 166 | 2020-02-17 18:47:37 | footrest | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 165 | 2020-02-07 02:33:50 | footrest | 1 | 82945 | 3 | 3.173 | 26140.9 |
| 164 | 2020-02-03 04:34:00 | footrest | 1 | 82945 | 3 | 1.576 | 52630.1 |
| 163 | 2020-01-24 13:35:17 | footrest | 1 | 82945 | 3 | 3.000 | 27648.3 |
| 162 | 2020-01-23 18:24:01 | footrest | 1 | 82945 | 3 | 3.110 | 26670.4 |
| 161 | 2020-01-23 11:33:08 | footrest | 1 | 82945 | 3 | 3.126 | 26533.9 |
| 160 | 2020-01-18 00:49:23 | footrest | 3 | 146162 | 147 | 18.330 | 7973.9 |
| 159 | 2020-01-17 18:30:09 | footrest | 3 | 146162 | 147 | 16.956 | 8620.1 |
| 158 | 2020-01-17 13:35:56 | footrest | 2 | 121059 | 16 | 8.330 | 14532.9 |
| 157 | 2020-01-17 13:34:55 | footrest | 3 | 146162 | 147 | 13.143 | 11120.9 |
| 156 | 2020-01-17 07:03:27 | footrest | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 155 | 2020-01-14 07:08:09 | footrest | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 154 | 2020-01-02 18:02:24 | footrest | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 153 | 2019-12-30 22:27:55 | footrest | 1 | 82945 | 3 | 1.546 | 53651.4 |
| 152 | 2019-12-02 03:16:55 | footrest | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 151 | 2019-11-28 10:35:52 | footrest | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 150 | 2019-10-19 12:51:45 | footrest | 1 | 82945 | 3 | 1.283 | 64649.3 |
| 149 | 2019-10-01 00:36:56 | footrest | 1 | 82945 | 3 | 1.240 | 66891.1 |
| 148 | 2019-08-26 19:33:30 | footrest | 1 | 82945 | 3 | 1.200 | 69120.8 |
| 147 | 2019-05-27 03:38:37 | footrest | 1 | 82945 | 3 | 1.490 | 55667.8 |
| 146 | 2019-04-07 13:19:17 | footrest | 1 | 82945 | 3 | 1.253 | 66197.1 |
| 145 | 2019-03-28 02:08:47 | footrest | 1 | 82945 | 3 | 1.246 | 66569.0 |
| 144 | 2019-02-27 19:06:53 | footrest | 1 | 82945 | 3 | 1.293 | 64149.3 |