History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"workshop"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
197 | 2024-05-05 11:19:17 | workshop | 1 | 82945 | 2 | 1.483 | 55930.5 |
196 | 2024-05-04 20:25:24 | workshop | 4 | 161609 | 209 | 15.783 | 10239.4 |
195 | 2024-05-04 10:44:12 | workshop | 4 | 161609 | 209 | 17.750 | 9104.7 |
194 | 2024-05-04 09:18:23 | workshop | 4 | 161609 | 209 | 26.160 | 6177.7 |
193 | 2024-05-04 09:18:15 | workshop | 3 | 146162 | 26 | 13.343 | 10954.2 |
192 | 2024-05-04 09:18:19 | workshop | 2 | 121059 | 6 | 3.856 | 31395.0 |
191 | 2024-05-04 09:16:15 | workshop | 1 | 82945 | 2 | 1.563 | 53067.8 |
190 | 2024-05-01 10:49:54 | workshop | 1 | 82945 | 2 | 3.220 | 25759.3 |
189 | 2024-04-05 16:24:44 | workshop | 4 | 161609 | 209 | 14.330 | 11277.7 |
188 | 2024-04-05 16:24:43 | workshop | 2 | 121059 | 6 | 8.830 | 13710.0 |
187 | 2024-04-05 16:24:41 | workshop | 1 | 82945 | 2 | 2.936 | 28251.0 |
186 | 2024-04-01 23:00:55 | workshop | 3 | 146162 | 26 | 7.783 | 18779.6 |
185 | 2024-03-31 19:34:32 | workshop | 3 | 146162 | 26 | 8.750 | 16704.2 |
184 | 2024-03-30 20:29:28 | workshop | 4 | 161609 | 209 | 36.910 | 4378.5 |
183 | 2024-03-30 04:04:57 | workshop | 4 | 161609 | 209 | 42.190 | 3830.5 |
182 | 2024-03-29 09:50:09 | workshop | 4 | 161609 | 209 | 25.206 | 6411.5 |
181 | 2024-03-29 09:50:11 | workshop | 3 | 146162 | 26 | 17.486 | 8358.8 |
180 | 2024-03-29 09:50:10 | workshop | 2 | 121059 | 6 | 5.813 | 20825.6 |
179 | 2024-03-27 19:57:09 | workshop | 1 | 82945 | 2 | 2.860 | 29001.7 |
178 | 2024-03-20 02:17:21 | workshop | 3 | 146162 | 26 | 10.140 | 14414.4 |
177 | 2024-03-20 02:17:23 | workshop | 2 | 121059 | 6 | 7.766 | 15588.3 |
176 | 2024-03-20 02:17:05 | workshop | 1 | 82945 | 2 | 1.236 | 67107.6 |
175 | 2024-03-07 19:18:10 | workshop | 3 | 146162 | 26 | 14.643 | 9981.7 |
174 | 2024-03-06 09:10:23 | workshop | 4 | 161609 | 209 | 25.453 | 6349.3 |
173 | 2024-03-06 09:10:42 | workshop | 2 | 121059 | 6 | 6.920 | 17494.1 |
172 | 2024-03-06 09:10:32 | workshop | 1 | 82945 | 2 | 3.940 | 21052.0 |
171 | 2024-03-06 09:10:22 | workshop | 2 | 121059 | 6 | 4.156 | 29128.7 |
170 | 2024-03-06 09:10:20 | workshop | 1 | 82945 | 2 | 3.063 | 27079.7 |
169 | 2024-03-02 16:12:01 | workshop | 3 | 146162 | 26 | 15.563 | 9391.6 |
168 | 2024-03-01 14:15:00 | workshop | 3 | 146162 | 26 | 9.110 | 16044.1 |
167 | 2024-03-01 09:27:06 | workshop | 3 | 146162 | 26 | 16.250 | 8994.6 |
166 | 2024-02-29 07:53:43 | workshop | 1 | 82945 | 2 | 3.076 | 26965.2 |
165 | 2024-02-27 11:31:43 | workshop | 4 | 161609 | 209 | 12.970 | 12460.2 |
164 | 2024-02-26 11:06:31 | workshop | 4 | 161609 | 209 | 17.000 | 9506.4 |
163 | 2024-02-26 11:06:28 | workshop | 3 | 146162 | 26 | 10.580 | 13814.9 |
162 | 2024-02-26 11:06:29 | workshop | 2 | 121059 | 6 | 4.033 | 30017.1 |
161 | 2024-02-05 10:51:07 | workshop | 1 | 82945 | 2 | 1.356 | 61168.9 |
160 | 2024-02-04 13:22:11 | workshop | 4 | 161609 | 209 | 18.893 | 8553.9 |
159 | 2024-02-04 10:01:20 | workshop | 4 | 161609 | 209 | 28.986 | 5575.4 |
158 | 2024-02-04 08:10:27 | workshop | 2 | 121059 | 6 | 11.373 | 10644.4 |
157 | 2024-02-03 07:38:54 | workshop | 1 | 82945 | 2 | 1.373 | 60411.5 |
156 | 2024-01-31 09:01:07 | workshop | 2 | 121059 | 6 | 3.623 | 33414.0 |
155 | 2024-01-31 09:01:03 | workshop | 3 | 146162 | 26 | 7.456 | 19603.3 |
154 | 2024-01-29 23:03:25 | workshop | 1 | 82945 | 2 | 1.500 | 55296.7 |
153 | 2024-01-29 17:07:32 | workshop | 2 | 121059 | 6 | 7.610 | 15907.9 |
152 | 2024-01-29 17:07:28 | workshop | 3 | 146162 | 26 | 7.436 | 19656.0 |
151 | 2024-01-29 17:07:23 | workshop | 1 | 82945 | 2 | 1.420 | 58412.0 |
150 | 2024-01-27 01:57:39 | workshop | 4 | 161609 | 209 | 15.373 | 10512.5 |
149 | 2024-01-27 01:39:59 | workshop | 4 | 161609 | 209 | 17.326 | 9327.5 |
148 | 2024-01-27 01:39:33 | workshop | 4 | 161609 | 209 | 18.720 | 8633.0 |
147 | 2024-01-18 08:46:48 | workshop | 1 | 82945 | 2 | 1.373 | 60411.5 |
146 | 2024-01-12 08:07:26 | workshop | 3 | 146162 | 26 | 7.046 | 20744.0 |
145 | 2023-12-24 21:09:20 | workshop | 1 | 82945 | 2 | 1.720 | 48223.8 |
144 | 2023-12-11 13:30:32 | workshop | 1 | 82945 | 2 | 1.296 | 64000.8 |
143 | 2023-11-27 23:48:43 | workshop | 1 | 82945 | 2 | 1.470 | 56425.2 |
142 | 2023-11-18 03:06:09 | workshop | 2 | 121059 | 6 | 3.283 | 36874.5 |
141 | 2023-11-05 17:34:03 | workshop | 1 | 82945 | 2 | 1.406 | 58993.6 |
140 | 2023-10-21 12:10:53 | workshop | 3 | 146162 | 26 | 6.076 | 24055.6 |
139 | 2023-09-13 09:37:26 | workshop | 1 | 82945 | 2 | 1.250 | 66356.0 |
138 | 2023-08-19 11:03:40 | workshop | 2 | 121059 | 6 | 3.153 | 38394.9 |
137 | 2023-08-12 00:47:33 | workshop | 1 | 82945 | 2 | 1.390 | 59672.7 |
136 | 2023-08-01 21:31:19 | workshop | 3 | 146162 | 26 | 8.530 | 17135.1 |
135 | 2023-06-25 22:16:33 | workshop | 1 | 82945 | 2 | 1.356 | 61168.9 |
134 | 2023-05-01 20:30:47 | workshop | 2 | 121059 | 6 | 3.110 | 38925.7 |
133 | 2023-04-11 10:12:49 | workshop | 3 | 146162 | 26 | 6.096 | 23976.7 |
132 | 2023-04-03 19:59:45 | workshop | 1 | 82945 | 2 | 1.250 | 66356.0 |
131 | 2023-03-24 22:33:13 | workshop | 1 | 82945 | 2 | 1.343 | 61761.0 |
130 | 2023-02-05 14:51:56 | workshop | 2 | 121059 | 6 | 3.313 | 36540.6 |
129 | 2023-01-18 06:38:11 | workshop | 1 | 82945 | 2 | 1.203 | 68948.5 |
128 | 2023-01-18 04:32:53 | workshop | 3 | 146162 | 26 | 6.890 | 21213.6 |
127 | 2022-11-16 14:24:08 | workshop | 2 | 121059 | 6 | 4.063 | 29795.5 |
126 | 2022-11-14 20:35:45 | workshop | 1 | 82945 | 2 | 1.216 | 68211.3 |
125 | 2022-11-02 10:01:39 | workshop | 1 | 82945 | 2 | 1.593 | 52068.4 |
124 | 2022-10-29 20:40:22 | workshop | 3 | 146162 | 26 | 5.970 | 24482.7 |
123 | 2022-07-04 22:41:38 | workshop | 1 | 82945 | 2 | 1.266 | 65517.4 |
122 | 2022-07-02 16:31:44 | workshop | 1 | 82945 | 2 | 1.343 | 61761.0 |
121 | 2022-06-20 10:10:03 | workshop | 2 | 121059 | 6 | 3.126 | 38726.5 |
120 | 2022-06-10 04:26:28 | workshop | 1 | 82945 | 2 | 1.266 | 65517.4 |
119 | 2022-05-23 11:14:48 | workshop | 3 | 146162 | 26 | 6.203 | 23563.1 |
118 | 2022-03-07 14:12:56 | workshop | 1 | 82945 | 2 | 1.440 | 57600.7 |
117 | 2022-01-09 15:45:45 | workshop | 1 | 82945 | 2 | 1.373 | 60411.5 |
116 | 2021-12-20 03:35:55 | workshop | 1 | 82945 | 2 | 1.503 | 55186.3 |
115 | 2021-11-06 11:20:08 | workshop | 1 | 82945 | 2 | 1.376 | 60279.8 |
114 | 2021-08-28 22:14:54 | workshop | 1 | 82945 | 2 | 1.233 | 67270.9 |
113 | 2021-06-02 11:57:33 | workshop | 1 | 82945 | 2 | 2.953 | 28088.4 |
112 | 2021-05-08 07:06:12 | workshop | 1 | 82945 | 2 | 1.453 | 57085.3 |
111 | 2021-05-08 00:14:47 | workshop | 1 | 82945 | 2 | 1.266 | 65517.4 |
110 | 2021-04-06 17:03:26 | workshop | 1 | 82945 | 2 | 1.393 | 59544.1 |
109 | 2021-02-02 01:05:47 | workshop | 1 | 82945 | 2 | 1.330 | 62364.7 |
108 | 2021-01-21 23:06:30 | workshop | 1 | 82945 | 2 | 1.483 | 55930.5 |
107 | 2020-10-31 01:26:07 | workshop | 1 | 82945 | 2 | 1.466 | 56579.1 |
106 | 2020-10-31 00:15:32 | workshop | 1 | 82945 | 2 | 1.500 | 55296.7 |
105 | 2020-10-07 07:33:36 | workshop | 1 | 82945 | 2 | 1.236 | 67107.6 |
104 | 2020-08-28 18:33:03 | workshop | 1 | 82945 | 2 | 1.263 | 65673.0 |
103 | 2020-08-22 18:45:02 | workshop | 1 | 82945 | 2 | 1.343 | 61761.0 |
102 | 2020-07-22 10:24:17 | workshop | 1 | 82945 | 2 | 1.343 | 61761.0 |
101 | 2020-04-17 05:38:42 | workshop | 1 | 82945 | 2 | 1.330 | 62364.7 |
100 | 2020-03-25 00:28:32 | workshop | 1 | 82945 | 2 | 1.483 | 55930.5 |
99 | 2020-02-13 15:40:23 | workshop | 1 | 82945 | 2 | 1.390 | 59672.7 |
98 | 2020-02-06 19:40:59 | workshop | 1 | 82945 | 2 | 2.953 | 28088.4 |