History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"scootches"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
224 | 2024-04-27 22:25:57 | scootches | 1 | 81242 | 5 | 1.873 | 43375.3 |
223 | 2024-04-10 16:06:09 | scootches | 3 | 148641 | 111 | 23.690 | 6274.4 |
222 | 2024-04-10 16:06:06 | scootches | 2 | 121436 | 21 | 10.656 | 11396.0 |
221 | 2024-04-10 16:04:20 | scootches | 1 | 81242 | 5 | 3.346 | 24280.3 |
220 | 2024-04-06 11:14:24 | scootches | 1 | 81242 | 5 | 1.843 | 44081.4 |
219 | 2024-04-05 19:54:00 | scootches | 1 | 81242 | 5 | 1.580 | 51419.0 |
218 | 2024-04-05 03:11:09 | scootches | 3 | 148641 | 111 | 14.030 | 10594.5 |
217 | 2024-04-05 03:11:09 | scootches | 2 | 121436 | 21 | 9.190 | 13213.9 |
216 | 2024-04-05 03:10:55 | scootches | 1 | 81242 | 5 | 1.626 | 49964.3 |
215 | 2024-03-30 05:39:31 | scootches | 1 | 81242 | 5 | 1.550 | 52414.2 |
214 | 2024-03-07 03:00:05 | scootches | 2 | 121436 | 21 | 6.690 | 18151.9 |
213 | 2024-03-06 16:49:43 | scootches | 1 | 81242 | 5 | 1.360 | 59736.8 |
212 | 2024-03-04 07:09:59 | scootches | 2 | 121436 | 21 | 10.360 | 11721.6 |
211 | 2024-03-04 07:01:49 | scootches | 1 | 81242 | 5 | 1.546 | 52549.8 |
210 | 2024-03-01 17:57:30 | scootches | 1 | 81242 | 5 | 1.686 | 48186.2 |
209 | 2024-03-01 08:47:10 | scootches | 1 | 81242 | 5 | 1.390 | 58447.5 |
208 | 2024-02-22 03:44:41 | scootches | 3 | 148641 | 111 | 16.890 | 8800.5 |
207 | 2024-02-21 18:05:17 | scootches | 3 | 148641 | 111 | 17.423 | 8531.3 |
206 | 2024-02-19 14:08:35 | scootches | 3 | 148641 | 111 | 8.736 | 17014.8 |
205 | 2024-02-19 04:30:50 | scootches | 3 | 148641 | 111 | 17.063 | 8711.3 |
204 | 2024-02-02 14:38:24 | scootches | 2 | 121436 | 21 | 3.423 | 35476.5 |
203 | 2024-02-02 14:37:32 | scootches | 1 | 81242 | 5 | 1.360 | 59736.8 |
202 | 2024-01-30 05:34:18 | scootches | 1 | 81242 | 5 | 1.330 | 61084.2 |
201 | 2024-01-22 12:51:53 | scootches | 1 | 81242 | 5 | 1.250 | 64993.6 |
200 | 2024-01-11 08:54:02 | scootches | 3 | 148641 | 111 | 14.360 | 10351.0 |
199 | 2024-01-01 12:23:14 | scootches | 1 | 81242 | 5 | 1.406 | 57782.4 |
198 | 2023-12-18 12:39:00 | scootches | 1 | 81242 | 5 | 1.233 | 65889.7 |
197 | 2023-12-15 05:44:00 | scootches | 1 | 81242 | 5 | 1.406 | 57782.4 |
196 | 2023-11-25 16:53:16 | scootches | 2 | 121436 | 21 | 3.203 | 37913.2 |
195 | 2023-11-18 09:44:03 | scootches | 2 | 121436 | 21 | 3.080 | 39427.3 |
194 | 2023-11-18 09:43:56 | scootches | 3 | 148641 | 111 | 6.796 | 21871.8 |
193 | 2023-11-17 17:28:46 | scootches | 1 | 81242 | 5 | 1.513 | 53696.0 |
192 | 2023-11-16 07:50:22 | scootches | 3 | 148641 | 111 | 6.500 | 22867.8 |
191 | 2023-11-15 22:45:05 | scootches | 1 | 81242 | 5 | 1.406 | 57782.4 |
190 | 2023-11-08 18:26:59 | scootches | 1 | 81242 | 5 | 1.250 | 64993.6 |
189 | 2023-10-25 15:20:07 | scootches | 1 | 81242 | 5 | 1.300 | 62493.8 |
188 | 2023-10-15 20:11:29 | scootches | 1 | 81242 | 5 | 1.313 | 61875.1 |
187 | 2023-10-06 08:17:25 | scootches | 1 | 81242 | 5 | 3.126 | 25989.1 |
186 | 2023-09-03 17:42:30 | scootches | 1 | 81242 | 5 | 2.983 | 27235.0 |
185 | 2023-08-25 07:23:24 | scootches | 2 | 121436 | 21 | 3.766 | 32245.4 |
184 | 2023-08-17 18:25:17 | scootches | 3 | 148641 | 111 | 7.016 | 21186.0 |
183 | 2023-07-28 09:54:20 | scootches | 1 | 81242 | 5 | 1.250 | 64993.6 |
182 | 2023-05-11 20:19:40 | scootches | 2 | 121436 | 21 | 3.140 | 38673.9 |
181 | 2023-05-02 01:11:58 | scootches | 3 | 148641 | 111 | 6.436 | 23095.2 |
180 | 2023-03-21 22:26:55 | scootches | 1 | 81242 | 5 | 1.233 | 65889.7 |
179 | 2023-02-17 00:27:23 | scootches | 2 | 121436 | 21 | 3.093 | 39261.6 |
178 | 2023-02-09 15:56:27 | scootches | 3 | 148641 | 111 | 6.843 | 21721.6 |
177 | 2023-01-31 11:35:08 | scootches | 1 | 81242 | 5 | 1.250 | 64993.6 |
176 | 2022-11-29 00:39:48 | scootches | 2 | 121436 | 21 | 3.250 | 37364.9 |
175 | 2022-11-28 04:59:23 | scootches | 1 | 81242 | 5 | 1.360 | 59736.8 |
174 | 2022-11-22 02:02:59 | scootches | 3 | 148641 | 111 | 6.093 | 24395.4 |
173 | 2022-11-13 07:08:33 | scootches | 1 | 81242 | 5 | 1.360 | 59736.8 |
172 | 2022-07-22 18:39:29 | scootches | 1 | 81242 | 5 | 1.373 | 59171.2 |
171 | 2022-07-20 10:36:57 | scootches | 1 | 81242 | 5 | 1.266 | 64172.2 |
170 | 2022-07-05 22:50:49 | scootches | 2 | 121436 | 21 | 3.233 | 37561.4 |
169 | 2022-07-03 16:38:26 | scootches | 2 | 121436 | 21 | 3.080 | 39427.3 |
168 | 2022-06-26 18:34:30 | scootches | 3 | 148641 | 111 | 7.403 | 20078.5 |
167 | 2022-06-25 09:43:49 | scootches | 1 | 81242 | 5 | 1.436 | 56575.2 |
166 | 2022-06-24 02:28:00 | scootches | 3 | 148641 | 111 | 6.093 | 24395.4 |
165 | 2022-03-30 19:54:05 | scootches | 3 | 148641 | 111 | 7.876 | 18872.7 |
164 | 2022-03-19 22:48:00 | scootches | 1 | 81242 | 5 | 1.266 | 64172.2 |
163 | 2022-02-14 22:01:05 | scootches | 2 | 121436 | 21 | 3.560 | 34111.2 |
162 | 2022-02-14 15:40:45 | scootches | 3 | 148641 | 111 | 7.076 | 21006.4 |
161 | 2022-02-12 10:13:39 | scootches | 3 | 148641 | 111 | 7.313 | 20325.6 |
160 | 2022-02-02 18:12:28 | scootches | 1 | 81242 | 5 | 1.266 | 64172.2 |
159 | 2021-12-30 04:29:48 | scootches | 1 | 81242 | 5 | 1.406 | 57782.4 |
158 | 2021-11-13 13:18:56 | scootches | 2 | 121436 | 21 | 3.906 | 31089.6 |
157 | 2021-11-13 05:39:45 | scootches | 3 | 148641 | 111 | 7.376 | 20152.0 |
156 | 2021-11-11 12:24:40 | scootches | 2 | 121436 | 21 | 3.563 | 34082.5 |
155 | 2021-11-03 21:04:55 | scootches | 1 | 81242 | 5 | 1.420 | 57212.7 |
154 | 2021-10-03 18:48:16 | scootches | 1 | 81242 | 5 | 1.266 | 64172.2 |
153 | 2021-09-23 08:52:40 | scootches | 1 | 81242 | 5 | 1.266 | 64172.2 |
152 | 2021-09-21 07:13:15 | scootches | 1 | 81242 | 5 | 1.596 | 50903.5 |
151 | 2021-09-20 14:35:04 | scootches | 2 | 121436 | 21 | 3.580 | 33920.7 |
150 | 2021-09-01 15:16:09 | scootches | 1 | 81242 | 5 | 1.250 | 64993.6 |
149 | 2021-07-01 04:03:40 | scootches | 1 | 81242 | 5 | 1.266 | 64172.2 |
148 | 2021-06-20 21:45:38 | scootches | 1 | 81242 | 5 | 1.406 | 57782.4 |
147 | 2021-04-17 04:40:17 | scootches | 1 | 81242 | 5 | 2.890 | 28111.4 |
146 | 2021-03-31 04:16:42 | scootches | 1 | 81242 | 5 | 1.373 | 59171.2 |
145 | 2021-01-29 18:11:07 | scootches | 1 | 81242 | 5 | 1.313 | 61875.1 |
144 | 2021-01-27 19:02:28 | scootches | 1 | 81242 | 5 | 1.296 | 62686.7 |
143 | 2020-12-19 14:05:02 | scootches | 1 | 81242 | 5 | 1.280 | 63470.3 |
142 | 2020-11-19 08:54:33 | scootches | 1 | 81242 | 5 | 1.326 | 61268.5 |
141 | 2020-11-11 15:53:38 | scootches | 1 | 81242 | 5 | 1.283 | 63321.9 |
140 | 2020-11-08 07:47:11 | scootches | 1 | 81242 | 5 | 1.266 | 64172.2 |
139 | 2020-09-19 03:43:03 | scootches | 1 | 81242 | 5 | 1.233 | 65889.7 |
138 | 2020-08-09 18:46:41 | scootches | 1 | 81242 | 5 | 1.406 | 57782.4 |
137 | 2020-08-06 13:25:39 | scootches | 1 | 81242 | 5 | 1.326 | 61268.5 |
136 | 2020-05-28 00:38:53 | scootches | 1 | 81242 | 5 | 1.236 | 65729.8 |
135 | 2020-05-25 01:14:41 | scootches | 1 | 81242 | 5 | 1.280 | 63470.3 |
134 | 2020-05-11 19:10:28 | scootches | 1 | 81242 | 5 | 1.330 | 61084.2 |
133 | 2020-03-25 17:57:15 | scootches | 1 | 81242 | 5 | 1.500 | 54161.3 |
132 | 2020-02-28 09:47:47 | scootches | 1 | 81242 | 5 | 2.813 | 28880.9 |
131 | 2020-02-28 08:12:17 | scootches | 1 | 81242 | 5 | 4.516 | 17989.8 |
130 | 2020-02-27 07:16:56 | scootches | 1 | 81242 | 5 | 1.313 | 61875.1 |
129 | 2020-02-25 08:04:16 | scootches | 3 | 148641 | 111 | 11.110 | 13379.0 |
128 | 2020-02-23 19:03:45 | scootches | 3 | 148641 | 111 | 7.423 | 20024.4 |
127 | 2020-02-22 19:04:58 | scootches | 3 | 148641 | 111 | 7.580 | 19609.6 |
126 | 2020-02-20 14:29:23 | scootches | 1 | 81242 | 5 | 1.483 | 54782.2 |
125 | 2020-02-19 04:27:46 | scootches | 1 | 81242 | 5 | 1.563 | 51978.2 |