History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"dentists"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
298 | 2024-05-06 10:20:36 | dentists | 1 | 82945 | 2 | 3.140 | 26415.6 |
297 | 2024-05-06 00:09:53 | dentists | 1 | 82945 | 2 | 1.686 | 49196.3 |
296 | 2024-05-03 19:57:25 | dentists | 2 | 121059 | 20 | 5.656 | 21403.6 |
295 | 2024-05-03 15:39:57 | dentists | 3 | 146162 | 170 | 7.796 | 18748.3 |
294 | 2024-05-01 15:47:14 | dentists | 2 | 121059 | 20 | 8.283 | 14615.4 |
293 | 2024-05-01 09:13:41 | dentists | 3 | 146162 | 170 | 18.250 | 8008.9 |
292 | 2024-05-01 03:27:04 | dentists | 2 | 121059 | 20 | 3.843 | 31501.2 |
291 | 2024-05-01 03:27:00 | dentists | 3 | 146162 | 170 | 8.000 | 18270.3 |
290 | 2024-05-01 03:26:52 | dentists | 1 | 82945 | 2 | 2.983 | 27805.9 |
289 | 2024-05-01 03:26:14 | dentists | 2 | 121059 | 20 | 8.503 | 14237.2 |
288 | 2024-05-01 03:26:18 | dentists | 1 | 82945 | 2 | 3.263 | 25419.9 |
287 | 2024-05-01 03:26:10 | dentists | 3 | 146162 | 170 | 8.986 | 16265.5 |
286 | 2024-04-12 20:16:00 | dentists | 1 | 82945 | 2 | 4.420 | 18765.8 |
285 | 2024-04-09 23:14:47 | dentists | 2 | 121059 | 20 | 15.810 | 7657.1 |
284 | 2024-04-09 21:10:46 | dentists | 3 | 146162 | 170 | 25.236 | 5791.8 |
283 | 2024-04-09 20:50:04 | dentists | 2 | 121059 | 20 | 3.983 | 30393.9 |
282 | 2024-04-08 03:34:31 | dentists | 2 | 121059 | 20 | 3.860 | 31362.4 |
281 | 2024-04-06 09:58:17 | dentists | 1 | 82945 | 2 | 3.736 | 22201.6 |
280 | 2024-04-02 04:28:27 | dentists | 3 | 146162 | 170 | 17.640 | 8285.8 |
279 | 2024-04-01 01:08:52 | dentists | 2 | 121059 | 20 | 4.360 | 27765.8 |
278 | 2024-03-30 22:21:13 | dentists | 3 | 146162 | 170 | 11.643 | 12553.6 |
277 | 2024-03-30 22:21:11 | dentists | 2 | 121059 | 20 | 7.173 | 16877.0 |
276 | 2024-03-30 10:28:00 | dentists | 3 | 146162 | 170 | 15.986 | 9143.1 |
275 | 2024-03-30 07:38:03 | dentists | 3 | 146162 | 170 | 9.343 | 15644.0 |
274 | 2024-03-30 07:27:40 | dentists | 3 | 146162 | 170 | 12.436 | 11753.1 |
273 | 2024-03-30 07:27:41 | dentists | 2 | 121059 | 20 | 4.453 | 27185.9 |
272 | 2024-03-30 07:27:38 | dentists | 1 | 82945 | 2 | 1.343 | 61761.0 |
271 | 2024-02-12 20:44:46 | dentists | 1 | 82945 | 2 | 1.280 | 64800.8 |
270 | 2024-01-25 23:11:41 | dentists | 1 | 82945 | 2 | 1.593 | 52068.4 |
269 | 2023-12-10 05:17:24 | dentists | 2 | 121059 | 20 | 3.186 | 37997.2 |
268 | 2023-11-30 07:39:15 | dentists | 1 | 82945 | 2 | 1.453 | 57085.3 |
267 | 2023-11-28 23:57:11 | dentists | 1 | 82945 | 2 | 1.313 | 63172.1 |
266 | 2023-11-22 05:41:18 | dentists | 1 | 82945 | 2 | 2.533 | 32745.8 |
265 | 2023-11-21 21:21:00 | dentists | 1 | 82945 | 2 | 1.406 | 58993.6 |
264 | 2023-11-13 21:30:50 | dentists | 1 | 82945 | 2 | 1.376 | 60279.8 |
263 | 2023-11-03 13:35:18 | dentists | 1 | 82945 | 2 | 1.420 | 58412.0 |
262 | 2023-10-17 18:58:27 | dentists | 1 | 82945 | 2 | 1.296 | 64000.8 |
261 | 2023-10-05 15:33:37 | dentists | 1 | 82945 | 2 | 1.390 | 59672.7 |
260 | 2023-09-28 23:18:11 | dentists | 1 | 82945 | 2 | 1.283 | 64649.3 |
259 | 2023-09-27 06:34:24 | dentists | 1 | 82945 | 2 | 1.310 | 63316.8 |
258 | 2023-09-09 01:09:02 | dentists | 1 | 82945 | 2 | 1.266 | 65517.4 |
257 | 2023-09-07 07:28:09 | dentists | 2 | 121059 | 20 | 3.156 | 38358.4 |
256 | 2023-07-04 15:40:20 | dentists | 1 | 82945 | 2 | 1.280 | 64800.8 |
255 | 2023-06-07 16:21:01 | dentists | 1 | 82945 | 2 | 1.266 | 65517.4 |
254 | 2023-05-26 07:40:23 | dentists | 2 | 121059 | 20 | 3.376 | 35858.7 |
253 | 2023-05-05 03:12:25 | dentists | 1 | 82945 | 2 | 1.266 | 65517.4 |
252 | 2023-03-27 02:17:42 | dentists | 1 | 82945 | 2 | 1.403 | 59119.7 |
251 | 2023-03-21 05:12:22 | dentists | 1 | 82945 | 2 | 1.423 | 58288.8 |
250 | 2023-03-18 11:12:34 | dentists | 1 | 82945 | 2 | 1.250 | 66356.0 |
249 | 2023-03-05 00:36:06 | dentists | 2 | 121059 | 20 | 3.106 | 38975.9 |
248 | 2023-01-12 03:19:49 | dentists | 1 | 82945 | 2 | 1.263 | 65673.0 |
247 | 2022-12-10 15:59:04 | dentists | 2 | 121059 | 20 | 3.156 | 38358.4 |
246 | 2022-12-03 02:23:31 | dentists | 1 | 82945 | 2 | 1.343 | 61761.0 |
245 | 2022-11-19 05:25:57 | dentists | 1 | 82945 | 2 | 1.436 | 57761.1 |
244 | 2022-11-16 09:45:16 | dentists | 1 | 82945 | 2 | 1.436 | 57761.1 |
243 | 2022-10-21 00:50:54 | dentists | 1 | 82945 | 2 | 1.250 | 66356.0 |
242 | 2022-09-14 20:41:45 | dentists | 1 | 82945 | 2 | 1.453 | 57085.3 |
241 | 2022-08-06 05:55:34 | dentists | 1 | 82945 | 2 | 1.346 | 61623.3 |
240 | 2022-07-13 20:52:15 | dentists | 2 | 121059 | 20 | 3.153 | 38394.9 |
239 | 2022-06-12 08:09:38 | dentists | 1 | 82945 | 2 | 1.406 | 58993.6 |
238 | 2022-04-11 18:20:44 | dentists | 1 | 82945 | 2 | 1.576 | 52630.1 |
237 | 2022-02-22 14:01:40 | dentists | 2 | 121059 | 20 | 3.923 | 30858.8 |
236 | 2022-02-20 09:42:05 | dentists | 2 | 121059 | 20 | 3.750 | 32282.4 |
235 | 2022-02-19 21:54:15 | dentists | 1 | 82945 | 2 | 1.596 | 51970.6 |
234 | 2022-02-03 19:37:22 | dentists | 1 | 82945 | 2 | 1.486 | 55817.6 |
233 | 2021-12-27 09:34:07 | dentists | 1 | 82945 | 2 | 1.330 | 62364.7 |
232 | 2021-12-09 02:52:02 | dentists | 1 | 82945 | 2 | 2.940 | 28212.6 |
231 | 2021-12-03 08:26:43 | dentists | 2 | 121059 | 20 | 3.390 | 35710.6 |
230 | 2021-10-22 14:05:40 | dentists | 1 | 82945 | 2 | 1.406 | 58993.6 |
229 | 2021-10-14 13:16:51 | dentists | 1 | 82945 | 2 | 3.046 | 27230.8 |
228 | 2021-10-12 09:01:19 | dentists | 1 | 82945 | 2 | 1.283 | 64649.3 |
227 | 2021-10-11 11:53:58 | dentists | 1 | 82945 | 2 | 1.596 | 51970.6 |
226 | 2021-10-10 08:53:56 | dentists | 1 | 82945 | 2 | 1.280 | 64800.8 |
225 | 2021-09-25 12:21:41 | dentists | 1 | 82945 | 2 | 1.453 | 57085.3 |
224 | 2021-09-23 11:24:53 | dentists | 1 | 82945 | 2 | 1.486 | 55817.6 |
223 | 2021-09-20 12:29:15 | dentists | 1 | 82945 | 2 | 1.580 | 52496.8 |
222 | 2021-09-19 11:57:32 | dentists | 1 | 82945 | 2 | 1.486 | 55817.6 |
221 | 2021-09-13 11:10:13 | dentists | 1 | 82945 | 2 | 1.420 | 58412.0 |
220 | 2021-06-20 09:38:08 | dentists | 1 | 82945 | 2 | 1.453 | 57085.3 |
219 | 2021-06-17 03:20:34 | dentists | 1 | 82945 | 2 | 1.516 | 54713.1 |
218 | 2021-05-17 07:51:08 | dentists | 1 | 82945 | 2 | 1.530 | 54212.4 |
217 | 2021-05-13 15:22:44 | dentists | 1 | 82945 | 2 | 1.483 | 55930.5 |
216 | 2021-04-12 14:18:39 | dentists | 1 | 82945 | 2 | 1.313 | 63172.1 |
215 | 2021-03-10 19:16:40 | dentists | 1 | 82945 | 2 | 1.280 | 64800.8 |
214 | 2021-02-19 10:53:47 | dentists | 1 | 82945 | 2 | 1.296 | 64000.8 |
213 | 2020-12-01 05:08:31 | dentists | 1 | 82945 | 2 | 1.313 | 63172.1 |
212 | 2020-11-19 12:56:06 | dentists | 1 | 82945 | 2 | 1.346 | 61623.3 |
211 | 2020-11-10 11:04:01 | dentists | 1 | 82945 | 2 | 1.343 | 61761.0 |
210 | 2020-10-22 21:08:03 | dentists | 1 | 82945 | 2 | 1.280 | 64800.8 |
209 | 2020-10-17 05:44:28 | dentists | 1 | 82945 | 2 | 1.483 | 55930.5 |
208 | 2020-10-05 05:57:11 | dentists | 1 | 82945 | 2 | 1.280 | 64800.8 |
207 | 2020-08-30 11:47:44 | dentists | 1 | 82945 | 2 | 1.343 | 61761.0 |
206 | 2020-08-13 02:50:45 | dentists | 1 | 82945 | 2 | 1.296 | 64000.8 |
205 | 2020-07-29 20:28:38 | dentists | 1 | 82945 | 2 | 1.546 | 53651.4 |
204 | 2020-07-26 15:12:35 | dentists | 1 | 82945 | 2 | 1.453 | 57085.3 |
203 | 2020-05-12 01:06:25 | dentists | 1 | 82945 | 2 | 1.300 | 63803.8 |
202 | 2020-03-20 22:02:37 | dentists | 1 | 82945 | 2 | 1.373 | 60411.5 |
201 | 2020-03-03 16:36:12 | dentists | 3 | 146162 | 170 | 8.170 | 17890.1 |
200 | 2020-02-26 21:04:27 | dentists | 1 | 82945 | 2 | 3.093 | 26817.0 |
199 | 2020-02-19 02:17:58 | dentists | 1 | 82945 | 2 | 1.623 | 51106.0 |