History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"departing"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
282 | 2024-05-11 07:46:13 | departing | 1 | 81242 | 2 | 3.500 | 23212.0 |
281 | 2024-05-01 01:31:37 | departing | 1 | 81242 | 2 | 1.640 | 49537.8 |
280 | 2024-04-30 19:30:02 | departing | 1 | 81242 | 2 | 1.876 | 43306.0 |
279 | 2024-04-29 04:02:51 | departing | 3 | 148641 | 277 | 15.343 | 9687.9 |
278 | 2024-04-29 03:08:30 | departing | 3 | 148641 | 277 | 19.610 | 7579.9 |
277 | 2024-04-27 22:42:29 | departing | 3 | 148641 | 277 | 17.830 | 8336.6 |
276 | 2024-04-27 10:18:08 | departing | 1 | 81242 | 2 | 1.593 | 50999.4 |
275 | 2024-04-26 13:22:23 | departing | 3 | 148641 | 277 | 19.220 | 7733.7 |
274 | 2024-04-26 13:21:07 | departing | 3 | 148641 | 277 | 27.360 | 5432.8 |
273 | 2024-03-30 07:15:56 | departing | 1 | 81242 | 2 | 3.156 | 25742.1 |
272 | 2024-03-30 06:07:36 | departing | 1 | 81242 | 2 | 3.376 | 24064.6 |
271 | 2024-03-27 03:54:18 | departing | 1 | 81242 | 2 | 2.796 | 29056.5 |
270 | 2024-03-09 13:47:01 | departing | 2 | 121436 | 31 | 3.250 | 37364.9 |
269 | 2024-03-03 18:48:25 | departing | 2 | 121436 | 31 | 4.860 | 24986.8 |
268 | 2024-03-03 17:56:32 | departing | 3 | 148641 | 277 | 8.750 | 16987.5 |
267 | 2024-02-28 10:49:33 | departing | 1 | 81242 | 2 | 2.923 | 27794.0 |
266 | 2024-02-22 20:46:22 | departing | 3 | 148641 | 277 | 8.220 | 18082.8 |
265 | 2024-02-22 20:46:20 | departing | 2 | 121436 | 31 | 3.936 | 30852.6 |
264 | 2024-02-22 14:48:10 | departing | 1 | 81242 | 2 | 1.343 | 60492.9 |
263 | 2024-02-19 09:42:14 | departing | 1 | 81242 | 2 | 2.046 | 39707.7 |
262 | 2024-02-06 06:53:22 | departing | 1 | 81242 | 2 | 1.330 | 61084.2 |
261 | 2024-01-29 09:34:50 | departing | 1 | 81242 | 2 | 1.516 | 53589.7 |
260 | 2023-12-25 21:37:41 | departing | 1 | 81242 | 2 | 1.483 | 54782.2 |
259 | 2023-12-18 13:35:19 | departing | 3 | 148641 | 277 | 6.220 | 23897.3 |
258 | 2023-12-16 05:25:14 | departing | 1 | 81242 | 2 | 1.373 | 59171.2 |
257 | 2023-11-27 04:32:22 | departing | 1 | 81242 | 2 | 1.390 | 58447.5 |
256 | 2023-11-25 01:57:53 | departing | 2 | 121436 | 31 | 3.763 | 32271.1 |
255 | 2023-10-31 13:58:44 | departing | 1 | 81242 | 2 | 1.440 | 56418.1 |
254 | 2023-10-21 12:14:55 | departing | 1 | 81242 | 2 | 1.250 | 64993.6 |
253 | 2023-10-05 16:57:01 | departing | 1 | 81242 | 2 | 1.360 | 59736.8 |
252 | 2023-09-24 01:44:03 | departing | 3 | 148641 | 277 | 6.906 | 21523.5 |
251 | 2023-09-18 14:43:37 | departing | 3 | 148641 | 277 | 6.186 | 24028.6 |
250 | 2023-09-11 17:41:33 | departing | 1 | 81242 | 2 | 1.453 | 55913.3 |
249 | 2023-08-23 22:35:46 | departing | 2 | 121436 | 31 | 3.140 | 38673.9 |
248 | 2023-07-04 15:17:35 | departing | 1 | 81242 | 2 | 1.453 | 55913.3 |
247 | 2023-06-28 20:35:32 | departing | 1 | 81242 | 2 | 1.250 | 64993.6 |
246 | 2023-06-20 04:09:17 | departing | 3 | 148641 | 277 | 6.250 | 23782.6 |
245 | 2023-05-08 07:35:06 | departing | 2 | 121436 | 31 | 3.046 | 39867.4 |
244 | 2023-04-07 21:38:20 | departing | 1 | 81242 | 2 | 1.326 | 61268.5 |
243 | 2023-03-17 23:02:05 | departing | 1 | 81242 | 2 | 1.373 | 59171.2 |
242 | 2023-03-15 01:26:20 | departing | 3 | 148641 | 277 | 6.250 | 23782.6 |
241 | 2023-02-15 17:11:00 | departing | 2 | 121436 | 31 | 3.063 | 39646.1 |
240 | 2023-01-31 05:51:35 | departing | 1 | 81242 | 2 | 1.216 | 66810.9 |
239 | 2022-12-18 16:58:28 | departing | 3 | 148641 | 277 | 6.280 | 23668.9 |
238 | 2022-11-29 19:43:29 | departing | 1 | 81242 | 2 | 1.220 | 66591.8 |
237 | 2022-11-29 04:41:15 | departing | 1 | 81242 | 2 | 1.233 | 65889.7 |
236 | 2022-11-26 14:04:46 | departing | 2 | 121436 | 31 | 3.343 | 36325.5 |
235 | 2022-11-26 13:01:15 | departing | 1 | 81242 | 2 | 1.236 | 65729.8 |
234 | 2022-08-11 14:06:48 | departing | 3 | 148641 | 277 | 6.250 | 23782.6 |
233 | 2022-08-02 21:33:52 | departing | 1 | 81242 | 2 | 1.326 | 61268.5 |
232 | 2022-07-24 12:37:55 | departing | 1 | 81242 | 2 | 1.266 | 64172.2 |
231 | 2022-04-26 00:31:20 | departing | 2 | 121436 | 31 | 3.140 | 38673.9 |
230 | 2022-04-23 17:16:22 | departing | 2 | 121436 | 31 | 3.220 | 37713.0 |
229 | 2022-04-08 07:07:06 | departing | 1 | 81242 | 2 | 1.983 | 40969.2 |
228 | 2022-04-04 20:42:11 | departing | 1 | 81242 | 2 | 1.643 | 49447.4 |
227 | 2022-03-21 12:53:52 | departing | 1 | 81242 | 2 | 1.486 | 54671.6 |
226 | 2022-01-10 20:11:19 | departing | 2 | 121436 | 31 | 3.716 | 32679.2 |
225 | 2021-12-31 18:24:18 | departing | 1 | 81242 | 2 | 1.453 | 55913.3 |
224 | 2021-12-29 14:30:45 | departing | 1 | 81242 | 2 | 1.280 | 63470.3 |
223 | 2021-12-21 01:28:19 | departing | 1 | 81242 | 2 | 1.466 | 55417.5 |
222 | 2021-11-19 19:07:38 | departing | 1 | 81242 | 2 | 1.360 | 59736.8 |
221 | 2021-11-17 18:22:32 | departing | 1 | 81242 | 2 | 1.390 | 58447.5 |
220 | 2021-09-17 01:20:20 | departing | 1 | 81242 | 2 | 1.313 | 61875.1 |
219 | 2021-09-13 19:53:02 | departing | 1 | 81242 | 2 | 1.436 | 56575.2 |
218 | 2021-06-13 16:40:14 | departing | 1 | 81242 | 2 | 1.423 | 57092.1 |
217 | 2021-05-27 16:56:02 | departing | 2 | 121436 | 31 | 3.500 | 34696.0 |
216 | 2021-05-01 21:45:10 | departing | 2 | 121436 | 31 | 3.733 | 32530.4 |
215 | 2021-04-23 22:04:46 | departing | 1 | 81242 | 2 | 1.390 | 58447.5 |
214 | 2021-04-22 20:33:53 | departing | 1 | 81242 | 2 | 1.563 | 51978.2 |
213 | 2021-03-10 19:05:52 | departing | 1 | 81242 | 2 | 1.360 | 59736.8 |
212 | 2021-03-09 00:32:51 | departing | 1 | 81242 | 2 | 1.233 | 65889.7 |
211 | 2021-02-12 20:53:15 | departing | 1 | 81242 | 2 | 1.283 | 63321.9 |
210 | 2021-02-08 21:49:46 | departing | 2 | 121436 | 31 | 3.360 | 36141.7 |
209 | 2021-01-19 23:47:59 | departing | 1 | 81242 | 2 | 1.376 | 59042.2 |
208 | 2020-12-31 00:28:22 | departing | 1 | 81242 | 2 | 1.296 | 62686.7 |
207 | 2020-12-20 14:34:57 | departing | 1 | 81242 | 2 | 1.250 | 64993.6 |
206 | 2020-11-19 12:50:33 | departing | 1 | 81242 | 2 | 1.250 | 64993.6 |
205 | 2020-11-14 21:40:07 | departing | 2 | 121436 | 31 | 3.123 | 38884.4 |
204 | 2020-10-26 21:32:08 | departing | 2 | 121436 | 31 | 3.156 | 38477.8 |
203 | 2020-10-05 15:49:52 | departing | 1 | 81242 | 2 | 1.296 | 62686.7 |
202 | 2020-10-04 19:10:35 | departing | 1 | 81242 | 2 | 1.356 | 59913.0 |
201 | 2020-10-04 14:55:52 | departing | 1 | 81242 | 2 | 1.390 | 58447.5 |
200 | 2020-09-13 22:42:22 | departing | 1 | 81242 | 2 | 1.266 | 64172.2 |
199 | 2020-08-13 02:50:53 | departing | 1 | 81242 | 2 | 1.313 | 61875.1 |
198 | 2020-07-28 23:15:44 | departing | 1 | 81242 | 2 | 1.326 | 61268.5 |
197 | 2020-07-20 17:40:10 | departing | 1 | 81242 | 2 | 1.343 | 60492.9 |
196 | 2020-05-12 01:07:19 | departing | 1 | 81242 | 2 | 1.420 | 57212.7 |
195 | 2020-03-21 20:16:52 | departing | 1 | 81242 | 2 | 1.250 | 64993.6 |
194 | 2020-02-25 10:52:55 | departing | 1 | 81242 | 2 | 1.686 | 48186.2 |
193 | 2020-02-25 08:15:41 | departing | 1 | 81242 | 2 | 1.500 | 54161.3 |
192 | 2020-02-22 22:49:28 | departing | 1 | 81242 | 2 | 1.470 | 55266.7 |
191 | 2020-02-22 09:29:24 | departing | 1 | 81242 | 2 | 1.500 | 54161.3 |
190 | 2020-02-20 07:12:12 | departing | 1 | 81242 | 2 | 3.626 | 22405.4 |
189 | 2020-02-14 05:17:49 | departing | 1 | 81242 | 2 | 1.753 | 46344.6 |
188 | 2020-02-12 11:50:07 | departing | 1 | 81242 | 2 | 1.546 | 52549.8 |
187 | 2020-02-09 10:25:28 | departing | 1 | 81242 | 2 | 3.063 | 26523.7 |
186 | 2020-02-08 20:42:41 | departing | 1 | 81242 | 2 | 1.500 | 54161.3 |
185 | 2020-02-07 06:11:29 | departing | 1 | 81242 | 2 | 1.360 | 59736.8 |
184 | 2020-02-04 21:46:28 | departing | 1 | 81242 | 2 | 1.360 | 59736.8 |
183 | 2020-01-27 22:21:35 | departing | 1 | 81242 | 2 | 1.516 | 53589.7 |