History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"opuntias"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
232 | 2024-05-31 19:31:04 | opuntias | 4 | 161609 | 612 | 19.610 | 8241.2 |
231 | 2024-05-31 17:25:01 | opuntias | 4 | 161609 | 612 | 21.516 | 7511.1 |
230 | 2024-05-31 05:45:08 | opuntias | 4 | 161609 | 612 | 12.203 | 13243.4 |
229 | 2024-05-31 05:34:12 | opuntias | 3 | 146162 | 32 | 9.780 | 14945.0 |
228 | 2024-05-31 05:34:04 | opuntias | 4 | 161609 | 612 | 14.453 | 11181.7 |
227 | 2024-05-31 05:34:15 | opuntias | 1 | 82945 | 2 | 1.813 | 45750.1 |
226 | 2024-05-31 05:34:08 | opuntias | 2 | 121059 | 3 | 4.173 | 29010.1 |
225 | 2024-05-13 09:35:16 | opuntias | 1 | 82945 | 2 | 3.453 | 24021.1 |
224 | 2024-05-11 15:37:21 | opuntias | 1 | 82945 | 2 | 2.580 | 32149.2 |
223 | 2024-05-03 17:13:04 | opuntias | 3 | 146162 | 32 | 19.720 | 7411.9 |
222 | 2024-05-03 17:13:07 | opuntias | 2 | 121059 | 3 | 6.986 | 17328.8 |
221 | 2024-05-03 09:19:35 | opuntias | 1 | 82945 | 2 | 1.513 | 54821.5 |
220 | 2024-04-29 10:47:39 | opuntias | 4 | 161609 | 612 | 39.503 | 4091.1 |
219 | 2024-04-29 03:49:10 | opuntias | 1 | 82945 | 2 | 3.486 | 23793.7 |
218 | 2024-04-28 17:09:06 | opuntias | 4 | 161609 | 612 | 23.033 | 7016.4 |
217 | 2024-04-28 11:50:30 | opuntias | 4 | 161609 | 612 | 36.550 | 4421.6 |
216 | 2024-04-28 04:05:51 | opuntias | 4 | 161609 | 612 | 11.673 | 13844.7 |
215 | 2024-04-28 04:05:48 | opuntias | 1 | 82945 | 2 | 1.936 | 42843.5 |
214 | 2024-04-28 04:05:41 | opuntias | 3 | 146162 | 32 | 8.906 | 16411.6 |
213 | 2024-04-28 04:05:44 | opuntias | 1 | 82945 | 2 | 2.966 | 27965.3 |
212 | 2024-04-28 04:05:31 | opuntias | 4 | 161609 | 612 | 12.956 | 12473.7 |
211 | 2024-04-28 04:05:37 | opuntias | 2 | 121059 | 3 | 3.736 | 32403.4 |
210 | 2024-03-31 22:49:34 | opuntias | 3 | 146162 | 32 | 23.533 | 6210.9 |
209 | 2024-03-31 22:49:34 | opuntias | 2 | 121059 | 3 | 10.390 | 11651.5 |
208 | 2024-03-31 22:49:27 | opuntias | 1 | 82945 | 2 | 3.186 | 26034.2 |
207 | 2024-03-30 00:26:30 | opuntias | 1 | 82945 | 2 | 4.203 | 19734.7 |
206 | 2024-03-14 10:22:14 | opuntias | 1 | 82945 | 2 | 2.780 | 29836.3 |
205 | 2024-03-14 10:21:57 | opuntias | 3 | 146162 | 32 | 7.920 | 18454.8 |
204 | 2024-03-13 16:16:12 | opuntias | 4 | 161609 | 612 | 14.373 | 11243.9 |
203 | 2024-03-12 17:11:19 | opuntias | 4 | 161609 | 612 | 13.516 | 11956.9 |
202 | 2024-03-12 08:45:23 | opuntias | 2 | 121059 | 3 | 3.420 | 35397.4 |
201 | 2024-03-12 02:44:52 | opuntias | 3 | 146162 | 32 | 15.313 | 9545.0 |
200 | 2024-03-11 08:41:25 | opuntias | 4 | 161609 | 612 | 26.783 | 6034.0 |
199 | 2024-03-11 01:15:20 | opuntias | 4 | 161609 | 612 | 40.626 | 3978.0 |
198 | 2024-03-11 01:15:23 | opuntias | 3 | 146162 | 32 | 26.253 | 5567.4 |
197 | 2024-03-11 01:15:22 | opuntias | 2 | 121059 | 3 | 4.296 | 28179.5 |
196 | 2024-03-11 01:15:15 | opuntias | 1 | 82945 | 2 | 3.376 | 24569.0 |
195 | 2024-02-29 13:15:55 | opuntias | 1 | 82945 | 2 | 1.500 | 55296.7 |
194 | 2024-02-29 13:09:55 | opuntias | 1 | 82945 | 2 | 1.500 | 55296.7 |
193 | 2024-02-28 16:37:05 | opuntias | 2 | 121059 | 3 | 10.266 | 11792.2 |
192 | 2024-02-28 16:37:02 | opuntias | 3 | 146162 | 32 | 8.580 | 17035.2 |
191 | 2024-02-28 13:55:20 | opuntias | 1 | 82945 | 2 | 1.406 | 58993.6 |
190 | 2024-02-27 16:01:03 | opuntias | 2 | 121059 | 3 | 3.280 | 36908.2 |
189 | 2024-02-27 16:00:53 | opuntias | 3 | 146162 | 32 | 7.080 | 20644.4 |
188 | 2024-02-26 19:57:32 | opuntias | 3 | 146162 | 32 | 7.360 | 19859.0 |
187 | 2024-02-26 19:57:33 | opuntias | 2 | 121059 | 3 | 3.876 | 31233.0 |
186 | 2024-02-14 22:38:27 | opuntias | 2 | 121059 | 3 | 9.123 | 13269.6 |
185 | 2024-02-12 15:51:05 | opuntias | 3 | 146162 | 32 | 26.596 | 5495.6 |
184 | 2024-02-09 20:25:17 | opuntias | 3 | 146162 | 32 | 7.673 | 19048.9 |
183 | 2024-02-09 20:25:19 | opuntias | 2 | 121059 | 3 | 4.000 | 30264.8 |
182 | 2024-02-09 20:25:01 | opuntias | 1 | 82945 | 2 | 1.596 | 51970.6 |
181 | 2024-02-09 17:40:25 | opuntias | 1 | 82945 | 2 | 1.533 | 54106.3 |
180 | 2024-02-02 05:48:00 | opuntias | 4 | 161609 | 612 | 12.186 | 13261.9 |
179 | 2024-02-01 02:06:36 | opuntias | 4 | 161609 | 612 | 12.140 | 13312.1 |
178 | 2024-02-01 01:17:35 | opuntias | 4 | 161609 | 612 | 11.203 | 14425.5 |
177 | 2024-02-01 01:17:31 | opuntias | 1 | 82945 | 2 | 1.390 | 59672.7 |
176 | 2024-01-09 00:50:20 | opuntias | 4 | 161609 | 612 | 15.126 | 10684.2 |
175 | 2024-01-02 13:49:38 | opuntias | 4 | 161609 | 612 | 11.843 | 13646.0 |
174 | 2024-01-02 13:49:41 | opuntias | 3 | 146162 | 32 | 7.296 | 20033.2 |
173 | 2024-01-02 13:49:40 | opuntias | 2 | 121059 | 3 | 3.813 | 31749.0 |
172 | 2023-12-07 22:10:48 | opuntias | 1 | 82945 | 2 | 1.406 | 58993.6 |
171 | 2023-11-18 21:05:43 | opuntias | 1 | 82945 | 2 | 1.406 | 58993.6 |
170 | 2023-11-13 22:39:56 | opuntias | 1 | 82945 | 2 | 1.406 | 58993.6 |
169 | 2022-12-21 12:04:42 | opuntias | 1 | 82945 | 2 | 1.423 | 58288.8 |
168 | 2022-11-16 22:32:01 | opuntias | 1 | 82945 | 2 | 1.466 | 56579.1 |
167 | 2021-07-16 23:22:48 | opuntias | 1 | 82945 | 2 | 1.343 | 61761.0 |
166 | 2021-06-25 01:03:55 | opuntias | 1 | 82945 | 2 | 1.296 | 64000.8 |
165 | 2021-06-21 05:09:32 | opuntias | 1 | 82945 | 2 | 1.356 | 61168.9 |
164 | 2021-06-01 23:43:33 | opuntias | 4 | 161609 | 612 | 10.283 | 15716.1 |
163 | 2021-05-05 16:43:38 | opuntias | 2 | 121059 | 3 | 3.560 | 34005.3 |
162 | 2021-04-10 22:15:45 | opuntias | 3 | 146162 | 32 | 8.956 | 16320.0 |
161 | 2021-03-14 22:07:36 | opuntias | 3 | 146162 | 32 | 6.110 | 23921.8 |
160 | 2021-03-08 17:59:09 | opuntias | 1 | 82945 | 2 | 1.283 | 64649.3 |
159 | 2021-02-12 04:31:04 | opuntias | 2 | 121059 | 3 | 3.140 | 38553.8 |
158 | 2021-01-30 20:13:50 | opuntias | 4 | 161609 | 612 | 10.673 | 15141.9 |
157 | 2021-01-23 11:04:50 | opuntias | 4 | 161609 | 612 | 17.970 | 8993.3 |
156 | 2021-01-19 17:46:21 | opuntias | 1 | 82945 | 2 | 1.283 | 64649.3 |
155 | 2020-12-24 18:31:53 | opuntias | 4 | 161609 | 612 | 10.876 | 14859.2 |
154 | 2020-11-24 19:25:54 | opuntias | 1 | 82945 | 2 | 1.250 | 66356.0 |
153 | 2020-11-05 12:25:16 | opuntias | 3 | 146162 | 32 | 7.313 | 19986.6 |
152 | 2020-11-01 22:08:33 | opuntias | 3 | 146162 | 32 | 7.516 | 19446.8 |
151 | 2020-10-31 20:33:08 | opuntias | 1 | 82945 | 2 | 1.423 | 58288.8 |
150 | 2020-10-28 20:59:52 | opuntias | 1 | 82945 | 2 | 1.406 | 58993.6 |
149 | 2020-10-28 09:54:45 | opuntias | 4 | 161609 | 612 | 12.410 | 13022.5 |
148 | 2020-10-24 19:11:22 | opuntias | 4 | 161609 | 612 | 10.830 | 14922.3 |
147 | 2020-10-17 09:28:04 | opuntias | 1 | 82945 | 2 | 1.406 | 58993.6 |
146 | 2020-10-05 02:09:33 | opuntias | 1 | 82945 | 2 | 1.453 | 57085.3 |
145 | 2020-09-03 11:21:39 | opuntias | 1 | 82945 | 2 | 1.780 | 46598.3 |
144 | 2020-08-30 02:42:49 | opuntias | 1 | 82945 | 2 | 1.296 | 64000.8 |
143 | 2020-03-23 00:51:16 | opuntias | 1 | 82945 | 2 | 1.440 | 57600.7 |
142 | 2020-03-14 06:12:09 | opuntias | 1 | 82945 | 2 | 1.330 | 62364.7 |
141 | 2020-03-01 09:44:48 | opuntias | 1 | 82945 | 2 | 1.500 | 55296.7 |
140 | 2020-03-01 06:27:11 | opuntias | 1 | 82945 | 2 | 1.546 | 53651.4 |
139 | 2020-02-11 04:17:56 | opuntias | 4 | 161609 | 612 | 12.563 | 12863.9 |
138 | 2020-02-08 09:52:43 | opuntias | 1 | 82945 | 2 | 2.313 | 35860.4 |
137 | 2020-02-07 01:52:36 | opuntias | 4 | 161609 | 612 | 18.126 | 8915.9 |
136 | 2020-02-06 23:36:56 | opuntias | 4 | 161609 | 612 | 42.610 | 3792.7 |
135 | 2020-02-06 21:34:27 | opuntias | 4 | 161609 | 612 | 14.966 | 10798.4 |
134 | 2020-02-06 18:19:05 | opuntias | 4 | 161609 | 612 | 13.406 | 12055.0 |
133 | 2020-02-04 16:59:48 | opuntias | 4 | 161609 | 612 | 39.533 | 4088.0 |