History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"traveler"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 246 | 2024-04-26 20:03:22 | traveler | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 245 | 2024-04-25 08:47:36 | traveler | 2 | 121059 | 26 | 7.046 | 17181.2 |
| 244 | 2024-04-25 08:47:36 | traveler | 1 | 82945 | 5 | 4.330 | 19155.9 |
| 243 | 2024-04-22 17:20:07 | traveler | 1 | 82945 | 5 | 2.266 | 36604.1 |
| 242 | 2024-04-22 17:19:54 | traveler | 2 | 121059 | 26 | 6.376 | 18986.7 |
| 241 | 2024-04-22 17:19:54 | traveler | 1 | 82945 | 5 | 1.580 | 52496.8 |
| 240 | 2024-04-08 08:55:37 | traveler | 1 | 82945 | 5 | 1.596 | 51970.6 |
| 239 | 2024-04-06 14:41:20 | traveler | 2 | 121059 | 26 | 4.343 | 27874.5 |
| 238 | 2024-04-06 08:13:02 | traveler | 1 | 82945 | 5 | 10.250 | 8092.2 |
| 237 | 2024-04-06 00:51:54 | traveler | 3 | 146162 | 174 | 11.203 | 13046.7 |
| 236 | 2024-04-05 05:39:27 | traveler | 3 | 146162 | 174 | 22.656 | 6451.4 |
| 235 | 2024-04-05 05:39:27 | traveler | 2 | 121059 | 26 | 8.800 | 13756.7 |
| 234 | 2024-04-05 05:39:12 | traveler | 1 | 82945 | 5 | 1.610 | 51518.6 |
| 233 | 2024-04-04 09:32:27 | traveler | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 232 | 2024-03-30 20:34:00 | traveler | 3 | 146162 | 174 | 10.220 | 14301.6 |
| 231 | 2024-03-30 14:49:10 | traveler | 3 | 146162 | 174 | 25.940 | 5634.6 |
| 230 | 2024-03-30 08:46:48 | traveler | 3 | 146162 | 174 | 18.546 | 7881.1 |
| 229 | 2024-03-30 08:46:45 | traveler | 2 | 121059 | 26 | 4.296 | 28179.5 |
| 228 | 2024-03-30 08:46:37 | traveler | 1 | 82945 | 5 | 3.826 | 21679.3 |
| 227 | 2024-03-23 02:16:04 | traveler | 2 | 121059 | 26 | 3.906 | 30993.1 |
| 226 | 2024-03-22 06:33:22 | traveler | 2 | 121059 | 26 | 3.953 | 30624.6 |
| 225 | 2024-03-22 06:33:20 | traveler | 1 | 82945 | 5 | 1.483 | 55930.5 |
| 224 | 2024-03-10 15:43:51 | traveler | 1 | 82945 | 5 | 1.486 | 55817.6 |
| 223 | 2024-03-04 21:42:56 | traveler | 1 | 82945 | 5 | 4.860 | 17066.9 |
| 222 | 2024-02-29 03:49:09 | traveler | 2 | 121059 | 26 | 3.983 | 30393.9 |
| 221 | 2024-02-29 03:48:56 | traveler | 3 | 146162 | 174 | 7.893 | 18517.9 |
| 220 | 2024-02-27 05:41:42 | traveler | 3 | 146162 | 174 | 7.860 | 18595.7 |
| 219 | 2024-02-26 08:25:37 | traveler | 3 | 146162 | 174 | 11.236 | 13008.4 |
| 218 | 2024-02-26 08:25:39 | traveler | 2 | 121059 | 26 | 4.173 | 29010.1 |
| 217 | 2024-02-21 18:48:26 | traveler | 2 | 121059 | 26 | 4.126 | 29340.5 |
| 216 | 2024-02-21 16:24:18 | traveler | 2 | 121059 | 26 | 8.656 | 13985.6 |
| 215 | 2024-02-21 03:43:58 | traveler | 2 | 121059 | 26 | 9.720 | 12454.6 |
| 214 | 2024-02-21 03:43:56 | traveler | 1 | 82945 | 5 | 3.050 | 27195.1 |
| 213 | 2024-02-21 00:35:47 | traveler | 1 | 82945 | 5 | 1.563 | 53067.8 |
| 212 | 2024-01-31 11:36:04 | traveler | 1 | 82945 | 5 | 1.250 | 66356.0 |
| 211 | 2024-01-23 15:22:43 | traveler | 3 | 146162 | 174 | 13.486 | 10838.1 |
| 210 | 2024-01-23 01:41:18 | traveler | 3 | 146162 | 174 | 18.563 | 7873.8 |
| 209 | 2024-01-21 23:27:33 | traveler | 3 | 146162 | 174 | 7.720 | 18932.9 |
| 208 | 2024-01-17 23:09:42 | traveler | 1 | 82945 | 5 | 2.656 | 31229.3 |
| 207 | 2024-01-17 13:54:50 | traveler | 1 | 82945 | 5 | 1.326 | 62552.8 |
| 206 | 2024-01-13 21:09:24 | traveler | 3 | 146162 | 174 | 6.326 | 23105.0 |
| 205 | 2023-12-26 02:20:55 | traveler | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 204 | 2023-12-13 06:27:38 | traveler | 1 | 82945 | 5 | 1.483 | 55930.5 |
| 203 | 2023-11-10 18:44:40 | traveler | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 202 | 2023-11-02 18:55:37 | traveler | 1 | 82945 | 5 | 3.186 | 26034.2 |
| 201 | 2023-11-01 11:20:20 | traveler | 3 | 146162 | 174 | 6.530 | 22383.2 |
| 200 | 2023-10-15 20:44:34 | traveler | 1 | 82945 | 5 | 1.390 | 59672.7 |
| 199 | 2023-09-30 03:55:56 | traveler | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 198 | 2023-08-12 15:49:09 | traveler | 1 | 82945 | 5 | 2.656 | 31229.3 |
| 197 | 2023-08-08 05:37:16 | traveler | 3 | 146162 | 174 | 6.390 | 22873.6 |
| 196 | 2023-06-23 13:30:16 | traveler | 1 | 82945 | 5 | 1.640 | 50576.2 |
| 195 | 2023-05-13 22:30:34 | traveler | 1 | 82945 | 5 | 1.250 | 66356.0 |
| 194 | 2023-04-16 07:36:35 | traveler | 3 | 146162 | 174 | 6.830 | 21400.0 |
| 193 | 2023-03-08 00:17:38 | traveler | 1 | 82945 | 5 | 1.250 | 66356.0 |
| 192 | 2023-02-19 02:34:03 | traveler | 1 | 82945 | 5 | 1.250 | 66356.0 |
| 191 | 2023-01-21 10:00:54 | traveler | 3 | 146162 | 174 | 6.873 | 21266.1 |
| 190 | 2022-12-29 11:38:52 | traveler | 1 | 82945 | 5 | 1.393 | 59544.1 |
| 189 | 2022-11-02 15:20:12 | traveler | 3 | 146162 | 174 | 7.423 | 19690.4 |
| 188 | 2022-10-07 12:50:54 | traveler | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 187 | 2022-10-04 00:01:24 | traveler | 1 | 82945 | 5 | 1.343 | 61761.0 |
| 186 | 2022-09-16 04:12:23 | traveler | 1 | 82945 | 5 | 1.483 | 55930.5 |
| 185 | 2022-07-01 13:55:11 | traveler | 1 | 82945 | 5 | 1.263 | 65673.0 |
| 184 | 2022-06-04 07:35:33 | traveler | 3 | 146162 | 174 | 6.360 | 22981.4 |
| 183 | 2022-05-06 18:06:52 | traveler | 1 | 82945 | 5 | 1.423 | 58288.8 |
| 182 | 2022-03-06 12:17:04 | traveler | 1 | 82945 | 5 | 1.486 | 55817.6 |
| 181 | 2022-03-04 07:38:55 | traveler | 1 | 82945 | 5 | 1.406 | 58993.6 |
| 180 | 2021-12-27 10:19:23 | traveler | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 179 | 2021-12-16 23:50:40 | traveler | 1 | 82945 | 5 | 1.656 | 50087.6 |
| 178 | 2021-10-26 03:26:46 | traveler | 1 | 82945 | 5 | 1.250 | 66356.0 |
| 177 | 2021-10-03 11:20:14 | traveler | 1 | 82945 | 5 | 1.250 | 66356.0 |
| 176 | 2021-08-28 13:28:52 | traveler | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 175 | 2021-06-09 19:58:25 | traveler | 1 | 82945 | 5 | 1.423 | 58288.8 |
| 174 | 2021-05-14 13:26:28 | traveler | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 173 | 2021-04-15 16:17:06 | traveler | 1 | 82945 | 5 | 1.283 | 64649.3 |
| 172 | 2021-02-01 20:58:52 | traveler | 1 | 82945 | 5 | 1.326 | 62552.8 |
| 171 | 2021-01-18 20:50:07 | traveler | 1 | 82945 | 5 | 1.263 | 65673.0 |
| 170 | 2020-12-31 02:33:50 | traveler | 1 | 82945 | 5 | 1.423 | 58288.8 |
| 169 | 2020-11-12 02:51:21 | traveler | 1 | 82945 | 5 | 1.283 | 64649.3 |
| 168 | 2020-11-07 06:26:45 | traveler | 1 | 82945 | 5 | 1.423 | 58288.8 |
| 167 | 2020-10-25 22:38:50 | traveler | 1 | 82945 | 5 | 1.233 | 67270.9 |
| 166 | 2020-10-16 12:17:07 | traveler | 1 | 82945 | 5 | 1.283 | 64649.3 |
| 165 | 2020-09-30 10:47:20 | traveler | 1 | 82945 | 5 | 1.236 | 67107.6 |
| 164 | 2020-08-02 12:57:42 | traveler | 1 | 82945 | 5 | 1.546 | 53651.4 |
| 163 | 2020-06-05 12:46:56 | traveler | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 162 | 2020-04-03 01:48:53 | traveler | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 161 | 2020-03-22 20:55:39 | traveler | 1 | 82945 | 5 | 1.486 | 55817.6 |
| 160 | 2020-02-29 21:43:01 | traveler | 1 | 82945 | 5 | 1.530 | 54212.4 |
| 159 | 2020-02-27 04:10:28 | traveler | 1 | 82945 | 5 | 3.373 | 24590.9 |
| 158 | 2020-02-23 18:50:02 | traveler | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 157 | 2020-02-18 19:13:08 | traveler | 1 | 82945 | 5 | 3.063 | 27079.7 |
| 156 | 2020-02-18 10:12:28 | traveler | 1 | 82945 | 5 | 1.546 | 53651.4 |
| 155 | 2020-02-18 09:36:17 | traveler | 1 | 82945 | 5 | 2.860 | 29001.7 |
| 154 | 2020-02-03 14:00:01 | traveler | 1 | 82945 | 5 | 2.563 | 32362.5 |
| 153 | 2020-02-03 09:41:05 | traveler | 1 | 82945 | 5 | 5.800 | 14300.9 |
| 152 | 2020-01-25 01:15:02 | traveler | 1 | 82945 | 5 | 1.516 | 54713.1 |
| 151 | 2020-01-23 05:11:56 | traveler | 1 | 82945 | 5 | 3.280 | 25288.1 |
| 150 | 2020-01-22 17:51:17 | traveler | 1 | 82945 | 5 | 2.296 | 36125.9 |
| 149 | 2020-01-22 16:11:19 | traveler | 1 | 82945 | 5 | 3.220 | 25759.3 |
| 148 | 2020-01-17 09:54:18 | traveler | 1 | 82945 | 5 | 1.483 | 55930.5 |
| 147 | 2020-01-12 12:46:34 | traveler | 1 | 82945 | 5 | 3.346 | 24789.3 |