History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"affiliate"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
340 | 2024-05-07 07:10:59 | affiliate | 2 | 121436 | 5 | 9.796 | 12396.5 |
339 | 2024-05-07 01:09:45 | affiliate | 1 | 81242 | 3 | 1.436 | 56575.2 |
338 | 2024-05-04 06:55:16 | affiliate | 1 | 81242 | 3 | 1.500 | 54161.3 |
337 | 2024-05-03 08:53:28 | affiliate | 1 | 81242 | 3 | 2.983 | 27235.0 |
336 | 2024-05-03 08:04:24 | affiliate | 3 | 148641 | 30 | 19.656 | 7562.1 |
335 | 2024-05-03 04:27:32 | affiliate | 2 | 121436 | 5 | 8.766 | 13853.1 |
334 | 2024-05-03 01:11:45 | affiliate | 1 | 81242 | 3 | 1.423 | 57092.1 |
333 | 2024-04-29 03:14:22 | affiliate | 1 | 81242 | 3 | 2.156 | 37681.8 |
332 | 2024-04-29 02:39:02 | affiliate | 1 | 81242 | 3 | 1.500 | 54161.3 |
331 | 2024-04-28 13:14:31 | affiliate | 2 | 121436 | 5 | 6.643 | 18280.3 |
330 | 2024-04-28 10:56:10 | affiliate | 1 | 81242 | 3 | 2.033 | 39961.6 |
329 | 2024-04-26 10:10:19 | affiliate | 1 | 81242 | 3 | 1.626 | 49964.3 |
328 | 2024-04-26 05:51:21 | affiliate | 4 | 165329 | 205 | 10.436 | 15842.2 |
327 | 2024-04-12 20:54:07 | affiliate | 1 | 81242 | 3 | 1.563 | 51978.2 |
326 | 2024-04-11 14:59:08 | affiliate | 3 | 148641 | 30 | 8.016 | 18543.0 |
325 | 2024-04-10 07:49:32 | affiliate | 4 | 165329 | 205 | 44.486 | 3716.4 |
324 | 2024-04-08 18:13:45 | affiliate | 4 | 165329 | 205 | 50.753 | 3257.5 |
323 | 2024-04-08 18:13:51 | affiliate | 3 | 148641 | 30 | 17.843 | 8330.5 |
322 | 2024-04-08 18:13:52 | affiliate | 2 | 121436 | 5 | 12.046 | 10081.0 |
321 | 2024-04-08 18:12:42 | affiliate | 1 | 81242 | 3 | 2.123 | 38267.5 |
320 | 2024-04-06 03:28:09 | affiliate | 2 | 121436 | 5 | 14.826 | 8190.7 |
319 | 2024-04-06 03:20:34 | affiliate | 1 | 81242 | 3 | 3.576 | 22718.7 |
318 | 2024-04-01 09:49:19 | affiliate | 1 | 81242 | 3 | 1.483 | 54782.2 |
317 | 2024-03-27 17:24:15 | affiliate | 1 | 81242 | 3 | 4.656 | 17448.9 |
316 | 2024-03-27 16:38:33 | affiliate | 2 | 121436 | 5 | 3.373 | 36002.4 |
315 | 2024-03-27 16:36:21 | affiliate | 1 | 81242 | 3 | 2.796 | 29056.5 |
314 | 2024-03-10 03:31:37 | affiliate | 3 | 148641 | 30 | 21.110 | 7041.3 |
313 | 2024-03-09 07:25:17 | affiliate | 4 | 165329 | 205 | 40.016 | 4131.6 |
312 | 2024-03-09 01:15:20 | affiliate | 3 | 148641 | 30 | 20.830 | 7135.9 |
311 | 2024-03-09 01:15:13 | affiliate | 4 | 165329 | 205 | 20.643 | 8009.0 |
310 | 2024-03-09 01:15:18 | affiliate | 2 | 121436 | 5 | 8.030 | 15122.8 |
309 | 2024-03-08 21:49:18 | affiliate | 1 | 81242 | 3 | 1.580 | 51419.0 |
308 | 2024-03-05 12:01:39 | affiliate | 1 | 81242 | 3 | 2.640 | 30773.5 |
307 | 2024-03-02 05:21:48 | affiliate | 1 | 81242 | 3 | 1.530 | 53099.3 |
306 | 2024-02-06 18:47:42 | affiliate | 2 | 121436 | 5 | 3.783 | 32100.4 |
305 | 2024-02-06 18:46:25 | affiliate | 1 | 81242 | 3 | 1.423 | 57092.1 |
304 | 2024-02-04 10:42:28 | affiliate | 3 | 148641 | 30 | 8.156 | 18224.7 |
303 | 2024-02-04 09:12:08 | affiliate | 3 | 148641 | 30 | 11.203 | 13268.0 |
302 | 2024-02-03 13:07:02 | affiliate | 4 | 165329 | 205 | 10.876 | 15201.3 |
301 | 2024-02-03 05:21:38 | affiliate | 4 | 165329 | 205 | 29.580 | 5589.2 |
300 | 2024-02-03 05:21:48 | affiliate | 3 | 148641 | 30 | 16.453 | 9034.3 |
299 | 2024-02-03 05:21:43 | affiliate | 2 | 121436 | 5 | 12.686 | 9572.4 |
298 | 2024-02-03 00:00:37 | affiliate | 1 | 81242 | 3 | 1.406 | 57782.4 |
297 | 2024-01-09 21:19:58 | affiliate | 1 | 81242 | 3 | 3.000 | 27080.7 |
296 | 2024-01-06 07:06:55 | affiliate | 1 | 81242 | 3 | 1.406 | 57782.4 |
295 | 2024-01-03 05:10:04 | affiliate | 1 | 81242 | 3 | 1.296 | 62686.7 |
294 | 2023-12-30 01:03:13 | affiliate | 1 | 81242 | 3 | 1.360 | 59736.8 |
293 | 2023-12-29 20:40:49 | affiliate | 2 | 121436 | 5 | 2.970 | 40887.5 |
292 | 2023-12-26 23:53:13 | affiliate | 3 | 148641 | 30 | 5.766 | 25778.9 |
291 | 2023-12-19 12:37:01 | affiliate | 4 | 165329 | 205 | 10.703 | 15447.0 |
290 | 2023-10-25 09:41:10 | affiliate | 1 | 81242 | 3 | 1.330 | 61084.2 |
289 | 2023-10-21 00:54:18 | affiliate | 1 | 81242 | 3 | 3.076 | 26411.6 |
288 | 2023-10-02 20:38:04 | affiliate | 2 | 121436 | 5 | 3.186 | 38115.5 |
287 | 2023-09-29 23:06:46 | affiliate | 1 | 81242 | 3 | 2.953 | 27511.7 |
286 | 2023-09-28 07:02:54 | affiliate | 3 | 148641 | 30 | 6.406 | 23203.4 |
285 | 2023-09-26 23:15:44 | affiliate | 4 | 165329 | 205 | 10.876 | 15201.3 |
284 | 2023-09-20 02:06:45 | affiliate | 4 | 165329 | 205 | 11.753 | 14067.0 |
283 | 2023-09-11 23:07:17 | affiliate | 4 | 165329 | 205 | 10.266 | 16104.5 |
282 | 2023-09-03 13:01:31 | affiliate | 1 | 81242 | 3 | 1.343 | 60492.9 |
281 | 2023-08-18 09:47:57 | affiliate | 1 | 81242 | 3 | 1.203 | 67532.8 |
280 | 2023-08-10 02:04:54 | affiliate | 4 | 165329 | 205 | 11.673 | 14163.4 |
279 | 2023-08-09 02:56:12 | affiliate | 4 | 165329 | 205 | 13.390 | 12347.2 |
278 | 2023-07-13 01:42:45 | affiliate | 2 | 121436 | 5 | 3.203 | 37913.2 |
277 | 2023-07-08 13:52:06 | affiliate | 3 | 148641 | 30 | 6.810 | 21826.9 |
276 | 2023-06-22 09:54:20 | affiliate | 4 | 165329 | 205 | 11.330 | 14592.1 |
275 | 2023-05-24 07:24:31 | affiliate | 4 | 165329 | 205 | 9.873 | 16745.6 |
274 | 2023-05-19 21:17:55 | affiliate | 1 | 81242 | 3 | 1.236 | 65729.8 |
273 | 2023-05-05 01:41:29 | affiliate | 4 | 165329 | 205 | 10.470 | 15790.7 |
272 | 2023-05-03 10:13:51 | affiliate | 1 | 81242 | 3 | 1.266 | 64172.2 |
271 | 2023-04-25 21:49:19 | affiliate | 4 | 165329 | 205 | 11.250 | 14695.9 |
270 | 2023-03-31 05:23:55 | affiliate | 2 | 121436 | 5 | 3.296 | 36843.4 |
269 | 2023-03-29 08:32:27 | affiliate | 3 | 148641 | 30 | 5.670 | 26215.3 |
268 | 2023-03-16 00:33:14 | affiliate | 4 | 165329 | 205 | 10.966 | 15076.5 |
267 | 2023-03-15 11:45:00 | affiliate | 1 | 81242 | 3 | 1.203 | 67532.8 |
266 | 2023-01-03 23:39:33 | affiliate | 1 | 81242 | 3 | 1.326 | 61268.5 |
265 | 2023-01-02 11:39:23 | affiliate | 1 | 81242 | 3 | 1.310 | 62016.8 |
264 | 2022-12-26 20:35:02 | affiliate | 3 | 148641 | 30 | 5.780 | 25716.4 |
263 | 2022-12-26 09:38:40 | affiliate | 2 | 121436 | 5 | 3.236 | 37526.6 |
262 | 2022-12-18 15:12:13 | affiliate | 4 | 165329 | 205 | 9.750 | 16956.8 |
261 | 2022-12-10 13:29:36 | affiliate | 4 | 165329 | 205 | 9.736 | 16981.2 |
260 | 2022-11-28 08:17:21 | affiliate | 4 | 165329 | 205 | 12.343 | 13394.6 |
259 | 2022-09-26 12:43:36 | affiliate | 1 | 81242 | 3 | 1.233 | 65889.7 |
258 | 2022-09-22 12:49:23 | affiliate | 4 | 165329 | 205 | 10.733 | 15403.8 |
257 | 2022-08-29 18:10:46 | affiliate | 3 | 148641 | 30 | 5.703 | 26063.7 |
256 | 2022-08-29 04:40:11 | affiliate | 1 | 81242 | 3 | 1.186 | 68500.8 |
255 | 2022-08-29 00:00:53 | affiliate | 4 | 165329 | 205 | 9.953 | 16611.0 |
254 | 2022-08-27 08:52:05 | affiliate | 2 | 121436 | 5 | 2.953 | 41122.9 |
253 | 2022-08-23 18:01:20 | affiliate | 4 | 165329 | 205 | 11.220 | 14735.2 |
252 | 2022-08-15 08:45:17 | affiliate | 1 | 81242 | 3 | 1.220 | 66591.8 |
251 | 2022-08-14 01:28:31 | affiliate | 1 | 81242 | 3 | 1.203 | 67532.8 |
250 | 2022-08-11 09:58:21 | affiliate | 4 | 165329 | 205 | 10.253 | 16124.9 |
249 | 2022-08-09 01:19:43 | affiliate | 4 | 165329 | 205 | 9.826 | 16825.7 |
248 | 2022-05-28 11:44:43 | affiliate | 4 | 165329 | 205 | 10.423 | 15861.9 |
247 | 2022-05-08 20:36:07 | affiliate | 1 | 81242 | 3 | 1.220 | 66591.8 |
246 | 2022-05-06 23:41:35 | affiliate | 1 | 81242 | 3 | 1.453 | 55913.3 |
245 | 2022-04-25 01:58:56 | affiliate | 1 | 81242 | 3 | 1.216 | 66810.9 |
244 | 2022-04-23 02:33:24 | affiliate | 4 | 165329 | 205 | 12.390 | 13343.7 |
243 | 2022-04-12 03:19:49 | affiliate | 2 | 121436 | 5 | 3.203 | 37913.2 |
242 | 2022-03-29 20:32:54 | affiliate | 4 | 165329 | 205 | 11.250 | 14695.9 |
241 | 2022-03-12 06:41:36 | affiliate | 4 | 165329 | 205 | 9.953 | 16611.0 |