History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"zebras"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
289 | 2024-04-17 20:20:05 | zebras | 1 | 48755 | 3 | 1.813 | 26891.9 |
288 | 2024-04-13 17:38:48 | zebras | 1 | 48755 | 3 | 1.813 | 26891.9 |
287 | 2024-04-13 14:12:55 | zebras | 1 | 48755 | 3 | 0.983 | 49598.2 |
286 | 2024-04-06 13:13:20 | zebras | 1 | 48755 | 3 | 2.110 | 23106.6 |
285 | 2024-04-01 17:18:19 | zebras | 3 | 112716 | 432 | 25.483 | 4423.2 |
284 | 2024-04-01 16:52:39 | zebras | 2 | 82551 | 26 | 5.530 | 14927.8 |
283 | 2024-04-01 16:32:21 | zebras | 2 | 82551 | 26 | 2.640 | 31269.3 |
282 | 2024-04-01 16:32:01 | zebras | 3 | 112716 | 432 | 5.703 | 19764.3 |
281 | 2024-03-31 14:52:32 | zebras | 1 | 48755 | 3 | 1.860 | 26212.4 |
280 | 2024-03-28 19:53:54 | zebras | 2 | 82551 | 26 | 2.873 | 28733.4 |
279 | 2024-03-28 19:15:41 | zebras | 3 | 112716 | 432 | 15.000 | 7514.4 |
278 | 2024-03-28 15:57:07 | zebras | 3 | 112716 | 432 | 10.750 | 10485.2 |
277 | 2024-03-28 15:57:09 | zebras | 1 | 48755 | 3 | 0.843 | 57835.1 |
276 | 2024-03-28 15:57:05 | zebras | 2 | 82551 | 26 | 2.436 | 33887.9 |
275 | 2024-01-22 10:36:14 | zebras | 1 | 48755 | 3 | 0.716 | 68093.6 |
274 | 2023-12-20 05:29:51 | zebras | 3 | 112716 | 432 | 4.483 | 25143.0 |
273 | 2023-12-15 08:30:57 | zebras | 2 | 82551 | 26 | 2.483 | 33246.5 |
272 | 2023-11-24 00:10:31 | zebras | 1 | 48755 | 3 | 0.720 | 67715.3 |
271 | 2023-11-22 15:01:02 | zebras | 1 | 48755 | 3 | 0.796 | 61250.0 |
270 | 2023-11-18 21:37:06 | zebras | 1 | 48755 | 3 | 0.733 | 66514.3 |
269 | 2023-11-04 07:30:27 | zebras | 1 | 48755 | 3 | 0.720 | 67715.3 |
268 | 2023-11-02 13:45:11 | zebras | 1 | 48755 | 3 | 1.610 | 30282.6 |
267 | 2023-10-23 19:49:30 | zebras | 1 | 48755 | 3 | 0.736 | 66243.2 |
266 | 2023-10-14 19:15:27 | zebras | 2 | 82551 | 26 | 2.453 | 33653.1 |
265 | 2023-10-13 06:21:28 | zebras | 3 | 112716 | 432 | 10.860 | 10379.0 |
264 | 2023-10-10 14:32:30 | zebras | 1 | 48755 | 3 | 0.750 | 65006.7 |
263 | 2023-10-08 23:17:22 | zebras | 1 | 48755 | 3 | 0.780 | 62506.4 |
262 | 2023-09-28 10:48:46 | zebras | 3 | 112716 | 432 | 5.063 | 22262.7 |
261 | 2023-09-23 08:50:14 | zebras | 1 | 48755 | 3 | 0.733 | 66514.3 |
260 | 2023-09-20 19:58:26 | zebras | 3 | 112716 | 432 | 5.500 | 20493.8 |
259 | 2023-09-15 18:49:26 | zebras | 2 | 82551 | 26 | 2.876 | 28703.4 |
258 | 2023-09-13 23:46:52 | zebras | 1 | 48755 | 3 | 0.720 | 67715.3 |
257 | 2023-09-05 22:23:16 | zebras | 1 | 48755 | 3 | 0.796 | 61250.0 |
256 | 2023-08-03 22:16:02 | zebras | 3 | 112716 | 432 | 5.360 | 21029.1 |
255 | 2023-07-07 08:37:37 | zebras | 1 | 48755 | 3 | 0.733 | 66514.3 |
254 | 2023-06-23 19:35:36 | zebras | 3 | 112716 | 432 | 4.453 | 25312.4 |
253 | 2023-06-19 02:00:28 | zebras | 2 | 82551 | 26 | 2.343 | 35233.0 |
252 | 2023-06-08 19:31:37 | zebras | 1 | 48755 | 3 | 0.733 | 66514.3 |
251 | 2023-05-02 03:05:25 | zebras | 1 | 48755 | 3 | 0.716 | 68093.6 |
250 | 2023-04-03 19:44:43 | zebras | 1 | 48755 | 3 | 0.780 | 62506.4 |
249 | 2023-03-28 12:06:07 | zebras | 1 | 48755 | 3 | 0.733 | 66514.3 |
248 | 2023-03-17 13:31:18 | zebras | 3 | 112716 | 432 | 5.203 | 21663.7 |
247 | 2023-03-17 00:50:25 | zebras | 2 | 82551 | 26 | 2.016 | 40947.9 |
246 | 2023-01-27 17:35:57 | zebras | 1 | 48755 | 3 | 0.783 | 62266.9 |
245 | 2023-01-11 15:27:18 | zebras | 1 | 48755 | 3 | 0.703 | 69352.8 |
244 | 2023-01-03 22:01:17 | zebras | 3 | 112716 | 432 | 4.610 | 24450.3 |
243 | 2023-01-02 20:05:56 | zebras | 3 | 112716 | 432 | 5.140 | 21929.2 |
242 | 2022-12-19 17:39:52 | zebras | 2 | 82551 | 26 | 2.016 | 40947.9 |
241 | 2022-12-19 12:33:34 | zebras | 3 | 112716 | 432 | 4.483 | 25143.0 |
240 | 2022-12-09 23:49:03 | zebras | 1 | 48755 | 3 | 0.766 | 63648.8 |
239 | 2022-11-20 03:37:42 | zebras | 3 | 112716 | 432 | 4.893 | 23036.2 |
238 | 2022-10-29 04:08:47 | zebras | 3 | 112716 | 432 | 4.610 | 24450.3 |
237 | 2022-10-26 01:34:14 | zebras | 3 | 112716 | 432 | 4.516 | 24959.3 |
236 | 2022-10-19 04:59:24 | zebras | 1 | 48755 | 3 | 0.716 | 68093.6 |
235 | 2022-09-20 23:40:50 | zebras | 2 | 82551 | 26 | 2.280 | 36206.6 |
234 | 2022-09-13 08:22:14 | zebras | 3 | 112716 | 432 | 4.500 | 25048.0 |
233 | 2022-09-12 08:32:27 | zebras | 3 | 112716 | 432 | 4.703 | 23966.8 |
232 | 2022-09-02 20:08:33 | zebras | 3 | 112716 | 432 | 4.516 | 24959.3 |
231 | 2022-08-30 10:10:45 | zebras | 3 | 112716 | 432 | 4.546 | 24794.5 |
230 | 2022-08-27 00:03:01 | zebras | 2 | 82551 | 26 | 2.033 | 40605.5 |
229 | 2022-08-17 20:14:19 | zebras | 1 | 48755 | 3 | 0.720 | 67715.3 |
228 | 2022-08-15 05:01:46 | zebras | 2 | 82551 | 26 | 2.033 | 40605.5 |
227 | 2022-08-13 13:48:49 | zebras | 3 | 112716 | 432 | 4.470 | 25216.1 |
226 | 2022-08-07 09:29:16 | zebras | 1 | 48755 | 3 | 0.736 | 66243.2 |
225 | 2022-07-27 23:44:34 | zebras | 3 | 112716 | 432 | 4.846 | 23259.6 |
224 | 2022-07-26 12:08:04 | zebras | 3 | 112716 | 432 | 5.483 | 20557.4 |
223 | 2022-07-25 00:30:14 | zebras | 3 | 112716 | 432 | 4.720 | 23880.5 |
222 | 2022-07-18 16:51:10 | zebras | 3 | 112716 | 432 | 4.766 | 23650.0 |
221 | 2022-07-12 13:31:05 | zebras | 3 | 112716 | 432 | 4.750 | 23729.7 |
220 | 2022-07-09 18:19:51 | zebras | 3 | 112716 | 432 | 4.593 | 24540.8 |
219 | 2022-07-01 12:33:51 | zebras | 1 | 48755 | 3 | 0.720 | 67715.3 |
218 | 2022-06-09 23:10:54 | zebras | 1 | 48755 | 3 | 0.783 | 62266.9 |
217 | 2022-06-05 18:53:35 | zebras | 3 | 112716 | 432 | 4.466 | 25238.7 |
216 | 2022-05-25 16:54:35 | zebras | 1 | 48755 | 3 | 0.906 | 53813.5 |
215 | 2022-05-17 03:14:21 | zebras | 1 | 48755 | 3 | 0.876 | 55656.4 |
214 | 2022-05-16 16:02:21 | zebras | 1 | 48755 | 3 | 0.736 | 66243.2 |
213 | 2022-05-13 16:39:23 | zebras | 3 | 112716 | 432 | 5.330 | 21147.5 |
212 | 2022-04-30 18:25:28 | zebras | 3 | 112716 | 432 | 8.720 | 12926.1 |
211 | 2022-03-30 17:12:08 | zebras | 2 | 82551 | 26 | 2.906 | 28407.1 |
210 | 2022-03-12 01:28:19 | zebras | 3 | 112716 | 432 | 4.876 | 23116.5 |
209 | 2022-03-08 01:58:07 | zebras | 1 | 48755 | 3 | 0.720 | 67715.3 |
208 | 2022-02-24 02:00:11 | zebras | 1 | 48755 | 3 | 0.860 | 56691.9 |
207 | 2022-02-21 22:43:04 | zebras | 1 | 48755 | 3 | 0.970 | 50262.9 |
206 | 2022-02-15 23:19:35 | zebras | 1 | 48755 | 3 | 0.813 | 59969.2 |
205 | 2021-12-31 20:42:05 | zebras | 1 | 48755 | 3 | 0.890 | 54780.9 |
204 | 2021-12-11 11:00:55 | zebras | 1 | 48755 | 3 | 0.813 | 59969.2 |
203 | 2021-12-08 22:21:24 | zebras | 1 | 48755 | 3 | 0.860 | 56691.9 |
202 | 2021-11-21 23:58:44 | zebras | 1 | 48755 | 3 | 0.800 | 60943.8 |
201 | 2021-11-01 14:21:33 | zebras | 1 | 48755 | 3 | 0.720 | 67715.3 |
200 | 2021-06-06 22:57:39 | zebras | 1 | 48755 | 3 | 0.783 | 62266.9 |
199 | 2021-05-12 13:51:15 | zebras | 1 | 48755 | 3 | 0.783 | 62266.9 |
198 | 2021-03-15 07:43:32 | zebras | 1 | 48755 | 3 | 0.796 | 61250.0 |
197 | 2021-02-27 04:11:32 | zebras | 1 | 48755 | 3 | 0.766 | 63648.8 |
196 | 2021-02-12 13:50:50 | zebras | 1 | 48755 | 3 | 0.733 | 66514.3 |
195 | 2020-12-27 18:25:56 | zebras | 1 | 48755 | 3 | 0.736 | 66243.2 |
194 | 2020-11-11 02:29:02 | zebras | 1 | 48755 | 3 | 0.983 | 49598.2 |
193 | 2020-10-31 21:21:01 | zebras | 1 | 48755 | 3 | 0.813 | 59969.2 |
192 | 2020-03-26 12:36:13 | zebras | 1 | 48755 | 3 | 0.830 | 58741.0 |
191 | 2020-03-24 20:44:13 | zebras | 1 | 48755 | 3 | 2.640 | 18467.8 |
190 | 2020-03-24 11:45:12 | zebras | 1 | 48755 | 3 | 1.703 | 28628.9 |