History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sprinkle"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
201 | 2024-04-13 03:54:45 | sprinkle | 1 | 82945 | 4 | 1.606 | 51646.9 |
200 | 2024-04-09 20:23:16 | sprinkle | 2 | 121059 | 14 | 9.250 | 13087.5 |
199 | 2024-04-08 23:26:44 | sprinkle | 3 | 146162 | 119 | 10.126 | 14434.3 |
198 | 2024-04-08 23:26:45 | sprinkle | 2 | 121059 | 14 | 8.940 | 13541.3 |
197 | 2024-04-08 06:15:49 | sprinkle | 2 | 121059 | 14 | 3.546 | 34139.6 |
196 | 2024-04-08 06:13:44 | sprinkle | 3 | 146162 | 119 | 7.516 | 19446.8 |
195 | 2024-04-08 02:32:39 | sprinkle | 2 | 121059 | 14 | 4.190 | 28892.4 |
194 | 2024-04-06 14:40:11 | sprinkle | 3 | 146162 | 119 | 7.893 | 18517.9 |
193 | 2024-04-05 19:34:04 | sprinkle | 3 | 146162 | 119 | 16.050 | 9106.7 |
192 | 2024-04-05 19:34:03 | sprinkle | 2 | 121059 | 14 | 7.860 | 15401.9 |
191 | 2024-04-05 19:34:00 | sprinkle | 1 | 82945 | 4 | 3.190 | 26001.6 |
190 | 2024-03-30 06:52:18 | sprinkle | 1 | 82945 | 4 | 3.233 | 25655.7 |
189 | 2024-03-29 19:08:59 | sprinkle | 1 | 82945 | 4 | 1.486 | 55817.6 |
188 | 2024-03-16 01:09:30 | sprinkle | 3 | 146162 | 119 | 16.530 | 8842.2 |
187 | 2024-03-10 10:00:09 | sprinkle | 3 | 146162 | 119 | 21.440 | 6817.3 |
186 | 2024-03-07 22:57:01 | sprinkle | 2 | 121059 | 14 | 5.780 | 20944.5 |
185 | 2024-03-07 22:40:21 | sprinkle | 2 | 121059 | 14 | 3.860 | 31362.4 |
184 | 2024-03-07 22:39:33 | sprinkle | 3 | 146162 | 119 | 7.966 | 18348.2 |
183 | 2024-03-06 13:43:58 | sprinkle | 2 | 121059 | 14 | 7.360 | 16448.2 |
182 | 2024-03-06 13:43:54 | sprinkle | 3 | 146162 | 119 | 8.893 | 16435.6 |
181 | 2024-03-06 13:43:42 | sprinkle | 1 | 82945 | 4 | 1.623 | 51106.0 |
180 | 2024-03-06 13:43:31 | sprinkle | 2 | 121059 | 14 | 9.283 | 13040.9 |
179 | 2024-03-06 13:43:30 | sprinkle | 3 | 146162 | 119 | 9.296 | 15723.1 |
178 | 2024-03-06 13:43:27 | sprinkle | 1 | 82945 | 4 | 3.140 | 26415.6 |
177 | 2024-02-28 12:49:07 | sprinkle | 1 | 82945 | 4 | 1.563 | 53067.8 |
176 | 2024-02-10 00:37:44 | sprinkle | 2 | 121059 | 14 | 4.156 | 29128.7 |
175 | 2024-02-05 01:06:46 | sprinkle | 3 | 146162 | 119 | 15.376 | 9505.9 |
174 | 2024-02-04 22:38:15 | sprinkle | 3 | 146162 | 119 | 13.236 | 11042.8 |
173 | 2024-02-04 22:38:12 | sprinkle | 2 | 121059 | 14 | 6.576 | 18409.2 |
172 | 2024-01-31 07:24:27 | sprinkle | 2 | 121059 | 14 | 4.346 | 27855.3 |
171 | 2024-01-29 22:16:28 | sprinkle | 2 | 121059 | 14 | 6.826 | 17735.0 |
170 | 2024-01-29 22:15:47 | sprinkle | 3 | 146162 | 119 | 8.703 | 16794.4 |
169 | 2024-01-29 22:15:45 | sprinkle | 3 | 146162 | 119 | 8.500 | 17195.5 |
168 | 2024-01-29 20:02:04 | sprinkle | 3 | 146162 | 119 | 13.766 | 10617.6 |
167 | 2024-01-29 16:20:01 | sprinkle | 3 | 146162 | 119 | 7.670 | 19056.3 |
166 | 2024-01-07 21:49:31 | sprinkle | 1 | 82945 | 4 | 1.516 | 54713.1 |
165 | 2023-12-29 15:00:36 | sprinkle | 1 | 82945 | 4 | 1.296 | 64000.8 |
164 | 2023-12-09 23:32:56 | sprinkle | 2 | 121059 | 14 | 3.326 | 36397.8 |
163 | 2023-12-07 05:52:50 | sprinkle | 3 | 146162 | 119 | 7.936 | 18417.6 |
162 | 2023-12-03 11:11:34 | sprinkle | 3 | 146162 | 119 | 7.626 | 19166.3 |
161 | 2023-12-02 12:48:30 | sprinkle | 1 | 82945 | 4 | 1.390 | 59672.7 |
160 | 2023-11-18 06:55:32 | sprinkle | 1 | 82945 | 4 | 1.500 | 55296.7 |
159 | 2023-11-07 05:57:12 | sprinkle | 3 | 146162 | 119 | 6.343 | 23043.0 |
158 | 2023-10-17 18:58:51 | sprinkle | 1 | 82945 | 4 | 1.423 | 58288.8 |
157 | 2023-09-29 13:03:51 | sprinkle | 1 | 82945 | 4 | 1.373 | 60411.5 |
156 | 2023-09-13 19:12:07 | sprinkle | 3 | 146162 | 119 | 8.923 | 16380.4 |
155 | 2023-09-11 23:31:01 | sprinkle | 1 | 82945 | 4 | 2.766 | 29987.3 |
154 | 2023-09-11 23:29:01 | sprinkle | 2 | 121059 | 14 | 4.360 | 27765.8 |
153 | 2023-09-05 00:52:16 | sprinkle | 2 | 121059 | 14 | 3.376 | 35858.7 |
152 | 2023-08-13 05:02:41 | sprinkle | 1 | 82945 | 4 | 1.330 | 62364.7 |
151 | 2023-08-12 01:28:15 | sprinkle | 3 | 146162 | 119 | 6.453 | 22650.2 |
150 | 2023-07-28 17:10:01 | sprinkle | 1 | 82945 | 4 | 1.280 | 64800.8 |
149 | 2023-05-11 18:45:11 | sprinkle | 1 | 82945 | 4 | 1.563 | 53067.8 |
148 | 2023-04-26 07:47:24 | sprinkle | 3 | 146162 | 119 | 6.296 | 23215.1 |
147 | 2023-03-06 01:01:53 | sprinkle | 1 | 82945 | 4 | 1.266 | 65517.4 |
146 | 2023-03-05 18:42:38 | sprinkle | 1 | 82945 | 4 | 1.296 | 64000.8 |
145 | 2023-02-20 13:10:19 | sprinkle | 2 | 121059 | 14 | 3.156 | 38358.4 |
144 | 2023-02-13 15:55:10 | sprinkle | 3 | 146162 | 119 | 7.016 | 20832.7 |
143 | 2023-02-01 03:22:31 | sprinkle | 3 | 146162 | 119 | 7.876 | 18557.9 |
142 | 2022-12-29 03:46:12 | sprinkle | 3 | 146162 | 119 | 6.673 | 21903.5 |
141 | 2022-12-27 22:13:13 | sprinkle | 1 | 82945 | 4 | 1.530 | 54212.4 |
140 | 2022-12-27 00:50:55 | sprinkle | 3 | 146162 | 119 | 6.720 | 21750.3 |
139 | 2022-12-12 20:22:18 | sprinkle | 3 | 146162 | 119 | 6.296 | 23215.1 |
138 | 2022-12-02 20:20:30 | sprinkle | 2 | 121059 | 14 | 3.186 | 37997.2 |
137 | 2022-11-12 01:59:40 | sprinkle | 3 | 146162 | 119 | 6.373 | 22934.6 |
136 | 2022-11-08 20:05:03 | sprinkle | 3 | 146162 | 119 | 7.780 | 18786.9 |
135 | 2022-10-08 14:55:44 | sprinkle | 1 | 82945 | 4 | 1.453 | 57085.3 |
134 | 2022-09-14 12:23:23 | sprinkle | 1 | 82945 | 4 | 1.250 | 66356.0 |
133 | 2022-09-05 19:44:20 | sprinkle | 3 | 146162 | 119 | 6.326 | 23105.0 |
132 | 2022-07-13 04:09:58 | sprinkle | 1 | 82945 | 4 | 1.283 | 64649.3 |
131 | 2022-06-14 10:08:27 | sprinkle | 3 | 146162 | 119 | 6.686 | 21860.9 |
130 | 2022-04-30 12:33:21 | sprinkle | 1 | 82945 | 4 | 1.326 | 62552.8 |
129 | 2022-04-10 18:43:29 | sprinkle | 2 | 121059 | 14 | 3.173 | 38152.9 |
128 | 2022-04-09 08:55:17 | sprinkle | 2 | 121059 | 14 | 3.186 | 37997.2 |
127 | 2022-03-17 16:25:22 | sprinkle | 1 | 82945 | 4 | 1.670 | 49667.7 |
126 | 2022-01-11 19:53:55 | sprinkle | 1 | 82945 | 4 | 1.310 | 63316.8 |
125 | 2022-01-02 08:25:57 | sprinkle | 2 | 121059 | 14 | 3.780 | 32026.2 |
124 | 2021-12-09 03:55:23 | sprinkle | 1 | 82945 | 4 | 1.500 | 55296.7 |
123 | 2021-10-21 13:41:52 | sprinkle | 1 | 82945 | 4 | 1.406 | 58993.6 |
122 | 2021-09-25 16:10:26 | sprinkle | 2 | 121059 | 14 | 7.813 | 15494.6 |
121 | 2021-09-20 13:54:13 | sprinkle | 1 | 82945 | 4 | 2.593 | 31988.0 |
120 | 2021-09-20 01:02:42 | sprinkle | 1 | 82945 | 4 | 1.343 | 61761.0 |
119 | 2021-09-19 08:31:54 | sprinkle | 2 | 121059 | 14 | 3.860 | 31362.4 |
118 | 2021-09-19 08:26:18 | sprinkle | 1 | 82945 | 4 | 1.436 | 57761.1 |
117 | 2021-09-13 01:06:33 | sprinkle | 1 | 82945 | 4 | 1.393 | 59544.1 |
116 | 2021-07-29 23:50:12 | sprinkle | 1 | 82945 | 4 | 1.406 | 58993.6 |
115 | 2021-04-06 06:45:40 | sprinkle | 1 | 82945 | 4 | 1.470 | 56425.2 |
114 | 2021-03-10 13:33:48 | sprinkle | 1 | 82945 | 4 | 1.313 | 63172.1 |
113 | 2021-01-27 14:40:05 | sprinkle | 3 | 146162 | 119 | 6.656 | 21959.4 |
112 | 2021-01-24 07:10:55 | sprinkle | 3 | 146162 | 119 | 6.326 | 23105.0 |
111 | 2021-01-21 13:09:32 | sprinkle | 1 | 82945 | 4 | 1.343 | 61761.0 |
110 | 2020-12-25 23:17:09 | sprinkle | 3 | 146162 | 119 | 6.466 | 22604.7 |
109 | 2020-12-22 07:23:20 | sprinkle | 1 | 82945 | 4 | 1.466 | 56579.1 |
108 | 2020-11-04 00:25:11 | sprinkle | 1 | 82945 | 4 | 1.516 | 54713.1 |
107 | 2020-03-30 08:33:33 | sprinkle | 1 | 82945 | 4 | 1.280 | 64800.8 |
106 | 2020-03-23 23:14:32 | sprinkle | 1 | 82945 | 4 | 1.483 | 55930.5 |
105 | 2020-02-29 19:31:37 | sprinkle | 1 | 82945 | 4 | 1.580 | 52496.8 |
104 | 2020-02-29 18:21:54 | sprinkle | 1 | 82945 | 4 | 1.470 | 56425.2 |
103 | 2020-02-24 22:59:42 | sprinkle | 1 | 82945 | 4 | 1.826 | 45424.4 |
102 | 2020-02-23 11:14:05 | sprinkle | 1 | 82945 | 4 | 1.610 | 51518.6 |