History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"thecate"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
281 | 2024-04-11 04:39:17 | thecate | 2 | 107671 | 10 | 3.390 | 31761.4 |
280 | 2024-04-11 04:39:04 | thecate | 3 | 134027 | 196 | 6.893 | 19443.9 |
279 | 2024-04-08 13:54:39 | thecate | 3 | 134027 | 196 | 15.046 | 8907.8 |
278 | 2024-04-08 08:16:05 | thecate | 2 | 107671 | 10 | 6.826 | 15773.7 |
277 | 2024-04-08 08:15:53 | thecate | 3 | 134027 | 196 | 8.690 | 15423.1 |
276 | 2024-04-06 09:40:55 | thecate | 3 | 134027 | 196 | 23.843 | 5621.2 |
275 | 2024-04-06 09:36:10 | thecate | 3 | 134027 | 196 | 14.770 | 9074.3 |
274 | 2024-04-06 09:35:09 | thecate | 3 | 134027 | 196 | 17.236 | 7776.0 |
273 | 2024-03-31 23:01:54 | thecate | 1 | 69583 | 2 | 1.390 | 50059.7 |
272 | 2024-03-31 23:01:45 | thecate | 3 | 134027 | 196 | 8.266 | 16214.3 |
271 | 2024-03-31 23:01:44 | thecate | 2 | 107671 | 10 | 3.750 | 28712.3 |
270 | 2024-03-31 23:01:41 | thecate | 1 | 69583 | 2 | 2.656 | 26198.4 |
269 | 2024-03-29 03:53:39 | thecate | 1 | 69583 | 2 | 1.373 | 50679.5 |
268 | 2024-03-06 08:43:13 | thecate | 3 | 134027 | 196 | 15.940 | 8408.2 |
267 | 2024-03-04 22:03:56 | thecate | 3 | 134027 | 196 | 24.143 | 5551.4 |
266 | 2024-03-03 08:16:32 | thecate | 3 | 134027 | 196 | 7.003 | 19138.5 |
265 | 2024-03-03 08:16:34 | thecate | 2 | 107671 | 10 | 3.360 | 32044.9 |
264 | 2024-03-03 08:08:14 | thecate | 1 | 69583 | 2 | 6.123 | 11364.2 |
263 | 2024-02-29 23:22:29 | thecate | 1 | 69583 | 2 | 1.326 | 52475.9 |
262 | 2024-02-20 06:43:18 | thecate | 2 | 107671 | 10 | 6.750 | 15951.3 |
261 | 2024-01-19 16:32:13 | thecate | 2 | 107671 | 10 | 3.093 | 34811.2 |
260 | 2024-01-15 07:45:06 | thecate | 2 | 107671 | 10 | 2.920 | 36873.6 |
259 | 2024-01-13 07:16:36 | thecate | 1 | 69583 | 2 | 1.046 | 66522.9 |
258 | 2023-12-27 05:08:51 | thecate | 1 | 69583 | 2 | 1.063 | 65459.1 |
257 | 2023-12-12 02:53:04 | thecate | 1 | 69583 | 2 | 1.203 | 57841.2 |
256 | 2023-12-08 03:10:24 | thecate | 3 | 134027 | 196 | 6.580 | 20368.8 |
255 | 2023-11-23 21:17:38 | thecate | 1 | 69583 | 2 | 1.140 | 61037.7 |
254 | 2023-11-15 20:56:59 | thecate | 2 | 107671 | 10 | 3.236 | 33272.9 |
253 | 2023-11-08 04:29:06 | thecate | 1 | 69583 | 2 | 1.126 | 61796.6 |
252 | 2023-11-04 12:08:31 | thecate | 1 | 69583 | 2 | 1.156 | 60192.9 |
251 | 2023-10-26 17:30:15 | thecate | 1 | 69583 | 2 | 1.330 | 52318.0 |
250 | 2023-10-22 03:01:10 | thecate | 1 | 69583 | 2 | 1.090 | 63837.6 |
249 | 2023-09-14 02:08:06 | thecate | 1 | 69583 | 2 | 1.063 | 65459.1 |
248 | 2023-09-04 15:10:00 | thecate | 3 | 134027 | 196 | 6.266 | 21389.6 |
247 | 2023-08-29 06:04:29 | thecate | 1 | 69583 | 2 | 1.063 | 65459.1 |
246 | 2023-08-16 21:57:18 | thecate | 2 | 107671 | 10 | 3.173 | 33933.5 |
245 | 2023-06-14 08:27:38 | thecate | 1 | 69583 | 2 | 1.156 | 60192.9 |
244 | 2023-05-31 17:43:38 | thecate | 1 | 69583 | 2 | 1.093 | 63662.4 |
243 | 2023-05-20 16:27:51 | thecate | 3 | 134027 | 196 | 5.656 | 23696.4 |
242 | 2023-05-02 21:47:35 | thecate | 2 | 107671 | 10 | 3.046 | 35348.3 |
241 | 2023-03-25 09:33:32 | thecate | 1 | 69583 | 2 | 1.030 | 67556.3 |
240 | 2023-02-26 21:16:26 | thecate | 3 | 134027 | 196 | 6.076 | 22058.4 |
239 | 2023-02-16 04:41:36 | thecate | 1 | 69583 | 2 | 1.063 | 65459.1 |
238 | 2023-02-07 12:35:22 | thecate | 2 | 107671 | 10 | 3.156 | 34116.3 |
237 | 2023-01-10 20:31:20 | thecate | 1 | 69583 | 2 | 1.013 | 68690.0 |
236 | 2022-12-10 08:12:03 | thecate | 3 | 134027 | 196 | 5.653 | 23709.0 |
235 | 2022-11-19 06:00:12 | thecate | 2 | 107671 | 10 | 2.686 | 40086.0 |
234 | 2022-10-14 08:08:15 | thecate | 1 | 69583 | 2 | 1.033 | 67360.1 |
233 | 2022-10-08 02:59:12 | thecate | 1 | 69583 | 2 | 1.156 | 60192.9 |
232 | 2022-07-27 12:41:41 | thecate | 3 | 134027 | 196 | 5.563 | 24092.6 |
231 | 2022-06-22 14:46:16 | thecate | 2 | 107671 | 10 | 2.796 | 38508.9 |
230 | 2022-06-05 08:16:10 | thecate | 1 | 69583 | 2 | 1.190 | 58473.1 |
229 | 2022-06-03 03:13:31 | thecate | 1 | 69583 | 2 | 1.203 | 57841.2 |
228 | 2022-05-27 22:52:04 | thecate | 1 | 69583 | 2 | 1.063 | 65459.1 |
227 | 2022-05-05 10:24:49 | thecate | 1 | 69583 | 2 | 1.360 | 51164.0 |
226 | 2022-02-28 17:09:26 | thecate | 3 | 134027 | 196 | 7.596 | 17644.4 |
225 | 2022-02-10 21:03:28 | thecate | 1 | 69583 | 2 | 1.033 | 67360.1 |
224 | 2022-02-08 17:09:39 | thecate | 1 | 69583 | 2 | 1.250 | 55666.4 |
223 | 2022-01-23 00:30:17 | thecate | 1 | 69583 | 2 | 1.046 | 66522.9 |
222 | 2021-12-13 19:28:51 | thecate | 1 | 69583 | 2 | 1.203 | 57841.2 |
221 | 2021-12-12 22:03:11 | thecate | 1 | 69583 | 2 | 1.266 | 54962.9 |
220 | 2021-12-10 19:36:57 | thecate | 1 | 69583 | 2 | 1.076 | 64668.2 |
219 | 2021-09-27 03:36:18 | thecate | 1 | 69583 | 2 | 1.046 | 66522.9 |
218 | 2021-06-27 12:32:34 | thecate | 1 | 69583 | 2 | 1.063 | 65459.1 |
217 | 2021-05-22 21:50:38 | thecate | 1 | 69583 | 2 | 1.203 | 57841.2 |
216 | 2021-04-24 00:24:03 | thecate | 1 | 69583 | 2 | 1.190 | 58473.1 |
215 | 2021-04-13 08:14:57 | thecate | 1 | 69583 | 2 | 1.390 | 50059.7 |
214 | 2021-03-26 16:53:04 | thecate | 1 | 69583 | 2 | 1.203 | 57841.2 |
213 | 2021-03-26 00:13:18 | thecate | 1 | 69583 | 2 | 1.046 | 66522.9 |
212 | 2021-03-22 07:44:34 | thecate | 1 | 69583 | 2 | 2.143 | 32469.9 |
211 | 2021-01-09 07:24:41 | thecate | 1 | 69583 | 2 | 1.060 | 65644.3 |
210 | 2020-12-19 09:57:07 | thecate | 1 | 69583 | 2 | 1.060 | 65644.3 |
209 | 2020-10-29 23:43:46 | thecate | 1 | 69583 | 2 | 1.093 | 63662.4 |
208 | 2020-10-20 09:10:46 | thecate | 1 | 69583 | 2 | 1.046 | 66522.9 |
207 | 2020-10-17 10:59:20 | thecate | 1 | 69583 | 2 | 1.076 | 64668.2 |
206 | 2020-10-17 07:29:00 | thecate | 1 | 69583 | 2 | 1.203 | 57841.2 |
205 | 2020-09-19 00:11:19 | thecate | 1 | 69583 | 2 | 1.173 | 59320.5 |
204 | 2020-05-24 21:25:58 | thecate | 1 | 69583 | 2 | 1.170 | 59472.6 |
203 | 2020-05-21 19:39:19 | thecate | 1 | 69583 | 2 | 1.063 | 65459.1 |
202 | 2020-03-29 14:48:12 | thecate | 1 | 69583 | 2 | 1.190 | 58473.1 |
201 | 2020-03-25 07:04:46 | thecate | 1 | 69583 | 2 | 1.186 | 58670.3 |
200 | 2020-03-24 07:15:21 | thecate | 1 | 69583 | 2 | 1.406 | 49490.0 |
199 | 2020-03-20 23:15:55 | thecate | 1 | 69583 | 2 | 1.110 | 62687.4 |
198 | 2020-03-02 18:57:28 | thecate | 1 | 69583 | 2 | 1.250 | 55666.4 |
197 | 2020-03-02 16:53:45 | thecate | 1 | 69583 | 2 | 1.266 | 54962.9 |
196 | 2020-03-01 07:20:16 | thecate | 3 | 134027 | 196 | 21.283 | 6297.4 |
195 | 2020-02-29 08:43:57 | thecate | 1 | 69583 | 2 | 1.250 | 55666.4 |
194 | 2020-02-29 06:17:22 | thecate | 1 | 69583 | 2 | 1.250 | 55666.4 |
193 | 2020-02-27 16:35:02 | thecate | 3 | 134027 | 196 | 7.530 | 17799.1 |
192 | 2020-02-27 09:32:54 | thecate | 3 | 134027 | 196 | 8.576 | 15628.1 |
191 | 2020-02-21 02:42:36 | thecate | 1 | 69583 | 2 | 1.220 | 57035.2 |
190 | 2020-02-18 17:03:54 | thecate | 1 | 69583 | 2 | 1.326 | 52475.9 |
189 | 2020-02-18 12:28:09 | thecate | 1 | 69583 | 2 | 1.173 | 59320.5 |
188 | 2020-02-16 18:34:49 | thecate | 3 | 134027 | 196 | 14.826 | 9040.0 |
187 | 2020-02-15 03:50:53 | thecate | 3 | 134027 | 196 | 9.736 | 13766.1 |
186 | 2020-02-15 00:13:31 | thecate | 3 | 134027 | 196 | 16.453 | 8146.1 |
185 | 2020-02-14 13:37:39 | thecate | 3 | 134027 | 196 | 9.686 | 13837.2 |
184 | 2020-02-10 09:00:19 | thecate | 1 | 69583 | 2 | 1.403 | 49595.9 |
183 | 2020-02-05 07:31:28 | thecate | 1 | 69583 | 2 | 3.580 | 19436.6 |
182 | 2020-02-01 10:02:51 | thecate | 1 | 69583 | 2 | 1.266 | 54962.9 |