History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gypsied"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
295 | 2024-04-27 06:48:05 | gypsied | 1 | 69583 | 3 | 2.453 | 28366.5 |
294 | 2024-04-20 17:41:11 | gypsied | 4 | 151207 | 1540 | 40.813 | 3704.9 |
293 | 2024-04-13 04:09:01 | gypsied | 2 | 107671 | 7 | 3.156 | 34116.3 |
292 | 2024-04-13 04:01:29 | gypsied | 3 | 134027 | 97 | 6.813 | 19672.2 |
291 | 2024-04-12 22:51:00 | gypsied | 3 | 134027 | 97 | 10.750 | 12467.6 |
290 | 2024-04-12 22:50:36 | gypsied | 4 | 151207 | 1540 | 14.236 | 10621.5 |
289 | 2024-04-10 20:40:59 | gypsied | 4 | 151207 | 1540 | 18.596 | 8131.2 |
288 | 2024-04-10 20:40:44 | gypsied | 3 | 134027 | 97 | 22.656 | 5915.7 |
287 | 2024-04-09 19:50:10 | gypsied | 3 | 134027 | 97 | 7.546 | 17761.3 |
286 | 2024-04-09 19:16:48 | gypsied | 4 | 151207 | 1540 | 24.890 | 6075.0 |
285 | 2024-04-09 17:56:45 | gypsied | 4 | 151207 | 1540 | 17.300 | 8740.3 |
284 | 2024-04-09 05:13:52 | gypsied | 3 | 134027 | 97 | 9.953 | 13466.0 |
283 | 2024-04-09 05:13:53 | gypsied | 2 | 107671 | 7 | 5.156 | 20882.7 |
282 | 2024-04-09 05:13:44 | gypsied | 1 | 69583 | 3 | 1.860 | 37410.2 |
281 | 2024-04-09 03:36:58 | gypsied | 4 | 151207 | 1540 | 39.456 | 3832.3 |
280 | 2024-04-09 03:17:32 | gypsied | 4 | 151207 | 1540 | 29.173 | 5183.1 |
279 | 2024-04-09 03:17:40 | gypsied | 3 | 134027 | 97 | 10.170 | 13178.7 |
278 | 2024-04-09 03:17:44 | gypsied | 1 | 69583 | 3 | 5.216 | 13340.3 |
277 | 2024-04-09 03:17:34 | gypsied | 2 | 107671 | 7 | 3.733 | 28843.0 |
276 | 2024-04-09 03:17:25 | gypsied | 1 | 69583 | 3 | 1.263 | 55093.4 |
275 | 2024-04-05 17:39:11 | gypsied | 1 | 69583 | 3 | 3.656 | 19032.5 |
274 | 2024-03-10 19:07:46 | gypsied | 1 | 69583 | 3 | 3.906 | 17814.4 |
273 | 2024-03-09 00:14:24 | gypsied | 3 | 134027 | 97 | 20.860 | 6425.1 |
272 | 2024-03-09 00:13:48 | gypsied | 2 | 107671 | 7 | 3.576 | 30109.3 |
271 | 2024-03-08 23:58:26 | gypsied | 3 | 134027 | 97 | 20.733 | 6464.4 |
270 | 2024-03-08 21:57:53 | gypsied | 1 | 69583 | 3 | 2.530 | 27503.2 |
269 | 2024-03-06 15:24:44 | gypsied | 3 | 134027 | 97 | 9.736 | 13766.1 |
268 | 2024-03-04 21:53:46 | gypsied | 4 | 151207 | 1540 | 19.830 | 7625.2 |
267 | 2024-03-04 18:39:49 | gypsied | 4 | 151207 | 1540 | 24.610 | 6144.1 |
266 | 2024-03-04 18:28:39 | gypsied | 3 | 134027 | 97 | 17.626 | 7603.9 |
265 | 2024-03-04 18:24:13 | gypsied | 4 | 151207 | 1540 | 29.686 | 5093.5 |
264 | 2024-03-04 14:44:29 | gypsied | 4 | 151207 | 1540 | 26.250 | 5760.3 |
263 | 2024-03-04 14:44:29 | gypsied | 3 | 134027 | 97 | 18.953 | 7071.5 |
262 | 2024-03-04 14:44:29 | gypsied | 2 | 107671 | 7 | 5.766 | 18673.4 |
261 | 2024-03-04 14:27:05 | gypsied | 1 | 69583 | 3 | 1.143 | 60877.5 |
260 | 2024-02-29 06:48:00 | gypsied | 1 | 69583 | 3 | 1.123 | 61961.7 |
259 | 2024-02-29 06:47:49 | gypsied | 2 | 107671 | 7 | 3.220 | 33438.2 |
258 | 2024-02-24 15:27:38 | gypsied | 2 | 107671 | 7 | 2.610 | 41253.3 |
257 | 2024-02-07 21:40:05 | gypsied | 1 | 69583 | 3 | 1.043 | 66714.3 |
256 | 2024-02-07 06:21:15 | gypsied | 2 | 107671 | 7 | 3.216 | 33479.8 |
255 | 2024-02-07 06:21:03 | gypsied | 3 | 134027 | 97 | 7.140 | 18771.3 |
254 | 2024-02-05 07:44:06 | gypsied | 3 | 134027 | 97 | 14.423 | 9292.6 |
253 | 2024-02-04 21:23:21 | gypsied | 4 | 151207 | 1540 | 20.703 | 7303.6 |
252 | 2024-02-04 05:18:02 | gypsied | 2 | 107671 | 7 | 3.013 | 35735.5 |
251 | 2024-02-04 05:17:54 | gypsied | 3 | 134027 | 97 | 5.343 | 25084.6 |
250 | 2024-02-03 03:30:06 | gypsied | 4 | 151207 | 1540 | 15.313 | 9874.4 |
249 | 2024-02-03 01:41:50 | gypsied | 4 | 151207 | 1540 | 10.656 | 14189.8 |
248 | 2024-02-03 01:16:42 | gypsied | 3 | 134027 | 97 | 12.280 | 10914.3 |
247 | 2024-02-03 01:16:38 | gypsied | 4 | 151207 | 1540 | 11.766 | 12851.2 |
246 | 2024-02-03 01:16:34 | gypsied | 1 | 69583 | 3 | 2.406 | 28920.6 |
245 | 2024-02-03 01:16:30 | gypsied | 2 | 107671 | 7 | 3.283 | 32796.5 |
244 | 2024-01-19 12:19:52 | gypsied | 1 | 69583 | 3 | 1.140 | 61037.7 |
243 | 2024-01-14 05:20:44 | gypsied | 1 | 69583 | 3 | 1.033 | 67360.1 |
242 | 2024-01-08 18:26:17 | gypsied | 1 | 69583 | 3 | 2.063 | 33729.0 |
241 | 2024-01-03 03:55:09 | gypsied | 1 | 69583 | 3 | 2.516 | 27656.2 |
240 | 2023-11-22 01:09:41 | gypsied | 2 | 107671 | 7 | 2.796 | 38508.9 |
239 | 2023-11-08 21:52:31 | gypsied | 1 | 69583 | 3 | 1.046 | 66522.9 |
238 | 2023-09-29 18:29:49 | gypsied | 1 | 69583 | 3 | 1.110 | 62687.4 |
237 | 2023-09-29 13:49:14 | gypsied | 1 | 69583 | 3 | 1.173 | 59320.5 |
236 | 2023-09-02 06:59:27 | gypsied | 1 | 69583 | 3 | 1.720 | 40455.2 |
235 | 2023-08-29 20:37:28 | gypsied | 1 | 69583 | 3 | 1.016 | 68487.2 |
234 | 2023-08-22 23:12:35 | gypsied | 2 | 107671 | 7 | 2.640 | 40784.5 |
233 | 2023-06-02 05:14:50 | gypsied | 1 | 69583 | 3 | 1.000 | 69583.0 |
232 | 2023-05-08 05:50:32 | gypsied | 2 | 107671 | 7 | 2.610 | 41253.3 |
231 | 2023-04-24 13:57:07 | gypsied | 1 | 69583 | 3 | 1.016 | 68487.2 |
230 | 2023-03-26 12:10:53 | gypsied | 1 | 69583 | 3 | 1.043 | 66714.3 |
229 | 2023-02-16 00:40:40 | gypsied | 2 | 107671 | 7 | 2.576 | 41797.7 |
228 | 2023-01-10 03:17:25 | gypsied | 1 | 69583 | 3 | 1.013 | 68690.0 |
227 | 2022-12-20 22:35:24 | gypsied | 1 | 69583 | 3 | 1.203 | 57841.2 |
226 | 2022-11-25 18:07:19 | gypsied | 2 | 107671 | 7 | 2.936 | 36672.7 |
225 | 2022-10-12 05:07:08 | gypsied | 1 | 69583 | 3 | 1.030 | 67556.3 |
224 | 2022-07-24 22:06:45 | gypsied | 1 | 69583 | 3 | 1.016 | 68487.2 |
223 | 2022-06-19 02:54:25 | gypsied | 1 | 69583 | 3 | 1.190 | 58473.1 |
222 | 2022-05-28 10:32:58 | gypsied | 1 | 69583 | 3 | 1.000 | 69583.0 |
221 | 2022-04-15 21:15:35 | gypsied | 2 | 107671 | 7 | 2.576 | 41797.7 |
220 | 2022-03-13 07:23:10 | gypsied | 1 | 69583 | 3 | 1.016 | 68487.2 |
219 | 2022-03-09 21:31:08 | gypsied | 1 | 69583 | 3 | 1.330 | 52318.0 |
218 | 2022-02-11 19:23:48 | gypsied | 1 | 69583 | 3 | 1.013 | 68690.0 |
217 | 2022-01-03 02:14:50 | gypsied | 2 | 107671 | 7 | 2.686 | 40086.0 |
216 | 2021-12-05 11:33:23 | gypsied | 1 | 69583 | 3 | 1.046 | 66522.9 |
215 | 2021-11-02 17:50:09 | gypsied | 1 | 69583 | 3 | 1.016 | 68487.2 |
214 | 2021-11-02 07:19:43 | gypsied | 1 | 69583 | 3 | 1.046 | 66522.9 |
213 | 2021-07-16 13:55:27 | gypsied | 1 | 69583 | 3 | 1.126 | 61796.6 |
212 | 2021-04-17 12:04:47 | gypsied | 1 | 69583 | 3 | 1.220 | 57035.2 |
211 | 2021-04-07 05:17:17 | gypsied | 1 | 69583 | 3 | 2.220 | 31343.7 |
210 | 2021-01-22 08:46:11 | gypsied | 1 | 69583 | 3 | 1.063 | 65459.1 |
209 | 2021-01-03 23:16:53 | gypsied | 1 | 69583 | 3 | 1.140 | 61037.7 |
208 | 2020-10-21 00:51:19 | gypsied | 1 | 69583 | 3 | 1.123 | 61961.7 |
207 | 2020-10-08 17:55:40 | gypsied | 1 | 69583 | 3 | 1.033 | 67360.1 |
206 | 2020-10-07 20:45:16 | gypsied | 1 | 69583 | 3 | 1.016 | 68487.2 |
205 | 2020-10-02 07:04:40 | gypsied | 1 | 69583 | 3 | 1.046 | 66522.9 |
204 | 2020-08-31 11:09:03 | gypsied | 1 | 69583 | 3 | 1.140 | 61037.7 |
203 | 2020-08-27 11:52:26 | gypsied | 1 | 69583 | 3 | 1.173 | 59320.5 |
202 | 2020-06-15 15:42:32 | gypsied | 1 | 69583 | 3 | 1.033 | 67360.1 |
201 | 2020-03-29 13:55:51 | gypsied | 1 | 69583 | 3 | 1.190 | 58473.1 |
200 | 2020-03-29 01:33:13 | gypsied | 1 | 69583 | 3 | 1.126 | 61796.6 |
199 | 2020-03-27 17:59:02 | gypsied | 1 | 69583 | 3 | 1.110 | 62687.4 |
198 | 2020-03-21 21:54:19 | gypsied | 1 | 69583 | 3 | 1.030 | 67556.3 |
197 | 2020-02-27 07:18:02 | gypsied | 1 | 69583 | 3 | 2.466 | 28217.0 |
196 | 2020-02-27 00:31:26 | gypsied | 1 | 69583 | 3 | 1.126 | 61796.6 |