History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"excite"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
312 | 2024-04-01 17:03:37 | excite | 3 | 112716 | 327 | 7.173 | 15713.9 |
311 | 2024-03-31 20:55:57 | excite | 3 | 112716 | 327 | 6.546 | 17219.1 |
310 | 2024-03-31 08:48:44 | excite | 2 | 82551 | 36 | 5.203 | 15866.0 |
309 | 2024-03-31 08:48:42 | excite | 3 | 112716 | 327 | 5.950 | 18943.9 |
308 | 2024-03-30 05:37:36 | excite | 2 | 82551 | 36 | 2.626 | 31436.0 |
307 | 2024-03-30 05:37:09 | excite | 3 | 112716 | 327 | 9.410 | 11978.3 |
306 | 2024-03-30 04:05:57 | excite | 3 | 112716 | 327 | 19.623 | 5744.1 |
305 | 2024-03-30 03:06:59 | excite | 2 | 82551 | 36 | 2.626 | 31436.0 |
304 | 2024-03-30 03:06:46 | excite | 1 | 48755 | 6 | 1.763 | 27654.6 |
303 | 2024-03-07 02:22:03 | excite | 3 | 112716 | 327 | 6.233 | 18083.7 |
302 | 2024-03-07 02:22:01 | excite | 2 | 82551 | 36 | 2.766 | 29844.9 |
301 | 2024-03-07 02:16:08 | excite | 1 | 48755 | 6 | 0.733 | 66514.3 |
300 | 2024-03-01 16:46:48 | excite | 3 | 112716 | 327 | 12.843 | 8776.5 |
299 | 2024-02-29 13:52:35 | excite | 2 | 82551 | 36 | 2.373 | 34787.6 |
298 | 2024-02-28 12:39:55 | excite | 2 | 82551 | 36 | 2.403 | 34353.3 |
297 | 2024-02-28 12:39:30 | excite | 3 | 112716 | 327 | 8.360 | 13482.8 |
296 | 2024-02-27 07:37:34 | excite | 2 | 82551 | 36 | 2.326 | 35490.5 |
295 | 2024-02-27 07:37:19 | excite | 3 | 112716 | 327 | 5.610 | 20092.0 |
294 | 2024-02-26 06:12:41 | excite | 2 | 82551 | 36 | 5.920 | 13944.4 |
293 | 2024-02-26 06:09:15 | excite | 3 | 112716 | 327 | 7.766 | 14514.0 |
292 | 2024-02-26 04:44:23 | excite | 3 | 112716 | 327 | 14.066 | 8013.4 |
291 | 2024-01-24 02:16:53 | excite | 1 | 48755 | 6 | 0.750 | 65006.7 |
290 | 2024-01-12 12:41:57 | excite | 3 | 112716 | 327 | 5.610 | 20092.0 |
289 | 2024-01-12 12:41:58 | excite | 2 | 82551 | 36 | 2.626 | 31436.0 |
288 | 2024-01-07 14:36:20 | excite | 1 | 48755 | 6 | 0.733 | 66514.3 |
287 | 2023-12-03 16:23:06 | excite | 3 | 112716 | 327 | 5.533 | 20371.6 |
286 | 2023-12-03 16:23:07 | excite | 2 | 82551 | 36 | 2.513 | 32849.6 |
285 | 2023-11-21 22:19:30 | excite | 2 | 82551 | 36 | 2.090 | 39498.1 |
284 | 2023-11-21 07:37:26 | excite | 3 | 112716 | 327 | 5.250 | 21469.7 |
283 | 2023-11-19 20:40:24 | excite | 1 | 48755 | 6 | 0.826 | 59025.4 |
282 | 2023-11-17 23:13:27 | excite | 1 | 48755 | 6 | 0.826 | 59025.4 |
281 | 2023-11-10 12:33:29 | excite | 1 | 48755 | 6 | 0.813 | 59969.2 |
280 | 2023-11-06 19:29:50 | excite | 1 | 48755 | 6 | 0.796 | 61250.0 |
279 | 2023-10-30 03:41:01 | excite | 1 | 48755 | 6 | 0.763 | 63899.1 |
278 | 2023-10-28 07:49:57 | excite | 1 | 48755 | 6 | 1.140 | 42767.5 |
277 | 2023-10-25 10:10:49 | excite | 1 | 48755 | 6 | 0.826 | 59025.4 |
276 | 2023-10-13 23:38:27 | excite | 1 | 48755 | 6 | 1.640 | 29728.7 |
275 | 2023-10-03 16:30:58 | excite | 1 | 48755 | 6 | 0.736 | 66243.2 |
274 | 2023-09-26 08:42:08 | excite | 1 | 48755 | 6 | 0.733 | 66514.3 |
273 | 2023-09-15 14:06:30 | excite | 1 | 48755 | 6 | 0.750 | 65006.7 |
272 | 2023-09-11 19:58:36 | excite | 1 | 48755 | 6 | 0.716 | 68093.6 |
271 | 2023-09-06 01:26:38 | excite | 1 | 48755 | 6 | 0.750 | 65006.7 |
270 | 2023-08-23 12:08:17 | excite | 3 | 112716 | 327 | 4.673 | 24120.7 |
269 | 2023-08-22 11:41:15 | excite | 2 | 82551 | 36 | 2.326 | 35490.5 |
268 | 2023-06-08 10:15:32 | excite | 1 | 48755 | 6 | 0.813 | 59969.2 |
267 | 2023-05-25 20:23:11 | excite | 1 | 48755 | 6 | 0.720 | 67715.3 |
266 | 2023-05-07 22:29:08 | excite | 2 | 82551 | 36 | 2.063 | 40015.0 |
265 | 2023-04-30 23:51:41 | excite | 3 | 112716 | 327 | 4.640 | 24292.2 |
264 | 2023-03-30 07:51:38 | excite | 1 | 48755 | 6 | 0.843 | 57835.1 |
263 | 2023-02-15 16:19:29 | excite | 2 | 82551 | 36 | 2.123 | 38884.1 |
262 | 2023-02-12 22:26:16 | excite | 1 | 48755 | 6 | 0.826 | 59025.4 |
261 | 2023-02-06 11:11:52 | excite | 3 | 112716 | 327 | 5.750 | 19602.8 |
260 | 2023-01-13 02:45:29 | excite | 1 | 48755 | 6 | 1.530 | 31866.0 |
259 | 2022-11-25 18:21:50 | excite | 2 | 82551 | 36 | 2.060 | 40073.3 |
258 | 2022-11-19 23:02:47 | excite | 3 | 112716 | 327 | 4.783 | 23566.0 |
257 | 2022-10-24 02:47:59 | excite | 1 | 48755 | 6 | 0.716 | 68093.6 |
256 | 2022-10-22 23:47:52 | excite | 1 | 48755 | 6 | 0.720 | 67715.3 |
255 | 2022-07-19 00:51:45 | excite | 3 | 112716 | 327 | 4.546 | 24794.5 |
254 | 2022-06-29 05:57:45 | excite | 1 | 48755 | 6 | 0.983 | 49598.2 |
253 | 2022-06-24 01:24:26 | excite | 3 | 112716 | 327 | 4.593 | 24540.8 |
252 | 2022-06-11 21:40:42 | excite | 1 | 48755 | 6 | 0.830 | 58741.0 |
251 | 2022-04-21 10:25:34 | excite | 2 | 82551 | 36 | 3.173 | 26016.7 |
250 | 2022-03-05 20:15:46 | excite | 1 | 48755 | 6 | 0.873 | 55847.7 |
249 | 2022-02-19 10:56:01 | excite | 1 | 48755 | 6 | 0.826 | 59025.4 |
248 | 2022-02-05 10:49:20 | excite | 3 | 112716 | 327 | 4.593 | 24540.8 |
247 | 2021-12-13 00:22:15 | excite | 1 | 48755 | 6 | 0.813 | 59969.2 |
246 | 2021-12-08 16:43:25 | excite | 1 | 48755 | 6 | 0.860 | 56691.9 |
245 | 2021-12-06 14:12:55 | excite | 1 | 48755 | 6 | 0.860 | 56691.9 |
244 | 2021-12-04 11:57:39 | excite | 1 | 48755 | 6 | 0.810 | 60191.4 |
243 | 2021-11-25 12:50:58 | excite | 1 | 48755 | 6 | 0.826 | 59025.4 |
242 | 2021-10-28 06:30:44 | excite | 1 | 48755 | 6 | 0.733 | 66514.3 |
241 | 2021-08-15 21:52:05 | excite | 1 | 48755 | 6 | 0.736 | 66243.2 |
240 | 2021-07-12 06:55:56 | excite | 1 | 48755 | 6 | 0.766 | 63648.8 |
239 | 2021-05-01 15:49:15 | excite | 1 | 48755 | 6 | 0.846 | 57630.0 |
238 | 2021-04-30 21:15:50 | excite | 1 | 48755 | 6 | 0.750 | 65006.7 |
237 | 2021-03-30 05:18:13 | excite | 1 | 48755 | 6 | 0.750 | 65006.7 |
236 | 2021-02-08 00:17:28 | excite | 1 | 48755 | 6 | 0.810 | 60191.4 |
235 | 2021-01-29 05:45:38 | excite | 1 | 48755 | 6 | 0.830 | 58741.0 |
234 | 2021-01-27 03:32:58 | excite | 1 | 48755 | 6 | 0.733 | 66514.3 |
233 | 2021-01-13 19:59:16 | excite | 1 | 48755 | 6 | 0.736 | 66243.2 |
232 | 2020-10-26 11:16:23 | excite | 1 | 48755 | 6 | 0.750 | 65006.7 |
231 | 2020-10-25 20:41:31 | excite | 1 | 48755 | 6 | 0.843 | 57835.1 |
230 | 2020-10-25 12:42:39 | excite | 1 | 48755 | 6 | 0.736 | 66243.2 |
229 | 2020-10-19 06:09:52 | excite | 1 | 48755 | 6 | 0.736 | 66243.2 |
228 | 2020-10-18 13:28:47 | excite | 1 | 48755 | 6 | 0.750 | 65006.7 |
227 | 2020-09-29 08:42:02 | excite | 1 | 48755 | 6 | 0.750 | 65006.7 |
226 | 2020-07-26 21:00:07 | excite | 1 | 48755 | 6 | 0.780 | 62506.4 |
225 | 2020-07-26 06:19:03 | excite | 1 | 48755 | 6 | 0.813 | 59969.2 |
224 | 2020-07-22 18:36:09 | excite | 1 | 48755 | 6 | 0.750 | 65006.7 |
223 | 2020-06-21 06:14:11 | excite | 1 | 48755 | 6 | 0.876 | 55656.4 |
222 | 2020-06-13 01:35:09 | excite | 1 | 48755 | 6 | 0.766 | 63648.8 |
221 | 2020-06-12 01:15:01 | excite | 1 | 48755 | 6 | 0.766 | 63648.8 |
220 | 2020-04-20 19:57:10 | excite | 1 | 48755 | 6 | 0.766 | 63648.8 |
219 | 2020-03-28 02:54:45 | excite | 1 | 48755 | 6 | 0.890 | 54780.9 |
218 | 2020-03-27 23:09:26 | excite | 1 | 48755 | 6 | 0.733 | 66514.3 |
217 | 2020-03-26 18:41:10 | excite | 1 | 48755 | 6 | 1.703 | 28628.9 |
216 | 2020-03-24 07:35:25 | excite | 1 | 48755 | 6 | 1.936 | 25183.4 |
215 | 2020-03-24 04:08:11 | excite | 1 | 48755 | 6 | 0.906 | 53813.5 |
214 | 2020-03-20 09:03:17 | excite | 1 | 48755 | 6 | 1.670 | 29194.6 |
213 | 2020-02-27 07:15:31 | excite | 1 | 48755 | 6 | 0.906 | 53813.5 |