History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"refences"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
307 | 2024-05-31 15:28:32 | refences | 1 | 82945 | 4 | 6.546 | 12671.1 |
306 | 2024-05-06 23:00:32 | refences | 2 | 121059 | 25 | 4.860 | 24909.3 |
305 | 2024-05-04 09:17:10 | refences | 3 | 146162 | 227 | 7.063 | 20694.0 |
304 | 2024-05-04 09:17:01 | refences | 2 | 121059 | 25 | 3.720 | 32542.7 |
303 | 2024-05-02 06:20:31 | refences | 2 | 121059 | 25 | 3.876 | 31233.0 |
302 | 2024-05-01 10:08:09 | refences | 2 | 121059 | 25 | 10.030 | 12069.7 |
301 | 2024-04-30 23:00:14 | refences | 2 | 121059 | 25 | 4.080 | 29671.3 |
300 | 2024-04-30 22:39:30 | refences | 1 | 82945 | 4 | 1.576 | 52630.1 |
299 | 2024-04-30 13:01:58 | refences | 1 | 82945 | 4 | 1.673 | 49578.6 |
298 | 2024-04-29 05:19:56 | refences | 2 | 121059 | 25 | 4.033 | 30017.1 |
297 | 2024-04-29 05:19:48 | refences | 2 | 121059 | 25 | 3.673 | 32959.2 |
296 | 2024-04-29 05:19:49 | refences | 1 | 82945 | 4 | 1.470 | 56425.2 |
295 | 2024-04-29 05:19:33 | refences | 3 | 146162 | 227 | 8.953 | 16325.5 |
294 | 2024-04-28 06:57:55 | refences | 3 | 146162 | 227 | 10.050 | 14543.5 |
293 | 2024-04-28 04:32:47 | refences | 3 | 146162 | 227 | 25.563 | 5717.7 |
292 | 2024-04-05 17:35:56 | refences | 1 | 82945 | 4 | 5.016 | 16536.1 |
291 | 2024-04-01 19:59:35 | refences | 3 | 146162 | 227 | 18.046 | 8099.4 |
290 | 2024-04-01 19:59:39 | refences | 2 | 121059 | 25 | 12.610 | 9600.2 |
289 | 2024-04-01 09:50:54 | refences | 2 | 121059 | 25 | 3.936 | 30756.9 |
288 | 2024-03-31 22:12:04 | refences | 3 | 146162 | 227 | 9.110 | 16044.1 |
287 | 2024-03-31 04:31:30 | refences | 2 | 121059 | 25 | 11.986 | 10100.0 |
286 | 2024-03-31 04:21:40 | refences | 1 | 82945 | 4 | 3.280 | 25288.1 |
285 | 2024-03-28 21:15:35 | refences | 2 | 121059 | 25 | 4.440 | 27265.5 |
284 | 2024-03-28 21:15:35 | refences | 1 | 82945 | 4 | 5.000 | 16589.0 |
283 | 2024-03-28 21:15:08 | refences | 3 | 146162 | 227 | 10.486 | 13938.8 |
282 | 2024-03-28 09:39:05 | refences | 1 | 82945 | 4 | 1.406 | 58993.6 |
281 | 2024-03-28 09:38:55 | refences | 3 | 146162 | 227 | 7.546 | 19369.5 |
280 | 2024-03-28 09:38:55 | refences | 2 | 121059 | 25 | 3.640 | 33258.0 |
279 | 2024-03-28 09:38:50 | refences | 1 | 82945 | 4 | 1.376 | 60279.8 |
278 | 2024-03-22 20:05:25 | refences | 1 | 82945 | 4 | 1.750 | 47397.1 |
277 | 2024-03-17 09:22:23 | refences | 3 | 146162 | 227 | 7.906 | 18487.5 |
276 | 2024-03-06 04:39:33 | refences | 1 | 82945 | 4 | 2.156 | 38471.7 |
275 | 2024-03-02 01:09:29 | refences | 2 | 121059 | 25 | 4.640 | 26090.3 |
274 | 2024-02-29 18:33:02 | refences | 3 | 146162 | 227 | 8.046 | 18165.8 |
273 | 2024-02-29 18:33:06 | refences | 2 | 121059 | 25 | 3.810 | 31774.0 |
272 | 2024-02-28 06:57:21 | refences | 1 | 82945 | 4 | 3.440 | 24111.9 |
271 | 2024-02-27 07:41:17 | refences | 2 | 121059 | 25 | 4.190 | 28892.4 |
270 | 2024-02-27 07:40:34 | refences | 3 | 146162 | 227 | 7.986 | 18302.3 |
269 | 2024-02-26 22:20:17 | refences | 3 | 146162 | 227 | 7.656 | 19091.2 |
268 | 2024-02-26 22:20:18 | refences | 2 | 121059 | 25 | 3.920 | 30882.4 |
267 | 2024-02-26 22:20:15 | refences | 1 | 82945 | 4 | 1.516 | 54713.1 |
266 | 2024-01-31 16:08:08 | refences | 2 | 121059 | 25 | 3.440 | 35191.6 |
265 | 2024-01-29 09:43:11 | refences | 3 | 146162 | 227 | 12.076 | 12103.5 |
264 | 2024-01-27 13:55:03 | refences | 2 | 121059 | 25 | 3.330 | 36354.1 |
263 | 2024-01-27 13:52:23 | refences | 3 | 146162 | 227 | 7.343 | 19904.9 |
262 | 2024-01-27 13:51:57 | refences | 2 | 121059 | 25 | 3.876 | 31233.0 |
261 | 2024-01-27 13:51:53 | refences | 3 | 146162 | 227 | 7.703 | 18974.7 |
260 | 2024-01-27 13:51:45 | refences | 1 | 82945 | 4 | 1.453 | 57085.3 |
259 | 2023-12-21 08:29:05 | refences | 2 | 121059 | 25 | 3.703 | 32692.1 |
258 | 2023-12-18 00:54:38 | refences | 1 | 82945 | 4 | 1.436 | 57761.1 |
257 | 2023-12-06 15:17:51 | refences | 1 | 82945 | 4 | 1.470 | 56425.2 |
256 | 2023-12-01 05:52:23 | refences | 3 | 146162 | 227 | 6.233 | 23449.7 |
255 | 2023-11-19 04:19:54 | refences | 1 | 82945 | 4 | 1.283 | 64649.3 |
254 | 2023-10-29 06:18:44 | refences | 1 | 82945 | 4 | 1.470 | 56425.2 |
253 | 2023-10-23 18:12:56 | refences | 1 | 82945 | 4 | 1.280 | 64800.8 |
252 | 2023-10-18 16:55:55 | refences | 1 | 82945 | 4 | 1.390 | 59672.7 |
251 | 2023-10-07 00:35:08 | refences | 1 | 82945 | 4 | 1.283 | 64649.3 |
250 | 2023-10-06 08:03:31 | refences | 1 | 82945 | 4 | 1.313 | 63172.1 |
249 | 2023-09-21 13:30:48 | refences | 2 | 121059 | 25 | 3.250 | 37248.9 |
248 | 2023-09-16 23:41:43 | refences | 1 | 82945 | 4 | 1.500 | 55296.7 |
247 | 2023-08-30 04:48:30 | refences | 3 | 146162 | 227 | 6.703 | 21805.5 |
246 | 2023-08-02 05:55:24 | refences | 1 | 82945 | 4 | 1.296 | 64000.8 |
245 | 2023-07-16 15:18:39 | refences | 1 | 82945 | 4 | 1.330 | 62364.7 |
244 | 2023-07-09 05:59:15 | refences | 1 | 82945 | 4 | 1.483 | 55930.5 |
243 | 2023-06-25 04:00:29 | refences | 2 | 121059 | 25 | 3.186 | 37997.2 |
242 | 2023-05-17 11:29:09 | refences | 3 | 146162 | 227 | 6.280 | 23274.2 |
241 | 2023-04-30 12:45:39 | refences | 1 | 82945 | 4 | 1.516 | 54713.1 |
240 | 2023-03-25 08:17:28 | refences | 1 | 82945 | 4 | 1.296 | 64000.8 |
239 | 2023-03-18 13:23:16 | refences | 2 | 121059 | 25 | 3.593 | 33693.0 |
238 | 2023-02-25 08:36:51 | refences | 1 | 82945 | 4 | 1.280 | 64800.8 |
237 | 2023-02-22 19:18:40 | refences | 3 | 146162 | 227 | 12.813 | 11407.3 |
236 | 2022-12-23 12:21:36 | refences | 1 | 82945 | 4 | 1.296 | 64000.8 |
235 | 2022-12-19 09:07:46 | refences | 2 | 121059 | 25 | 3.406 | 35542.9 |
234 | 2022-12-10 11:26:09 | refences | 1 | 82945 | 4 | 1.470 | 56425.2 |
233 | 2022-12-05 18:04:41 | refences | 3 | 146162 | 227 | 16.080 | 9089.7 |
232 | 2022-09-09 07:27:41 | refences | 1 | 82945 | 4 | 1.313 | 63172.1 |
231 | 2022-08-16 16:37:58 | refences | 1 | 82945 | 4 | 1.563 | 53067.8 |
230 | 2022-08-13 15:02:44 | refences | 2 | 121059 | 25 | 3.250 | 37248.9 |
229 | 2022-08-09 20:28:09 | refences | 1 | 82945 | 4 | 1.440 | 57600.7 |
228 | 2022-07-19 16:34:07 | refences | 3 | 146162 | 227 | 6.906 | 21164.5 |
227 | 2022-07-17 09:21:02 | refences | 3 | 146162 | 227 | 6.373 | 22934.6 |
226 | 2022-04-20 11:38:47 | refences | 1 | 82945 | 4 | 1.530 | 54212.4 |
225 | 2022-04-16 02:38:36 | refences | 1 | 82945 | 4 | 1.516 | 54713.1 |
224 | 2022-03-14 06:48:46 | refences | 2 | 121059 | 25 | 3.250 | 37248.9 |
223 | 2022-02-21 08:24:50 | refences | 3 | 146162 | 227 | 8.266 | 17682.3 |
222 | 2022-01-14 01:13:59 | refences | 1 | 82945 | 4 | 1.376 | 60279.8 |
221 | 2022-01-11 21:46:19 | refences | 1 | 82945 | 4 | 1.343 | 61761.0 |
220 | 2022-01-03 12:33:17 | refences | 1 | 82945 | 4 | 1.533 | 54106.3 |
219 | 2021-12-16 03:29:32 | refences | 2 | 121059 | 25 | 4.296 | 28179.5 |
218 | 2021-11-23 19:48:38 | refences | 3 | 146162 | 227 | 6.360 | 22981.4 |
217 | 2021-11-10 00:04:30 | refences | 1 | 82945 | 4 | 1.766 | 46967.7 |
216 | 2021-09-30 14:12:33 | refences | 1 | 82945 | 4 | 1.313 | 63172.1 |
215 | 2021-09-25 11:07:18 | refences | 1 | 82945 | 4 | 1.280 | 64800.8 |
214 | 2021-09-08 06:40:21 | refences | 1 | 82945 | 4 | 1.466 | 56579.1 |
213 | 2021-07-01 04:49:50 | refences | 1 | 82945 | 4 | 1.360 | 60989.0 |
212 | 2021-04-28 02:01:16 | refences | 1 | 82945 | 4 | 1.296 | 64000.8 |
211 | 2021-03-31 05:12:22 | refences | 1 | 82945 | 4 | 1.313 | 63172.1 |
210 | 2021-01-11 07:34:26 | refences | 1 | 82945 | 4 | 1.313 | 63172.1 |
209 | 2020-12-19 14:54:05 | refences | 1 | 82945 | 4 | 1.296 | 64000.8 |
208 | 2020-10-23 14:59:56 | refences | 1 | 82945 | 4 | 1.343 | 61761.0 |