History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"disasters"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
251 | 2024-04-13 04:34:08 | disasters | 1 | 81242 | 3 | 2.203 | 36877.9 |
250 | 2024-04-10 08:31:30 | disasters | 1 | 81242 | 3 | 1.733 | 46879.4 |
249 | 2024-03-31 22:54:47 | disasters | 3 | 148641 | 159 | 27.970 | 5314.3 |
248 | 2024-03-31 22:55:03 | disasters | 1 | 81242 | 3 | 4.703 | 17274.5 |
247 | 2024-03-31 22:54:46 | disasters | 2 | 121436 | 18 | 3.876 | 31330.2 |
246 | 2024-03-31 22:54:44 | disasters | 1 | 81242 | 3 | 1.610 | 50460.9 |
245 | 2024-03-10 07:18:24 | disasters | 3 | 148641 | 159 | 17.956 | 8278.1 |
244 | 2024-03-09 01:36:50 | disasters | 3 | 148641 | 159 | 19.063 | 7797.4 |
243 | 2024-03-09 01:36:50 | disasters | 2 | 121436 | 18 | 7.673 | 15826.4 |
242 | 2024-03-08 22:28:25 | disasters | 1 | 81242 | 3 | 1.500 | 54161.3 |
241 | 2024-03-01 18:45:06 | disasters | 3 | 148641 | 159 | 17.766 | 8366.6 |
240 | 2024-03-01 14:17:24 | disasters | 3 | 148641 | 159 | 8.170 | 18193.5 |
239 | 2024-03-01 14:17:23 | disasters | 2 | 121436 | 18 | 3.983 | 30488.6 |
238 | 2024-03-01 14:17:22 | disasters | 1 | 81242 | 3 | 1.576 | 51549.5 |
237 | 2024-03-01 14:17:15 | disasters | 1 | 81242 | 3 | 1.203 | 67532.8 |
236 | 2024-02-10 12:53:36 | disasters | 1 | 81242 | 3 | 2.720 | 29868.4 |
235 | 2024-02-02 21:18:44 | disasters | 1 | 81242 | 3 | 1.423 | 57092.1 |
234 | 2024-02-01 00:25:56 | disasters | 1 | 81242 | 3 | 1.390 | 58447.5 |
233 | 2024-01-31 06:47:27 | disasters | 1 | 81242 | 3 | 1.453 | 55913.3 |
232 | 2024-01-31 06:47:11 | disasters | 1 | 81242 | 3 | 1.330 | 61084.2 |
231 | 2024-01-30 05:25:47 | disasters | 1 | 81242 | 3 | 1.403 | 57905.9 |
230 | 2024-01-18 05:02:00 | disasters | 3 | 148641 | 159 | 6.326 | 23496.8 |
229 | 2024-01-18 05:01:59 | disasters | 2 | 121436 | 18 | 3.326 | 36511.1 |
228 | 2024-01-01 05:41:37 | disasters | 1 | 81242 | 3 | 1.343 | 60492.9 |
227 | 2023-11-29 20:09:39 | disasters | 1 | 81242 | 3 | 1.313 | 61875.1 |
226 | 2023-11-17 02:06:25 | disasters | 1 | 81242 | 3 | 1.313 | 61875.1 |
225 | 2023-10-27 01:47:52 | disasters | 1 | 81242 | 3 | 1.216 | 66810.9 |
224 | 2023-10-11 13:34:43 | disasters | 1 | 81242 | 3 | 1.440 | 56418.1 |
223 | 2023-10-04 09:53:23 | disasters | 3 | 148641 | 159 | 8.236 | 18047.7 |
222 | 2023-10-04 09:53:24 | disasters | 2 | 121436 | 18 | 4.173 | 29100.4 |
221 | 2023-10-03 08:55:24 | disasters | 1 | 81242 | 3 | 1.826 | 44491.8 |
220 | 2023-09-15 01:40:35 | disasters | 1 | 81242 | 3 | 1.326 | 61268.5 |
219 | 2023-08-18 05:54:20 | disasters | 1 | 81242 | 3 | 1.453 | 55913.3 |
218 | 2023-06-24 10:38:21 | disasters | 1 | 81242 | 3 | 1.216 | 66810.9 |
217 | 2023-06-24 10:06:58 | disasters | 1 | 81242 | 3 | 1.233 | 65889.7 |
216 | 2023-05-04 19:43:15 | disasters | 1 | 81242 | 3 | 1.296 | 62686.7 |
215 | 2023-04-03 21:12:28 | disasters | 1 | 81242 | 3 | 1.203 | 67532.8 |
214 | 2023-03-25 20:07:54 | disasters | 1 | 81242 | 3 | 1.263 | 64324.6 |
213 | 2023-03-12 05:28:30 | disasters | 1 | 81242 | 3 | 2.500 | 32496.8 |
212 | 2023-01-19 22:30:29 | disasters | 1 | 81242 | 3 | 1.220 | 66591.8 |
211 | 2022-11-24 02:53:35 | disasters | 1 | 81242 | 3 | 1.266 | 64172.2 |
210 | 2022-11-16 12:23:39 | disasters | 1 | 81242 | 3 | 1.373 | 59171.2 |
209 | 2022-09-02 08:43:23 | disasters | 1 | 81242 | 3 | 1.250 | 64993.6 |
208 | 2022-07-31 06:56:55 | disasters | 1 | 81242 | 3 | 1.203 | 67532.8 |
207 | 2022-07-08 14:58:30 | disasters | 1 | 81242 | 3 | 1.216 | 66810.9 |
206 | 2022-04-05 17:53:58 | disasters | 1 | 81242 | 3 | 1.563 | 51978.2 |
205 | 2022-03-09 00:29:53 | disasters | 1 | 81242 | 3 | 1.500 | 54161.3 |
204 | 2022-03-06 22:26:50 | disasters | 1 | 81242 | 3 | 1.356 | 59913.0 |
203 | 2022-01-01 04:03:20 | disasters | 1 | 81242 | 3 | 1.313 | 61875.1 |
202 | 2021-12-18 15:08:47 | disasters | 1 | 81242 | 3 | 1.266 | 64172.2 |
201 | 2021-10-04 00:46:56 | disasters | 1 | 81242 | 3 | 1.360 | 59736.8 |
200 | 2021-09-26 00:50:46 | disasters | 1 | 81242 | 3 | 1.360 | 59736.8 |
199 | 2021-09-18 00:46:46 | disasters | 1 | 81242 | 3 | 1.393 | 58321.6 |
198 | 2021-09-14 15:40:46 | disasters | 1 | 81242 | 3 | 1.403 | 57905.9 |
197 | 2021-06-14 12:32:58 | disasters | 1 | 81242 | 3 | 1.236 | 65729.8 |
196 | 2021-06-13 16:06:33 | disasters | 1 | 81242 | 3 | 1.486 | 54671.6 |
195 | 2021-06-06 15:36:23 | disasters | 1 | 81242 | 3 | 1.423 | 57092.1 |
194 | 2021-05-12 19:22:58 | disasters | 1 | 81242 | 3 | 1.406 | 57782.4 |
193 | 2021-05-02 09:35:28 | disasters | 1 | 81242 | 3 | 1.313 | 61875.1 |
192 | 2021-03-29 07:01:44 | disasters | 1 | 81242 | 3 | 1.266 | 64172.2 |
191 | 2021-03-08 02:32:26 | disasters | 1 | 81242 | 3 | 1.233 | 65889.7 |
190 | 2021-02-26 01:11:10 | disasters | 1 | 81242 | 3 | 1.390 | 58447.5 |
189 | 2021-02-18 15:36:06 | disasters | 1 | 81242 | 3 | 1.483 | 54782.2 |
188 | 2020-12-04 12:01:12 | disasters | 1 | 81242 | 3 | 1.233 | 65889.7 |
187 | 2020-11-30 09:00:57 | disasters | 1 | 81242 | 3 | 1.453 | 55913.3 |
186 | 2020-11-13 15:38:50 | disasters | 1 | 81242 | 3 | 1.233 | 65889.7 |
185 | 2020-10-21 23:19:38 | disasters | 1 | 81242 | 3 | 1.283 | 63321.9 |
184 | 2020-10-13 20:38:42 | disasters | 1 | 81242 | 3 | 1.233 | 65889.7 |
183 | 2020-10-06 22:43:54 | disasters | 1 | 81242 | 3 | 1.233 | 65889.7 |
182 | 2020-08-29 17:41:38 | disasters | 1 | 81242 | 3 | 1.236 | 65729.8 |
181 | 2020-08-15 14:59:24 | disasters | 1 | 81242 | 3 | 1.233 | 65889.7 |
180 | 2020-05-22 01:52:06 | disasters | 1 | 81242 | 3 | 1.220 | 66591.8 |
179 | 2020-05-18 22:36:39 | disasters | 1 | 81242 | 3 | 1.250 | 64993.6 |
178 | 2020-05-18 20:38:59 | disasters | 1 | 81242 | 3 | 1.250 | 64993.6 |
177 | 2020-03-20 14:54:47 | disasters | 1 | 81242 | 3 | 1.423 | 57092.1 |
176 | 2020-03-01 17:01:47 | disasters | 1 | 81242 | 3 | 1.466 | 55417.5 |
175 | 2020-02-28 01:10:35 | disasters | 1 | 81242 | 3 | 1.626 | 49964.3 |
174 | 2020-02-19 06:38:12 | disasters | 1 | 81242 | 3 | 1.576 | 51549.5 |
173 | 2020-02-16 00:43:42 | disasters | 1 | 81242 | 3 | 1.313 | 61875.1 |
172 | 2020-02-14 22:09:34 | disasters | 1 | 81242 | 3 | 1.590 | 51095.6 |
171 | 2020-02-09 13:06:48 | disasters | 1 | 81242 | 3 | 2.750 | 29542.5 |
170 | 2020-02-06 14:26:36 | disasters | 1 | 81242 | 3 | 1.563 | 51978.2 |
169 | 2020-02-02 10:46:40 | disasters | 1 | 81242 | 3 | 2.390 | 33992.5 |
168 | 2020-02-02 10:38:35 | disasters | 1 | 81242 | 3 | 1.343 | 60492.9 |
167 | 2020-02-02 07:17:14 | disasters | 1 | 81242 | 3 | 4.720 | 17212.3 |
166 | 2020-01-22 19:29:52 | disasters | 1 | 81242 | 3 | 3.063 | 26523.7 |
165 | 2020-01-20 16:59:06 | disasters | 1 | 81242 | 3 | 4.750 | 17103.6 |
164 | 2020-01-15 23:05:59 | disasters | 1 | 81242 | 3 | 3.123 | 26014.1 |
163 | 2020-01-10 22:30:10 | disasters | 1 | 81242 | 3 | 1.356 | 59913.0 |
162 | 2020-01-09 00:21:35 | disasters | 1 | 81242 | 3 | 1.390 | 58447.5 |
161 | 2019-12-30 18:15:59 | disasters | 1 | 81242 | 3 | 1.313 | 61875.1 |
160 | 2019-12-30 12:34:24 | disasters | 1 | 81242 | 3 | 1.313 | 61875.1 |
159 | 2019-12-22 06:07:12 | disasters | 1 | 81242 | 3 | 1.423 | 57092.1 |
158 | 2019-11-16 06:00:17 | disasters | 1 | 81242 | 3 | 1.393 | 58321.6 |
157 | 2019-11-08 18:30:09 | disasters | 1 | 81242 | 3 | 1.423 | 57092.1 |
156 | 2019-08-14 19:36:42 | disasters | 1 | 81242 | 3 | 1.393 | 58321.6 |
155 | 2019-05-15 01:13:52 | disasters | 1 | 81242 | 3 | 1.333 | 60946.7 |
154 | 2019-02-05 16:15:25 | disasters | 1 | 81242 | 3 | 1.260 | 64477.8 |
153 | 2019-01-28 14:26:01 | disasters | 1 | 81242 | 3 | 1.246 | 65202.2 |
152 | 2019-01-09 16:00:59 | disasters | 1 | 81242 | 3 | 1.436 | 56575.2 |