History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sporran"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
224 | 2024-04-07 23:36:40 | sporran | 1 | 69583 | 2 | 4.546 | 15306.4 |
223 | 2024-04-05 09:43:46 | sporran | 1 | 69583 | 2 | 1.376 | 50569.0 |
222 | 2024-03-05 20:57:51 | sporran | 1 | 69583 | 2 | 4.220 | 16488.9 |
221 | 2024-02-27 09:04:48 | sporran | 1 | 69583 | 2 | 2.640 | 26357.2 |
220 | 2024-02-18 04:20:10 | sporran | 1 | 69583 | 2 | 2.766 | 25156.5 |
219 | 2023-12-31 12:52:01 | sporran | 1 | 69583 | 2 | 1.076 | 64668.2 |
218 | 2023-12-24 18:59:08 | sporran | 1 | 69583 | 2 | 1.233 | 56433.9 |
217 | 2023-11-27 00:26:52 | sporran | 1 | 69583 | 2 | 1.110 | 62687.4 |
216 | 2023-11-19 07:43:40 | sporran | 1 | 69583 | 2 | 1.063 | 65459.1 |
215 | 2023-10-17 10:22:47 | sporran | 1 | 69583 | 2 | 2.126 | 32729.5 |
214 | 2023-10-12 12:01:00 | sporran | 1 | 69583 | 2 | 1.076 | 64668.2 |
213 | 2023-09-12 06:28:38 | sporran | 1 | 69583 | 2 | 1.233 | 56433.9 |
212 | 2023-08-08 17:43:27 | sporran | 1 | 69583 | 2 | 1.140 | 61037.7 |
211 | 2022-08-25 06:19:59 | sporran | 1 | 69583 | 2 | 1.360 | 51164.0 |
210 | 2021-06-04 21:03:37 | sporran | 1 | 69583 | 2 | 1.233 | 56433.9 |
209 | 2021-05-10 15:24:23 | sporran | 1 | 69583 | 2 | 1.263 | 55093.4 |
208 | 2021-02-16 20:58:57 | sporran | 1 | 69583 | 2 | 1.093 | 63662.4 |
207 | 2020-11-08 20:31:51 | sporran | 1 | 69583 | 2 | 1.106 | 62914.1 |
206 | 2020-10-26 22:44:57 | sporran | 1 | 69583 | 2 | 1.296 | 53690.6 |
205 | 2020-10-21 18:18:51 | sporran | 1 | 69583 | 2 | 1.250 | 55666.4 |
204 | 2020-08-30 07:50:28 | sporran | 1 | 69583 | 2 | 1.186 | 58670.3 |
203 | 2020-08-06 03:23:01 | sporran | 1 | 69583 | 2 | 1.093 | 63662.4 |
202 | 2020-03-29 07:06:39 | sporran | 1 | 69583 | 2 | 1.313 | 52995.4 |
201 | 2020-03-25 09:22:42 | sporran | 1 | 69583 | 2 | 1.190 | 58473.1 |
200 | 2020-03-24 12:32:06 | sporran | 1 | 69583 | 2 | 1.893 | 36758.1 |
199 | 2020-03-23 13:49:13 | sporran | 1 | 69583 | 2 | 1.406 | 49490.0 |
198 | 2020-03-20 21:13:43 | sporran | 1 | 69583 | 2 | 1.220 | 57035.2 |
197 | 2020-03-20 18:40:56 | sporran | 1 | 69583 | 2 | 1.126 | 61796.6 |
196 | 2020-02-24 15:07:40 | sporran | 1 | 69583 | 2 | 1.326 | 52475.9 |
195 | 2020-02-11 06:13:30 | sporran | 1 | 69583 | 2 | 1.263 | 55093.4 |
194 | 2020-02-08 07:34:20 | sporran | 1 | 69583 | 2 | 2.703 | 25742.9 |
193 | 2020-02-06 19:12:45 | sporran | 1 | 69583 | 2 | 2.876 | 24194.4 |
192 | 2020-02-05 14:51:41 | sporran | 1 | 69583 | 2 | 2.530 | 27503.2 |
191 | 2020-02-02 21:40:42 | sporran | 1 | 69583 | 2 | 1.326 | 52475.9 |
190 | 2020-01-27 08:44:49 | sporran | 1 | 69583 | 2 | 2.423 | 28717.7 |
189 | 2020-01-18 01:57:02 | sporran | 2 | 107671 | 7 | 11.846 | 9089.2 |
188 | 2020-01-18 00:42:54 | sporran | 2 | 107671 | 7 | 5.940 | 18126.4 |
187 | 2020-01-17 07:34:52 | sporran | 1 | 69583 | 2 | 4.190 | 16606.9 |
186 | 2020-01-15 04:42:11 | sporran | 1 | 69583 | 2 | 2.750 | 25302.9 |
185 | 2020-01-13 04:15:15 | sporran | 1 | 69583 | 2 | 1.330 | 52318.0 |
184 | 2020-01-08 15:42:47 | sporran | 1 | 69583 | 2 | 1.253 | 55533.1 |
183 | 2020-01-01 17:36:31 | sporran | 1 | 69583 | 2 | 1.310 | 53116.8 |
182 | 2019-12-27 18:17:31 | sporran | 2 | 107671 | 7 | 3.330 | 32333.6 |
181 | 2019-12-27 16:05:05 | sporran | 1 | 69583 | 2 | 1.140 | 61037.7 |
180 | 2019-12-27 04:10:01 | sporran | 1 | 69583 | 2 | 1.783 | 39025.8 |
179 | 2019-12-24 14:18:27 | sporran | 1 | 69583 | 2 | 1.233 | 56433.9 |
178 | 2019-12-12 08:33:25 | sporran | 1 | 69583 | 2 | 1.203 | 57841.2 |
177 | 2019-09-10 15:22:39 | sporran | 1 | 69583 | 2 | 1.176 | 59169.2 |
176 | 2019-06-04 19:14:49 | sporran | 1 | 69583 | 2 | 1.063 | 65459.1 |
175 | 2019-06-02 15:38:50 | sporran | 1 | 69583 | 2 | 1.193 | 58326.1 |
174 | 2019-05-30 05:46:30 | sporran | 1 | 69583 | 2 | 1.216 | 57222.9 |
173 | 2019-04-05 17:35:02 | sporran | 1 | 69583 | 2 | 1.113 | 62518.4 |
172 | 2019-02-17 05:48:40 | sporran | 1 | 69583 | 2 | 1.206 | 57697.3 |
171 | 2019-02-15 17:34:06 | sporran | 1 | 69583 | 2 | 1.180 | 58968.6 |
170 | 2019-01-14 08:16:31 | sporran | 1 | 69583 | 2 | 1.296 | 53690.6 |
169 | 2018-10-25 17:12:41 | sporran | 1 | 69583 | 2 | 1.133 | 61414.8 |
168 | 2018-10-17 05:33:16 | sporran | 1 | 69583 | 2 | 1.150 | 60507.0 |
167 | 2018-09-16 04:50:36 | sporran | 1 | 69583 | 2 | 1.203 | 57841.2 |
166 | 2018-09-12 14:23:47 | sporran | 1 | 69583 | 2 | 1.213 | 57364.4 |
165 | 2018-08-28 04:12:08 | sporran | 1 | 69583 | 2 | 1.073 | 64849.0 |
164 | 2018-08-26 09:41:52 | sporran | 1 | 69583 | 2 | 1.273 | 54660.6 |
163 | 2018-08-24 14:27:39 | sporran | 1 | 69583 | 2 | 1.210 | 57506.6 |
162 | 2018-08-22 17:37:33 | sporran | 1 | 69583 | 2 | 1.116 | 62350.4 |
161 | 2018-08-15 21:01:34 | sporran | 1 | 69583 | 2 | 1.216 | 57222.9 |
160 | 2018-08-14 03:04:48 | sporran | 1 | 69583 | 2 | 1.200 | 57985.8 |
159 | 2018-08-14 03:04:34 | sporran | 1 | 69583 | 2 | 1.250 | 55666.4 |
158 | 2018-08-14 02:51:11 | sporran | 1 | 69583 | 2 | 1.253 | 55533.1 |
157 | 2018-08-09 01:19:47 | sporran | 1 | 69583 | 2 | 1.253 | 55533.1 |
156 | 2018-08-03 20:52:58 | sporran | 1 | 69583 | 2 | 1.076 | 64668.2 |
155 | 2018-08-01 15:04:09 | sporran | 1 | 69583 | 2 | 1.186 | 58670.3 |
154 | 2018-07-30 17:03:55 | sporran | 1 | 69583 | 2 | 1.093 | 63662.4 |
153 | 2018-07-30 06:14:47 | sporran | 1 | 69583 | 2 | 1.360 | 51164.0 |
152 | 2018-07-28 01:11:38 | sporran | 1 | 69583 | 2 | 1.180 | 58968.6 |
151 | 2018-07-26 01:30:56 | sporran | 1 | 69583 | 2 | 1.076 | 64668.2 |
150 | 2018-07-25 18:58:17 | sporran | 1 | 69583 | 2 | 1.096 | 63488.1 |
149 | 2018-07-20 11:32:07 | sporran | 1 | 69583 | 2 | 1.093 | 63662.4 |
148 | 2018-07-20 11:07:29 | sporran | 1 | 69583 | 2 | 1.283 | 54234.6 |
147 | 2018-07-18 10:34:21 | sporran | 1 | 69583 | 2 | 1.093 | 63662.4 |
146 | 2018-07-13 20:51:48 | sporran | 1 | 69583 | 2 | 1.156 | 60192.9 |
145 | 2018-07-04 10:04:17 | sporran | 1 | 69583 | 2 | 1.073 | 64849.0 |
144 | 2018-06-27 23:03:12 | sporran | 1 | 69583 | 2 | 2.746 | 25339.8 |
143 | 2018-06-26 01:55:26 | sporran | 1 | 69583 | 2 | 1.203 | 57841.2 |
142 | 2018-06-25 23:32:39 | sporran | 1 | 69583 | 2 | 1.066 | 65274.9 |
141 | 2018-06-25 22:02:22 | sporran | 1 | 69583 | 2 | 1.250 | 55666.4 |
140 | 2018-06-11 04:45:19 | sporran | 1 | 69583 | 2 | 1.056 | 65893.0 |
139 | 2018-05-31 06:13:51 | sporran | 1 | 69583 | 2 | 1.096 | 63488.1 |
138 | 2018-05-31 06:13:31 | sporran | 1 | 69583 | 2 | 1.086 | 64072.7 |
137 | 2018-05-10 00:44:32 | sporran | 1 | 69583 | 2 | 1.120 | 62127.7 |
136 | 2018-05-06 03:18:17 | sporran | 1 | 69583 | 2 | 1.116 | 62350.4 |
135 | 2018-03-24 11:59:52 | sporran | 1 | 69583 | 2 | 1.976 | 35214.1 |
134 | 2018-02-18 09:45:09 | sporran | 1 | 69583 | 2 | 1.646 | 42274.0 |
133 | 2018-02-18 09:42:19 | sporran | 1 | 69583 | 2 | 1.653 | 42095.0 |
132 | 2018-02-18 00:03:08 | sporran | 1 | 69583 | 2 | 2.696 | 25809.7 |
131 | 2018-02-15 14:17:43 | sporran | 1 | 69583 | 2 | 2.043 | 34059.2 |
130 | 2018-02-14 06:04:30 | sporran | 1 | 69583 | 2 | 2.000 | 34791.5 |
129 | 2017-12-14 08:09:24 | sporran | 1 | 69583 | 2 | 1.596 | 43598.4 |
128 | 2017-12-06 19:02:53 | sporran | 1 | 69583 | 2 | 2.673 | 26031.8 |
127 | 2017-12-01 05:48:48 | sporran | 1 | 69583 | 2 | 1.450 | 47988.3 |
126 | 2017-11-16 12:38:38 | sporran | 2 | 107671 | 7 | 4.746 | 22686.7 |
125 | 2017-11-16 12:33:37 | sporran | 1 | 69583 | 2 | 1.733 | 40151.8 |