History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"stonecrops"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
196 | 2024-04-27 10:47:50 | stonecrops | 1 | 67641 | 2 | 3.810 | 17753.5 |
195 | 2024-03-10 06:59:13 | stonecrops | 3 | 140603 | 7 | 10.580 | 13289.5 |
194 | 2024-03-10 06:58:59 | stonecrops | 2 | 108824 | 2 | 10.033 | 10846.6 |
193 | 2024-03-10 06:58:16 | stonecrops | 1 | 67641 | 2 | 4.190 | 16143.4 |
192 | 2024-03-08 14:34:38 | stonecrops | 3 | 140603 | 7 | 22.860 | 6150.6 |
191 | 2024-03-08 14:34:43 | stonecrops | 2 | 108824 | 2 | 6.626 | 16423.8 |
190 | 2024-03-08 14:34:11 | stonecrops | 3 | 140603 | 7 | 15.470 | 9088.8 |
189 | 2024-03-08 14:34:18 | stonecrops | 2 | 108824 | 2 | 7.720 | 14096.4 |
188 | 2024-03-08 14:31:07 | stonecrops | 1 | 67641 | 2 | 1.296 | 52192.1 |
187 | 2024-03-08 14:30:59 | stonecrops | 1 | 67641 | 2 | 1.280 | 52844.5 |
186 | 2024-03-08 14:30:10 | stonecrops | 4 | 161450 | 54 | 27.456 | 5880.3 |
185 | 2024-03-02 16:16:20 | stonecrops | 4 | 161450 | 54 | 29.956 | 5389.6 |
184 | 2024-03-02 15:50:37 | stonecrops | 5 | 173545 | 486 | 43.176 | 4019.5 |
183 | 2024-03-02 00:45:04 | stonecrops | 5 | 173545 | 486 | 26.423 | 6568.0 |
182 | 2024-02-25 16:44:38 | stonecrops | 5 | 173545 | 486 | 41.783 | 4153.5 |
181 | 2024-02-25 16:44:45 | stonecrops | 4 | 161450 | 54 | 29.160 | 5536.7 |
180 | 2024-02-25 16:44:42 | stonecrops | 3 | 140603 | 7 | 16.656 | 8441.6 |
179 | 2024-02-25 16:44:42 | stonecrops | 2 | 108824 | 2 | 7.296 | 14915.6 |
178 | 2024-02-25 16:40:57 | stonecrops | 1 | 67641 | 2 | 3.923 | 17242.2 |
177 | 2024-02-19 20:34:18 | stonecrops | 4 | 161450 | 54 | 12.860 | 12554.4 |
176 | 2024-02-19 20:34:19 | stonecrops | 3 | 140603 | 7 | 7.610 | 18476.1 |
175 | 2024-02-19 20:34:17 | stonecrops | 2 | 108824 | 2 | 3.296 | 33017.0 |
174 | 2024-02-19 17:40:45 | stonecrops | 1 | 67641 | 2 | 1.280 | 52844.5 |
173 | 2024-02-19 02:26:08 | stonecrops | 5 | 173545 | 486 | 23.176 | 7488.1 |
172 | 2024-02-19 02:00:00 | stonecrops | 5 | 173545 | 486 | 53.723 | 3230.4 |
171 | 2024-02-18 00:14:26 | stonecrops | 5 | 173545 | 486 | 27.300 | 6357.0 |
170 | 2024-02-18 00:14:20 | stonecrops | 3 | 140603 | 7 | 22.923 | 6133.7 |
169 | 2024-02-18 00:14:19 | stonecrops | 4 | 161450 | 54 | 23.846 | 6770.5 |
168 | 2024-02-18 00:14:29 | stonecrops | 2 | 108824 | 2 | 8.360 | 13017.2 |
167 | 2024-02-17 21:00:01 | stonecrops | 1 | 67641 | 2 | 1.376 | 49157.7 |
166 | 2024-01-31 11:00:03 | stonecrops | 1 | 67641 | 2 | 1.216 | 55625.8 |
165 | 2024-01-31 10:59:31 | stonecrops | 1 | 67641 | 2 | 1.123 | 60232.4 |
164 | 2024-01-18 13:18:33 | stonecrops | 1 | 67641 | 2 | 1.220 | 55443.4 |
163 | 2023-12-24 16:38:41 | stonecrops | 1 | 67641 | 2 | 1.140 | 59334.2 |
162 | 2023-11-30 01:40:12 | stonecrops | 1 | 67641 | 2 | 1.033 | 65480.2 |
161 | 2023-11-16 09:12:29 | stonecrops | 1 | 67641 | 2 | 1.030 | 65670.9 |
160 | 2023-09-09 13:23:42 | stonecrops | 1 | 67641 | 2 | 1.030 | 65670.9 |
159 | 2023-09-03 17:16:50 | stonecrops | 1 | 67641 | 2 | 1.000 | 67641.0 |
158 | 2023-02-13 07:30:29 | stonecrops | 1 | 67641 | 2 | 1.126 | 60071.9 |
157 | 2022-12-10 09:29:05 | stonecrops | 1 | 67641 | 2 | 1.156 | 58513.0 |
156 | 2022-11-18 02:02:37 | stonecrops | 1 | 67641 | 2 | 1.170 | 57812.8 |
155 | 2022-08-12 11:07:45 | stonecrops | 1 | 67641 | 2 | 1.016 | 66575.8 |
154 | 2022-06-04 11:02:07 | stonecrops | 1 | 67641 | 2 | 1.000 | 67641.0 |
153 | 2022-04-13 19:58:26 | stonecrops | 1 | 67641 | 2 | 1.156 | 58513.0 |
152 | 2022-01-01 07:42:33 | stonecrops | 1 | 67641 | 2 | 1.046 | 64666.3 |
151 | 2021-09-24 11:23:13 | stonecrops | 1 | 67641 | 2 | 1.123 | 60232.4 |
150 | 2021-08-16 23:08:47 | stonecrops | 1 | 67641 | 2 | 1.046 | 64666.3 |
149 | 2021-06-22 13:23:18 | stonecrops | 2 | 108824 | 2 | 3.110 | 34991.6 |
148 | 2021-05-18 09:54:09 | stonecrops | 3 | 140603 | 7 | 6.580 | 21368.2 |
147 | 2021-05-12 19:35:20 | stonecrops | 1 | 67641 | 2 | 1.156 | 58513.0 |
146 | 2021-04-21 13:22:05 | stonecrops | 1 | 67641 | 2 | 1.170 | 57812.8 |
145 | 2021-04-17 20:17:42 | stonecrops | 1 | 67641 | 2 | 1.220 | 55443.4 |
144 | 2021-04-11 15:23:44 | stonecrops | 1 | 67641 | 2 | 1.143 | 59178.5 |
143 | 2021-04-03 06:04:14 | stonecrops | 2 | 108824 | 2 | 2.983 | 36481.4 |
142 | 2021-03-07 16:46:42 | stonecrops | 2 | 108824 | 2 | 3.280 | 33178.0 |
141 | 2021-02-18 14:30:45 | stonecrops | 1 | 67641 | 2 | 1.080 | 62630.6 |
140 | 2021-01-30 21:57:49 | stonecrops | 3 | 140603 | 7 | 5.796 | 24258.6 |
139 | 2021-01-18 02:31:58 | stonecrops | 2 | 108824 | 2 | 2.686 | 40515.3 |
138 | 2021-01-02 21:07:23 | stonecrops | 3 | 140603 | 7 | 5.466 | 25723.2 |
137 | 2020-12-19 02:48:59 | stonecrops | 2 | 108824 | 2 | 2.656 | 40972.9 |
136 | 2020-12-13 07:20:33 | stonecrops | 1 | 67641 | 2 | 1.046 | 64666.3 |
135 | 2020-11-11 04:30:25 | stonecrops | 3 | 140603 | 7 | 5.873 | 23940.6 |
134 | 2020-10-29 11:41:00 | stonecrops | 2 | 108824 | 2 | 2.830 | 38453.7 |
133 | 2020-10-13 19:25:31 | stonecrops | 1 | 67641 | 2 | 1.033 | 65480.2 |
132 | 2020-10-12 17:31:31 | stonecrops | 1 | 67641 | 2 | 1.220 | 55443.4 |
131 | 2020-08-21 02:45:25 | stonecrops | 1 | 67641 | 2 | 1.030 | 65670.9 |
130 | 2020-04-24 21:21:14 | stonecrops | 1 | 67641 | 2 | 1.153 | 58665.2 |
129 | 2020-03-26 03:51:39 | stonecrops | 1 | 67641 | 2 | 1.173 | 57665.0 |
128 | 2020-02-14 17:09:44 | stonecrops | 1 | 67641 | 2 | 1.220 | 55443.4 |
127 | 2020-02-11 15:14:55 | stonecrops | 1 | 67641 | 2 | 1.330 | 50857.9 |
126 | 2020-02-10 05:01:28 | stonecrops | 1 | 67641 | 2 | 1.313 | 51516.4 |
125 | 2020-02-08 22:40:27 | stonecrops | 1 | 67641 | 2 | 2.563 | 26391.3 |
124 | 2020-01-22 22:28:04 | stonecrops | 1 | 67641 | 2 | 1.530 | 44209.8 |
123 | 2020-01-15 14:30:52 | stonecrops | 1 | 67641 | 2 | 1.236 | 54725.7 |
122 | 2020-01-06 23:48:42 | stonecrops | 1 | 67641 | 2 | 1.126 | 60071.9 |
121 | 2019-12-20 00:28:19 | stonecrops | 1 | 67641 | 2 | 1.030 | 65670.9 |
120 | 2019-09-18 18:45:56 | stonecrops | 1 | 67641 | 2 | 1.083 | 62457.1 |
119 | 2019-07-15 14:32:34 | stonecrops | 1 | 67641 | 2 | 1.106 | 61158.2 |
118 | 2019-06-30 11:12:34 | stonecrops | 1 | 67641 | 2 | 1.010 | 66971.3 |
117 | 2019-06-05 02:25:49 | stonecrops | 1 | 67641 | 2 | 1.136 | 59543.1 |
116 | 2019-06-02 03:01:32 | stonecrops | 1 | 67641 | 2 | 1.040 | 65039.4 |
115 | 2019-05-29 04:54:58 | stonecrops | 1 | 67641 | 2 | 1.020 | 66314.7 |
114 | 2019-05-22 06:14:29 | stonecrops | 1 | 67641 | 2 | 1.030 | 65670.9 |
113 | 2019-04-30 14:13:29 | stonecrops | 1 | 67641 | 2 | 1.040 | 65039.4 |
112 | 2018-12-28 09:19:06 | stonecrops | 1 | 67641 | 2 | 1.140 | 59334.2 |
111 | 2018-07-11 00:42:17 | stonecrops | 1 | 67641 | 2 | 1.026 | 65926.9 |
110 | 2018-05-12 17:01:41 | stonecrops | 1 | 67641 | 2 | 1.106 | 61158.2 |
109 | 2018-05-05 21:39:16 | stonecrops | 1 | 67641 | 2 | 1.186 | 57032.9 |
108 | 2018-02-09 10:57:58 | stonecrops | 1 | 67641 | 2 | 2.030 | 33320.7 |
107 | 2018-01-05 00:54:50 | stonecrops | 1 | 67641 | 2 | 2.016 | 33552.1 |
106 | 2017-12-11 03:47:24 | stonecrops | 1 | 67641 | 2 | 1.713 | 39486.9 |
105 | 2017-11-09 15:04:25 | stonecrops | 1 | 67641 | 2 | 2.103 | 32164.1 |
104 | 2017-08-02 11:20:15 | stonecrops | 1 | 67641 | 2 | 1.426 | 47434.1 |
103 | 2017-01-25 05:31:06 | stonecrops | 5 | 173545 | 486 | 20.686 | 8389.5 |
102 | 2017-01-17 13:02:40 | stonecrops | 5 | 173545 | 486 | 21.046 | 8246.0 |
101 | 2016-09-15 18:06:55 | stonecrops | 5 | 173545 | 486 | 27.226 | 6374.2 |
100 | 2016-09-11 11:34:03 | stonecrops | 1 | 67641 | 2 | 1.540 | 43922.7 |
99 | 2016-09-11 03:56:44 | stonecrops | 5 | 173545 | 486 | 21.706 | 7995.3 |
98 | 2016-09-07 04:16:24 | stonecrops | 5 | 173545 | 486 | 39.713 | 4370.0 |
97 | 2016-09-05 06:21:29 | stonecrops | 5 | 173545 | 486 | 22.493 | 7715.5 |