History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"navaid"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
265 | 2024-04-16 20:15:03 | navaid | 1 | 48755 | 2 | 1.876 | 25988.8 |
264 | 2024-04-06 17:10:46 | navaid | 3 | 112716 | 232 | 6.106 | 18459.9 |
263 | 2024-04-06 17:10:47 | navaid | 2 | 82551 | 13 | 2.720 | 30349.6 |
262 | 2024-04-06 17:10:42 | navaid | 1 | 48755 | 2 | 0.936 | 52088.7 |
261 | 2024-04-06 17:10:33 | navaid | 3 | 112716 | 232 | 5.376 | 20966.5 |
260 | 2024-04-06 17:10:33 | navaid | 2 | 82551 | 13 | 2.530 | 32628.9 |
259 | 2024-04-06 17:10:30 | navaid | 1 | 48755 | 2 | 1.783 | 27344.4 |
258 | 2024-03-31 18:19:08 | navaid | 1 | 48755 | 2 | 0.940 | 51867.0 |
257 | 2024-03-19 23:16:02 | navaid | 1 | 48755 | 2 | 0.860 | 56691.9 |
256 | 2024-03-03 08:47:11 | navaid | 2 | 82551 | 13 | 2.796 | 29524.7 |
255 | 2024-03-03 08:46:25 | navaid | 3 | 112716 | 232 | 8.970 | 12565.9 |
254 | 2024-02-27 22:07:22 | navaid | 3 | 112716 | 232 | 6.656 | 16934.5 |
253 | 2024-02-27 21:18:28 | navaid | 2 | 82551 | 13 | 5.533 | 14919.8 |
252 | 2024-02-27 20:55:16 | navaid | 3 | 112716 | 232 | 5.720 | 19705.6 |
251 | 2024-02-27 20:55:15 | navaid | 2 | 82551 | 13 | 2.970 | 27794.9 |
250 | 2024-02-27 20:55:12 | navaid | 1 | 48755 | 2 | 0.796 | 61250.0 |
249 | 2023-12-20 02:52:29 | navaid | 1 | 48755 | 2 | 0.780 | 62506.4 |
248 | 2023-12-10 17:10:06 | navaid | 1 | 48755 | 2 | 0.830 | 58741.0 |
247 | 2023-11-25 03:02:55 | navaid | 1 | 48755 | 2 | 0.750 | 65006.7 |
246 | 2023-11-21 22:49:11 | navaid | 1 | 48755 | 2 | 0.936 | 52088.7 |
245 | 2023-11-03 19:38:05 | navaid | 1 | 48755 | 2 | 0.750 | 65006.7 |
244 | 2023-11-03 15:21:59 | navaid | 1 | 48755 | 2 | 0.750 | 65006.7 |
243 | 2023-10-24 14:18:36 | navaid | 3 | 112716 | 232 | 5.686 | 19823.4 |
242 | 2023-10-23 10:23:44 | navaid | 2 | 82551 | 13 | 2.563 | 32208.7 |
241 | 2023-10-23 10:23:40 | navaid | 3 | 112716 | 232 | 5.516 | 20434.4 |
240 | 2023-10-20 18:47:40 | navaid | 1 | 48755 | 2 | 0.733 | 66514.3 |
239 | 2023-10-16 14:20:33 | navaid | 1 | 48755 | 2 | 0.843 | 57835.1 |
238 | 2023-10-07 06:16:08 | navaid | 1 | 48755 | 2 | 0.876 | 55656.4 |
237 | 2023-09-27 08:34:03 | navaid | 1 | 48755 | 2 | 0.813 | 59969.2 |
236 | 2023-09-15 05:40:15 | navaid | 1 | 48755 | 2 | 0.840 | 58041.7 |
235 | 2023-08-03 10:05:30 | navaid | 1 | 48755 | 2 | 0.763 | 63899.1 |
234 | 2023-07-31 01:25:23 | navaid | 1 | 48755 | 2 | 0.783 | 62266.9 |
233 | 2023-05-27 22:34:05 | navaid | 1 | 48755 | 2 | 0.720 | 67715.3 |
232 | 2023-05-03 23:58:37 | navaid | 1 | 48755 | 2 | 2.170 | 22467.7 |
231 | 2023-03-31 13:34:01 | navaid | 1 | 48755 | 2 | 0.830 | 58741.0 |
230 | 2023-03-25 17:20:46 | navaid | 1 | 48755 | 2 | 0.750 | 65006.7 |
229 | 2023-02-26 03:34:50 | navaid | 1 | 48755 | 2 | 0.733 | 66514.3 |
228 | 2022-12-24 14:56:52 | navaid | 1 | 48755 | 2 | 0.810 | 60191.4 |
227 | 2022-11-29 13:16:53 | navaid | 1 | 48755 | 2 | 0.796 | 61250.0 |
226 | 2022-09-12 07:09:22 | navaid | 1 | 48755 | 2 | 0.733 | 66514.3 |
225 | 2022-09-10 05:10:45 | navaid | 1 | 48755 | 2 | 0.750 | 65006.7 |
224 | 2022-07-19 07:28:20 | navaid | 1 | 48755 | 2 | 0.763 | 63899.1 |
223 | 2022-06-25 14:10:23 | navaid | 1 | 48755 | 2 | 0.936 | 52088.7 |
222 | 2022-03-04 19:13:28 | navaid | 1 | 48755 | 2 | 0.750 | 65006.7 |
221 | 2021-10-31 22:43:55 | navaid | 1 | 48755 | 2 | 0.826 | 59025.4 |
220 | 2021-07-18 07:09:06 | navaid | 1 | 48755 | 2 | 0.873 | 55847.7 |
219 | 2021-06-04 03:21:01 | navaid | 1 | 48755 | 2 | 0.923 | 52822.3 |
218 | 2021-05-08 16:29:14 | navaid | 3 | 112716 | 232 | 5.403 | 20861.7 |
217 | 2021-04-15 13:14:20 | navaid | 1 | 48755 | 2 | 1.250 | 39004.0 |
216 | 2021-04-12 06:21:01 | navaid | 3 | 112716 | 232 | 5.656 | 19928.6 |
215 | 2021-04-11 17:08:30 | navaid | 1 | 48755 | 2 | 0.893 | 54596.9 |
214 | 2021-04-08 12:59:32 | navaid | 1 | 48755 | 2 | 0.750 | 65006.7 |
213 | 2021-02-19 04:46:14 | navaid | 3 | 112716 | 232 | 5.423 | 20784.8 |
212 | 2021-01-23 10:25:09 | navaid | 1 | 48755 | 2 | 0.826 | 59025.4 |
211 | 2021-01-01 22:35:16 | navaid | 1 | 48755 | 2 | 0.783 | 62266.9 |
210 | 2020-11-17 19:54:08 | navaid | 1 | 48755 | 2 | 0.813 | 59969.2 |
209 | 2020-11-03 14:23:26 | navaid | 1 | 48755 | 2 | 0.856 | 56956.8 |
208 | 2020-10-24 12:32:14 | navaid | 1 | 48755 | 2 | 0.766 | 63648.8 |
207 | 2020-09-30 01:48:58 | navaid | 1 | 48755 | 2 | 0.720 | 67715.3 |
206 | 2020-06-14 03:56:24 | navaid | 1 | 48755 | 2 | 0.906 | 53813.5 |
205 | 2020-03-26 04:22:40 | navaid | 1 | 48755 | 2 | 0.843 | 57835.1 |
204 | 2020-03-24 23:05:04 | navaid | 1 | 48755 | 2 | 1.030 | 47335.0 |
203 | 2020-03-23 19:53:42 | navaid | 1 | 48755 | 2 | 0.923 | 52822.3 |
202 | 2020-03-23 01:41:47 | navaid | 1 | 48755 | 2 | 0.860 | 56691.9 |
201 | 2020-03-21 14:11:45 | navaid | 1 | 48755 | 2 | 0.890 | 54780.9 |
200 | 2020-03-18 00:31:01 | navaid | 1 | 48755 | 2 | 0.766 | 63648.8 |
199 | 2020-03-12 09:57:22 | navaid | 1 | 48755 | 2 | 0.736 | 66243.2 |
198 | 2020-02-28 08:29:23 | navaid | 1 | 48755 | 2 | 0.936 | 52088.7 |
197 | 2020-02-25 21:04:16 | navaid | 1 | 48755 | 2 | 0.906 | 53813.5 |
196 | 2020-02-15 08:30:49 | navaid | 1 | 48755 | 2 | 1.936 | 25183.4 |
195 | 2020-02-07 06:55:46 | navaid | 1 | 48755 | 2 | 0.826 | 59025.4 |
194 | 2020-02-05 21:44:49 | navaid | 1 | 48755 | 2 | 1.576 | 30935.9 |
193 | 2020-02-02 21:07:02 | navaid | 1 | 48755 | 2 | 0.970 | 50262.9 |
192 | 2020-02-01 07:36:35 | navaid | 1 | 48755 | 2 | 0.860 | 56691.9 |
191 | 2020-01-27 19:25:51 | navaid | 1 | 48755 | 2 | 0.953 | 51159.5 |
190 | 2020-01-22 07:28:09 | navaid | 1 | 48755 | 2 | 2.796 | 17437.4 |
189 | 2020-01-14 17:57:23 | navaid | 1 | 48755 | 2 | 0.906 | 53813.5 |
188 | 2020-01-14 10:21:21 | navaid | 1 | 48755 | 2 | 1.876 | 25988.8 |
187 | 2020-01-10 22:50:34 | navaid | 1 | 48755 | 2 | 0.906 | 53813.5 |
186 | 2020-01-03 09:15:39 | navaid | 1 | 48755 | 2 | 0.860 | 56691.9 |
185 | 2019-12-26 05:00:30 | navaid | 1 | 48755 | 2 | 1.893 | 25755.4 |
184 | 2019-12-26 04:54:23 | navaid | 1 | 48755 | 2 | 1.106 | 44082.3 |
183 | 2019-12-24 15:30:51 | navaid | 1 | 48755 | 2 | 0.813 | 59969.2 |
182 | 2019-12-24 11:44:21 | navaid | 1 | 48755 | 2 | 0.970 | 50262.9 |
181 | 2019-12-06 14:44:42 | navaid | 1 | 48755 | 2 | 0.873 | 55847.7 |
180 | 2019-09-07 14:36:09 | navaid | 1 | 48755 | 2 | 0.826 | 59025.4 |
179 | 2019-06-07 22:32:52 | navaid | 1 | 48755 | 2 | 0.763 | 63899.1 |
178 | 2019-02-26 15:26:59 | navaid | 1 | 48755 | 2 | 0.843 | 57835.1 |
177 | 2019-02-25 16:56:53 | navaid | 1 | 48755 | 2 | 0.803 | 60716.1 |
176 | 2019-02-13 19:35:19 | navaid | 1 | 48755 | 2 | 0.733 | 66514.3 |
175 | 2019-02-08 14:13:35 | navaid | 1 | 48755 | 2 | 0.720 | 67715.3 |
174 | 2019-02-08 14:05:41 | navaid | 1 | 48755 | 2 | 0.723 | 67434.3 |
173 | 2019-02-06 20:02:05 | navaid | 1 | 48755 | 2 | 0.780 | 62506.4 |
172 | 2019-02-05 01:39:53 | navaid | 1 | 48755 | 2 | 0.736 | 66243.2 |
171 | 2019-01-29 01:49:50 | navaid | 1 | 48755 | 2 | 0.793 | 61481.7 |
170 | 2019-01-22 01:10:48 | navaid | 1 | 48755 | 2 | 0.863 | 56494.8 |
169 | 2019-01-20 06:43:48 | navaid | 1 | 48755 | 2 | 0.730 | 66787.7 |
168 | 2019-01-16 06:21:04 | navaid | 1 | 48755 | 2 | 0.716 | 68093.6 |
167 | 2019-01-05 02:17:12 | navaid | 1 | 48755 | 2 | 0.736 | 66243.2 |
166 | 2018-12-24 13:16:27 | navaid | 1 | 48755 | 2 | 0.710 | 68669.0 |