History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"nectarine"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
188 | 2024-04-28 18:26:55 | nectarine | 1 | 81242 | 2 | 1.373 | 59171.2 |
187 | 2024-04-19 10:48:27 | nectarine | 3 | 148641 | 38 | 15.363 | 9675.3 |
186 | 2024-04-19 10:48:24 | nectarine | 2 | 121436 | 5 | 13.220 | 9185.8 |
185 | 2024-04-19 10:06:26 | nectarine | 1 | 81242 | 2 | 1.296 | 62686.7 |
184 | 2024-04-12 00:10:28 | nectarine | 3 | 148641 | 38 | 20.813 | 7141.7 |
183 | 2024-04-10 15:24:56 | nectarine | 3 | 148641 | 38 | 12.063 | 12322.1 |
182 | 2024-04-08 17:38:58 | nectarine | 4 | 165329 | 434 | 29.893 | 5530.7 |
181 | 2024-04-08 17:19:06 | nectarine | 4 | 165329 | 434 | 27.876 | 5930.9 |
180 | 2024-04-06 18:41:32 | nectarine | 1 | 81242 | 2 | 2.170 | 37438.7 |
179 | 2024-04-04 08:59:39 | nectarine | 3 | 148641 | 38 | 16.376 | 9076.8 |
178 | 2024-04-04 08:59:37 | nectarine | 2 | 121436 | 5 | 12.096 | 10039.4 |
177 | 2024-04-04 08:59:32 | nectarine | 4 | 165329 | 434 | 16.203 | 10203.6 |
176 | 2024-04-04 06:29:43 | nectarine | 1 | 81242 | 2 | 1.453 | 55913.3 |
175 | 2024-03-28 10:28:45 | nectarine | 1 | 81242 | 2 | 1.266 | 64172.2 |
174 | 2024-03-20 06:21:59 | nectarine | 3 | 148641 | 38 | 28.110 | 5287.8 |
173 | 2024-03-20 06:21:58 | nectarine | 2 | 121436 | 5 | 8.750 | 13878.4 |
172 | 2024-03-20 05:57:10 | nectarine | 1 | 81242 | 2 | 1.403 | 57905.9 |
171 | 2024-03-06 14:53:00 | nectarine | 1 | 81242 | 2 | 1.390 | 58447.5 |
170 | 2024-03-03 06:09:20 | nectarine | 4 | 165329 | 434 | 14.640 | 11293.0 |
169 | 2024-03-02 14:47:51 | nectarine | 4 | 165329 | 434 | 32.910 | 5023.7 |
168 | 2024-03-02 14:47:51 | nectarine | 3 | 148641 | 38 | 22.940 | 6479.6 |
167 | 2024-03-02 14:47:52 | nectarine | 2 | 121436 | 5 | 8.593 | 14132.0 |
166 | 2024-03-02 13:54:50 | nectarine | 1 | 81242 | 2 | 3.126 | 25989.1 |
165 | 2024-03-01 09:28:28 | nectarine | 1 | 81242 | 2 | 3.140 | 25873.2 |
164 | 2024-02-27 09:01:40 | nectarine | 1 | 81242 | 2 | 1.846 | 44009.8 |
163 | 2024-02-14 07:31:50 | nectarine | 1 | 81242 | 2 | 1.423 | 57092.1 |
162 | 2024-01-30 20:48:36 | nectarine | 1 | 81242 | 2 | 1.436 | 56575.2 |
161 | 2024-01-26 08:32:19 | nectarine | 1 | 81242 | 2 | 1.436 | 56575.2 |
160 | 2024-01-12 20:05:33 | nectarine | 2 | 121436 | 5 | 3.140 | 38673.9 |
159 | 2023-12-30 21:20:30 | nectarine | 4 | 165329 | 434 | 13.033 | 12685.4 |
158 | 2023-12-19 08:03:44 | nectarine | 1 | 81242 | 2 | 1.266 | 64172.2 |
157 | 2023-12-05 12:44:56 | nectarine | 1 | 81242 | 2 | 1.453 | 55913.3 |
156 | 2023-12-02 14:46:42 | nectarine | 1 | 81242 | 2 | 1.216 | 66810.9 |
155 | 2023-11-28 19:18:12 | nectarine | 1 | 81242 | 2 | 1.250 | 64993.6 |
154 | 2023-10-25 18:19:02 | nectarine | 1 | 81242 | 2 | 1.406 | 57782.4 |
153 | 2023-10-24 07:03:50 | nectarine | 1 | 81242 | 2 | 1.373 | 59171.2 |
152 | 2023-10-20 14:55:54 | nectarine | 2 | 121436 | 5 | 3.173 | 38271.7 |
151 | 2023-10-05 01:43:01 | nectarine | 4 | 165329 | 434 | 11.266 | 14675.0 |
150 | 2023-09-16 11:00:08 | nectarine | 1 | 81242 | 2 | 1.453 | 55913.3 |
149 | 2023-08-01 02:30:24 | nectarine | 2 | 121436 | 5 | 3.076 | 39478.5 |
148 | 2023-07-16 07:02:14 | nectarine | 4 | 165329 | 434 | 10.686 | 15471.6 |
147 | 2023-07-07 16:43:30 | nectarine | 1 | 81242 | 2 | 1.216 | 66810.9 |
146 | 2023-06-17 14:22:35 | nectarine | 1 | 81242 | 2 | 1.250 | 64993.6 |
145 | 2023-04-13 14:42:46 | nectarine | 1 | 81242 | 2 | 1.376 | 59042.2 |
144 | 2023-04-06 23:58:55 | nectarine | 2 | 121436 | 5 | 3.080 | 39427.3 |
143 | 2023-03-30 18:24:32 | nectarine | 4 | 165329 | 434 | 12.470 | 13258.1 |
142 | 2023-02-19 15:59:36 | nectarine | 1 | 81242 | 2 | 1.390 | 58447.5 |
141 | 2023-02-06 05:23:51 | nectarine | 1 | 81242 | 2 | 1.203 | 67532.8 |
140 | 2023-01-05 03:08:59 | nectarine | 2 | 121436 | 5 | 3.046 | 39867.4 |
139 | 2022-12-26 01:39:54 | nectarine | 4 | 165329 | 434 | 11.580 | 14277.1 |
138 | 2022-12-04 22:22:40 | nectarine | 1 | 81242 | 2 | 1.233 | 65889.7 |
137 | 2022-10-11 19:19:19 | nectarine | 1 | 81242 | 2 | 1.250 | 64993.6 |
136 | 2022-09-11 11:46:02 | nectarine | 2 | 121436 | 5 | 3.123 | 38884.4 |
135 | 2022-09-09 09:29:03 | nectarine | 2 | 121436 | 5 | 3.076 | 39478.5 |
134 | 2022-09-01 21:06:30 | nectarine | 3 | 148641 | 38 | 6.326 | 23496.8 |
133 | 2022-09-01 14:55:58 | nectarine | 4 | 165329 | 434 | 11.266 | 14675.0 |
132 | 2022-08-25 21:49:47 | nectarine | 4 | 165329 | 434 | 11.093 | 14903.9 |
131 | 2022-08-25 19:17:35 | nectarine | 3 | 148641 | 38 | 7.080 | 20994.5 |
130 | 2022-08-01 12:04:41 | nectarine | 1 | 81242 | 2 | 1.266 | 64172.2 |
129 | 2022-07-29 13:26:21 | nectarine | 1 | 81242 | 2 | 1.343 | 60492.9 |
128 | 2022-06-08 08:34:13 | nectarine | 4 | 165329 | 434 | 11.486 | 14394.0 |
127 | 2022-05-27 22:40:33 | nectarine | 1 | 81242 | 2 | 1.343 | 60492.9 |
126 | 2022-05-03 06:24:32 | nectarine | 4 | 165329 | 434 | 10.813 | 15289.8 |
125 | 2022-04-30 01:53:53 | nectarine | 4 | 165329 | 434 | 10.810 | 15294.1 |
124 | 2022-04-01 19:43:07 | nectarine | 2 | 121436 | 5 | 3.296 | 36843.4 |
123 | 2022-03-30 16:21:33 | nectarine | 2 | 121436 | 5 | 4.390 | 27662.0 |
122 | 2022-03-26 20:05:51 | nectarine | 1 | 81242 | 2 | 1.280 | 63470.3 |
121 | 2022-03-21 00:52:16 | nectarine | 4 | 165329 | 434 | 12.610 | 13110.9 |
120 | 2022-01-19 14:50:55 | nectarine | 1 | 81242 | 2 | 1.296 | 62686.7 |
119 | 2022-01-16 08:30:02 | nectarine | 1 | 81242 | 2 | 1.373 | 59171.2 |
118 | 2022-01-13 01:34:51 | nectarine | 1 | 81242 | 2 | 1.280 | 63470.3 |
117 | 2021-12-30 04:42:39 | nectarine | 2 | 121436 | 5 | 3.220 | 37713.0 |
116 | 2021-12-26 09:33:48 | nectarine | 1 | 81242 | 2 | 1.406 | 57782.4 |
115 | 2021-12-10 03:57:21 | nectarine | 4 | 165329 | 434 | 15.266 | 10829.9 |
114 | 2021-11-14 14:29:51 | nectarine | 1 | 81242 | 2 | 2.266 | 35852.6 |
113 | 2021-09-27 07:15:23 | nectarine | 1 | 81242 | 2 | 1.423 | 57092.1 |
112 | 2021-09-26 18:19:30 | nectarine | 1 | 81242 | 2 | 1.326 | 61268.5 |
111 | 2021-09-24 00:46:15 | nectarine | 1 | 81242 | 2 | 1.263 | 64324.6 |
110 | 2021-09-22 10:05:13 | nectarine | 1 | 81242 | 2 | 1.296 | 62686.7 |
109 | 2021-06-18 09:16:49 | nectarine | 1 | 81242 | 2 | 1.250 | 64993.6 |
108 | 2021-01-30 05:08:44 | nectarine | 1 | 81242 | 2 | 1.360 | 59736.8 |
107 | 2020-08-27 22:00:54 | nectarine | 1 | 81242 | 2 | 1.440 | 56418.1 |
106 | 2020-08-25 00:37:52 | nectarine | 1 | 81242 | 2 | 1.220 | 66591.8 |
105 | 2020-05-20 21:21:03 | nectarine | 1 | 81242 | 2 | 1.233 | 65889.7 |
104 | 2020-03-22 15:27:28 | nectarine | 1 | 81242 | 2 | 1.563 | 51978.2 |
103 | 2020-02-26 05:54:22 | nectarine | 1 | 81242 | 2 | 1.483 | 54782.2 |
102 | 2020-02-25 18:33:31 | nectarine | 1 | 81242 | 2 | 2.580 | 31489.1 |
101 | 2020-02-25 06:58:44 | nectarine | 1 | 81242 | 2 | 1.983 | 40969.2 |
100 | 2020-02-24 19:15:03 | nectarine | 1 | 81242 | 2 | 1.563 | 51978.2 |
99 | 2020-02-15 05:13:27 | nectarine | 1 | 81242 | 2 | 3.173 | 25604.2 |
98 | 2020-01-29 06:02:32 | nectarine | 1 | 81242 | 2 | 1.576 | 51549.5 |
97 | 2020-01-27 06:14:31 | nectarine | 1 | 81242 | 2 | 1.516 | 53589.7 |
96 | 2020-01-25 12:44:16 | nectarine | 1 | 81242 | 2 | 3.456 | 23507.5 |
95 | 2020-01-25 05:14:19 | nectarine | 1 | 81242 | 2 | 1.590 | 51095.6 |
94 | 2020-01-19 07:24:49 | nectarine | 1 | 81242 | 2 | 1.470 | 55266.7 |
93 | 2020-01-15 19:32:15 | nectarine | 1 | 81242 | 2 | 1.670 | 48647.9 |
92 | 2020-01-02 23:21:23 | nectarine | 1 | 81242 | 2 | 1.596 | 50903.5 |
91 | 2020-01-01 14:12:27 | nectarine | 1 | 81242 | 2 | 1.250 | 64993.6 |
90 | 2019-11-28 15:09:56 | nectarine | 1 | 81242 | 2 | 1.250 | 64993.6 |
89 | 2019-08-27 00:09:37 | nectarine | 1 | 81242 | 2 | 1.223 | 66428.5 |