History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shamrock"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
207 | 2024-04-26 17:14:41 | shamrock | 4 | 161609 | 341 | 14.643 | 11036.6 |
206 | 2024-04-26 16:03:27 | shamrock | 1 | 82945 | 2 | 1.376 | 60279.8 |
205 | 2024-04-26 16:03:18 | shamrock | 3 | 146162 | 42 | 7.440 | 19645.4 |
204 | 2024-04-26 16:03:11 | shamrock | 4 | 161609 | 341 | 13.623 | 11863.0 |
203 | 2024-04-26 16:03:23 | shamrock | 1 | 82945 | 2 | 1.483 | 55930.5 |
202 | 2024-04-26 16:03:15 | shamrock | 2 | 121059 | 4 | 6.360 | 19034.4 |
201 | 2024-04-11 03:02:43 | shamrock | 3 | 146162 | 42 | 13.343 | 10954.2 |
200 | 2024-04-09 23:52:31 | shamrock | 3 | 146162 | 42 | 28.936 | 5051.2 |
199 | 2024-04-09 23:52:30 | shamrock | 2 | 121059 | 4 | 11.703 | 10344.3 |
198 | 2024-04-09 22:28:15 | shamrock | 1 | 82945 | 2 | 1.610 | 51518.6 |
197 | 2024-04-01 14:42:11 | shamrock | 4 | 161609 | 341 | 23.796 | 6791.4 |
196 | 2024-04-01 14:42:09 | shamrock | 2 | 121059 | 4 | 9.983 | 12126.5 |
195 | 2024-04-01 12:31:36 | shamrock | 3 | 146162 | 42 | 17.813 | 8205.4 |
194 | 2024-04-01 08:57:43 | shamrock | 3 | 146162 | 42 | 12.733 | 11479.0 |
193 | 2024-04-01 08:57:34 | shamrock | 1 | 82945 | 2 | 1.766 | 46967.7 |
192 | 2024-03-31 13:50:28 | shamrock | 1 | 82945 | 2 | 5.173 | 16034.2 |
191 | 2024-03-29 19:57:04 | shamrock | 2 | 121059 | 4 | 5.500 | 22010.7 |
190 | 2024-03-29 19:57:02 | shamrock | 1 | 82945 | 2 | 3.483 | 23814.2 |
189 | 2024-03-26 18:05:10 | shamrock | 4 | 161609 | 341 | 12.046 | 13416.0 |
188 | 2024-03-26 17:44:36 | shamrock | 4 | 161609 | 341 | 12.796 | 12629.6 |
187 | 2024-03-26 12:34:49 | shamrock | 4 | 161609 | 341 | 23.950 | 6747.8 |
186 | 2024-03-26 12:34:53 | shamrock | 1 | 82945 | 2 | 1.563 | 53067.8 |
185 | 2024-03-26 12:34:45 | shamrock | 1 | 82945 | 2 | 1.576 | 52630.1 |
184 | 2024-03-26 12:34:38 | shamrock | 2 | 121059 | 4 | 4.030 | 30039.5 |
183 | 2024-03-08 00:33:05 | shamrock | 1 | 82945 | 2 | 1.593 | 52068.4 |
182 | 2024-03-06 11:38:14 | shamrock | 3 | 146162 | 42 | 26.800 | 5453.8 |
181 | 2024-03-05 08:42:34 | shamrock | 3 | 146162 | 42 | 20.470 | 7140.3 |
180 | 2024-03-04 18:20:10 | shamrock | 3 | 146162 | 42 | 10.703 | 13656.2 |
179 | 2024-03-04 15:47:19 | shamrock | 4 | 161609 | 341 | 27.703 | 5833.6 |
178 | 2024-03-04 01:01:36 | shamrock | 2 | 121059 | 4 | 4.110 | 29454.7 |
177 | 2024-03-04 00:59:55 | shamrock | 3 | 146162 | 42 | 8.843 | 16528.6 |
176 | 2024-03-02 06:47:44 | shamrock | 4 | 161609 | 341 | 14.656 | 11026.8 |
175 | 2024-03-02 06:47:46 | shamrock | 3 | 146162 | 42 | 12.890 | 11339.2 |
174 | 2024-03-02 06:47:42 | shamrock | 2 | 121059 | 4 | 4.360 | 27765.8 |
173 | 2024-03-02 06:47:37 | shamrock | 1 | 82945 | 2 | 3.936 | 21073.4 |
172 | 2024-02-29 13:14:04 | shamrock | 1 | 82945 | 2 | 1.530 | 54212.4 |
171 | 2024-02-26 07:50:34 | shamrock | 1 | 82945 | 2 | 1.466 | 56579.1 |
170 | 2024-02-25 08:04:19 | shamrock | 4 | 161609 | 341 | 12.673 | 12752.2 |
169 | 2024-02-25 08:04:14 | shamrock | 1 | 82945 | 2 | 1.453 | 57085.3 |
168 | 2024-02-09 16:54:28 | shamrock | 4 | 161609 | 341 | 19.486 | 8293.6 |
167 | 2024-02-07 05:17:26 | shamrock | 4 | 161609 | 341 | 16.813 | 9612.1 |
166 | 2024-01-30 09:33:02 | shamrock | 1 | 82945 | 2 | 2.950 | 28116.9 |
165 | 2024-01-30 07:23:48 | shamrock | 1 | 82945 | 2 | 1.500 | 55296.7 |
164 | 2024-01-29 08:52:17 | shamrock | 3 | 146162 | 42 | 7.110 | 20557.2 |
163 | 2024-01-28 23:24:15 | shamrock | 3 | 146162 | 42 | 7.970 | 18339.0 |
162 | 2024-01-28 23:24:07 | shamrock | 2 | 121059 | 4 | 3.500 | 34588.3 |
161 | 2024-01-28 03:41:18 | shamrock | 2 | 121059 | 4 | 3.580 | 33815.4 |
160 | 2024-01-26 00:23:43 | shamrock | 4 | 161609 | 341 | 12.923 | 12505.5 |
159 | 2024-01-26 00:23:12 | shamrock | 4 | 161609 | 341 | 12.626 | 12799.7 |
158 | 2024-01-25 15:56:43 | shamrock | 4 | 161609 | 341 | 13.500 | 11971.0 |
157 | 2024-01-16 03:12:56 | shamrock | 4 | 161609 | 341 | 14.173 | 11402.6 |
156 | 2024-01-06 21:04:25 | shamrock | 1 | 82945 | 2 | 1.343 | 61761.0 |
155 | 2023-11-29 21:02:49 | shamrock | 4 | 161609 | 341 | 11.393 | 14184.9 |
154 | 2023-11-27 08:48:10 | shamrock | 1 | 82945 | 2 | 1.326 | 62552.8 |
153 | 2023-11-26 13:58:29 | shamrock | 1 | 82945 | 2 | 1.280 | 64800.8 |
152 | 2023-11-26 02:04:52 | shamrock | 1 | 82945 | 2 | 1.406 | 58993.6 |
151 | 2023-11-25 03:34:58 | shamrock | 1 | 82945 | 2 | 1.296 | 64000.8 |
150 | 2023-11-10 02:42:42 | shamrock | 4 | 161609 | 341 | 18.173 | 8892.8 |
149 | 2023-11-06 16:37:38 | shamrock | 2 | 121059 | 4 | 3.186 | 37997.2 |
148 | 2023-11-04 15:12:33 | shamrock | 4 | 161609 | 341 | 11.203 | 14425.5 |
147 | 2023-11-01 06:21:05 | shamrock | 1 | 82945 | 2 | 2.016 | 41143.4 |
146 | 2023-10-29 20:47:39 | shamrock | 1 | 82945 | 2 | 1.280 | 64800.8 |
145 | 2023-09-27 02:09:47 | shamrock | 1 | 82945 | 2 | 1.360 | 60989.0 |
144 | 2023-09-23 06:58:52 | shamrock | 1 | 82945 | 2 | 1.813 | 45750.1 |
143 | 2023-09-12 16:36:54 | shamrock | 1 | 82945 | 2 | 1.593 | 52068.4 |
142 | 2023-08-26 06:06:29 | shamrock | 1 | 82945 | 2 | 1.453 | 57085.3 |
141 | 2023-08-24 03:17:36 | shamrock | 1 | 82945 | 2 | 1.313 | 63172.1 |
140 | 2023-08-22 13:59:07 | shamrock | 1 | 82945 | 2 | 1.343 | 61761.0 |
139 | 2023-08-11 17:07:52 | shamrock | 2 | 121059 | 4 | 3.500 | 34588.3 |
138 | 2023-08-11 05:15:27 | shamrock | 4 | 161609 | 341 | 10.466 | 15441.3 |
137 | 2023-08-09 13:38:02 | shamrock | 1 | 82945 | 2 | 1.440 | 57600.7 |
136 | 2023-08-08 13:20:56 | shamrock | 1 | 82945 | 2 | 2.500 | 33178.0 |
135 | 2023-08-07 12:44:56 | shamrock | 1 | 82945 | 2 | 1.313 | 63172.1 |
134 | 2023-08-06 22:25:28 | shamrock | 1 | 82945 | 2 | 2.356 | 35205.9 |
133 | 2023-07-17 23:23:15 | shamrock | 1 | 82945 | 2 | 1.450 | 57203.4 |
132 | 2023-07-16 21:17:51 | shamrock | 1 | 82945 | 2 | 1.296 | 64000.8 |
131 | 2023-07-15 12:34:24 | shamrock | 1 | 82945 | 2 | 1.280 | 64800.8 |
130 | 2023-07-14 13:14:43 | shamrock | 1 | 82945 | 2 | 1.390 | 59672.7 |
129 | 2023-07-13 23:58:10 | shamrock | 1 | 82945 | 2 | 1.373 | 60411.5 |
128 | 2023-05-25 03:46:19 | shamrock | 1 | 82945 | 2 | 1.313 | 63172.1 |
127 | 2023-04-25 03:19:18 | shamrock | 4 | 161609 | 341 | 10.483 | 15416.3 |
126 | 2023-04-23 06:17:26 | shamrock | 2 | 121059 | 4 | 3.766 | 32145.2 |
125 | 2023-03-29 06:17:54 | shamrock | 1 | 82945 | 2 | 1.283 | 64649.3 |
124 | 2023-03-20 06:21:54 | shamrock | 1 | 82945 | 2 | 1.266 | 65517.4 |
123 | 2023-01-31 06:15:56 | shamrock | 4 | 161609 | 341 | 13.063 | 12371.5 |
122 | 2023-01-29 23:12:15 | shamrock | 2 | 121059 | 4 | 3.156 | 38358.4 |
121 | 2023-01-07 10:15:57 | shamrock | 1 | 82945 | 2 | 1.283 | 64649.3 |
120 | 2023-01-05 15:14:30 | shamrock | 4 | 161609 | 341 | 10.483 | 15416.3 |
119 | 2023-01-03 19:56:09 | shamrock | 1 | 82945 | 2 | 1.516 | 54713.1 |
118 | 2023-01-01 13:49:33 | shamrock | 1 | 82945 | 2 | 1.346 | 61623.3 |
117 | 2022-12-30 12:07:01 | shamrock | 1 | 82945 | 2 | 1.500 | 55296.7 |
116 | 2022-12-09 17:53:30 | shamrock | 4 | 161609 | 341 | 22.893 | 7059.3 |
115 | 2022-11-12 13:24:16 | shamrock | 4 | 161609 | 341 | 10.453 | 15460.5 |
114 | 2022-11-11 12:49:26 | shamrock | 2 | 121059 | 4 | 3.360 | 36029.5 |
113 | 2022-11-06 13:37:57 | shamrock | 1 | 82945 | 2 | 1.450 | 57203.4 |
112 | 2022-10-02 11:57:21 | shamrock | 1 | 82945 | 2 | 1.420 | 58412.0 |
111 | 2022-06-13 12:50:39 | shamrock | 2 | 121059 | 4 | 3.390 | 35710.6 |
110 | 2022-06-07 05:24:10 | shamrock | 1 | 82945 | 2 | 1.296 | 64000.8 |
109 | 2022-05-28 05:42:34 | shamrock | 4 | 161609 | 341 | 10.563 | 15299.5 |
108 | 2022-05-17 16:28:16 | shamrock | 1 | 82945 | 2 | 1.983 | 41828.0 |