History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"granulated"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
192 | 2024-05-03 04:25:43 | granulated | 1 | 67641 | 4 | 2.876 | 23519.1 |
191 | 2024-04-28 22:56:31 | granulated | 1 | 67641 | 4 | 1.063 | 63632.2 |
190 | 2024-04-27 05:28:32 | granulated | 1 | 67641 | 4 | 2.190 | 30886.3 |
189 | 2024-04-25 01:11:14 | granulated | 2 | 108824 | 13 | 7.516 | 14479.0 |
188 | 2024-04-25 01:11:09 | granulated | 3 | 140603 | 50 | 7.656 | 18365.1 |
187 | 2024-04-24 23:43:22 | granulated | 1 | 67641 | 4 | 1.003 | 67438.7 |
186 | 2024-04-11 19:22:33 | granulated | 2 | 108824 | 13 | 4.876 | 22318.3 |
185 | 2024-04-11 19:21:51 | granulated | 1 | 67641 | 4 | 1.170 | 57812.8 |
184 | 2024-04-09 15:59:41 | granulated | 1 | 67641 | 4 | 3.013 | 22449.7 |
183 | 2024-04-07 23:46:53 | granulated | 4 | 161450 | 270 | 50.770 | 3180.0 |
182 | 2024-04-07 15:19:24 | granulated | 4 | 161450 | 270 | 35.113 | 4598.0 |
181 | 2024-04-02 05:07:21 | granulated | 4 | 161450 | 270 | 29.846 | 5409.4 |
180 | 2024-03-31 10:51:02 | granulated | 4 | 161450 | 270 | 37.830 | 4267.8 |
179 | 2024-03-31 10:51:03 | granulated | 3 | 140603 | 50 | 20.033 | 7018.6 |
178 | 2024-03-31 10:50:58 | granulated | 2 | 108824 | 13 | 3.610 | 30145.2 |
177 | 2024-03-31 09:30:21 | granulated | 1 | 67641 | 4 | 1.236 | 54725.7 |
176 | 2024-03-27 14:11:59 | granulated | 1 | 67641 | 4 | 1.126 | 60071.9 |
175 | 2024-03-20 06:55:37 | granulated | 3 | 140603 | 50 | 20.283 | 6932.1 |
174 | 2024-03-20 06:55:37 | granulated | 2 | 108824 | 13 | 6.660 | 16339.9 |
173 | 2024-03-20 05:36:23 | granulated | 1 | 67641 | 4 | 0.986 | 68601.4 |
172 | 2024-03-12 01:15:25 | granulated | 1 | 67641 | 4 | 1.110 | 60937.8 |
171 | 2024-03-09 17:00:13 | granulated | 4 | 161450 | 270 | 28.596 | 5645.9 |
170 | 2024-03-09 12:53:23 | granulated | 1 | 67641 | 4 | 2.563 | 26391.3 |
169 | 2024-03-09 12:52:59 | granulated | 2 | 108824 | 13 | 4.906 | 22181.8 |
168 | 2024-03-08 12:29:44 | granulated | 4 | 161450 | 270 | 19.703 | 8194.2 |
167 | 2024-03-08 07:09:13 | granulated | 4 | 161450 | 270 | 22.423 | 7200.2 |
166 | 2024-03-08 07:09:11 | granulated | 2 | 108824 | 13 | 12.830 | 8482.0 |
165 | 2024-03-08 07:09:12 | granulated | 3 | 140603 | 50 | 7.876 | 17852.1 |
164 | 2024-03-08 07:07:35 | granulated | 1 | 67641 | 4 | 2.670 | 25333.7 |
163 | 2024-02-22 11:05:54 | granulated | 1 | 67641 | 4 | 3.766 | 17961.0 |
162 | 2024-02-11 15:52:08 | granulated | 4 | 161450 | 270 | 34.093 | 4735.6 |
161 | 2024-02-11 15:52:07 | granulated | 3 | 140603 | 50 | 17.280 | 8136.7 |
160 | 2024-02-11 15:52:05 | granulated | 2 | 108824 | 13 | 11.016 | 9878.7 |
159 | 2024-02-11 12:44:42 | granulated | 1 | 67641 | 4 | 1.080 | 62630.6 |
158 | 2024-02-06 02:00:33 | granulated | 1 | 67641 | 4 | 1.093 | 61885.6 |
157 | 2024-02-05 06:11:15 | granulated | 1 | 67641 | 4 | 1.190 | 56841.2 |
156 | 2024-02-02 23:42:23 | granulated | 1 | 67641 | 4 | 1.093 | 61885.6 |
155 | 2024-01-22 16:34:23 | granulated | 1 | 67641 | 4 | 0.983 | 68810.8 |
154 | 2024-01-11 19:43:57 | granulated | 1 | 67641 | 4 | 1.000 | 67641.0 |
153 | 2024-01-04 00:20:58 | granulated | 1 | 67641 | 4 | 1.060 | 63812.3 |
152 | 2023-12-29 08:53:34 | granulated | 1 | 67641 | 4 | 0.983 | 68810.8 |
151 | 2023-10-18 05:14:40 | granulated | 1 | 67641 | 4 | 1.123 | 60232.4 |
150 | 2023-10-01 02:00:37 | granulated | 1 | 67641 | 4 | 1.076 | 62863.4 |
149 | 2023-09-14 15:53:58 | granulated | 1 | 67641 | 4 | 1.123 | 60232.4 |
148 | 2023-09-05 09:03:56 | granulated | 1 | 67641 | 4 | 1.123 | 60232.4 |
147 | 2023-08-13 17:26:27 | granulated | 1 | 67641 | 4 | 1.110 | 60937.8 |
146 | 2023-05-13 01:11:47 | granulated | 1 | 67641 | 4 | 0.983 | 68810.8 |
145 | 2023-05-05 10:04:21 | granulated | 1 | 67641 | 4 | 0.970 | 69733.0 |
144 | 2023-03-09 01:46:44 | granulated | 1 | 67641 | 4 | 1.123 | 60232.4 |
143 | 2023-01-04 10:46:50 | granulated | 1 | 67641 | 4 | 1.000 | 67641.0 |
142 | 2022-12-31 16:37:09 | granulated | 1 | 67641 | 4 | 0.983 | 68810.8 |
141 | 2022-12-30 13:47:22 | granulated | 1 | 67641 | 4 | 1.063 | 63632.2 |
140 | 2022-09-18 02:49:56 | granulated | 1 | 67641 | 4 | 0.986 | 68601.4 |
139 | 2022-08-20 11:44:28 | granulated | 1 | 67641 | 4 | 0.970 | 69733.0 |
138 | 2022-04-26 23:25:34 | granulated | 1 | 67641 | 4 | 1.016 | 66575.8 |
137 | 2022-04-02 15:25:33 | granulated | 1 | 67641 | 4 | 1.013 | 66773.0 |
136 | 2022-01-13 22:57:16 | granulated | 1 | 67641 | 4 | 1.143 | 59178.5 |
135 | 2022-01-12 08:27:18 | granulated | 4 | 161450 | 270 | 11.190 | 14428.1 |
134 | 2021-12-06 01:13:59 | granulated | 1 | 67641 | 4 | 1.033 | 65480.2 |
133 | 2021-11-22 06:17:22 | granulated | 1 | 67641 | 4 | 1.000 | 67641.0 |
132 | 2021-10-24 11:09:14 | granulated | 1 | 67641 | 4 | 1.000 | 67641.0 |
131 | 2021-08-16 07:59:23 | granulated | 1 | 67641 | 4 | 0.983 | 68810.8 |
130 | 2021-05-02 03:46:32 | granulated | 1 | 67641 | 4 | 1.156 | 58513.0 |
129 | 2021-02-18 10:50:25 | granulated | 1 | 67641 | 4 | 1.110 | 60937.8 |
128 | 2021-01-12 00:33:45 | granulated | 1 | 67641 | 4 | 1.000 | 67641.0 |
127 | 2020-10-31 03:27:04 | granulated | 1 | 67641 | 4 | 1.000 | 67641.0 |
126 | 2020-10-01 21:44:48 | granulated | 1 | 67641 | 4 | 1.016 | 66575.8 |
125 | 2020-06-09 10:39:26 | granulated | 1 | 67641 | 4 | 1.123 | 60232.4 |
124 | 2020-03-25 23:51:34 | granulated | 4 | 161450 | 270 | 10.030 | 16096.7 |
123 | 2020-03-25 11:40:19 | granulated | 4 | 161450 | 270 | 19.093 | 8456.0 |
122 | 2020-03-24 17:23:29 | granulated | 1 | 67641 | 4 | 1.686 | 40119.2 |
121 | 2020-03-24 07:44:08 | granulated | 4 | 161450 | 270 | 30.846 | 5234.1 |
120 | 2020-03-22 21:30:54 | granulated | 4 | 161450 | 270 | 12.030 | 13420.6 |
119 | 2020-03-22 16:40:31 | granulated | 4 | 161450 | 270 | 11.953 | 13507.1 |
118 | 2020-03-01 03:32:47 | granulated | 1 | 67641 | 4 | 2.123 | 31861.0 |
117 | 2020-02-29 11:20:09 | granulated | 4 | 161450 | 270 | 18.640 | 8661.5 |
116 | 2020-02-27 11:18:22 | granulated | 4 | 161450 | 270 | 26.640 | 6060.4 |
115 | 2020-02-25 23:48:01 | granulated | 1 | 67641 | 4 | 1.250 | 54112.8 |
114 | 2020-02-25 22:38:54 | granulated | 1 | 67641 | 4 | 1.140 | 59334.2 |
113 | 2020-02-25 10:36:58 | granulated | 1 | 67641 | 4 | 1.203 | 56226.9 |
112 | 2020-02-25 06:04:51 | granulated | 4 | 161450 | 270 | 15.453 | 10447.8 |
111 | 2020-02-25 03:09:14 | granulated | 1 | 67641 | 4 | 1.153 | 58665.2 |
110 | 2020-02-13 05:11:42 | granulated | 1 | 67641 | 4 | 1.186 | 57032.9 |
109 | 2020-02-04 19:18:25 | granulated | 3 | 140603 | 50 | 14.670 | 9584.4 |
108 | 2020-01-31 06:31:44 | granulated | 1 | 67641 | 4 | 1.140 | 59334.2 |
107 | 2020-01-29 08:05:42 | granulated | 1 | 67641 | 4 | 2.733 | 24749.7 |
106 | 2020-01-28 21:42:07 | granulated | 1 | 67641 | 4 | 1.423 | 47534.1 |
105 | 2020-01-27 21:38:14 | granulated | 1 | 67641 | 4 | 1.373 | 49265.1 |
104 | 2020-01-25 13:35:25 | granulated | 4 | 161450 | 270 | 21.110 | 7648.0 |
103 | 2020-01-25 10:39:08 | granulated | 4 | 161450 | 270 | 25.140 | 6422.0 |
102 | 2020-01-25 07:58:01 | granulated | 4 | 161450 | 270 | 12.716 | 12696.6 |
101 | 2020-01-25 06:03:43 | granulated | 4 | 161450 | 270 | 40.096 | 4026.6 |
100 | 2020-01-24 22:42:47 | granulated | 4 | 161450 | 270 | 18.626 | 8668.0 |
99 | 2020-01-22 10:38:56 | granulated | 1 | 67641 | 4 | 3.266 | 20710.7 |
98 | 2020-01-18 00:11:02 | granulated | 1 | 67641 | 4 | 1.216 | 55625.8 |
97 | 2020-01-17 07:14:07 | granulated | 3 | 140603 | 50 | 6.890 | 20406.8 |
96 | 2020-01-17 02:07:05 | granulated | 3 | 140603 | 50 | 7.376 | 19062.2 |
95 | 2020-01-08 04:59:21 | granulated | 4 | 161450 | 270 | 15.283 | 10564.0 |
94 | 2020-01-06 18:33:00 | granulated | 1 | 67641 | 4 | 1.236 | 54725.7 |
93 | 2020-01-04 22:26:54 | granulated | 3 | 140603 | 50 | 6.470 | 21731.5 |