History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"deerflies"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
181 | 2024-04-27 23:29:00 | deerflies | 1 | 81242 | 1 | 4.110 | 19766.9 |
180 | 2024-04-26 21:06:07 | deerflies | 4 | 165329 | 355 | 37.953 | 4356.2 |
179 | 2024-04-26 10:11:52 | deerflies | 4 | 165329 | 355 | 37.783 | 4375.8 |
178 | 2024-04-26 10:11:47 | deerflies | 2 | 121436 | 2 | 4.876 | 24904.8 |
177 | 2024-04-26 09:54:22 | deerflies | 1 | 81242 | 1 | 1.593 | 50999.4 |
176 | 2024-04-21 16:29:05 | deerflies | 4 | 165329 | 355 | 11.516 | 14356.5 |
175 | 2024-04-21 07:38:32 | deerflies | 4 | 165329 | 355 | 45.330 | 3647.2 |
174 | 2024-04-20 23:55:52 | deerflies | 4 | 165329 | 355 | 37.190 | 4445.5 |
173 | 2024-04-20 08:06:57 | deerflies | 4 | 165329 | 355 | 10.486 | 15766.6 |
172 | 2024-04-12 16:36:47 | deerflies | 3 | 148641 | 28 | 19.220 | 7733.7 |
171 | 2024-04-12 16:35:51 | deerflies | 3 | 148641 | 28 | 10.343 | 14371.2 |
170 | 2024-04-10 11:08:40 | deerflies | 3 | 148641 | 28 | 16.873 | 8809.4 |
169 | 2024-04-10 11:08:44 | deerflies | 2 | 121436 | 2 | 5.686 | 21357.0 |
168 | 2024-04-10 11:08:07 | deerflies | 1 | 81242 | 1 | 5.313 | 15291.2 |
167 | 2024-04-01 08:08:18 | deerflies | 2 | 121436 | 2 | 8.956 | 13559.2 |
166 | 2024-04-01 07:57:35 | deerflies | 1 | 81242 | 1 | 1.470 | 55266.7 |
165 | 2024-03-30 19:40:11 | deerflies | 1 | 81242 | 1 | 3.126 | 25989.1 |
164 | 2024-03-16 10:36:57 | deerflies | 4 | 165329 | 355 | 47.486 | 3481.6 |
163 | 2024-03-14 00:56:16 | deerflies | 4 | 165329 | 355 | 26.923 | 6140.8 |
162 | 2024-03-11 11:03:32 | deerflies | 4 | 165329 | 355 | 43.346 | 3814.2 |
161 | 2024-03-11 11:02:38 | deerflies | 4 | 165329 | 355 | 30.720 | 5381.8 |
160 | 2024-03-11 01:29:47 | deerflies | 4 | 165329 | 355 | 25.406 | 6507.5 |
159 | 2024-03-11 01:29:54 | deerflies | 2 | 121436 | 2 | 4.250 | 28573.2 |
158 | 2024-03-11 01:23:34 | deerflies | 1 | 81242 | 1 | 3.703 | 21939.5 |
157 | 2024-03-06 01:57:12 | deerflies | 1 | 81242 | 1 | 1.440 | 56418.1 |
156 | 2024-03-03 11:35:04 | deerflies | 3 | 148641 | 28 | 16.826 | 8834.0 |
155 | 2024-03-03 11:35:03 | deerflies | 2 | 121436 | 2 | 10.250 | 11847.4 |
154 | 2024-03-03 10:29:24 | deerflies | 1 | 81242 | 1 | 1.406 | 57782.4 |
153 | 2024-02-24 21:38:49 | deerflies | 1 | 81242 | 1 | 3.030 | 26812.5 |
152 | 2024-02-06 08:18:57 | deerflies | 3 | 148641 | 28 | 9.780 | 15198.5 |
151 | 2024-02-06 08:19:01 | deerflies | 2 | 121436 | 2 | 3.783 | 32100.4 |
150 | 2024-02-06 04:38:13 | deerflies | 1 | 81242 | 1 | 1.436 | 56575.2 |
149 | 2024-02-03 05:25:57 | deerflies | 4 | 165329 | 355 | 36.003 | 4592.1 |
148 | 2024-02-02 17:36:20 | deerflies | 4 | 165329 | 355 | 12.186 | 13567.1 |
147 | 2024-02-02 17:36:24 | deerflies | 3 | 148641 | 28 | 7.140 | 20818.1 |
146 | 2024-02-02 17:36:16 | deerflies | 2 | 121436 | 2 | 3.046 | 39867.4 |
145 | 2024-02-02 10:13:47 | deerflies | 1 | 81242 | 1 | 1.326 | 61268.5 |
144 | 2024-01-14 20:38:07 | deerflies | 1 | 81242 | 1 | 1.483 | 54782.2 |
143 | 2023-12-25 10:35:40 | deerflies | 1 | 81242 | 1 | 1.250 | 64993.6 |
142 | 2023-12-16 05:56:58 | deerflies | 4 | 165329 | 355 | 10.843 | 15247.5 |
141 | 2023-12-13 11:59:30 | deerflies | 1 | 81242 | 1 | 1.390 | 58447.5 |
140 | 2023-12-11 01:34:56 | deerflies | 1 | 81242 | 1 | 1.470 | 55266.7 |
139 | 2023-10-20 11:53:31 | deerflies | 1 | 81242 | 1 | 1.296 | 62686.7 |
138 | 2023-10-06 15:37:57 | deerflies | 4 | 165329 | 355 | 15.126 | 10930.1 |
137 | 2023-10-01 08:24:10 | deerflies | 4 | 165329 | 355 | 24.063 | 6870.7 |
136 | 2023-09-27 19:58:59 | deerflies | 4 | 165329 | 355 | 13.300 | 12430.8 |
135 | 2023-09-25 00:39:33 | deerflies | 1 | 81242 | 1 | 1.360 | 59736.8 |
134 | 2023-09-15 04:40:31 | deerflies | 4 | 165329 | 355 | 12.610 | 13110.9 |
133 | 2023-07-22 00:38:28 | deerflies | 1 | 81242 | 1 | 1.436 | 56575.2 |
132 | 2023-06-19 08:35:49 | deerflies | 1 | 81242 | 1 | 1.233 | 65889.7 |
131 | 2023-06-17 15:06:47 | deerflies | 4 | 165329 | 355 | 11.533 | 14335.3 |
130 | 2023-04-19 11:37:22 | deerflies | 1 | 81242 | 1 | 1.220 | 66591.8 |
129 | 2023-04-13 05:43:30 | deerflies | 4 | 165329 | 355 | 11.860 | 13940.1 |
128 | 2023-03-18 01:21:19 | deerflies | 4 | 165329 | 355 | 16.750 | 9870.4 |
127 | 2023-02-11 06:30:11 | deerflies | 1 | 81242 | 1 | 1.436 | 56575.2 |
126 | 2023-02-06 20:02:01 | deerflies | 1 | 81242 | 1 | 1.233 | 65889.7 |
125 | 2022-12-20 08:57:30 | deerflies | 4 | 165329 | 355 | 10.483 | 15771.2 |
124 | 2022-12-05 07:41:24 | deerflies | 1 | 81242 | 1 | 1.233 | 65889.7 |
123 | 2022-10-06 13:02:00 | deerflies | 1 | 81242 | 1 | 1.216 | 66810.9 |
122 | 2022-10-02 23:04:53 | deerflies | 1 | 81242 | 1 | 1.236 | 65729.8 |
121 | 2022-08-16 07:08:50 | deerflies | 4 | 165329 | 355 | 10.343 | 15984.6 |
120 | 2022-07-31 13:33:30 | deerflies | 1 | 81242 | 1 | 1.250 | 64993.6 |
119 | 2022-07-29 04:21:21 | deerflies | 1 | 81242 | 1 | 1.250 | 64993.6 |
118 | 2022-05-23 03:06:49 | deerflies | 1 | 81242 | 1 | 1.250 | 64993.6 |
117 | 2022-03-19 11:41:27 | deerflies | 1 | 81242 | 1 | 1.406 | 57782.4 |
116 | 2022-01-25 01:01:14 | deerflies | 1 | 81242 | 1 | 1.296 | 62686.7 |
115 | 2021-12-27 13:42:46 | deerflies | 1 | 81242 | 1 | 1.453 | 55913.3 |
114 | 2021-11-17 19:42:29 | deerflies | 1 | 81242 | 1 | 1.250 | 64993.6 |
113 | 2021-09-28 22:52:52 | deerflies | 1 | 81242 | 1 | 1.203 | 67532.8 |
112 | 2021-09-25 17:01:16 | deerflies | 1 | 81242 | 1 | 1.406 | 57782.4 |
111 | 2021-06-22 16:02:40 | deerflies | 1 | 81242 | 1 | 1.263 | 64324.6 |
110 | 2021-03-20 11:19:35 | deerflies | 1 | 81242 | 1 | 1.266 | 64172.2 |
109 | 2021-03-07 06:30:40 | deerflies | 1 | 81242 | 1 | 1.406 | 57782.4 |
108 | 2021-02-22 18:21:25 | deerflies | 1 | 81242 | 1 | 1.390 | 58447.5 |
107 | 2021-02-11 05:30:46 | deerflies | 1 | 81242 | 1 | 1.420 | 57212.7 |
106 | 2020-12-18 12:36:37 | deerflies | 1 | 81242 | 1 | 1.236 | 65729.8 |
105 | 2020-12-10 07:36:11 | deerflies | 1 | 81242 | 1 | 1.250 | 64993.6 |
104 | 2020-11-11 04:05:36 | deerflies | 1 | 81242 | 1 | 1.330 | 61084.2 |
103 | 2020-10-17 07:54:27 | deerflies | 1 | 81242 | 1 | 1.250 | 64993.6 |
102 | 2020-09-03 14:09:22 | deerflies | 1 | 81242 | 1 | 1.420 | 57212.7 |
101 | 2020-05-23 11:03:51 | deerflies | 1 | 81242 | 1 | 1.236 | 65729.8 |
100 | 2020-03-25 04:57:25 | deerflies | 1 | 81242 | 1 | 1.610 | 50460.9 |
99 | 2020-03-01 01:37:25 | deerflies | 1 | 81242 | 1 | 1.546 | 52549.8 |
98 | 2020-03-01 00:29:44 | deerflies | 1 | 81242 | 1 | 1.486 | 54671.6 |
97 | 2020-02-17 09:34:27 | deerflies | 1 | 81242 | 1 | 1.466 | 55417.5 |
96 | 2020-02-14 12:15:36 | deerflies | 1 | 81242 | 1 | 2.530 | 32111.5 |
95 | 2020-02-09 12:17:05 | deerflies | 1 | 81242 | 1 | 3.080 | 26377.3 |
94 | 2020-02-03 16:05:14 | deerflies | 1 | 81242 | 1 | 3.170 | 25628.4 |
93 | 2020-01-31 15:19:04 | deerflies | 1 | 81242 | 1 | 2.126 | 38213.5 |
92 | 2020-01-31 03:13:35 | deerflies | 1 | 81242 | 1 | 1.390 | 58447.5 |
91 | 2020-01-19 10:32:10 | deerflies | 1 | 81242 | 1 | 2.903 | 27985.5 |
90 | 2020-01-17 11:24:37 | deerflies | 1 | 81242 | 1 | 1.486 | 54671.6 |
89 | 2020-01-06 11:45:05 | deerflies | 1 | 81242 | 1 | 1.356 | 59913.0 |
88 | 2019-12-31 12:25:35 | deerflies | 1 | 81242 | 1 | 1.296 | 62686.7 |
87 | 2019-11-17 20:25:45 | deerflies | 1 | 81242 | 1 | 1.376 | 59042.2 |
86 | 2019-08-16 07:00:13 | deerflies | 1 | 81242 | 1 | 1.303 | 62350.0 |
85 | 2019-08-11 00:31:36 | deerflies | 4 | 165329 | 355 | 10.626 | 15558.9 |
84 | 2019-08-11 00:31:29 | deerflies | 3 | 148641 | 28 | 6.346 | 23422.8 |
83 | 2019-08-11 00:31:19 | deerflies | 2 | 121436 | 2 | 3.013 | 40304.0 |
82 | 2019-08-11 00:31:11 | deerflies | 1 | 81242 | 1 | 1.150 | 70645.2 |