History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"overwater"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
181 | 2024-05-02 05:44:43 | overwater | 1 | 81242 | 3 | 1.546 | 52549.8 |
180 | 2024-05-01 01:44:59 | overwater | 1 | 81242 | 3 | 1.390 | 58447.5 |
179 | 2024-04-30 04:33:30 | overwater | 1 | 81242 | 3 | 1.486 | 54671.6 |
178 | 2024-04-24 17:29:52 | overwater | 1 | 81242 | 3 | 1.326 | 61268.5 |
177 | 2024-04-03 00:56:49 | overwater | 3 | 148641 | 114 | 11.750 | 12650.3 |
176 | 2024-03-30 19:43:42 | overwater | 1 | 81242 | 3 | 5.720 | 14203.1 |
175 | 2024-03-30 10:08:40 | overwater | 3 | 148641 | 114 | 25.596 | 5807.2 |
174 | 2024-03-29 22:01:32 | overwater | 1 | 81242 | 3 | 1.530 | 53099.3 |
173 | 2024-03-29 07:35:08 | overwater | 3 | 148641 | 114 | 17.406 | 8539.6 |
172 | 2024-03-29 05:44:45 | overwater | 1 | 81242 | 3 | 4.983 | 16303.8 |
171 | 2024-03-21 17:36:38 | overwater | 2 | 121436 | 18 | 12.453 | 9751.5 |
170 | 2024-03-19 14:32:51 | overwater | 2 | 121436 | 18 | 8.453 | 14366.0 |
169 | 2024-03-19 14:14:00 | overwater | 1 | 81242 | 3 | 1.550 | 52414.2 |
168 | 2024-03-08 01:59:21 | overwater | 1 | 81242 | 3 | 1.406 | 57782.4 |
167 | 2024-02-29 01:30:10 | overwater | 1 | 81242 | 3 | 1.453 | 55913.3 |
166 | 2024-02-26 06:44:37 | overwater | 3 | 148641 | 114 | 9.126 | 16287.6 |
165 | 2024-02-26 05:03:22 | overwater | 1 | 81242 | 3 | 2.873 | 28277.8 |
164 | 2024-02-24 21:28:39 | overwater | 3 | 148641 | 114 | 23.873 | 6226.3 |
163 | 2024-02-02 03:55:23 | overwater | 1 | 81242 | 3 | 1.343 | 60492.9 |
162 | 2024-01-30 07:16:39 | overwater | 1 | 81242 | 3 | 1.436 | 56575.2 |
161 | 2024-01-20 08:15:52 | overwater | 3 | 148641 | 114 | 6.110 | 24327.5 |
160 | 2024-01-12 14:50:53 | overwater | 2 | 121436 | 18 | 3.530 | 34401.1 |
159 | 2023-12-21 19:51:31 | overwater | 1 | 81242 | 3 | 1.220 | 66591.8 |
158 | 2023-12-20 10:07:00 | overwater | 1 | 81242 | 3 | 1.516 | 53589.7 |
157 | 2023-12-14 04:02:51 | overwater | 1 | 81242 | 3 | 1.203 | 67532.8 |
156 | 2023-10-31 11:30:13 | overwater | 3 | 148641 | 114 | 6.920 | 21479.9 |
155 | 2023-10-18 23:43:15 | overwater | 2 | 121436 | 18 | 3.173 | 38271.7 |
154 | 2023-10-09 01:58:23 | overwater | 1 | 81242 | 3 | 1.216 | 66810.9 |
153 | 2023-10-06 22:13:06 | overwater | 1 | 81242 | 3 | 1.343 | 60492.9 |
152 | 2023-08-07 16:26:37 | overwater | 3 | 148641 | 114 | 6.436 | 23095.2 |
151 | 2023-08-03 17:01:03 | overwater | 1 | 81242 | 3 | 1.423 | 57092.1 |
150 | 2023-07-29 11:21:32 | overwater | 2 | 121436 | 18 | 3.440 | 35301.2 |
149 | 2023-06-02 11:03:00 | overwater | 1 | 81242 | 3 | 1.220 | 66591.8 |
148 | 2023-05-01 22:18:03 | overwater | 1 | 81242 | 3 | 1.376 | 59042.2 |
147 | 2023-04-19 13:12:31 | overwater | 3 | 148641 | 114 | 6.000 | 24773.5 |
146 | 2023-04-06 11:45:18 | overwater | 2 | 121436 | 18 | 2.953 | 41122.9 |
145 | 2023-02-20 15:31:22 | overwater | 1 | 81242 | 3 | 1.390 | 58447.5 |
144 | 2023-01-23 21:36:05 | overwater | 1 | 81242 | 3 | 1.330 | 61084.2 |
143 | 2023-01-18 23:07:26 | overwater | 3 | 148641 | 114 | 5.920 | 25108.3 |
142 | 2023-01-06 04:30:33 | overwater | 2 | 121436 | 18 | 3.343 | 36325.5 |
141 | 2022-12-18 12:54:03 | overwater | 1 | 81242 | 3 | 1.360 | 59736.8 |
140 | 2022-10-30 05:46:45 | overwater | 3 | 148641 | 114 | 5.970 | 24898.0 |
139 | 2022-09-10 18:53:43 | overwater | 1 | 81242 | 3 | 1.330 | 61084.2 |
138 | 2022-09-09 09:00:43 | overwater | 2 | 121436 | 18 | 3.016 | 40263.9 |
137 | 2022-08-31 19:31:23 | overwater | 1 | 81242 | 3 | 1.233 | 65889.7 |
136 | 2022-05-10 16:43:50 | overwater | 3 | 148641 | 114 | 8.156 | 18224.7 |
135 | 2022-05-05 01:04:54 | overwater | 1 | 81242 | 3 | 1.233 | 65889.7 |
134 | 2022-04-11 20:36:09 | overwater | 1 | 81242 | 3 | 1.500 | 54161.3 |
133 | 2022-04-08 06:04:47 | overwater | 1 | 81242 | 3 | 1.216 | 66810.9 |
132 | 2022-03-30 16:23:59 | overwater | 2 | 121436 | 18 | 3.830 | 31706.5 |
131 | 2022-01-07 19:01:48 | overwater | 1 | 81242 | 3 | 1.483 | 54782.2 |
130 | 2022-01-07 15:59:09 | overwater | 1 | 81242 | 3 | 1.390 | 58447.5 |
129 | 2021-12-30 04:44:01 | overwater | 2 | 121436 | 18 | 3.470 | 34996.0 |
128 | 2021-12-22 07:57:15 | overwater | 1 | 81242 | 3 | 1.250 | 64993.6 |
127 | 2021-11-13 00:25:04 | overwater | 1 | 81242 | 3 | 1.283 | 63321.9 |
126 | 2021-11-05 22:27:28 | overwater | 1 | 81242 | 3 | 1.346 | 60358.1 |
125 | 2021-11-03 19:59:28 | overwater | 1 | 81242 | 3 | 1.203 | 67532.8 |
124 | 2021-10-06 01:30:11 | overwater | 1 | 81242 | 3 | 1.313 | 61875.1 |
123 | 2021-09-22 02:11:42 | overwater | 1 | 81242 | 3 | 1.250 | 64993.6 |
122 | 2021-06-19 00:31:37 | overwater | 1 | 81242 | 3 | 1.330 | 61084.2 |
121 | 2021-06-16 09:01:43 | overwater | 1 | 81242 | 3 | 1.250 | 64993.6 |
120 | 2021-05-13 22:33:20 | overwater | 1 | 81242 | 3 | 1.500 | 54161.3 |
119 | 2021-05-08 23:28:48 | overwater | 1 | 81242 | 3 | 1.266 | 64172.2 |
118 | 2021-04-12 22:00:54 | overwater | 1 | 81242 | 3 | 1.406 | 57782.4 |
117 | 2021-03-16 08:49:30 | overwater | 1 | 81242 | 3 | 1.203 | 67532.8 |
116 | 2020-12-13 09:31:26 | overwater | 1 | 81242 | 3 | 1.233 | 65889.7 |
115 | 2020-11-02 15:00:28 | overwater | 1 | 81242 | 3 | 1.420 | 57212.7 |
114 | 2020-09-03 00:16:29 | overwater | 1 | 81242 | 3 | 1.203 | 67532.8 |
113 | 2020-05-16 18:29:53 | overwater | 1 | 81242 | 3 | 1.203 | 67532.8 |
112 | 2020-03-29 18:09:46 | overwater | 1 | 81242 | 3 | 1.483 | 54782.2 |
111 | 2020-03-26 09:39:04 | overwater | 1 | 81242 | 3 | 1.283 | 63321.9 |
110 | 2020-03-01 00:58:23 | overwater | 1 | 81242 | 3 | 1.436 | 56575.2 |
109 | 2020-02-29 23:27:43 | overwater | 1 | 81242 | 3 | 1.360 | 59736.8 |
108 | 2020-02-19 22:40:40 | overwater | 1 | 81242 | 3 | 1.406 | 57782.4 |
107 | 2020-02-17 00:44:19 | overwater | 1 | 81242 | 3 | 1.580 | 51419.0 |
106 | 2020-02-16 19:47:00 | overwater | 1 | 81242 | 3 | 1.766 | 46003.4 |
105 | 2020-02-12 23:21:54 | overwater | 1 | 81242 | 3 | 1.470 | 55266.7 |
104 | 2020-02-06 23:40:13 | overwater | 1 | 81242 | 3 | 2.906 | 27956.6 |
103 | 2020-02-06 19:32:34 | overwater | 1 | 81242 | 3 | 1.720 | 47233.7 |
102 | 2020-02-05 04:08:19 | overwater | 1 | 81242 | 3 | 1.453 | 55913.3 |
101 | 2020-01-25 08:43:13 | overwater | 1 | 81242 | 3 | 4.656 | 17448.9 |
100 | 2020-01-24 02:27:33 | overwater | 1 | 81242 | 3 | 3.203 | 25364.3 |
99 | 2020-01-23 05:52:23 | overwater | 1 | 81242 | 3 | 1.770 | 45899.4 |
98 | 2020-01-15 23:42:06 | overwater | 1 | 81242 | 3 | 1.420 | 57212.7 |
97 | 2020-01-13 23:43:04 | overwater | 1 | 81242 | 3 | 1.500 | 54161.3 |
96 | 2020-01-03 00:06:10 | overwater | 1 | 81242 | 3 | 1.313 | 61875.1 |
95 | 2019-12-29 17:44:06 | overwater | 1 | 81242 | 3 | 1.220 | 66591.8 |
94 | 2019-11-04 11:27:18 | overwater | 1 | 81242 | 3 | 1.280 | 63470.3 |
93 | 2019-08-06 10:23:18 | overwater | 1 | 81242 | 3 | 1.170 | 69437.6 |
92 | 2019-04-30 05:11:08 | overwater | 1 | 81242 | 3 | 1.196 | 67928.1 |
91 | 2019-04-03 14:42:57 | overwater | 1 | 81242 | 3 | 1.300 | 62493.8 |
90 | 2019-03-01 04:48:44 | overwater | 1 | 81242 | 3 | 1.183 | 68674.6 |
89 | 2019-02-25 19:34:05 | overwater | 1 | 81242 | 3 | 1.173 | 69260.0 |
88 | 2019-02-20 14:41:50 | overwater | 1 | 81242 | 3 | 1.190 | 68270.6 |
87 | 2019-02-13 21:39:32 | overwater | 1 | 81242 | 3 | 1.216 | 66810.9 |
86 | 2019-02-12 04:49:37 | overwater | 1 | 81242 | 3 | 1.203 | 67532.8 |
85 | 2019-01-30 22:14:32 | overwater | 1 | 81242 | 3 | 1.183 | 68674.6 |
84 | 2019-01-25 22:26:23 | overwater | 1 | 81242 | 3 | 1.413 | 57496.1 |
83 | 2019-01-12 05:39:34 | overwater | 1 | 81242 | 3 | 1.230 | 66050.4 |
82 | 2019-01-08 17:30:31 | overwater | 1 | 81242 | 3 | 1.386 | 58616.2 |