History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"scheelite"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
182 | 2024-05-07 04:44:32 | scheelite | 2 | 121436 | 2 | 4.310 | 28175.4 |
181 | 2024-05-07 04:44:12 | scheelite | 1 | 81242 | 2 | 2.216 | 36661.6 |
180 | 2024-05-06 18:16:49 | scheelite | 1 | 81242 | 2 | 1.513 | 53696.0 |
179 | 2024-05-03 12:33:27 | scheelite | 2 | 121436 | 2 | 3.546 | 34245.9 |
178 | 2024-05-03 01:54:12 | scheelite | 1 | 81242 | 2 | 1.470 | 55266.7 |
177 | 2024-05-02 08:48:01 | scheelite | 3 | 148641 | 22 | 21.816 | 6813.4 |
176 | 2024-04-30 22:21:31 | scheelite | 3 | 148641 | 22 | 10.670 | 13930.7 |
175 | 2024-04-28 13:13:23 | scheelite | 4 | 165329 | 220 | 42.676 | 3874.1 |
174 | 2024-04-28 09:13:18 | scheelite | 4 | 165329 | 220 | 15.266 | 10829.9 |
173 | 2024-04-27 23:51:12 | scheelite | 4 | 165329 | 220 | 32.033 | 5161.2 |
172 | 2024-04-13 09:33:28 | scheelite | 1 | 81242 | 2 | 1.330 | 61084.2 |
171 | 2024-04-11 12:21:09 | scheelite | 1 | 81242 | 2 | 1.436 | 56575.2 |
170 | 2024-04-04 09:03:53 | scheelite | 2 | 121436 | 2 | 5.110 | 23764.4 |
169 | 2024-04-04 06:18:59 | scheelite | 1 | 81242 | 2 | 4.750 | 17103.6 |
168 | 2024-03-31 17:08:45 | scheelite | 4 | 165329 | 220 | 44.003 | 3757.2 |
167 | 2024-03-27 22:33:40 | scheelite | 3 | 148641 | 22 | 11.296 | 13158.7 |
166 | 2024-03-26 19:55:08 | scheelite | 3 | 148641 | 22 | 18.796 | 7908.1 |
165 | 2024-03-26 19:24:04 | scheelite | 2 | 121436 | 2 | 7.250 | 16749.8 |
164 | 2024-03-26 18:24:04 | scheelite | 1 | 81242 | 2 | 1.263 | 64324.6 |
163 | 2024-03-25 23:22:54 | scheelite | 1 | 81242 | 2 | 1.530 | 53099.3 |
162 | 2024-03-25 03:13:07 | scheelite | 4 | 165329 | 220 | 12.656 | 13063.3 |
161 | 2024-03-25 03:13:03 | scheelite | 3 | 148641 | 22 | 7.466 | 19909.1 |
160 | 2024-03-25 03:12:59 | scheelite | 2 | 121436 | 2 | 4.173 | 29100.4 |
159 | 2024-03-19 01:15:32 | scheelite | 1 | 81242 | 2 | 3.673 | 22118.7 |
158 | 2024-03-14 20:23:53 | scheelite | 4 | 165329 | 220 | 19.830 | 8337.3 |
157 | 2024-03-13 19:07:35 | scheelite | 4 | 165329 | 220 | 12.440 | 13290.1 |
156 | 2024-03-13 18:48:52 | scheelite | 3 | 148641 | 22 | 24.420 | 6086.9 |
155 | 2024-03-12 09:12:09 | scheelite | 3 | 148641 | 22 | 33.206 | 4476.3 |
154 | 2024-03-12 09:12:09 | scheelite | 4 | 165329 | 220 | 30.470 | 5426.0 |
153 | 2024-03-12 09:12:09 | scheelite | 2 | 121436 | 2 | 7.330 | 16567.0 |
152 | 2024-03-12 07:18:52 | scheelite | 1 | 81242 | 2 | 4.846 | 16764.8 |
151 | 2024-02-22 23:19:49 | scheelite | 2 | 121436 | 2 | 3.186 | 38115.5 |
150 | 2024-02-10 06:32:39 | scheelite | 2 | 121436 | 2 | 3.153 | 38514.4 |
149 | 2024-02-10 06:21:33 | scheelite | 1 | 81242 | 2 | 1.343 | 60492.9 |
148 | 2024-02-06 21:15:38 | scheelite | 1 | 81242 | 2 | 1.263 | 64324.6 |
147 | 2024-02-06 20:43:48 | scheelite | 4 | 165329 | 220 | 12.626 | 13094.3 |
146 | 2024-02-06 20:43:55 | scheelite | 2 | 121436 | 2 | 3.890 | 31217.5 |
145 | 2024-02-06 20:43:51 | scheelite | 3 | 148641 | 22 | 7.626 | 19491.3 |
144 | 2024-02-06 20:43:43 | scheelite | 1 | 81242 | 2 | 1.420 | 57212.7 |
143 | 2024-01-18 10:10:48 | scheelite | 1 | 81242 | 2 | 1.466 | 55417.5 |
142 | 2024-01-17 03:14:24 | scheelite | 1 | 81242 | 2 | 1.486 | 54671.6 |
141 | 2024-01-08 02:45:36 | scheelite | 1 | 81242 | 2 | 1.360 | 59736.8 |
140 | 2023-12-23 14:01:08 | scheelite | 3 | 148641 | 22 | 6.203 | 23962.8 |
139 | 2023-11-18 14:42:17 | scheelite | 2 | 121436 | 2 | 3.080 | 39427.3 |
138 | 2023-11-11 18:00:18 | scheelite | 1 | 81242 | 2 | 1.356 | 59913.0 |
137 | 2023-09-25 13:25:18 | scheelite | 3 | 148641 | 22 | 16.843 | 8825.1 |
136 | 2023-08-31 04:04:31 | scheelite | 1 | 81242 | 2 | 1.250 | 64993.6 |
135 | 2023-08-18 18:05:27 | scheelite | 2 | 121436 | 2 | 3.063 | 39646.1 |
134 | 2023-07-07 15:17:13 | scheelite | 3 | 148641 | 22 | 6.956 | 21368.7 |
133 | 2023-06-03 15:48:46 | scheelite | 1 | 81242 | 2 | 1.343 | 60492.9 |
132 | 2023-05-02 19:24:34 | scheelite | 2 | 121436 | 2 | 3.030 | 40077.9 |
131 | 2023-03-26 17:18:45 | scheelite | 3 | 148641 | 22 | 6.733 | 22076.5 |
130 | 2023-03-25 15:43:59 | scheelite | 1 | 81242 | 2 | 1.233 | 65889.7 |
129 | 2023-02-07 11:52:06 | scheelite | 2 | 121436 | 2 | 3.030 | 40077.9 |
128 | 2023-01-09 10:35:59 | scheelite | 1 | 81242 | 2 | 1.283 | 63321.9 |
127 | 2022-12-23 10:01:05 | scheelite | 3 | 148641 | 22 | 6.766 | 21968.8 |
126 | 2022-11-19 08:29:39 | scheelite | 2 | 121436 | 2 | 3.593 | 33797.9 |
125 | 2022-10-11 18:26:54 | scheelite | 1 | 81242 | 2 | 1.263 | 64324.6 |
124 | 2022-08-25 00:20:16 | scheelite | 3 | 148641 | 22 | 6.076 | 24463.6 |
123 | 2022-06-23 15:55:21 | scheelite | 2 | 121436 | 2 | 3.140 | 38673.9 |
122 | 2022-05-27 05:15:45 | scheelite | 1 | 81242 | 2 | 1.250 | 64993.6 |
121 | 2022-02-25 19:08:28 | scheelite | 1 | 81242 | 2 | 1.393 | 58321.6 |
120 | 2022-01-18 12:50:40 | scheelite | 1 | 81242 | 2 | 1.266 | 64172.2 |
119 | 2021-12-09 17:45:41 | scheelite | 1 | 81242 | 2 | 1.546 | 52549.8 |
118 | 2021-06-13 23:35:51 | scheelite | 1 | 81242 | 2 | 1.373 | 59171.2 |
117 | 2021-05-04 03:40:10 | scheelite | 1 | 81242 | 2 | 1.546 | 52549.8 |
116 | 2021-01-29 01:15:06 | scheelite | 1 | 81242 | 2 | 1.373 | 59171.2 |
115 | 2021-01-17 06:47:42 | scheelite | 1 | 81242 | 2 | 1.343 | 60492.9 |
114 | 2020-11-22 17:18:19 | scheelite | 1 | 81242 | 2 | 1.233 | 65889.7 |
113 | 2020-11-09 11:42:46 | scheelite | 1 | 81242 | 2 | 1.390 | 58447.5 |
112 | 2020-10-28 14:50:12 | scheelite | 1 | 81242 | 2 | 1.470 | 55266.7 |
111 | 2020-03-31 15:05:27 | scheelite | 1 | 81242 | 2 | 1.483 | 54782.2 |
110 | 2020-03-28 10:51:47 | scheelite | 1 | 81242 | 2 | 1.436 | 56575.2 |
109 | 2020-03-24 22:35:27 | scheelite | 1 | 81242 | 2 | 1.500 | 54161.3 |
108 | 2020-02-14 13:13:41 | scheelite | 1 | 81242 | 2 | 1.440 | 56418.1 |
107 | 2020-02-08 01:09:42 | scheelite | 1 | 81242 | 2 | 3.203 | 25364.3 |
106 | 2020-02-04 17:21:37 | scheelite | 1 | 81242 | 2 | 3.173 | 25604.2 |
105 | 2020-02-04 05:52:14 | scheelite | 1 | 81242 | 2 | 1.563 | 51978.2 |
104 | 2020-02-03 23:06:20 | scheelite | 1 | 81242 | 2 | 1.593 | 50999.4 |
103 | 2020-01-25 12:56:09 | scheelite | 1 | 81242 | 2 | 3.890 | 20884.8 |
102 | 2020-01-17 07:04:51 | scheelite | 1 | 81242 | 2 | 1.436 | 56575.2 |
101 | 2020-01-09 01:16:23 | scheelite | 1 | 81242 | 2 | 4.660 | 17433.9 |
100 | 2020-01-04 22:35:43 | scheelite | 1 | 81242 | 2 | 1.390 | 58447.5 |
99 | 2019-12-14 19:58:26 | scheelite | 1 | 81242 | 2 | 1.263 | 64324.6 |
98 | 2019-09-13 06:14:42 | scheelite | 1 | 81242 | 2 | 1.183 | 68674.6 |
97 | 2019-09-10 04:16:57 | scheelite | 1 | 81242 | 2 | 1.293 | 62832.2 |
96 | 2019-05-29 03:27:09 | scheelite | 1 | 81242 | 2 | 1.256 | 64683.1 |
95 | 2019-02-14 02:24:15 | scheelite | 1 | 81242 | 2 | 1.210 | 67142.1 |
94 | 2019-01-22 09:02:58 | scheelite | 1 | 81242 | 2 | 1.340 | 60628.4 |
93 | 2019-01-14 19:07:51 | scheelite | 1 | 81242 | 2 | 1.340 | 60628.4 |
92 | 2019-01-09 08:36:40 | scheelite | 1 | 81242 | 2 | 1.286 | 63174.2 |
91 | 2018-12-24 21:33:53 | scheelite | 1 | 81242 | 2 | 1.283 | 63321.9 |
90 | 2018-12-22 21:22:33 | scheelite | 1 | 81242 | 2 | 1.203 | 67532.8 |
89 | 2018-12-09 19:18:40 | scheelite | 1 | 81242 | 2 | 1.216 | 66810.9 |
88 | 2018-11-13 04:58:58 | scheelite | 1 | 81242 | 2 | 1.286 | 63174.2 |
87 | 2018-10-28 08:39:30 | scheelite | 1 | 81242 | 2 | 1.356 | 59913.0 |
86 | 2018-10-26 11:01:02 | scheelite | 1 | 81242 | 2 | 1.376 | 59042.2 |
85 | 2018-10-12 08:33:28 | scheelite | 1 | 81242 | 2 | 1.336 | 60809.9 |
84 | 2018-10-10 12:53:14 | scheelite | 1 | 81242 | 2 | 1.236 | 65729.8 |
83 | 2018-10-03 01:55:47 | scheelite | 1 | 81242 | 2 | 1.290 | 62978.3 |