History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"establisher"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
218 | 2024-05-01 00:50:22 | establisher | 1 | 49908 | 4 | 0.910 | 54844.0 |
217 | 2024-04-29 18:00:50 | establisher | 4 | 148819 | 38 | 31.050 | 4792.9 |
216 | 2024-04-29 01:44:25 | establisher | 1 | 49908 | 4 | 0.906 | 55086.1 |
215 | 2024-04-25 13:59:19 | establisher | 1 | 49908 | 4 | 1.076 | 46382.9 |
214 | 2024-04-16 07:14:41 | establisher | 1 | 49908 | 4 | 0.906 | 55086.1 |
213 | 2024-04-12 15:15:55 | establisher | 1 | 49908 | 4 | 2.810 | 17760.9 |
212 | 2024-03-26 20:13:53 | establisher | 4 | 148819 | 38 | 27.550 | 5401.8 |
211 | 2024-03-26 04:16:07 | establisher | 2 | 86808 | 7 | 7.423 | 11694.5 |
210 | 2024-03-26 03:41:06 | establisher | 1 | 49908 | 4 | 0.923 | 54071.5 |
209 | 2024-03-22 04:43:21 | establisher | 3 | 121633 | 13 | 16.673 | 7295.2 |
208 | 2024-03-21 13:31:25 | establisher | 5 | 164607 | 215 | 53.800 | 3059.6 |
207 | 2024-03-20 11:43:31 | establisher | 3 | 121633 | 13 | 15.346 | 7926.0 |
206 | 2024-03-20 11:43:28 | establisher | 2 | 86808 | 7 | 7.390 | 11746.7 |
205 | 2024-03-20 11:35:04 | establisher | 1 | 49908 | 4 | 0.923 | 54071.5 |
204 | 2024-03-19 01:27:24 | establisher | 5 | 164607 | 215 | 40.376 | 4076.9 |
203 | 2024-03-18 10:49:38 | establisher | 4 | 148819 | 38 | 14.906 | 9983.8 |
202 | 2024-03-18 00:24:54 | establisher | 5 | 164607 | 215 | 19.593 | 8401.3 |
201 | 2024-03-17 10:27:27 | establisher | 5 | 164607 | 215 | 31.753 | 5184.0 |
200 | 2024-03-17 10:27:35 | establisher | 1 | 49908 | 4 | 1.826 | 27331.9 |
199 | 2024-03-17 10:27:29 | establisher | 3 | 121633 | 13 | 6.280 | 19368.3 |
198 | 2024-03-17 10:27:23 | establisher | 4 | 148819 | 38 | 11.203 | 13283.9 |
197 | 2024-03-17 10:27:25 | establisher | 2 | 86808 | 7 | 2.576 | 33698.8 |
196 | 2024-03-17 10:26:43 | establisher | 1 | 49908 | 4 | 0.843 | 59202.8 |
195 | 2024-02-17 10:41:48 | establisher | 1 | 49908 | 4 | 0.843 | 59202.8 |
194 | 2024-02-14 17:30:55 | establisher | 5 | 164607 | 215 | 59.940 | 2746.2 |
193 | 2024-02-14 06:11:26 | establisher | 2 | 86808 | 7 | 4.513 | 19235.1 |
192 | 2024-02-14 06:10:05 | establisher | 3 | 121633 | 13 | 5.016 | 24249.0 |
191 | 2024-02-14 00:46:15 | establisher | 5 | 164607 | 215 | 34.796 | 4730.6 |
190 | 2024-02-13 20:40:31 | establisher | 5 | 164607 | 215 | 46.786 | 3518.3 |
189 | 2024-02-13 20:40:33 | establisher | 2 | 86808 | 7 | 6.186 | 14033.0 |
188 | 2024-02-13 20:39:38 | establisher | 1 | 49908 | 4 | 1.530 | 32619.6 |
187 | 2024-02-13 20:24:18 | establisher | 1 | 49908 | 4 | 0.813 | 61387.5 |
186 | 2024-02-13 12:36:15 | establisher | 1 | 49908 | 4 | 1.656 | 30137.7 |
185 | 2024-02-12 16:53:32 | establisher | 1 | 49908 | 4 | 2.266 | 22024.7 |
184 | 2024-02-11 08:38:39 | establisher | 3 | 121633 | 13 | 6.610 | 18401.4 |
183 | 2024-02-10 10:30:22 | establisher | 1 | 49908 | 4 | 0.953 | 52369.4 |
182 | 2024-02-06 08:02:34 | establisher | 4 | 148819 | 38 | 10.703 | 13904.4 |
181 | 2024-01-29 23:58:45 | establisher | 1 | 49908 | 4 | 0.736 | 67809.8 |
180 | 2024-01-17 21:42:00 | establisher | 3 | 121633 | 13 | 4.703 | 25862.9 |
179 | 2024-01-06 10:39:22 | establisher | 1 | 49908 | 4 | 0.876 | 56972.6 |
178 | 2023-12-23 06:25:20 | establisher | 4 | 148819 | 38 | 8.250 | 18038.7 |
177 | 2023-12-06 20:06:25 | establisher | 1 | 49908 | 4 | 0.750 | 66544.0 |
176 | 2023-12-06 01:56:30 | establisher | 1 | 49908 | 4 | 0.843 | 59202.8 |
175 | 2023-11-26 00:44:30 | establisher | 1 | 49908 | 4 | 0.750 | 66544.0 |
174 | 2023-11-05 21:47:30 | establisher | 1 | 49908 | 4 | 0.843 | 59202.8 |
173 | 2023-10-28 22:47:33 | establisher | 3 | 121633 | 13 | 6.220 | 19555.1 |
172 | 2023-09-23 10:57:24 | establisher | 4 | 148819 | 38 | 9.030 | 16480.5 |
171 | 2023-09-21 11:36:12 | establisher | 1 | 49908 | 4 | 0.873 | 57168.4 |
170 | 2023-08-05 06:50:46 | establisher | 3 | 121633 | 13 | 4.530 | 26850.6 |
169 | 2023-07-15 08:36:24 | establisher | 1 | 49908 | 4 | 0.813 | 61387.5 |
168 | 2023-07-10 00:55:28 | establisher | 1 | 49908 | 4 | 0.736 | 67809.8 |
167 | 2023-07-02 01:54:43 | establisher | 4 | 148819 | 38 | 8.123 | 18320.7 |
166 | 2023-04-19 12:14:50 | establisher | 3 | 121633 | 13 | 4.343 | 28006.7 |
165 | 2023-04-18 04:46:58 | establisher | 1 | 49908 | 4 | 0.750 | 66544.0 |
164 | 2023-03-24 08:11:50 | establisher | 4 | 148819 | 38 | 9.110 | 16335.8 |
163 | 2023-02-21 21:24:11 | establisher | 1 | 49908 | 4 | 0.736 | 67809.8 |
162 | 2023-02-10 02:31:07 | establisher | 1 | 49908 | 4 | 0.983 | 50771.1 |
161 | 2023-01-20 13:52:42 | establisher | 3 | 121633 | 13 | 4.346 | 27987.3 |
160 | 2022-12-23 13:16:29 | establisher | 4 | 148819 | 38 | 7.876 | 18895.3 |
159 | 2022-12-07 19:14:14 | establisher | 1 | 49908 | 4 | 0.813 | 61387.5 |
158 | 2022-10-31 20:48:06 | establisher | 3 | 121633 | 13 | 4.436 | 27419.5 |
157 | 2022-09-26 03:16:02 | establisher | 1 | 49908 | 4 | 0.983 | 50771.1 |
156 | 2022-08-23 04:16:11 | establisher | 4 | 148819 | 38 | 8.830 | 16853.8 |
155 | 2022-08-06 15:57:18 | establisher | 1 | 49908 | 4 | 0.750 | 66544.0 |
154 | 2022-08-04 07:53:35 | establisher | 1 | 49908 | 4 | 0.736 | 67809.8 |
153 | 2022-07-01 17:25:00 | establisher | 2 | 86808 | 7 | 2.033 | 42699.5 |
152 | 2022-06-02 16:02:07 | establisher | 3 | 121633 | 13 | 4.483 | 27132.1 |
151 | 2022-05-06 02:21:53 | establisher | 1 | 49908 | 4 | 0.720 | 69316.7 |
150 | 2022-04-12 20:45:06 | establisher | 1 | 49908 | 4 | 1.186 | 42080.9 |
149 | 2022-01-02 05:26:35 | establisher | 1 | 49908 | 4 | 0.920 | 54247.8 |
148 | 2021-08-31 06:24:33 | establisher | 1 | 49908 | 4 | 0.766 | 65154.0 |
147 | 2021-05-17 07:02:57 | establisher | 1 | 49908 | 4 | 0.860 | 58032.6 |
146 | 2021-03-23 16:53:14 | establisher | 4 | 148819 | 38 | 11.220 | 13263.7 |
145 | 2021-02-28 03:02:20 | establisher | 1 | 49908 | 4 | 0.733 | 68087.3 |
144 | 2021-02-25 23:59:16 | establisher | 4 | 148819 | 38 | 8.123 | 18320.7 |
143 | 2021-01-31 20:15:26 | establisher | 1 | 49908 | 4 | 0.750 | 66544.0 |
142 | 2020-12-20 09:41:14 | establisher | 5 | 164607 | 215 | 14.376 | 11450.1 |
141 | 2020-11-04 11:27:21 | establisher | 1 | 49908 | 4 | 0.890 | 56076.4 |
140 | 2020-10-21 15:29:22 | establisher | 1 | 49908 | 4 | 0.783 | 63739.5 |
139 | 2020-10-19 08:41:29 | establisher | 1 | 49908 | 4 | 0.813 | 61387.5 |
138 | 2020-06-20 00:38:46 | establisher | 1 | 49908 | 4 | 1.060 | 47083.0 |
137 | 2020-03-27 19:17:29 | establisher | 1 | 49908 | 4 | 0.766 | 65154.0 |
136 | 2020-03-26 16:59:01 | establisher | 1 | 49908 | 4 | 0.890 | 56076.4 |
135 | 2020-03-14 23:44:36 | establisher | 1 | 49908 | 4 | 0.763 | 65410.2 |
134 | 2020-02-17 02:22:03 | establisher | 1 | 49908 | 4 | 1.860 | 26832.3 |
133 | 2020-02-11 05:55:14 | establisher | 1 | 49908 | 4 | 0.843 | 59202.8 |
132 | 2020-02-10 09:25:35 | establisher | 1 | 49908 | 4 | 1.000 | 49908.0 |
131 | 2020-02-03 00:08:53 | establisher | 1 | 49908 | 4 | 2.906 | 17174.1 |
130 | 2020-01-21 20:42:54 | establisher | 1 | 49908 | 4 | 0.923 | 54071.5 |
129 | 2020-01-21 17:17:33 | establisher | 1 | 49908 | 4 | 0.970 | 51451.5 |
128 | 2020-01-15 20:08:20 | establisher | 1 | 49908 | 4 | 0.826 | 60421.3 |
127 | 2020-01-07 00:07:46 | establisher | 1 | 49908 | 4 | 1.500 | 33272.0 |
126 | 2019-12-06 08:19:03 | establisher | 1 | 49908 | 4 | 0.826 | 60421.3 |
125 | 2019-11-19 06:03:00 | establisher | 3 | 121633 | 13 | 4.516 | 26933.8 |
124 | 2019-09-04 05:52:36 | establisher | 1 | 49908 | 4 | 0.816 | 61161.8 |
123 | 2019-05-23 03:55:56 | establisher | 1 | 49908 | 4 | 0.766 | 65154.0 |
122 | 2019-01-25 19:40:14 | establisher | 1 | 49908 | 4 | 0.730 | 68367.1 |
121 | 2018-11-27 03:09:24 | establisher | 1 | 49908 | 4 | 0.840 | 59414.3 |
120 | 2018-11-22 15:33:40 | establisher | 1 | 49908 | 4 | 0.706 | 70691.2 |
119 | 2018-09-16 23:57:34 | establisher | 1 | 49908 | 4 | 0.963 | 51825.5 |