History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"oompah"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
257 | 2024-04-15 17:41:16 | oompah | 1 | 48755 | 3 | 0.826 | 59025.4 |
256 | 2024-04-06 06:43:38 | oompah | 1 | 48755 | 3 | 2.110 | 23106.6 |
255 | 2024-03-29 08:31:50 | oompah | 1 | 48755 | 3 | 3.206 | 15207.4 |
254 | 2024-02-28 01:56:00 | oompah | 1 | 48755 | 3 | 1.903 | 25620.1 |
253 | 2024-02-05 18:24:14 | oompah | 2 | 82551 | 10 | 2.550 | 32372.9 |
252 | 2024-02-05 18:24:02 | oompah | 3 | 112716 | 128 | 8.283 | 13608.1 |
251 | 2024-02-04 22:18:26 | oompah | 3 | 112716 | 128 | 6.360 | 17722.6 |
250 | 2024-02-01 11:52:08 | oompah | 3 | 112716 | 128 | 4.906 | 22975.1 |
249 | 2024-02-01 11:52:04 | oompah | 2 | 82551 | 10 | 2.140 | 38575.2 |
248 | 2024-01-29 11:57:06 | oompah | 2 | 82551 | 10 | 4.970 | 16609.9 |
247 | 2024-01-26 23:57:01 | oompah | 1 | 48755 | 3 | 0.876 | 55656.4 |
246 | 2024-01-18 05:49:53 | oompah | 1 | 48755 | 3 | 0.750 | 65006.7 |
245 | 2023-12-27 22:52:50 | oompah | 1 | 48755 | 3 | 0.750 | 65006.7 |
244 | 2023-12-09 20:48:18 | oompah | 3 | 112716 | 128 | 5.140 | 21929.2 |
243 | 2023-12-09 20:48:17 | oompah | 2 | 82551 | 10 | 2.250 | 36689.3 |
242 | 2023-12-04 20:09:09 | oompah | 1 | 48755 | 3 | 0.970 | 50262.9 |
241 | 2023-12-03 19:27:37 | oompah | 3 | 112716 | 128 | 8.716 | 12932.1 |
240 | 2023-12-03 19:27:41 | oompah | 2 | 82551 | 10 | 5.280 | 15634.7 |
239 | 2023-11-16 00:38:39 | oompah | 3 | 112716 | 128 | 5.046 | 22337.7 |
238 | 2023-11-16 00:38:36 | oompah | 2 | 82551 | 10 | 2.093 | 39441.5 |
237 | 2023-11-11 03:31:30 | oompah | 1 | 48755 | 3 | 0.873 | 55847.7 |
236 | 2023-11-08 18:04:36 | oompah | 1 | 48755 | 3 | 0.750 | 65006.7 |
235 | 2023-11-07 23:29:19 | oompah | 2 | 82551 | 10 | 2.500 | 33020.4 |
234 | 2023-10-27 23:59:21 | oompah | 1 | 48755 | 3 | 0.843 | 57835.1 |
233 | 2023-10-20 04:11:53 | oompah | 1 | 48755 | 3 | 0.813 | 59969.2 |
232 | 2023-10-18 01:07:46 | oompah | 1 | 48755 | 3 | 0.830 | 58741.0 |
231 | 2023-10-15 09:31:59 | oompah | 1 | 48755 | 3 | 0.736 | 66243.2 |
230 | 2023-10-11 16:28:14 | oompah | 1 | 48755 | 3 | 0.750 | 65006.7 |
229 | 2023-10-04 05:49:51 | oompah | 1 | 48755 | 3 | 0.813 | 59969.2 |
228 | 2023-09-28 22:48:39 | oompah | 1 | 48755 | 3 | 0.766 | 63648.8 |
227 | 2023-09-12 05:43:42 | oompah | 1 | 48755 | 3 | 0.733 | 66514.3 |
226 | 2023-08-13 05:49:12 | oompah | 2 | 82551 | 10 | 2.126 | 38829.3 |
225 | 2023-08-10 11:12:55 | oompah | 1 | 48755 | 3 | 0.826 | 59025.4 |
224 | 2023-07-16 22:00:23 | oompah | 1 | 48755 | 3 | 0.873 | 55847.7 |
223 | 2023-05-08 23:28:14 | oompah | 1 | 48755 | 3 | 0.783 | 62266.9 |
222 | 2023-04-27 14:14:34 | oompah | 2 | 82551 | 10 | 2.110 | 39123.7 |
221 | 2023-03-12 03:39:19 | oompah | 1 | 48755 | 3 | 0.733 | 66514.3 |
220 | 2023-03-01 20:56:58 | oompah | 1 | 48755 | 3 | 0.766 | 63648.8 |
219 | 2023-01-31 10:09:54 | oompah | 2 | 82551 | 10 | 2.080 | 39688.0 |
218 | 2022-12-26 01:58:35 | oompah | 1 | 48755 | 3 | 0.813 | 59969.2 |
217 | 2022-11-12 22:57:13 | oompah | 2 | 82551 | 10 | 2.610 | 31628.7 |
216 | 2022-10-26 13:05:05 | oompah | 1 | 48755 | 3 | 0.766 | 63648.8 |
215 | 2022-09-12 01:46:05 | oompah | 1 | 48755 | 3 | 0.736 | 66243.2 |
214 | 2022-09-09 23:19:53 | oompah | 1 | 48755 | 3 | 0.766 | 63648.8 |
213 | 2022-09-01 19:09:20 | oompah | 1 | 48755 | 3 | 0.813 | 59969.2 |
212 | 2022-06-15 19:41:04 | oompah | 2 | 82551 | 10 | 2.266 | 36430.3 |
211 | 2022-06-06 23:17:10 | oompah | 1 | 48755 | 3 | 0.766 | 63648.8 |
210 | 2022-04-19 00:55:57 | oompah | 1 | 48755 | 3 | 0.813 | 59969.2 |
209 | 2022-02-03 20:51:55 | oompah | 2 | 82551 | 10 | 2.500 | 33020.4 |
208 | 2022-02-01 16:27:08 | oompah | 2 | 82551 | 10 | 2.296 | 35954.3 |
207 | 2022-01-23 06:05:20 | oompah | 1 | 48755 | 3 | 0.890 | 54780.9 |
206 | 2022-01-08 07:04:54 | oompah | 1 | 48755 | 3 | 0.783 | 62266.9 |
205 | 2021-11-09 03:31:55 | oompah | 2 | 82551 | 10 | 2.420 | 34112.0 |
204 | 2021-11-07 01:36:23 | oompah | 2 | 82551 | 10 | 2.140 | 38575.2 |
203 | 2021-11-06 12:19:55 | oompah | 1 | 48755 | 3 | 0.830 | 58741.0 |
202 | 2021-09-30 08:34:57 | oompah | 1 | 48755 | 3 | 0.840 | 58041.7 |
201 | 2021-09-24 05:00:54 | oompah | 1 | 48755 | 3 | 0.893 | 54596.9 |
200 | 2021-08-31 15:59:10 | oompah | 2 | 82551 | 10 | 2.436 | 33887.9 |
199 | 2021-08-31 01:00:35 | oompah | 1 | 48755 | 3 | 0.813 | 59969.2 |
198 | 2021-08-14 05:12:02 | oompah | 2 | 82551 | 10 | 4.233 | 19501.8 |
197 | 2021-08-11 09:31:05 | oompah | 1 | 48755 | 3 | 0.763 | 63899.1 |
196 | 2021-06-17 23:15:25 | oompah | 1 | 48755 | 3 | 0.860 | 56691.9 |
195 | 2021-04-19 11:04:36 | oompah | 2 | 82551 | 10 | 2.143 | 38521.2 |
194 | 2021-03-22 07:07:33 | oompah | 2 | 82551 | 10 | 2.143 | 38521.2 |
193 | 2021-03-17 01:16:57 | oompah | 3 | 112716 | 128 | 5.530 | 20382.6 |
192 | 2021-03-15 03:03:51 | oompah | 1 | 48755 | 3 | 0.860 | 56691.9 |
191 | 2021-02-24 19:23:49 | oompah | 2 | 82551 | 10 | 2.343 | 35233.0 |
190 | 2021-02-19 23:46:50 | oompah | 3 | 112716 | 128 | 10.283 | 10961.4 |
189 | 2021-02-01 04:44:43 | oompah | 1 | 48755 | 3 | 0.763 | 63899.1 |
188 | 2020-12-12 02:33:33 | oompah | 1 | 48755 | 3 | 0.783 | 62266.9 |
187 | 2020-11-07 13:07:48 | oompah | 1 | 48755 | 3 | 0.750 | 65006.7 |
186 | 2020-10-03 05:51:28 | oompah | 1 | 48755 | 3 | 0.766 | 63648.8 |
185 | 2020-09-05 09:23:32 | oompah | 1 | 48755 | 3 | 0.826 | 59025.4 |
184 | 2020-06-03 08:25:10 | oompah | 1 | 48755 | 3 | 0.856 | 56956.8 |
183 | 2020-05-18 21:25:32 | oompah | 1 | 48755 | 3 | 0.750 | 65006.7 |
182 | 2020-03-28 17:44:14 | oompah | 1 | 48755 | 3 | 1.780 | 27390.4 |
181 | 2020-03-24 08:38:22 | oompah | 1 | 48755 | 3 | 0.893 | 54596.9 |
180 | 2020-03-23 18:03:48 | oompah | 1 | 48755 | 3 | 0.936 | 52088.7 |
179 | 2020-03-23 11:01:54 | oompah | 1 | 48755 | 3 | 0.906 | 53813.5 |
178 | 2020-03-20 19:32:48 | oompah | 1 | 48755 | 3 | 0.750 | 65006.7 |
177 | 2020-03-07 03:56:17 | oompah | 1 | 48755 | 3 | 0.763 | 63899.1 |
176 | 2020-02-23 02:33:24 | oompah | 1 | 48755 | 3 | 2.013 | 24220.1 |
175 | 2020-02-18 01:34:53 | oompah | 1 | 48755 | 3 | 0.750 | 65006.7 |
174 | 2020-02-18 00:51:18 | oompah | 1 | 48755 | 3 | 0.966 | 50471.0 |
173 | 2020-02-17 23:18:54 | oompah | 1 | 48755 | 3 | 1.000 | 48755.0 |
172 | 2020-02-17 18:38:30 | oompah | 3 | 112716 | 128 | 8.343 | 13510.2 |
171 | 2020-02-15 13:04:49 | oompah | 3 | 112716 | 128 | 12.940 | 8710.7 |
170 | 2020-02-15 06:50:53 | oompah | 1 | 48755 | 3 | 0.953 | 51159.5 |
169 | 2020-02-13 01:46:03 | oompah | 1 | 48755 | 3 | 1.936 | 25183.4 |
168 | 2020-02-07 04:46:48 | oompah | 1 | 48755 | 3 | 0.923 | 52822.3 |
167 | 2020-02-07 03:34:12 | oompah | 1 | 48755 | 3 | 1.093 | 44606.6 |
166 | 2020-02-05 20:24:59 | oompah | 1 | 48755 | 3 | 0.856 | 56956.8 |
165 | 2020-01-26 23:28:11 | oompah | 3 | 112716 | 128 | 6.876 | 16392.7 |
164 | 2020-01-26 16:39:37 | oompah | 3 | 112716 | 128 | 8.876 | 12699.0 |
163 | 2020-01-23 16:26:50 | oompah | 1 | 48755 | 3 | 1.970 | 24748.7 |
162 | 2020-01-19 20:00:01 | oompah | 2 | 82551 | 10 | 5.406 | 15270.3 |
161 | 2020-01-19 14:29:11 | oompah | 3 | 112716 | 128 | 7.016 | 16065.6 |
160 | 2020-01-19 04:45:17 | oompah | 1 | 48755 | 3 | 0.920 | 52994.6 |
159 | 2020-01-18 22:44:15 | oompah | 1 | 48755 | 3 | 1.920 | 25393.2 |
158 | 2020-01-17 08:35:18 | oompah | 3 | 112716 | 128 | 10.860 | 10379.0 |