History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"xerox"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
287 | 2024-04-24 23:21:47 | xerox | 1 | 28756 | 1 | 0.563 | 51076.4 |
286 | 2024-04-04 23:15:50 | xerox | 1 | 28756 | 1 | 1.533 | 18758.0 |
285 | 2024-04-04 19:45:19 | xerox | 3 | 83667 | 523 | 6.970 | 12003.9 |
284 | 2024-04-03 10:25:19 | xerox | 3 | 83667 | 523 | 9.080 | 9214.4 |
283 | 2024-04-03 10:25:24 | xerox | 2 | 53800 | 20 | 2.126 | 25305.7 |
282 | 2024-04-03 08:44:38 | xerox | 1 | 28756 | 1 | 0.436 | 65954.1 |
281 | 2024-03-31 19:06:39 | xerox | 1 | 28756 | 1 | 0.500 | 57512.0 |
280 | 2024-03-28 20:04:53 | xerox | 1 | 28756 | 1 | 0.593 | 48492.4 |
279 | 2024-03-04 01:17:16 | xerox | 3 | 83667 | 523 | 3.690 | 22674.0 |
278 | 2024-03-04 01:17:16 | xerox | 2 | 53800 | 20 | 1.530 | 35163.4 |
277 | 2024-03-04 01:17:11 | xerox | 1 | 28756 | 1 | 0.516 | 55728.7 |
276 | 2024-03-01 13:04:14 | xerox | 1 | 28756 | 1 | 0.423 | 67981.1 |
275 | 2024-02-28 21:11:26 | xerox | 2 | 53800 | 20 | 1.360 | 39558.8 |
274 | 2024-02-28 21:10:37 | xerox | 3 | 83667 | 523 | 3.656 | 22884.8 |
273 | 2024-02-27 10:07:47 | xerox | 2 | 53800 | 20 | 1.406 | 38264.6 |
272 | 2024-02-27 10:07:31 | xerox | 3 | 83667 | 523 | 4.000 | 20916.8 |
271 | 2024-02-26 19:50:58 | xerox | 2 | 53800 | 20 | 1.893 | 28420.5 |
270 | 2024-02-26 19:50:56 | xerox | 3 | 83667 | 523 | 3.843 | 21771.3 |
269 | 2024-02-26 19:50:51 | xerox | 1 | 28756 | 1 | 0.423 | 67981.1 |
268 | 2024-01-29 04:32:35 | xerox | 2 | 53800 | 20 | 1.313 | 40974.9 |
267 | 2024-01-29 04:32:31 | xerox | 1 | 28756 | 1 | 0.470 | 61183.0 |
266 | 2024-01-27 16:21:13 | xerox | 1 | 28756 | 1 | 0.500 | 57512.0 |
265 | 2024-01-16 01:01:11 | xerox | 1 | 28756 | 1 | 0.440 | 65354.5 |
264 | 2024-01-15 17:17:47 | xerox | 1 | 28756 | 1 | 0.436 | 65954.1 |
263 | 2023-12-09 23:52:53 | xerox | 1 | 28756 | 1 | 0.483 | 59536.2 |
262 | 2023-12-01 14:13:05 | xerox | 1 | 28756 | 1 | 0.423 | 67981.1 |
261 | 2023-11-27 06:16:37 | xerox | 1 | 28756 | 1 | 0.500 | 57512.0 |
260 | 2023-11-24 10:39:22 | xerox | 3 | 83667 | 523 | 3.216 | 26015.9 |
259 | 2023-11-24 10:39:21 | xerox | 2 | 53800 | 20 | 1.373 | 39184.3 |
258 | 2023-11-11 06:00:56 | xerox | 1 | 28756 | 1 | 0.423 | 67981.1 |
257 | 2023-11-04 12:33:16 | xerox | 3 | 83667 | 523 | 3.843 | 21771.3 |
256 | 2023-11-04 12:33:15 | xerox | 2 | 53800 | 20 | 3.030 | 17755.8 |
255 | 2023-11-04 11:32:33 | xerox | 1 | 28756 | 1 | 0.440 | 65354.5 |
254 | 2023-10-27 08:16:02 | xerox | 1 | 28756 | 1 | 0.453 | 63479.0 |
253 | 2023-10-23 07:53:29 | xerox | 3 | 83667 | 523 | 4.093 | 20441.5 |
252 | 2023-10-23 07:53:31 | xerox | 2 | 53800 | 20 | 1.623 | 33148.5 |
251 | 2023-10-20 18:18:34 | xerox | 1 | 28756 | 1 | 0.470 | 61183.0 |
250 | 2023-10-13 16:49:03 | xerox | 1 | 28756 | 1 | 0.423 | 67981.1 |
249 | 2023-10-04 09:34:31 | xerox | 3 | 83667 | 523 | 3.533 | 23681.6 |
248 | 2023-10-01 14:48:18 | xerox | 3 | 83667 | 523 | 3.626 | 23074.2 |
247 | 2023-09-29 00:00:15 | xerox | 1 | 28756 | 1 | 0.483 | 59536.2 |
246 | 2023-09-28 03:37:49 | xerox | 3 | 83667 | 523 | 3.500 | 23904.9 |
245 | 2023-09-28 03:37:51 | xerox | 2 | 53800 | 20 | 1.500 | 35866.7 |
244 | 2023-09-22 10:33:56 | xerox | 1 | 28756 | 1 | 0.423 | 67981.1 |
243 | 2023-08-30 14:59:22 | xerox | 1 | 28756 | 1 | 0.486 | 59168.7 |
242 | 2023-08-02 04:26:23 | xerox | 1 | 28756 | 1 | 0.470 | 61183.0 |
241 | 2023-02-27 12:23:14 | xerox | 1 | 28756 | 1 | 0.470 | 61183.0 |
240 | 2022-09-14 03:00:44 | xerox | 1 | 28756 | 1 | 0.420 | 68466.7 |
239 | 2022-07-11 07:48:50 | xerox | 1 | 28756 | 1 | 0.423 | 67981.1 |
238 | 2022-03-13 12:21:56 | xerox | 1 | 28756 | 1 | 0.470 | 61183.0 |
237 | 2021-10-04 14:11:13 | xerox | 1 | 28756 | 1 | 0.423 | 67981.1 |
236 | 2021-07-31 05:39:54 | xerox | 1 | 28756 | 1 | 0.406 | 70827.6 |
235 | 2021-07-26 22:36:54 | xerox | 1 | 28756 | 1 | 1.016 | 28303.1 |
234 | 2021-06-15 11:21:27 | xerox | 1 | 28756 | 1 | 0.423 | 67981.1 |
233 | 2021-05-17 15:21:26 | xerox | 1 | 28756 | 1 | 0.466 | 61708.2 |
232 | 2021-02-24 17:55:49 | xerox | 1 | 28756 | 1 | 0.420 | 68466.7 |
231 | 2021-02-20 17:10:39 | xerox | 1 | 28756 | 1 | 0.530 | 54256.6 |
230 | 2021-01-29 19:56:07 | xerox | 1 | 28756 | 1 | 0.436 | 65954.1 |
229 | 2021-01-27 04:33:03 | xerox | 1 | 28756 | 1 | 0.420 | 68466.7 |
228 | 2021-01-01 12:34:55 | xerox | 1 | 28756 | 1 | 0.453 | 63479.0 |
227 | 2020-10-18 19:55:36 | xerox | 1 | 28756 | 1 | 0.436 | 65954.1 |
226 | 2020-10-18 18:04:31 | xerox | 1 | 28756 | 1 | 0.436 | 65954.1 |
225 | 2020-10-17 13:01:40 | xerox | 1 | 28756 | 1 | 0.423 | 67981.1 |
224 | 2020-10-15 08:05:42 | xerox | 1 | 28756 | 1 | 0.436 | 65954.1 |
223 | 2020-10-10 12:47:39 | xerox | 1 | 28756 | 1 | 0.453 | 63479.0 |
222 | 2020-08-24 13:18:14 | xerox | 1 | 28756 | 1 | 0.453 | 63479.0 |
221 | 2020-08-12 13:27:33 | xerox | 1 | 28756 | 1 | 0.483 | 59536.2 |
220 | 2020-05-22 19:03:05 | xerox | 1 | 28756 | 1 | 0.423 | 67981.1 |
219 | 2020-04-17 00:24:36 | xerox | 1 | 28756 | 1 | 0.440 | 65354.5 |
218 | 2020-03-30 03:40:42 | xerox | 1 | 28756 | 1 | 0.423 | 67981.1 |
217 | 2020-03-26 12:50:34 | xerox | 1 | 28756 | 1 | 0.470 | 61183.0 |
216 | 2020-03-22 09:47:08 | xerox | 1 | 28756 | 1 | 0.470 | 61183.0 |
215 | 2020-03-21 22:44:11 | xerox | 1 | 28756 | 1 | 0.500 | 57512.0 |
214 | 2020-03-21 04:49:17 | xerox | 1 | 28756 | 1 | 0.890 | 32310.1 |
213 | 2020-03-17 22:40:21 | xerox | 1 | 28756 | 1 | 0.500 | 57512.0 |
212 | 2020-02-24 22:47:20 | xerox | 1 | 28756 | 1 | 0.500 | 57512.0 |
211 | 2020-02-23 11:15:05 | xerox | 1 | 28756 | 1 | 1.046 | 27491.4 |
210 | 2020-02-19 14:34:51 | xerox | 1 | 28756 | 1 | 0.483 | 59536.2 |
209 | 2020-02-04 14:22:06 | xerox | 1 | 28756 | 1 | 0.610 | 47141.0 |
208 | 2020-02-04 06:49:51 | xerox | 1 | 28756 | 1 | 0.516 | 55728.7 |
207 | 2020-01-31 07:01:44 | xerox | 1 | 28756 | 1 | 0.466 | 61708.2 |
206 | 2020-01-31 05:22:49 | xerox | 1 | 28756 | 1 | 1.080 | 26625.9 |
205 | 2020-01-30 00:43:30 | xerox | 1 | 28756 | 1 | 0.440 | 65354.5 |
204 | 2020-01-27 21:07:31 | xerox | 1 | 28756 | 1 | 0.516 | 55728.7 |
203 | 2020-01-27 01:26:07 | xerox | 1 | 28756 | 1 | 0.533 | 53951.2 |
202 | 2020-01-21 18:06:25 | xerox | 1 | 28756 | 1 | 1.046 | 27491.4 |
201 | 2020-01-14 05:57:36 | xerox | 1 | 28756 | 1 | 0.530 | 54256.6 |
200 | 2020-01-13 13:59:06 | xerox | 1 | 28756 | 1 | 0.500 | 57512.0 |
199 | 2020-01-10 16:04:11 | xerox | 1 | 28756 | 1 | 1.000 | 28756.0 |
198 | 2020-01-02 11:33:39 | xerox | 1 | 28756 | 1 | 0.500 | 57512.0 |
197 | 2019-12-27 18:24:10 | xerox | 1 | 28756 | 1 | 0.546 | 52666.7 |
196 | 2019-12-26 08:29:01 | xerox | 1 | 28756 | 1 | 0.420 | 68466.7 |
195 | 2019-12-24 15:59:16 | xerox | 1 | 28756 | 1 | 0.500 | 57512.0 |
194 | 2019-12-24 05:43:45 | xerox | 1 | 28756 | 1 | 0.436 | 65954.1 |
193 | 2019-10-25 16:26:42 | xerox | 1 | 28756 | 1 | 0.420 | 68466.7 |
192 | 2019-10-05 17:30:16 | xerox | 1 | 28756 | 1 | 0.400 | 71890.0 |
191 | 2019-09-14 09:07:59 | xerox | 1 | 28756 | 1 | 0.390 | 73733.3 |
190 | 2019-07-02 02:24:12 | xerox | 1 | 28756 | 1 | 0.576 | 49923.6 |
189 | 2019-03-17 04:00:58 | xerox | 1 | 28756 | 1 | 0.413 | 69627.1 |
188 | 2019-03-03 12:35:49 | xerox | 1 | 28756 | 1 | 0.486 | 59168.7 |