History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"substantive"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
216 | 2024-04-28 01:46:18 | substantive | 1 | 49908 | 2 | 2.266 | 22024.7 |
215 | 2024-04-22 22:03:19 | substantive | 2 | 86808 | 7 | 2.296 | 37808.4 |
214 | 2024-04-16 20:29:21 | substantive | 5 | 164607 | 233 | 62.503 | 2633.6 |
213 | 2024-04-16 06:52:41 | substantive | 4 | 148819 | 46 | 9.250 | 16088.5 |
212 | 2024-04-15 00:06:28 | substantive | 4 | 148819 | 46 | 31.923 | 4661.8 |
211 | 2024-04-14 14:05:11 | substantive | 2 | 86808 | 7 | 6.516 | 13322.3 |
210 | 2024-04-14 14:01:56 | substantive | 1 | 49908 | 2 | 3.250 | 15356.3 |
209 | 2024-04-14 14:01:44 | substantive | 1 | 49908 | 2 | 3.013 | 16564.2 |
208 | 2024-04-14 11:31:48 | substantive | 4 | 148819 | 46 | 30.986 | 4802.8 |
207 | 2024-04-14 11:31:51 | substantive | 3 | 121633 | 19 | 16.503 | 7370.4 |
206 | 2024-04-14 11:31:47 | substantive | 2 | 86808 | 7 | 9.093 | 9546.7 |
205 | 2024-04-14 02:47:30 | substantive | 5 | 164607 | 233 | 34.033 | 4836.7 |
204 | 2024-04-12 02:56:40 | substantive | 5 | 164607 | 233 | 28.753 | 5724.9 |
203 | 2024-04-12 02:56:40 | substantive | 3 | 121633 | 19 | 15.063 | 8075.0 |
202 | 2024-04-12 02:56:37 | substantive | 4 | 148819 | 46 | 17.486 | 8510.8 |
201 | 2024-04-12 02:56:42 | substantive | 2 | 86808 | 7 | 12.503 | 6943.0 |
200 | 2024-04-12 02:52:20 | substantive | 1 | 49908 | 2 | 1.923 | 25953.2 |
199 | 2024-04-07 23:30:48 | substantive | 2 | 86808 | 7 | 7.046 | 12320.2 |
198 | 2024-04-07 23:23:53 | substantive | 1 | 49908 | 2 | 1.123 | 44441.7 |
197 | 2024-04-03 10:47:31 | substantive | 3 | 121633 | 19 | 15.126 | 8041.3 |
196 | 2024-04-03 10:47:30 | substantive | 2 | 86808 | 7 | 3.096 | 28038.8 |
195 | 2024-04-03 10:47:19 | substantive | 1 | 49908 | 2 | 2.983 | 16730.8 |
194 | 2024-03-16 13:10:03 | substantive | 4 | 148819 | 46 | 22.063 | 6745.2 |
193 | 2024-03-14 21:12:48 | substantive | 4 | 148819 | 46 | 33.550 | 4435.7 |
192 | 2024-03-14 09:28:03 | substantive | 4 | 148819 | 46 | 33.893 | 4390.8 |
191 | 2024-03-14 09:28:01 | substantive | 3 | 121633 | 19 | 17.890 | 6798.9 |
190 | 2024-03-14 04:40:39 | substantive | 5 | 164607 | 233 | 45.876 | 3588.1 |
189 | 2024-03-14 01:26:05 | substantive | 5 | 164607 | 233 | 38.113 | 4318.9 |
188 | 2024-03-14 01:26:16 | substantive | 3 | 121633 | 19 | 16.673 | 7295.2 |
187 | 2024-03-14 01:26:01 | substantive | 4 | 148819 | 46 | 19.220 | 7742.9 |
186 | 2024-03-14 01:26:14 | substantive | 2 | 86808 | 7 | 2.826 | 30717.6 |
185 | 2024-03-14 01:25:05 | substantive | 1 | 49908 | 2 | 2.876 | 17353.3 |
184 | 2024-03-14 01:23:56 | substantive | 5 | 164607 | 233 | 26.296 | 6259.8 |
183 | 2024-03-14 01:23:58 | substantive | 4 | 148819 | 46 | 23.660 | 6289.9 |
182 | 2024-03-14 01:24:14 | substantive | 1 | 49908 | 2 | 2.893 | 17251.3 |
181 | 2024-03-14 01:23:57 | substantive | 3 | 121633 | 19 | 6.266 | 19411.6 |
180 | 2024-03-14 01:23:56 | substantive | 2 | 86808 | 7 | 4.106 | 21141.7 |
179 | 2024-03-14 01:23:52 | substantive | 1 | 49908 | 2 | 1.033 | 48313.6 |
178 | 2024-02-11 18:20:59 | substantive | 1 | 49908 | 2 | 2.686 | 18580.8 |
177 | 2024-02-10 04:49:19 | substantive | 4 | 148819 | 46 | 19.813 | 7511.2 |
176 | 2024-02-10 04:32:30 | substantive | 3 | 121633 | 19 | 18.330 | 6635.7 |
175 | 2024-02-10 04:32:30 | substantive | 2 | 86808 | 7 | 8.266 | 10501.8 |
174 | 2024-02-10 03:06:20 | substantive | 1 | 49908 | 2 | 0.750 | 66544.0 |
173 | 2024-02-08 16:09:55 | substantive | 5 | 164607 | 233 | 54.050 | 3045.5 |
172 | 2024-02-08 16:09:55 | substantive | 4 | 148819 | 46 | 30.373 | 4899.7 |
171 | 2024-02-08 14:28:25 | substantive | 1 | 49908 | 2 | 0.890 | 56076.4 |
170 | 2024-01-31 13:17:11 | substantive | 1 | 49908 | 2 | 0.920 | 54247.8 |
169 | 2024-01-31 06:00:10 | substantive | 1 | 49908 | 2 | 1.656 | 30137.7 |
168 | 2024-01-31 04:47:27 | substantive | 1 | 49908 | 2 | 0.843 | 59202.8 |
167 | 2024-01-21 15:21:10 | substantive | 1 | 49908 | 2 | 0.750 | 66544.0 |
166 | 2023-12-18 09:28:13 | substantive | 1 | 49908 | 2 | 1.813 | 27527.9 |
165 | 2023-12-17 23:09:25 | substantive | 2 | 86808 | 7 | 2.296 | 37808.4 |
164 | 2023-12-12 12:51:02 | substantive | 4 | 148819 | 46 | 8.093 | 18388.6 |
163 | 2023-11-17 10:31:19 | substantive | 1 | 49908 | 2 | 0.733 | 68087.3 |
162 | 2023-10-06 11:34:00 | substantive | 1 | 49908 | 2 | 0.810 | 61614.8 |
161 | 2023-09-18 14:10:31 | substantive | 2 | 86808 | 7 | 2.033 | 42699.5 |
160 | 2023-09-13 18:58:05 | substantive | 4 | 148819 | 46 | 7.860 | 18933.7 |
159 | 2023-09-04 03:39:54 | substantive | 1 | 49908 | 2 | 0.736 | 67809.8 |
158 | 2023-06-25 02:36:32 | substantive | 2 | 86808 | 7 | 2.143 | 40507.7 |
157 | 2023-06-13 13:39:24 | substantive | 4 | 148819 | 46 | 7.830 | 19006.3 |
156 | 2023-03-21 04:07:04 | substantive | 2 | 86808 | 7 | 2.266 | 38308.9 |
155 | 2023-03-16 07:20:51 | substantive | 4 | 148819 | 46 | 7.593 | 19599.5 |
154 | 2023-01-18 11:09:58 | substantive | 1 | 49908 | 2 | 0.716 | 69703.9 |
153 | 2022-12-20 19:22:52 | substantive | 2 | 86808 | 7 | 1.986 | 43710.0 |
152 | 2022-12-17 23:20:10 | substantive | 4 | 148819 | 46 | 8.626 | 17252.4 |
151 | 2022-11-15 04:59:53 | substantive | 1 | 49908 | 2 | 0.733 | 68087.3 |
150 | 2022-08-17 19:11:59 | substantive | 2 | 86808 | 7 | 2.000 | 43404.0 |
149 | 2022-08-12 14:35:22 | substantive | 4 | 148819 | 46 | 7.690 | 19352.3 |
148 | 2022-08-12 14:35:12 | substantive | 4 | 148819 | 46 | 7.920 | 18790.3 |
147 | 2022-07-06 00:47:41 | substantive | 1 | 49908 | 2 | 0.780 | 63984.6 |
146 | 2022-03-19 10:56:37 | substantive | 1 | 49908 | 2 | 0.750 | 66544.0 |
145 | 2021-02-19 16:49:28 | substantive | 1 | 49908 | 2 | 0.860 | 58032.6 |
144 | 2020-11-01 23:02:10 | substantive | 1 | 49908 | 2 | 0.826 | 60421.3 |
143 | 2020-10-28 01:59:45 | substantive | 1 | 49908 | 2 | 0.826 | 60421.3 |
142 | 2020-04-02 13:20:40 | substantive | 1 | 49908 | 2 | 0.843 | 59202.8 |
141 | 2020-03-25 08:56:48 | substantive | 1 | 49908 | 2 | 0.750 | 66544.0 |
140 | 2020-03-06 00:26:22 | substantive | 1 | 49908 | 2 | 1.796 | 27788.4 |
139 | 2020-03-05 23:06:44 | substantive | 1 | 49908 | 2 | 0.876 | 56972.6 |
138 | 2020-02-28 14:17:53 | substantive | 1 | 49908 | 2 | 0.983 | 50771.1 |
137 | 2020-02-17 00:32:44 | substantive | 1 | 49908 | 2 | 1.750 | 28518.9 |
136 | 2020-02-16 19:45:21 | substantive | 1 | 49908 | 2 | 0.876 | 56972.6 |
135 | 2020-02-14 15:13:28 | substantive | 1 | 49908 | 2 | 1.873 | 26646.0 |
134 | 2020-02-11 10:59:49 | substantive | 1 | 49908 | 2 | 1.593 | 31329.6 |
133 | 2020-01-24 11:07:09 | substantive | 1 | 49908 | 2 | 3.203 | 15581.6 |
132 | 2020-01-20 08:21:18 | substantive | 1 | 49908 | 2 | 0.843 | 59202.8 |
131 | 2020-01-20 06:37:08 | substantive | 1 | 49908 | 2 | 0.903 | 55269.1 |
130 | 2020-01-13 23:57:12 | substantive | 1 | 49908 | 2 | 0.953 | 52369.4 |
129 | 2020-01-02 19:07:28 | substantive | 1 | 49908 | 2 | 0.810 | 61614.8 |
128 | 2019-12-13 21:35:41 | substantive | 1 | 49908 | 2 | 0.750 | 66544.0 |
127 | 2019-09-12 06:51:25 | substantive | 1 | 49908 | 2 | 0.690 | 72330.4 |
126 | 2019-05-31 06:06:41 | substantive | 1 | 49908 | 2 | 1.610 | 30998.8 |
125 | 2019-01-27 17:55:04 | substantive | 1 | 49908 | 2 | 0.830 | 60130.1 |
124 | 2018-12-09 00:07:07 | substantive | 1 | 49908 | 2 | 0.736 | 67809.8 |
123 | 2018-09-18 18:46:09 | substantive | 1 | 49908 | 2 | 0.820 | 60863.4 |
122 | 2018-06-19 17:45:00 | substantive | 1 | 49908 | 2 | 0.950 | 52534.7 |
121 | 2018-06-19 16:07:47 | substantive | 1 | 49908 | 2 | 0.920 | 54247.8 |
120 | 2018-06-17 03:42:50 | substantive | 1 | 49908 | 2 | 0.833 | 59913.6 |
119 | 2018-04-01 07:20:44 | substantive | 1 | 49908 | 2 | 1.070 | 46643.0 |
118 | 2017-12-02 14:29:57 | substantive | 1 | 49908 | 2 | 1.433 | 34827.6 |
117 | 2017-12-01 20:12:33 | substantive | 1 | 49908 | 2 | 1.153 | 43285.3 |