History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prewash"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
200 | 2024-05-02 06:37:08 | prewash | 1 | 69583 | 2 | 1.373 | 50679.5 |
199 | 2024-04-27 03:21:12 | prewash | 1 | 69583 | 2 | 1.360 | 51164.0 |
198 | 2024-04-12 01:24:39 | prewash | 1 | 69583 | 2 | 3.826 | 18186.9 |
197 | 2024-02-28 18:54:05 | prewash | 1 | 69583 | 2 | 1.093 | 63662.4 |
196 | 2024-01-12 22:35:36 | prewash | 1 | 69583 | 2 | 1.080 | 64428.7 |
195 | 2023-12-26 12:54:13 | prewash | 3 | 134027 | 161 | 8.156 | 16432.9 |
194 | 2023-12-09 03:00:19 | prewash | 1 | 69583 | 2 | 1.156 | 60192.9 |
193 | 2023-12-08 22:41:04 | prewash | 1 | 69583 | 2 | 1.126 | 61796.6 |
192 | 2023-12-08 07:58:38 | prewash | 1 | 69583 | 2 | 1.250 | 55666.4 |
191 | 2023-12-08 07:58:36 | prewash | 1 | 69583 | 2 | 1.203 | 57841.2 |
190 | 2023-12-03 04:59:15 | prewash | 1 | 69583 | 2 | 1.186 | 58670.3 |
189 | 2023-12-03 04:59:14 | prewash | 1 | 69583 | 2 | 1.140 | 61037.7 |
188 | 2023-11-19 01:02:23 | prewash | 1 | 69583 | 2 | 1.220 | 57035.2 |
187 | 2023-10-08 08:52:33 | prewash | 1 | 69583 | 2 | 2.546 | 27330.3 |
186 | 2023-10-08 08:46:09 | prewash | 2 | 107671 | 12 | 3.263 | 32997.5 |
185 | 2023-10-03 14:10:21 | prewash | 3 | 134027 | 161 | 8.033 | 16684.6 |
184 | 2023-10-01 14:37:24 | prewash | 3 | 134027 | 161 | 7.703 | 17399.3 |
183 | 2023-09-28 09:26:19 | prewash | 1 | 69583 | 2 | 1.296 | 53690.6 |
182 | 2023-09-27 09:48:33 | prewash | 3 | 134027 | 161 | 13.423 | 9984.9 |
181 | 2023-09-23 12:08:51 | prewash | 1 | 69583 | 2 | 1.220 | 57035.2 |
180 | 2023-09-22 21:14:32 | prewash | 1 | 69583 | 2 | 1.076 | 64668.2 |
179 | 2023-08-23 18:35:11 | prewash | 1 | 69583 | 2 | 1.780 | 39091.6 |
178 | 2023-07-15 17:54:11 | prewash | 1 | 69583 | 2 | 1.203 | 57841.2 |
177 | 2023-07-07 19:11:35 | prewash | 3 | 134027 | 161 | 5.796 | 23124.1 |
176 | 2023-04-21 16:21:54 | prewash | 1 | 69583 | 2 | 1.080 | 64428.7 |
175 | 2023-04-17 07:41:14 | prewash | 1 | 69583 | 2 | 1.266 | 54962.9 |
174 | 2023-03-25 16:29:36 | prewash | 3 | 134027 | 161 | 6.720 | 19944.5 |
173 | 2023-02-09 16:56:49 | prewash | 1 | 69583 | 2 | 1.186 | 58670.3 |
172 | 2023-01-29 01:00:12 | prewash | 3 | 134027 | 161 | 6.326 | 21186.7 |
171 | 2022-12-24 00:10:37 | prewash | 3 | 134027 | 161 | 5.780 | 23188.1 |
170 | 2022-12-14 05:13:09 | prewash | 3 | 134027 | 161 | 7.546 | 17761.3 |
169 | 2022-12-08 13:07:53 | prewash | 1 | 69583 | 2 | 1.060 | 65644.3 |
168 | 2022-12-07 15:35:35 | prewash | 1 | 69583 | 2 | 1.063 | 65459.1 |
167 | 2022-11-01 01:17:38 | prewash | 3 | 134027 | 161 | 6.563 | 20421.6 |
166 | 2022-08-23 01:54:56 | prewash | 3 | 134027 | 161 | 5.970 | 22450.1 |
165 | 2022-08-06 03:49:00 | prewash | 1 | 69583 | 2 | 1.093 | 63662.4 |
164 | 2022-08-03 19:02:15 | prewash | 1 | 69583 | 2 | 1.263 | 55093.4 |
163 | 2022-07-22 00:32:31 | prewash | 1 | 69583 | 2 | 1.076 | 64668.2 |
162 | 2022-07-11 14:21:17 | prewash | 1 | 69583 | 2 | 1.173 | 59320.5 |
161 | 2022-05-16 09:28:00 | prewash | 1 | 69583 | 2 | 1.283 | 54234.6 |
160 | 2022-04-27 15:15:53 | prewash | 1 | 69583 | 2 | 1.360 | 51164.0 |
159 | 2022-03-07 06:55:08 | prewash | 1 | 69583 | 2 | 1.063 | 65459.1 |
158 | 2022-03-03 20:36:10 | prewash | 1 | 69583 | 2 | 1.280 | 54361.7 |
157 | 2021-10-31 00:56:39 | prewash | 1 | 69583 | 2 | 1.110 | 62687.4 |
156 | 2021-07-13 19:24:55 | prewash | 1 | 69583 | 2 | 1.063 | 65459.1 |
155 | 2021-04-10 11:21:24 | prewash | 1 | 69583 | 2 | 1.203 | 57841.2 |
154 | 2021-02-13 11:51:18 | prewash | 1 | 69583 | 2 | 1.080 | 64428.7 |
153 | 2020-12-24 18:29:44 | prewash | 1 | 69583 | 2 | 1.266 | 54962.9 |
152 | 2020-10-23 18:37:35 | prewash | 1 | 69583 | 2 | 1.343 | 51811.6 |
151 | 2020-10-21 08:31:09 | prewash | 1 | 69583 | 2 | 1.610 | 43219.3 |
150 | 2020-10-04 10:02:31 | prewash | 1 | 69583 | 2 | 1.063 | 65459.1 |
149 | 2020-09-20 21:55:33 | prewash | 1 | 69583 | 2 | 1.093 | 63662.4 |
148 | 2020-06-09 11:09:26 | prewash | 1 | 69583 | 2 | 1.170 | 59472.6 |
147 | 2020-06-04 12:40:34 | prewash | 1 | 69583 | 2 | 1.093 | 63662.4 |
146 | 2020-03-29 22:51:21 | prewash | 1 | 69583 | 2 | 1.250 | 55666.4 |
145 | 2020-03-29 17:03:26 | prewash | 1 | 69583 | 2 | 1.440 | 48321.5 |
144 | 2020-03-27 18:04:50 | prewash | 1 | 69583 | 2 | 1.170 | 59472.6 |
143 | 2020-03-27 00:52:40 | prewash | 1 | 69583 | 2 | 1.310 | 53116.8 |
142 | 2020-03-21 07:47:47 | prewash | 1 | 69583 | 2 | 1.780 | 39091.6 |
141 | 2020-03-13 00:37:25 | prewash | 1 | 69583 | 2 | 1.283 | 54234.6 |
140 | 2020-02-25 13:13:41 | prewash | 1 | 69583 | 2 | 1.423 | 48898.8 |
139 | 2020-02-25 02:39:49 | prewash | 1 | 69583 | 2 | 2.546 | 27330.3 |
138 | 2020-02-23 01:23:37 | prewash | 1 | 69583 | 2 | 4.076 | 17071.4 |
137 | 2020-02-22 14:53:49 | prewash | 1 | 69583 | 2 | 2.783 | 25002.9 |
136 | 2020-02-22 12:51:29 | prewash | 1 | 69583 | 2 | 1.266 | 54962.9 |
135 | 2020-02-21 08:19:02 | prewash | 1 | 69583 | 2 | 1.093 | 63662.4 |
134 | 2020-02-13 15:46:59 | prewash | 1 | 69583 | 2 | 1.360 | 51164.0 |
133 | 2020-02-04 14:52:58 | prewash | 1 | 69583 | 2 | 1.936 | 35941.6 |
132 | 2020-01-26 19:19:16 | prewash | 1 | 69583 | 2 | 1.343 | 51811.6 |
131 | 2020-01-26 16:42:50 | prewash | 1 | 69583 | 2 | 1.330 | 52318.0 |
130 | 2020-01-21 12:56:00 | prewash | 1 | 69583 | 2 | 4.250 | 16372.5 |
129 | 2020-01-20 17:43:34 | prewash | 1 | 69583 | 2 | 2.796 | 24886.6 |
128 | 2020-01-15 17:09:35 | prewash | 1 | 69583 | 2 | 1.266 | 54962.9 |
127 | 2020-01-07 00:38:51 | prewash | 1 | 69583 | 2 | 1.546 | 45008.4 |
126 | 2020-01-06 01:34:08 | prewash | 1 | 69583 | 2 | 1.220 | 57035.2 |
125 | 2020-01-03 02:22:38 | prewash | 1 | 69583 | 2 | 2.563 | 27149.0 |
124 | 2019-12-29 04:37:50 | prewash | 1 | 69583 | 2 | 2.720 | 25582.0 |
123 | 2019-12-29 02:04:20 | prewash | 1 | 69583 | 2 | 1.233 | 56433.9 |
122 | 2019-11-21 00:37:52 | prewash | 1 | 69583 | 2 | 1.186 | 58670.3 |
121 | 2019-09-20 15:32:02 | prewash | 1 | 69583 | 2 | 1.033 | 67360.1 |
120 | 2019-08-30 23:37:21 | prewash | 1 | 69583 | 2 | 1.063 | 65459.1 |
119 | 2019-08-26 11:40:21 | prewash | 1 | 69583 | 2 | 1.130 | 61577.9 |
118 | 2019-08-22 07:25:04 | prewash | 1 | 69583 | 2 | 1.056 | 65893.0 |
117 | 2019-07-30 21:05:34 | prewash | 2 | 107671 | 12 | 2.836 | 37965.8 |
116 | 2019-07-28 21:42:39 | prewash | 1 | 69583 | 2 | 1.050 | 66269.5 |
115 | 2019-06-18 17:05:49 | prewash | 1 | 69583 | 2 | 1.220 | 57035.2 |
114 | 2019-05-09 23:34:02 | prewash | 1 | 69583 | 2 | 1.083 | 64250.2 |
113 | 2019-01-18 20:02:24 | prewash | 1 | 69583 | 2 | 1.200 | 57985.8 |
112 | 2018-09-16 10:59:26 | prewash | 1 | 69583 | 2 | 1.243 | 55979.9 |
111 | 2018-08-10 07:34:14 | prewash | 1 | 69583 | 2 | 2.320 | 29992.7 |
110 | 2018-08-08 14:56:23 | prewash | 1 | 69583 | 2 | 1.456 | 47790.5 |
109 | 2018-08-07 00:56:39 | prewash | 1 | 69583 | 2 | 1.293 | 53815.2 |
108 | 2018-07-29 23:50:45 | prewash | 1 | 69583 | 2 | 1.306 | 53279.5 |
107 | 2018-07-27 14:14:10 | prewash | 1 | 69583 | 2 | 1.220 | 57035.2 |
106 | 2018-07-25 08:15:02 | prewash | 1 | 69583 | 2 | 1.103 | 63085.2 |
105 | 2018-07-07 12:05:48 | prewash | 1 | 69583 | 2 | 1.180 | 58968.6 |
104 | 2018-07-05 07:58:38 | prewash | 1 | 69583 | 2 | 1.070 | 65030.8 |
103 | 2018-06-26 18:06:18 | prewash | 1 | 69583 | 2 | 1.140 | 61037.7 |
102 | 2018-06-15 20:27:53 | prewash | 1 | 69583 | 2 | 1.190 | 58473.1 |
101 | 2018-05-12 06:22:25 | prewash | 1 | 69583 | 2 | 1.186 | 58670.3 |