History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"catchword"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
225 | 2024-05-14 13:51:19 | catchword | 1 | 81242 | 3 | 1.673 | 48560.7 |
224 | 2024-05-13 18:52:45 | catchword | 1 | 81242 | 3 | 3.483 | 23325.3 |
223 | 2024-05-07 10:48:52 | catchword | 1 | 81242 | 3 | 3.563 | 22801.6 |
222 | 2024-05-04 10:10:47 | catchword | 2 | 121436 | 6 | 4.420 | 27474.2 |
221 | 2024-05-04 10:09:31 | catchword | 1 | 81242 | 3 | 1.610 | 50460.9 |
220 | 2024-05-04 10:08:24 | catchword | 1 | 81242 | 3 | 2.516 | 32290.1 |
219 | 2024-04-30 17:10:10 | catchword | 1 | 81242 | 3 | 1.656 | 49059.2 |
218 | 2024-04-26 21:24:38 | catchword | 2 | 121436 | 6 | 9.046 | 13424.3 |
217 | 2024-04-26 17:06:05 | catchword | 1 | 81242 | 3 | 2.860 | 28406.3 |
216 | 2024-04-21 08:54:43 | catchword | 3 | 148641 | 19 | 31.643 | 4697.4 |
215 | 2024-04-19 16:40:43 | catchword | 3 | 148641 | 19 | 16.563 | 8974.3 |
214 | 2024-04-15 23:57:37 | catchword | 3 | 148641 | 19 | 21.453 | 6928.7 |
213 | 2024-04-15 21:35:33 | catchword | 1 | 81242 | 3 | 3.250 | 24997.5 |
212 | 2024-04-13 01:17:00 | catchword | 1 | 81242 | 3 | 1.423 | 57092.1 |
211 | 2024-04-07 23:55:54 | catchword | 4 | 165329 | 148 | 45.500 | 3633.6 |
210 | 2024-04-07 00:51:22 | catchword | 2 | 121436 | 6 | 5.580 | 21762.7 |
209 | 2024-04-05 21:09:53 | catchword | 2 | 121436 | 6 | 13.563 | 8953.5 |
208 | 2024-04-05 21:08:46 | catchword | 1 | 81242 | 3 | 3.596 | 22592.3 |
207 | 2024-04-04 08:51:04 | catchword | 4 | 165329 | 148 | 43.783 | 3776.1 |
206 | 2024-04-04 08:43:59 | catchword | 3 | 148641 | 19 | 17.986 | 8264.3 |
205 | 2024-04-03 22:24:06 | catchword | 1 | 81242 | 3 | 1.640 | 49537.8 |
204 | 2024-04-03 22:23:49 | catchword | 4 | 165329 | 148 | 16.050 | 10300.9 |
203 | 2024-04-03 22:23:51 | catchword | 3 | 148641 | 19 | 13.393 | 11098.4 |
202 | 2024-04-03 22:23:50 | catchword | 2 | 121436 | 6 | 5.250 | 23130.7 |
201 | 2024-04-03 22:23:29 | catchword | 1 | 81242 | 3 | 3.296 | 24648.7 |
200 | 2024-03-28 11:54:49 | catchword | 3 | 148641 | 19 | 6.626 | 22433.0 |
199 | 2024-03-25 12:24:42 | catchword | 1 | 81242 | 3 | 1.266 | 64172.2 |
198 | 2024-03-11 01:49:22 | catchword | 1 | 81242 | 3 | 5.580 | 14559.5 |
197 | 2024-03-08 15:29:15 | catchword | 3 | 148641 | 19 | 13.453 | 11048.9 |
196 | 2024-03-08 15:29:14 | catchword | 2 | 121436 | 6 | 4.420 | 27474.2 |
195 | 2024-03-08 15:28:14 | catchword | 1 | 81242 | 3 | 2.266 | 35852.6 |
194 | 2024-03-07 05:08:31 | catchword | 1 | 81242 | 3 | 2.703 | 30056.2 |
193 | 2024-03-03 14:02:33 | catchword | 4 | 165329 | 148 | 32.266 | 5123.9 |
192 | 2024-03-03 14:02:34 | catchword | 3 | 148641 | 19 | 8.890 | 16720.0 |
191 | 2024-03-03 14:02:32 | catchword | 2 | 121436 | 6 | 4.140 | 29332.4 |
190 | 2024-02-27 12:35:03 | catchword | 1 | 81242 | 3 | 1.326 | 61268.5 |
189 | 2024-02-19 19:21:45 | catchword | 1 | 81242 | 3 | 1.593 | 50999.4 |
188 | 2024-02-19 02:32:34 | catchword | 1 | 81242 | 3 | 16.250 | 4999.5 |
187 | 2024-02-03 07:55:50 | catchword | 1 | 81242 | 3 | 2.936 | 27671.0 |
186 | 2024-01-27 10:04:29 | catchword | 1 | 81242 | 3 | 1.423 | 57092.1 |
185 | 2024-01-15 04:07:06 | catchword | 1 | 81242 | 3 | 1.403 | 57905.9 |
184 | 2024-01-11 06:37:31 | catchword | 1 | 81242 | 3 | 1.263 | 64324.6 |
183 | 2024-01-09 15:04:04 | catchword | 1 | 81242 | 3 | 1.406 | 57782.4 |
182 | 2023-12-02 15:49:27 | catchword | 3 | 148641 | 19 | 6.423 | 23142.0 |
181 | 2023-11-06 15:58:40 | catchword | 1 | 81242 | 3 | 1.466 | 55417.5 |
180 | 2023-08-31 15:09:23 | catchword | 3 | 148641 | 19 | 7.360 | 20195.8 |
179 | 2023-08-29 09:33:11 | catchword | 1 | 81242 | 3 | 1.330 | 61084.2 |
178 | 2023-08-28 14:47:24 | catchword | 1 | 81242 | 3 | 1.266 | 64172.2 |
177 | 2023-06-02 00:49:58 | catchword | 1 | 81242 | 3 | 1.343 | 60492.9 |
176 | 2023-05-19 05:09:09 | catchword | 3 | 148641 | 19 | 6.156 | 24145.7 |
175 | 2023-04-23 21:25:27 | catchword | 1 | 81242 | 3 | 1.250 | 64993.6 |
174 | 2023-03-26 15:44:35 | catchword | 1 | 81242 | 3 | 1.266 | 64172.2 |
173 | 2023-02-26 11:44:42 | catchword | 3 | 148641 | 19 | 6.796 | 21871.8 |
172 | 2023-01-10 03:34:49 | catchword | 1 | 81242 | 3 | 1.220 | 66591.8 |
171 | 2022-12-27 14:15:48 | catchword | 1 | 81242 | 3 | 1.250 | 64993.6 |
170 | 2022-12-07 07:45:28 | catchword | 3 | 148641 | 19 | 6.050 | 24568.8 |
169 | 2022-10-19 03:07:27 | catchword | 1 | 81242 | 3 | 1.266 | 64172.2 |
168 | 2022-08-13 12:25:36 | catchword | 1 | 81242 | 3 | 1.283 | 63321.9 |
167 | 2022-07-22 19:33:03 | catchword | 3 | 148641 | 19 | 6.203 | 23962.8 |
166 | 2022-07-19 03:55:04 | catchword | 4 | 165329 | 148 | 10.440 | 15836.1 |
165 | 2022-06-06 05:17:55 | catchword | 1 | 81242 | 3 | 1.283 | 63321.9 |
164 | 2022-04-29 20:39:00 | catchword | 1 | 81242 | 3 | 1.266 | 64172.2 |
163 | 2022-03-19 12:03:09 | catchword | 1 | 81242 | 3 | 1.266 | 64172.2 |
162 | 2022-03-16 01:15:18 | catchword | 1 | 81242 | 3 | 1.283 | 63321.9 |
161 | 2022-01-16 19:06:57 | catchword | 1 | 81242 | 3 | 1.423 | 57092.1 |
160 | 2021-11-14 14:34:22 | catchword | 1 | 81242 | 3 | 1.453 | 55913.3 |
159 | 2021-11-12 12:54:38 | catchword | 1 | 81242 | 3 | 1.360 | 59736.8 |
158 | 2021-11-12 04:42:24 | catchword | 1 | 81242 | 3 | 1.373 | 59171.2 |
157 | 2021-07-23 04:51:08 | catchword | 1 | 81242 | 3 | 1.266 | 64172.2 |
156 | 2021-04-29 13:32:06 | catchword | 1 | 81242 | 3 | 1.470 | 55266.7 |
155 | 2021-01-12 20:38:36 | catchword | 1 | 81242 | 3 | 2.626 | 30937.5 |
154 | 2020-11-02 11:48:50 | catchword | 1 | 81242 | 3 | 1.596 | 50903.5 |
153 | 2020-10-31 23:46:56 | catchword | 1 | 81242 | 3 | 1.263 | 64324.6 |
152 | 2020-10-05 03:17:01 | catchword | 1 | 81242 | 3 | 1.233 | 65889.7 |
151 | 2020-08-27 20:28:54 | catchword | 1 | 81242 | 3 | 1.376 | 59042.2 |
150 | 2020-07-29 20:22:35 | catchword | 1 | 81242 | 3 | 1.326 | 61268.5 |
149 | 2020-04-05 01:14:50 | catchword | 1 | 81242 | 3 | 1.326 | 61268.5 |
148 | 2020-03-26 03:04:20 | catchword | 1 | 81242 | 3 | 3.236 | 25105.7 |
147 | 2020-02-11 09:34:32 | catchword | 4 | 165329 | 148 | 14.890 | 11103.4 |
146 | 2020-02-11 01:20:00 | catchword | 4 | 165329 | 148 | 25.436 | 6499.8 |
145 | 2020-02-09 12:15:53 | catchword | 4 | 165329 | 148 | 31.423 | 5261.4 |
144 | 2020-02-08 15:36:06 | catchword | 1 | 81242 | 3 | 3.190 | 25467.7 |
143 | 2020-02-07 01:51:03 | catchword | 4 | 165329 | 148 | 30.266 | 5462.5 |
142 | 2020-02-05 05:45:31 | catchword | 4 | 165329 | 148 | 27.030 | 6116.5 |
141 | 2020-02-04 12:02:11 | catchword | 3 | 148641 | 19 | 14.986 | 9918.7 |
140 | 2020-02-04 12:01:51 | catchword | 4 | 165329 | 148 | 16.563 | 9981.8 |
139 | 2020-02-04 11:59:51 | catchword | 2 | 121436 | 6 | 5.720 | 21230.1 |
138 | 2020-02-04 06:55:57 | catchword | 1 | 81242 | 3 | 1.560 | 52078.2 |
137 | 2020-02-03 19:37:08 | catchword | 1 | 81242 | 3 | 1.580 | 51419.0 |
136 | 2020-02-03 18:46:38 | catchword | 1 | 81242 | 3 | 2.733 | 29726.3 |
135 | 2020-01-23 13:01:28 | catchword | 1 | 81242 | 3 | 4.063 | 19995.6 |
134 | 2020-01-23 05:01:34 | catchword | 1 | 81242 | 3 | 1.640 | 49537.8 |
133 | 2020-01-08 03:37:52 | catchword | 1 | 81242 | 3 | 5.783 | 14048.4 |
132 | 2020-01-02 22:16:01 | catchword | 1 | 81242 | 3 | 1.516 | 53589.7 |
131 | 2019-12-27 20:39:57 | catchword | 1 | 81242 | 3 | 1.373 | 59171.2 |
130 | 2019-09-27 06:26:42 | catchword | 1 | 81242 | 3 | 1.333 | 60946.7 |
129 | 2019-06-18 03:33:18 | catchword | 1 | 81242 | 3 | 1.446 | 56184.0 |
128 | 2019-02-24 12:48:52 | catchword | 1 | 81242 | 3 | 1.496 | 54306.1 |
127 | 2018-10-29 17:28:05 | catchword | 1 | 81242 | 3 | 2.670 | 30427.7 |
126 | 2018-07-25 16:18:37 | catchword | 1 | 81242 | 3 | 1.540 | 52754.5 |