History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"ranpikes"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
218 | 2024-05-05 21:17:48 | ranpikes | 1 | 82945 | 3 | 1.580 | 52496.8 |
217 | 2024-04-30 16:02:40 | ranpikes | 3 | 146162 | 136 | 14.110 | 10358.8 |
216 | 2024-04-29 12:02:55 | ranpikes | 3 | 146162 | 136 | 21.050 | 6943.6 |
215 | 2024-04-29 12:02:59 | ranpikes | 2 | 121059 | 8 | 16.970 | 7133.7 |
214 | 2024-04-29 10:34:25 | ranpikes | 1 | 82945 | 3 | 1.576 | 52630.1 |
213 | 2024-04-07 16:50:00 | ranpikes | 1 | 82945 | 3 | 5.406 | 15343.1 |
212 | 2024-04-06 01:47:59 | ranpikes | 3 | 146162 | 136 | 11.876 | 12307.3 |
211 | 2024-04-05 16:22:13 | ranpikes | 2 | 121059 | 8 | 3.750 | 32282.4 |
210 | 2024-04-05 16:20:51 | ranpikes | 3 | 146162 | 136 | 8.580 | 17035.2 |
209 | 2024-03-30 20:15:35 | ranpikes | 3 | 146162 | 136 | 16.626 | 8791.2 |
208 | 2024-03-30 13:11:08 | ranpikes | 2 | 121059 | 8 | 6.860 | 17647.1 |
207 | 2024-03-30 13:11:08 | ranpikes | 1 | 82945 | 3 | 1.673 | 49578.6 |
206 | 2024-03-30 12:02:51 | ranpikes | 3 | 146162 | 136 | 9.186 | 15911.4 |
205 | 2024-03-30 06:19:20 | ranpikes | 3 | 146162 | 136 | 17.063 | 8566.0 |
204 | 2024-03-30 06:19:21 | ranpikes | 2 | 121059 | 8 | 9.093 | 13313.4 |
203 | 2024-03-30 05:16:16 | ranpikes | 1 | 82945 | 3 | 1.500 | 55296.7 |
202 | 2024-03-07 10:37:55 | ranpikes | 1 | 82945 | 3 | 2.156 | 38471.7 |
201 | 2024-03-06 00:55:05 | ranpikes | 1 | 82945 | 3 | 1.593 | 52068.4 |
200 | 2024-02-29 19:16:36 | ranpikes | 2 | 121059 | 8 | 3.546 | 34139.6 |
199 | 2024-02-29 19:16:17 | ranpikes | 3 | 146162 | 136 | 6.953 | 21021.4 |
198 | 2024-02-26 08:45:20 | ranpikes | 3 | 146162 | 136 | 7.110 | 20557.2 |
197 | 2024-02-26 03:37:56 | ranpikes | 3 | 146162 | 136 | 11.313 | 12919.8 |
196 | 2024-02-26 03:37:54 | ranpikes | 2 | 121059 | 8 | 7.360 | 16448.2 |
195 | 2024-02-26 03:37:47 | ranpikes | 1 | 82945 | 3 | 3.236 | 25632.0 |
194 | 2024-01-27 00:52:03 | ranpikes | 3 | 146162 | 136 | 7.610 | 19206.6 |
193 | 2024-01-26 03:08:35 | ranpikes | 3 | 146162 | 136 | 7.923 | 18447.8 |
192 | 2024-01-22 12:55:01 | ranpikes | 1 | 82945 | 3 | 1.280 | 64800.8 |
191 | 2024-01-08 23:18:36 | ranpikes | 2 | 121059 | 8 | 7.423 | 16308.6 |
190 | 2024-01-08 23:18:34 | ranpikes | 3 | 146162 | 136 | 8.140 | 17956.0 |
189 | 2023-12-18 17:43:36 | ranpikes | 2 | 121059 | 8 | 3.250 | 37248.9 |
188 | 2023-12-06 13:20:01 | ranpikes | 1 | 82945 | 3 | 1.513 | 54821.5 |
187 | 2023-11-17 05:47:41 | ranpikes | 1 | 82945 | 3 | 1.296 | 64000.8 |
186 | 2023-10-31 20:57:52 | ranpikes | 1 | 82945 | 3 | 1.830 | 45325.1 |
185 | 2023-10-17 11:17:26 | ranpikes | 1 | 82945 | 3 | 2.423 | 34232.4 |
184 | 2023-10-17 07:57:10 | ranpikes | 1 | 82945 | 3 | 1.310 | 63316.8 |
183 | 2023-09-27 09:53:54 | ranpikes | 1 | 82945 | 3 | 4.576 | 18126.1 |
182 | 2023-09-19 18:52:16 | ranpikes | 2 | 121059 | 8 | 3.860 | 31362.4 |
181 | 2023-09-04 03:07:01 | ranpikes | 1 | 82945 | 3 | 1.406 | 58993.6 |
180 | 2023-06-28 20:38:47 | ranpikes | 2 | 121059 | 8 | 3.780 | 32026.2 |
179 | 2023-06-10 01:29:01 | ranpikes | 1 | 82945 | 3 | 1.296 | 64000.8 |
178 | 2023-06-06 18:24:03 | ranpikes | 1 | 82945 | 3 | 2.343 | 35401.2 |
177 | 2023-05-04 00:02:55 | ranpikes | 1 | 82945 | 3 | 3.793 | 21867.9 |
176 | 2023-04-04 09:26:21 | ranpikes | 1 | 82945 | 3 | 1.296 | 64000.8 |
175 | 2023-03-24 13:58:55 | ranpikes | 2 | 121059 | 8 | 3.450 | 35089.6 |
174 | 2023-02-07 02:11:32 | ranpikes | 1 | 82945 | 3 | 1.283 | 64649.3 |
173 | 2023-01-28 16:19:54 | ranpikes | 1 | 82945 | 3 | 1.313 | 63172.1 |
172 | 2022-12-22 00:24:44 | ranpikes | 2 | 121059 | 8 | 3.670 | 32986.1 |
171 | 2022-12-05 12:40:09 | ranpikes | 1 | 82945 | 3 | 1.283 | 64649.3 |
170 | 2022-09-19 02:06:25 | ranpikes | 1 | 82945 | 3 | 1.313 | 63172.1 |
169 | 2022-08-21 14:28:23 | ranpikes | 2 | 121059 | 8 | 3.266 | 37066.4 |
168 | 2022-07-31 20:33:45 | ranpikes | 1 | 82945 | 3 | 1.280 | 64800.8 |
167 | 2022-04-21 17:33:49 | ranpikes | 1 | 82945 | 3 | 1.796 | 46183.2 |
166 | 2021-12-20 15:56:32 | ranpikes | 1 | 82945 | 3 | 1.500 | 55296.7 |
165 | 2021-08-24 19:10:11 | ranpikes | 1 | 82945 | 3 | 1.326 | 62552.8 |
164 | 2021-05-11 20:24:05 | ranpikes | 1 | 82945 | 3 | 1.500 | 55296.7 |
163 | 2021-05-10 13:47:20 | ranpikes | 1 | 82945 | 3 | 3.280 | 25288.1 |
162 | 2021-04-10 15:12:10 | ranpikes | 1 | 82945 | 3 | 2.843 | 29175.2 |
161 | 2021-03-30 03:42:58 | ranpikes | 2 | 121059 | 8 | 3.736 | 32403.4 |
160 | 2021-02-07 21:18:33 | ranpikes | 2 | 121059 | 8 | 3.283 | 36874.5 |
159 | 2021-01-27 14:45:09 | ranpikes | 1 | 82945 | 3 | 1.440 | 57600.7 |
158 | 2021-01-25 16:46:00 | ranpikes | 1 | 82945 | 3 | 1.343 | 61761.0 |
157 | 2021-01-13 17:15:56 | ranpikes | 2 | 121059 | 8 | 3.280 | 36908.2 |
156 | 2020-12-26 21:28:09 | ranpikes | 1 | 82945 | 3 | 1.296 | 64000.8 |
155 | 2020-11-02 15:49:35 | ranpikes | 1 | 82945 | 3 | 1.373 | 60411.5 |
154 | 2020-10-26 07:47:22 | ranpikes | 1 | 82945 | 3 | 1.296 | 64000.8 |
153 | 2020-10-25 20:52:00 | ranpikes | 2 | 121059 | 8 | 3.813 | 31749.0 |
152 | 2020-10-23 02:31:22 | ranpikes | 1 | 82945 | 3 | 1.453 | 57085.3 |
151 | 2020-10-19 13:17:48 | ranpikes | 1 | 82945 | 3 | 1.453 | 57085.3 |
150 | 2020-09-04 04:38:47 | ranpikes | 1 | 82945 | 3 | 1.326 | 62552.8 |
149 | 2020-06-20 03:38:42 | ranpikes | 1 | 82945 | 3 | 1.466 | 56579.1 |
148 | 2020-03-28 23:02:02 | ranpikes | 1 | 82945 | 3 | 1.593 | 52068.4 |
147 | 2020-03-22 15:42:02 | ranpikes | 1 | 82945 | 3 | 1.783 | 46519.9 |
146 | 2020-03-12 06:41:21 | ranpikes | 1 | 82945 | 3 | 1.453 | 57085.3 |
145 | 2020-03-07 08:59:00 | ranpikes | 1 | 82945 | 3 | 1.280 | 64800.8 |
144 | 2020-02-29 21:59:15 | ranpikes | 1 | 82945 | 3 | 1.453 | 57085.3 |
143 | 2020-02-25 20:04:31 | ranpikes | 1 | 82945 | 3 | 3.046 | 27230.8 |
142 | 2020-02-20 14:09:02 | ranpikes | 1 | 82945 | 3 | 2.170 | 38223.5 |
141 | 2020-02-18 17:22:47 | ranpikes | 1 | 82945 | 3 | 1.576 | 52630.1 |
140 | 2020-02-17 01:39:29 | ranpikes | 1 | 82945 | 3 | 2.686 | 30880.5 |
139 | 2020-02-04 06:25:51 | ranpikes | 1 | 82945 | 3 | 2.343 | 35401.2 |
138 | 2020-02-02 05:29:30 | ranpikes | 1 | 82945 | 3 | 2.750 | 30161.8 |
137 | 2020-01-23 19:24:53 | ranpikes | 1 | 82945 | 3 | 1.810 | 45826.0 |
136 | 2020-01-23 12:17:12 | ranpikes | 1 | 82945 | 3 | 1.813 | 45750.1 |
135 | 2020-01-23 04:34:36 | ranpikes | 1 | 82945 | 3 | 3.283 | 25265.0 |
134 | 2020-01-17 19:52:45 | ranpikes | 3 | 146162 | 136 | 8.890 | 16441.2 |
133 | 2020-01-17 15:21:18 | ranpikes | 3 | 146162 | 136 | 17.720 | 8248.4 |
132 | 2020-01-17 10:17:54 | ranpikes | 2 | 121059 | 8 | 4.173 | 29010.1 |
131 | 2020-01-17 10:17:16 | ranpikes | 3 | 146162 | 136 | 8.076 | 18098.3 |
130 | 2020-01-17 03:55:29 | ranpikes | 1 | 82945 | 3 | 1.783 | 46519.9 |
129 | 2020-01-13 05:22:48 | ranpikes | 1 | 82945 | 3 | 1.610 | 51518.6 |
128 | 2019-12-31 22:26:48 | ranpikes | 1 | 82945 | 3 | 1.483 | 55930.5 |
127 | 2019-12-30 14:42:57 | ranpikes | 1 | 82945 | 3 | 1.500 | 55296.7 |
126 | 2019-12-06 11:09:33 | ranpikes | 1 | 82945 | 3 | 1.563 | 53067.8 |
125 | 2019-09-04 08:48:35 | ranpikes | 1 | 82945 | 3 | 1.206 | 68776.9 |
124 | 2019-05-29 12:37:34 | ranpikes | 1 | 82945 | 3 | 1.496 | 55444.5 |
123 | 2019-04-02 02:10:12 | ranpikes | 1 | 82945 | 3 | 1.666 | 49786.9 |
122 | 2019-02-28 06:01:28 | ranpikes | 1 | 82945 | 3 | 1.276 | 65003.9 |
121 | 2019-02-10 19:40:50 | ranpikes | 1 | 82945 | 3 | 1.263 | 65673.0 |
120 | 2019-02-09 18:15:47 | ranpikes | 2 | 121059 | 8 | 3.323 | 36430.6 |
119 | 2019-02-04 06:20:10 | ranpikes | 1 | 82945 | 3 | 1.253 | 66197.1 |