History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pamphlet"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
228 | 2024-05-05 08:32:17 | pamphlet | 1 | 82945 | 2 | 3.250 | 25521.5 |
227 | 2024-05-04 21:05:36 | pamphlet | 1 | 82945 | 2 | 4.126 | 20103.0 |
226 | 2024-04-30 23:51:37 | pamphlet | 4 | 161609 | 418 | 13.983 | 11557.5 |
225 | 2024-04-27 03:43:41 | pamphlet | 4 | 161609 | 418 | 37.486 | 4311.2 |
224 | 2024-04-26 02:11:37 | pamphlet | 4 | 161609 | 418 | 29.236 | 5527.7 |
223 | 2024-04-26 02:11:40 | pamphlet | 2 | 121059 | 2 | 4.233 | 28598.9 |
222 | 2024-04-26 02:11:13 | pamphlet | 3 | 146162 | 36 | 8.420 | 17358.9 |
221 | 2024-04-24 08:59:25 | pamphlet | 3 | 146162 | 36 | 23.656 | 6178.6 |
220 | 2024-04-24 08:59:20 | pamphlet | 2 | 121059 | 2 | 14.970 | 8086.8 |
219 | 2024-04-24 08:57:07 | pamphlet | 1 | 82945 | 2 | 1.733 | 47862.1 |
218 | 2024-04-19 13:27:40 | pamphlet | 2 | 121059 | 2 | 8.766 | 13810.1 |
217 | 2024-04-19 13:26:43 | pamphlet | 3 | 146162 | 36 | 8.766 | 16673.7 |
216 | 2024-04-15 14:15:18 | pamphlet | 3 | 146162 | 36 | 26.703 | 5473.6 |
215 | 2024-04-11 14:17:12 | pamphlet | 3 | 146162 | 36 | 7.280 | 20077.2 |
214 | 2024-04-11 14:17:13 | pamphlet | 2 | 121059 | 2 | 3.810 | 31774.0 |
213 | 2024-04-11 14:17:14 | pamphlet | 1 | 82945 | 2 | 1.500 | 55296.7 |
212 | 2024-04-10 19:49:37 | pamphlet | 4 | 161609 | 418 | 39.893 | 4051.1 |
211 | 2024-04-09 18:16:05 | pamphlet | 4 | 161609 | 418 | 20.483 | 7889.9 |
210 | 2024-04-08 08:58:18 | pamphlet | 1 | 82945 | 2 | 4.250 | 19516.5 |
209 | 2024-04-08 02:42:40 | pamphlet | 4 | 161609 | 418 | 15.656 | 10322.5 |
208 | 2024-04-08 02:42:26 | pamphlet | 2 | 121059 | 2 | 9.096 | 13309.0 |
207 | 2024-04-07 17:43:18 | pamphlet | 3 | 146162 | 36 | 27.173 | 5378.9 |
206 | 2024-04-07 17:43:17 | pamphlet | 2 | 121059 | 2 | 9.190 | 13172.9 |
205 | 2024-04-07 17:42:49 | pamphlet | 1 | 82945 | 2 | 4.030 | 20581.9 |
204 | 2024-04-03 19:37:52 | pamphlet | 1 | 82945 | 2 | 3.390 | 24467.6 |
203 | 2024-03-26 16:28:45 | pamphlet | 4 | 161609 | 418 | 13.033 | 12400.0 |
202 | 2024-03-26 16:28:50 | pamphlet | 3 | 146162 | 36 | 7.860 | 18595.7 |
201 | 2024-03-26 16:28:53 | pamphlet | 2 | 121059 | 2 | 3.906 | 30993.1 |
200 | 2024-03-12 05:46:46 | pamphlet | 2 | 121059 | 2 | 3.360 | 36029.5 |
199 | 2024-03-12 05:46:45 | pamphlet | 1 | 82945 | 2 | 1.356 | 61168.9 |
198 | 2024-03-11 13:47:39 | pamphlet | 2 | 121059 | 2 | 10.533 | 11493.3 |
197 | 2024-03-11 13:47:18 | pamphlet | 1 | 82945 | 2 | 1.656 | 50087.6 |
196 | 2024-03-11 13:46:25 | pamphlet | 3 | 146162 | 36 | 8.126 | 17987.0 |
195 | 2024-03-11 10:55:23 | pamphlet | 3 | 146162 | 36 | 21.160 | 6907.5 |
194 | 2024-03-11 08:50:13 | pamphlet | 3 | 146162 | 36 | 18.046 | 8099.4 |
193 | 2024-03-10 16:23:11 | pamphlet | 4 | 161609 | 418 | 36.580 | 4418.0 |
192 | 2024-03-08 09:18:54 | pamphlet | 4 | 161609 | 418 | 28.800 | 5611.4 |
191 | 2024-03-05 14:27:07 | pamphlet | 3 | 146162 | 36 | 11.686 | 12507.4 |
190 | 2024-03-05 14:27:08 | pamphlet | 2 | 121059 | 2 | 7.846 | 15429.4 |
189 | 2024-03-05 14:23:27 | pamphlet | 1 | 82945 | 2 | 1.580 | 52496.8 |
188 | 2024-03-04 20:48:49 | pamphlet | 1 | 82945 | 2 | 1.703 | 48705.2 |
187 | 2024-03-04 20:48:40 | pamphlet | 1 | 82945 | 2 | 2.093 | 39629.7 |
186 | 2024-03-04 13:38:43 | pamphlet | 4 | 161609 | 418 | 17.906 | 9025.4 |
185 | 2024-03-02 03:21:01 | pamphlet | 4 | 161609 | 418 | 15.703 | 10291.6 |
184 | 2024-02-26 02:18:59 | pamphlet | 4 | 161609 | 418 | 29.816 | 5420.2 |
183 | 2024-02-23 23:45:09 | pamphlet | 4 | 161609 | 418 | 30.176 | 5355.5 |
182 | 2024-02-23 23:45:08 | pamphlet | 3 | 146162 | 36 | 8.390 | 17421.0 |
181 | 2024-02-23 23:45:07 | pamphlet | 2 | 121059 | 2 | 6.576 | 18409.2 |
180 | 2024-02-09 18:09:30 | pamphlet | 1 | 82945 | 2 | 3.093 | 26817.0 |
179 | 2024-02-08 17:35:09 | pamphlet | 4 | 161609 | 418 | 29.410 | 5495.0 |
178 | 2024-02-08 09:57:13 | pamphlet | 3 | 146162 | 36 | 27.376 | 5339.1 |
177 | 2024-02-08 08:35:24 | pamphlet | 4 | 161609 | 418 | 15.360 | 10521.4 |
176 | 2024-02-06 09:15:42 | pamphlet | 3 | 146162 | 36 | 8.330 | 17546.5 |
175 | 2024-02-06 09:15:46 | pamphlet | 2 | 121059 | 2 | 3.953 | 30624.6 |
174 | 2024-02-06 09:12:06 | pamphlet | 4 | 161609 | 418 | 13.673 | 11819.6 |
173 | 2024-02-06 09:12:02 | pamphlet | 1 | 82945 | 2 | 1.470 | 56425.2 |
172 | 2024-01-30 01:19:25 | pamphlet | 3 | 146162 | 36 | 7.190 | 20328.5 |
171 | 2024-01-30 01:19:21 | pamphlet | 1 | 82945 | 2 | 1.330 | 62364.7 |
170 | 2024-01-24 16:57:35 | pamphlet | 4 | 161609 | 418 | 27.110 | 5961.2 |
169 | 2024-01-23 16:39:52 | pamphlet | 2 | 121059 | 2 | 15.016 | 8062.0 |
168 | 2024-01-23 16:39:39 | pamphlet | 4 | 161609 | 418 | 23.970 | 6742.1 |
167 | 2024-01-23 16:39:38 | pamphlet | 3 | 146162 | 36 | 8.810 | 16590.5 |
166 | 2024-01-20 08:31:10 | pamphlet | 1 | 82945 | 2 | 1.313 | 63172.1 |
165 | 2023-12-22 23:48:38 | pamphlet | 1 | 82945 | 2 | 1.326 | 62552.8 |
164 | 2023-11-26 16:39:45 | pamphlet | 1 | 82945 | 2 | 1.296 | 64000.8 |
163 | 2023-11-16 04:38:13 | pamphlet | 1 | 82945 | 2 | 1.326 | 62552.8 |
162 | 2023-11-10 21:14:51 | pamphlet | 1 | 82945 | 2 | 1.296 | 64000.8 |
161 | 2023-09-03 11:49:49 | pamphlet | 1 | 82945 | 2 | 1.263 | 65673.0 |
160 | 2023-02-22 20:20:18 | pamphlet | 1 | 82945 | 2 | 1.263 | 65673.0 |
159 | 2022-12-20 13:46:04 | pamphlet | 1 | 82945 | 2 | 1.283 | 64649.3 |
158 | 2022-11-25 01:33:22 | pamphlet | 1 | 82945 | 2 | 1.300 | 63803.8 |
157 | 2022-09-03 00:03:32 | pamphlet | 1 | 82945 | 2 | 1.313 | 63172.1 |
156 | 2022-05-03 17:15:36 | pamphlet | 1 | 82945 | 2 | 1.843 | 45005.4 |
155 | 2022-05-01 12:46:53 | pamphlet | 1 | 82945 | 2 | 1.263 | 65673.0 |
154 | 2021-05-30 05:41:16 | pamphlet | 4 | 161609 | 418 | 12.406 | 13026.7 |
153 | 2021-05-19 16:36:21 | pamphlet | 1 | 82945 | 2 | 1.296 | 64000.8 |
152 | 2021-05-09 23:25:21 | pamphlet | 3 | 146162 | 36 | 7.686 | 19016.7 |
151 | 2021-04-21 17:31:29 | pamphlet | 4 | 161609 | 418 | 12.530 | 12897.8 |
150 | 2021-04-06 15:51:45 | pamphlet | 1 | 82945 | 2 | 1.470 | 56425.2 |
149 | 2021-04-02 22:17:30 | pamphlet | 4 | 161609 | 418 | 11.953 | 13520.4 |
148 | 2021-02-11 10:31:52 | pamphlet | 4 | 161609 | 418 | 11.623 | 13904.2 |
147 | 2021-02-01 00:59:22 | pamphlet | 1 | 82945 | 2 | 1.436 | 57761.1 |
146 | 2021-01-23 12:45:47 | pamphlet | 3 | 146162 | 36 | 8.253 | 17710.2 |
145 | 2021-01-04 09:13:29 | pamphlet | 1 | 82945 | 2 | 1.313 | 63172.1 |
144 | 2020-12-07 08:04:16 | pamphlet | 1 | 82945 | 2 | 1.343 | 61761.0 |
143 | 2020-11-03 14:44:23 | pamphlet | 3 | 146162 | 36 | 11.503 | 12706.4 |
142 | 2020-11-01 23:31:06 | pamphlet | 1 | 82945 | 2 | 1.360 | 60989.0 |
141 | 2020-07-23 01:09:47 | pamphlet | 1 | 82945 | 2 | 1.330 | 62364.7 |
140 | 2020-03-29 05:23:22 | pamphlet | 1 | 82945 | 2 | 1.530 | 54212.4 |
139 | 2020-03-29 00:18:40 | pamphlet | 1 | 82945 | 2 | 1.513 | 54821.5 |
138 | 2020-03-25 13:46:24 | pamphlet | 1 | 82945 | 2 | 3.233 | 25655.7 |
137 | 2020-03-02 20:22:08 | pamphlet | 1 | 82945 | 2 | 1.530 | 54212.4 |
136 | 2020-02-29 14:15:16 | pamphlet | 1 | 82945 | 2 | 1.576 | 52630.1 |
135 | 2020-02-04 04:47:03 | pamphlet | 1 | 82945 | 2 | 2.893 | 28670.9 |
134 | 2020-02-02 03:24:46 | pamphlet | 1 | 82945 | 2 | 2.920 | 28405.8 |
133 | 2020-01-29 21:46:42 | pamphlet | 1 | 82945 | 2 | 1.500 | 55296.7 |
132 | 2020-01-27 20:53:49 | pamphlet | 1 | 82945 | 2 | 1.486 | 55817.6 |
131 | 2020-01-22 22:28:22 | pamphlet | 1 | 82945 | 2 | 3.716 | 22321.0 |
130 | 2020-01-15 19:22:37 | pamphlet | 1 | 82945 | 2 | 3.233 | 25655.7 |
129 | 2020-01-04 13:27:52 | pamphlet | 1 | 82945 | 2 | 1.450 | 57203.4 |