History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gallivanted"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
217 | 2024-04-27 14:18:00 | gallivanted | 4 | 148819 | 59 | 35.253 | 4221.5 |
216 | 2024-04-27 07:18:38 | gallivanted | 4 | 148819 | 59 | 22.113 | 6729.9 |
215 | 2024-04-26 21:21:45 | gallivanted | 1 | 49908 | 2 | 3.750 | 13308.8 |
214 | 2024-04-16 07:12:14 | gallivanted | 1 | 49908 | 2 | 0.720 | 69316.7 |
213 | 2024-04-15 18:20:57 | gallivanted | 4 | 148819 | 59 | 14.783 | 10066.9 |
212 | 2024-04-15 00:20:21 | gallivanted | 5 | 164607 | 357 | 53.986 | 3049.1 |
211 | 2024-04-14 23:47:10 | gallivanted | 5 | 164607 | 357 | 38.890 | 4232.6 |
210 | 2024-04-14 23:45:18 | gallivanted | 5 | 164607 | 357 | 47.970 | 3431.5 |
209 | 2024-04-14 23:45:23 | gallivanted | 4 | 148819 | 59 | 27.516 | 5408.5 |
208 | 2024-04-14 23:45:16 | gallivanted | 1 | 49908 | 2 | 1.360 | 36697.1 |
207 | 2024-04-14 23:37:43 | gallivanted | 1 | 49908 | 2 | 2.110 | 23653.1 |
206 | 2024-04-13 09:39:28 | gallivanted | 1 | 49908 | 2 | 0.843 | 59202.8 |
205 | 2024-04-13 00:41:17 | gallivanted | 1 | 49908 | 2 | 0.826 | 60421.3 |
204 | 2024-04-07 23:19:34 | gallivanted | 5 | 164607 | 357 | 33.223 | 4954.6 |
203 | 2024-04-07 06:37:06 | gallivanted | 5 | 164607 | 357 | 50.703 | 3246.5 |
202 | 2024-04-04 10:32:14 | gallivanted | 5 | 164607 | 357 | 46.330 | 3552.9 |
201 | 2024-04-04 10:22:20 | gallivanted | 5 | 164607 | 357 | 20.220 | 8140.8 |
200 | 2024-03-28 04:49:21 | gallivanted | 1 | 49908 | 2 | 0.843 | 59202.8 |
199 | 2024-03-27 08:31:53 | gallivanted | 4 | 148819 | 59 | 26.580 | 5598.9 |
198 | 2024-03-27 08:31:59 | gallivanted | 2 | 86808 | 6 | 8.436 | 10290.2 |
197 | 2024-03-27 08:06:37 | gallivanted | 1 | 49908 | 2 | 0.873 | 57168.4 |
196 | 2024-03-19 23:40:19 | gallivanted | 1 | 49908 | 2 | 0.830 | 60130.1 |
195 | 2024-03-19 23:39:59 | gallivanted | 3 | 121633 | 11 | 7.873 | 15449.4 |
194 | 2024-03-19 23:40:00 | gallivanted | 2 | 86808 | 6 | 5.203 | 16684.2 |
193 | 2024-03-19 23:39:39 | gallivanted | 1 | 49908 | 2 | 1.716 | 29083.9 |
192 | 2024-03-10 11:00:58 | gallivanted | 5 | 164607 | 357 | 41.610 | 3955.9 |
191 | 2024-03-10 04:30:18 | gallivanted | 5 | 164607 | 357 | 36.610 | 4496.2 |
190 | 2024-03-10 04:30:12 | gallivanted | 2 | 86808 | 6 | 10.623 | 8171.7 |
189 | 2024-03-10 04:30:15 | gallivanted | 3 | 121633 | 11 | 7.203 | 16886.4 |
188 | 2024-03-05 12:27:13 | gallivanted | 1 | 49908 | 2 | 0.830 | 60130.1 |
187 | 2024-03-04 14:31:19 | gallivanted | 1 | 49908 | 2 | 1.063 | 46950.1 |
186 | 2024-03-02 04:17:54 | gallivanted | 1 | 49908 | 2 | 0.940 | 53093.6 |
185 | 2024-02-26 05:44:12 | gallivanted | 1 | 49908 | 2 | 0.890 | 56076.4 |
184 | 2024-02-25 23:56:55 | gallivanted | 5 | 164607 | 357 | 57.550 | 2860.2 |
183 | 2024-02-23 15:47:32 | gallivanted | 5 | 164607 | 357 | 24.703 | 6663.4 |
182 | 2024-02-20 20:04:18 | gallivanted | 4 | 148819 | 59 | 15.986 | 9309.3 |
181 | 2024-02-08 12:25:44 | gallivanted | 1 | 49908 | 2 | 0.716 | 69703.9 |
180 | 2024-02-07 09:01:25 | gallivanted | 3 | 121633 | 11 | 9.966 | 12204.8 |
179 | 2024-02-07 09:01:21 | gallivanted | 2 | 86808 | 6 | 2.643 | 32844.5 |
178 | 2024-02-07 08:58:13 | gallivanted | 1 | 49908 | 2 | 0.720 | 69316.7 |
177 | 2024-02-07 08:58:10 | gallivanted | 1 | 49908 | 2 | 0.876 | 56972.6 |
176 | 2024-01-29 23:32:41 | gallivanted | 1 | 49908 | 2 | 0.796 | 62698.5 |
175 | 2024-01-23 08:32:30 | gallivanted | 3 | 121633 | 11 | 14.953 | 8134.4 |
174 | 2024-01-23 08:32:26 | gallivanted | 4 | 148819 | 59 | 13.550 | 10983.0 |
173 | 2024-01-23 08:32:30 | gallivanted | 2 | 86808 | 6 | 5.186 | 16738.9 |
172 | 2024-01-23 07:40:51 | gallivanted | 1 | 49908 | 2 | 0.796 | 62698.5 |
171 | 2024-01-23 06:59:44 | gallivanted | 5 | 164607 | 357 | 17.500 | 9406.1 |
170 | 2024-01-09 01:44:27 | gallivanted | 5 | 164607 | 357 | 14.420 | 11415.2 |
169 | 2024-01-06 07:39:28 | gallivanted | 1 | 49908 | 2 | 0.796 | 62698.5 |
168 | 2023-12-25 15:42:26 | gallivanted | 5 | 164607 | 357 | 15.250 | 10793.9 |
167 | 2023-12-25 03:25:53 | gallivanted | 1 | 49908 | 2 | 0.813 | 61387.5 |
166 | 2023-11-29 14:30:07 | gallivanted | 1 | 49908 | 2 | 0.750 | 66544.0 |
165 | 2023-11-29 09:09:16 | gallivanted | 1 | 49908 | 2 | 0.876 | 56972.6 |
164 | 2023-11-22 15:37:07 | gallivanted | 5 | 164607 | 357 | 14.016 | 11744.2 |
163 | 2023-10-28 07:12:55 | gallivanted | 1 | 49908 | 2 | 0.736 | 67809.8 |
162 | 2023-10-20 05:04:31 | gallivanted | 5 | 164607 | 357 | 31.126 | 5288.4 |
161 | 2023-10-07 04:25:28 | gallivanted | 5 | 164607 | 357 | 15.830 | 10398.4 |
160 | 2023-10-01 15:16:49 | gallivanted | 5 | 164607 | 357 | 14.876 | 11065.3 |
159 | 2023-09-27 03:14:59 | gallivanted | 5 | 164607 | 357 | 13.736 | 11983.6 |
158 | 2023-09-13 19:20:46 | gallivanted | 1 | 49908 | 2 | 0.843 | 59202.8 |
157 | 2023-07-06 13:08:08 | gallivanted | 5 | 164607 | 357 | 15.673 | 10502.6 |
156 | 2023-06-25 17:21:46 | gallivanted | 1 | 49908 | 2 | 0.720 | 69316.7 |
155 | 2023-06-24 20:51:02 | gallivanted | 1 | 49908 | 2 | 0.720 | 69316.7 |
154 | 2023-04-06 07:00:18 | gallivanted | 1 | 49908 | 2 | 0.783 | 63739.5 |
153 | 2023-03-27 18:47:25 | gallivanted | 5 | 164607 | 357 | 12.186 | 13507.9 |
152 | 2023-02-10 21:56:12 | gallivanted | 1 | 49908 | 2 | 0.800 | 62385.0 |
151 | 2023-01-25 02:07:31 | gallivanted | 5 | 164607 | 357 | 13.470 | 12220.3 |
150 | 2023-01-19 14:16:55 | gallivanted | 1 | 49908 | 2 | 0.766 | 65154.0 |
149 | 2022-12-25 16:02:02 | gallivanted | 5 | 164607 | 357 | 12.266 | 13419.8 |
148 | 2022-12-10 20:28:11 | gallivanted | 5 | 164607 | 357 | 12.440 | 13232.1 |
147 | 2022-11-15 19:23:51 | gallivanted | 1 | 49908 | 2 | 0.733 | 68087.3 |
146 | 2022-11-02 10:01:55 | gallivanted | 5 | 164607 | 357 | 13.220 | 12451.4 |
145 | 2022-10-24 13:34:09 | gallivanted | 5 | 164607 | 357 | 12.563 | 13102.5 |
144 | 2022-09-26 21:56:40 | gallivanted | 5 | 164607 | 357 | 12.643 | 13019.6 |
143 | 2022-09-18 04:18:15 | gallivanted | 1 | 49908 | 2 | 0.813 | 61387.5 |
142 | 2022-08-25 23:44:52 | gallivanted | 5 | 164607 | 357 | 12.420 | 13253.4 |
141 | 2022-07-17 21:12:26 | gallivanted | 2 | 86808 | 6 | 2.016 | 43059.5 |
140 | 2022-07-06 20:15:38 | gallivanted | 1 | 49908 | 2 | 0.720 | 69316.7 |
139 | 2022-04-17 11:36:34 | gallivanted | 1 | 49908 | 2 | 0.766 | 65154.0 |
138 | 2022-04-13 23:11:34 | gallivanted | 1 | 49908 | 2 | 0.736 | 67809.8 |
137 | 2022-03-22 08:53:36 | gallivanted | 1 | 49908 | 2 | 1.000 | 49908.0 |
136 | 2021-11-23 12:58:43 | gallivanted | 1 | 49908 | 2 | 1.686 | 29601.4 |
135 | 2021-07-13 16:41:18 | gallivanted | 1 | 49908 | 2 | 0.766 | 65154.0 |
134 | 2021-04-10 08:24:34 | gallivanted | 1 | 49908 | 2 | 0.783 | 63739.5 |
133 | 2021-04-04 03:33:16 | gallivanted | 3 | 121633 | 11 | 7.050 | 17252.9 |
132 | 2021-03-08 13:24:58 | gallivanted | 3 | 121633 | 11 | 4.280 | 28418.9 |
131 | 2021-02-12 11:09:32 | gallivanted | 3 | 121633 | 11 | 4.826 | 25203.7 |
130 | 2020-12-20 01:29:05 | gallivanted | 3 | 121633 | 11 | 4.936 | 24642.0 |
129 | 2020-12-09 21:24:17 | gallivanted | 1 | 49908 | 2 | 0.813 | 61387.5 |
128 | 2020-10-26 21:03:39 | gallivanted | 1 | 49908 | 2 | 0.736 | 67809.8 |
127 | 2020-09-12 11:35:36 | gallivanted | 1 | 49908 | 2 | 0.733 | 68087.3 |
126 | 2020-08-26 21:07:19 | gallivanted | 1 | 49908 | 2 | 0.796 | 62698.5 |
125 | 2020-08-06 02:39:22 | gallivanted | 1 | 49908 | 2 | 0.906 | 55086.1 |
124 | 2020-04-09 16:56:19 | gallivanted | 1 | 49908 | 2 | 0.750 | 66544.0 |
123 | 2020-03-26 01:47:51 | gallivanted | 1 | 49908 | 2 | 0.890 | 56076.4 |
122 | 2020-03-01 02:45:41 | gallivanted | 1 | 49908 | 2 | 0.843 | 59202.8 |
121 | 2020-02-29 22:03:57 | gallivanted | 1 | 49908 | 2 | 0.856 | 58303.7 |
120 | 2020-02-28 15:32:38 | gallivanted | 1 | 49908 | 2 | 0.843 | 59202.8 |
119 | 2020-02-28 14:07:51 | gallivanted | 1 | 49908 | 2 | 1.763 | 28308.6 |
118 | 2020-02-25 02:41:04 | gallivanted | 1 | 49908 | 2 | 1.873 | 26646.0 |