History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"nonfictions"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
179 | 2024-04-27 23:24:19 | nonfictions | 3 | 121633 | 30 | 17.470 | 6962.4 |
178 | 2024-04-27 23:24:13 | nonfictions | 2 | 86808 | 7 | 6.706 | 12944.8 |
177 | 2024-04-27 23:08:31 | nonfictions | 1 | 49908 | 2 | 1.686 | 29601.4 |
176 | 2024-04-23 01:33:09 | nonfictions | 1 | 49908 | 2 | 0.906 | 55086.1 |
175 | 2024-04-18 23:18:31 | nonfictions | 1 | 49908 | 2 | 0.750 | 66544.0 |
174 | 2024-04-18 15:03:07 | nonfictions | 4 | 148819 | 176 | 28.470 | 5227.2 |
173 | 2024-04-18 08:26:32 | nonfictions | 4 | 148819 | 176 | 37.363 | 3983.1 |
172 | 2024-04-18 06:21:38 | nonfictions | 4 | 148819 | 176 | 26.766 | 5560.0 |
171 | 2024-04-17 16:35:53 | nonfictions | 3 | 121633 | 30 | 10.860 | 11200.1 |
170 | 2024-04-17 16:35:51 | nonfictions | 4 | 148819 | 176 | 12.906 | 11531.0 |
169 | 2024-04-17 16:35:57 | nonfictions | 1 | 49908 | 2 | 1.173 | 42547.3 |
168 | 2024-04-17 16:35:52 | nonfictions | 2 | 86808 | 7 | 2.750 | 31566.5 |
167 | 2024-04-17 16:35:39 | nonfictions | 1 | 49908 | 2 | 0.826 | 60421.3 |
166 | 2024-04-16 03:08:19 | nonfictions | 3 | 121633 | 30 | 15.750 | 7722.7 |
165 | 2024-04-16 03:08:16 | nonfictions | 2 | 86808 | 7 | 6.750 | 12860.4 |
164 | 2024-04-15 14:59:32 | nonfictions | 3 | 121633 | 30 | 15.470 | 7862.5 |
163 | 2024-04-15 14:59:34 | nonfictions | 2 | 86808 | 7 | 4.813 | 18036.2 |
162 | 2024-04-15 14:59:10 | nonfictions | 1 | 49908 | 2 | 0.936 | 53320.5 |
161 | 2024-04-11 08:17:43 | nonfictions | 1 | 49908 | 2 | 0.733 | 68087.3 |
160 | 2024-04-10 09:31:26 | nonfictions | 3 | 121633 | 30 | 19.160 | 6348.3 |
159 | 2024-04-10 09:25:24 | nonfictions | 1 | 49908 | 2 | 0.953 | 52369.4 |
158 | 2024-03-30 05:52:55 | nonfictions | 2 | 86808 | 7 | 2.733 | 31762.9 |
157 | 2024-03-27 12:46:14 | nonfictions | 2 | 86808 | 7 | 8.360 | 10383.7 |
156 | 2024-03-27 11:20:40 | nonfictions | 1 | 49908 | 2 | 0.843 | 59202.8 |
155 | 2024-03-27 09:47:21 | nonfictions | 4 | 148819 | 176 | 9.906 | 15023.1 |
154 | 2024-03-19 18:26:17 | nonfictions | 4 | 148819 | 176 | 11.423 | 13028.0 |
153 | 2024-03-19 11:39:58 | nonfictions | 4 | 148819 | 176 | 23.783 | 6257.4 |
152 | 2024-03-18 13:05:54 | nonfictions | 4 | 148819 | 176 | 11.470 | 12974.6 |
151 | 2024-03-18 13:05:19 | nonfictions | 3 | 121633 | 30 | 13.236 | 9189.6 |
150 | 2024-03-17 11:47:08 | nonfictions | 4 | 148819 | 176 | 10.406 | 14301.3 |
149 | 2024-03-17 11:47:14 | nonfictions | 1 | 49908 | 2 | 0.903 | 55269.1 |
148 | 2024-03-17 11:47:08 | nonfictions | 3 | 121633 | 30 | 5.343 | 22764.9 |
147 | 2024-03-17 11:47:02 | nonfictions | 2 | 86808 | 7 | 2.690 | 32270.6 |
146 | 2024-03-17 11:46:56 | nonfictions | 1 | 49908 | 2 | 0.910 | 54844.0 |
145 | 2024-02-17 00:19:18 | nonfictions | 4 | 148819 | 176 | 31.376 | 4743.1 |
144 | 2024-02-16 11:48:27 | nonfictions | 3 | 121633 | 30 | 8.016 | 15173.8 |
143 | 2024-02-16 11:48:28 | nonfictions | 2 | 86808 | 7 | 4.563 | 19024.3 |
142 | 2024-02-16 08:48:48 | nonfictions | 1 | 49908 | 2 | 0.873 | 57168.4 |
141 | 2024-02-16 04:14:22 | nonfictions | 4 | 148819 | 176 | 20.546 | 7243.2 |
140 | 2024-02-14 01:10:21 | nonfictions | 1 | 49908 | 2 | 1.000 | 49908.0 |
139 | 2024-02-13 16:30:23 | nonfictions | 4 | 148819 | 176 | 25.733 | 5783.2 |
138 | 2024-02-13 14:45:06 | nonfictions | 4 | 148819 | 176 | 16.140 | 9220.5 |
137 | 2024-02-13 10:49:38 | nonfictions | 3 | 121633 | 30 | 7.390 | 16459.1 |
136 | 2024-02-13 10:49:35 | nonfictions | 2 | 86808 | 7 | 8.580 | 10117.5 |
135 | 2024-02-13 09:50:02 | nonfictions | 1 | 49908 | 2 | 1.813 | 27527.9 |
134 | 2024-02-13 07:29:10 | nonfictions | 4 | 148819 | 176 | 9.830 | 15139.3 |
133 | 2024-02-12 14:26:52 | nonfictions | 4 | 148819 | 176 | 17.736 | 8390.8 |
132 | 2024-02-12 14:26:57 | nonfictions | 3 | 121633 | 30 | 12.113 | 10041.5 |
131 | 2024-02-12 14:26:51 | nonfictions | 2 | 86808 | 7 | 5.483 | 15832.2 |
130 | 2024-02-12 07:25:22 | nonfictions | 1 | 49908 | 2 | 0.763 | 65410.2 |
129 | 2024-02-10 21:36:26 | nonfictions | 1 | 49908 | 2 | 0.953 | 52369.4 |
128 | 2024-01-27 01:48:12 | nonfictions | 1 | 49908 | 2 | 0.860 | 58032.6 |
127 | 2024-01-18 10:27:34 | nonfictions | 1 | 49908 | 2 | 0.750 | 66544.0 |
126 | 2024-01-03 13:30:39 | nonfictions | 1 | 49908 | 2 | 0.873 | 57168.4 |
125 | 2023-12-13 09:13:56 | nonfictions | 1 | 49908 | 2 | 0.763 | 65410.2 |
124 | 2023-12-11 06:34:58 | nonfictions | 1 | 49908 | 2 | 2.000 | 24954.0 |
123 | 2023-11-22 06:55:39 | nonfictions | 1 | 49908 | 2 | 2.266 | 22024.7 |
122 | 2023-10-20 16:08:07 | nonfictions | 1 | 49908 | 2 | 0.750 | 66544.0 |
121 | 2023-10-09 00:57:29 | nonfictions | 1 | 49908 | 2 | 0.780 | 63984.6 |
120 | 2023-09-09 05:10:13 | nonfictions | 1 | 49908 | 2 | 0.813 | 61387.5 |
119 | 2023-09-08 05:30:56 | nonfictions | 1 | 49908 | 2 | 0.720 | 69316.7 |
118 | 2023-06-15 10:45:45 | nonfictions | 1 | 49908 | 2 | 0.843 | 59202.8 |
117 | 2023-05-15 10:13:28 | nonfictions | 1 | 49908 | 2 | 0.843 | 59202.8 |
116 | 2023-04-01 04:06:35 | nonfictions | 1 | 49908 | 2 | 0.716 | 69703.9 |
115 | 2023-01-26 00:11:50 | nonfictions | 1 | 49908 | 2 | 0.733 | 68087.3 |
114 | 2023-01-14 04:57:27 | nonfictions | 1 | 49908 | 2 | 0.826 | 60421.3 |
113 | 2022-11-02 06:12:52 | nonfictions | 1 | 49908 | 2 | 0.720 | 69316.7 |
112 | 2022-09-23 15:02:58 | nonfictions | 1 | 49908 | 2 | 0.750 | 66544.0 |
111 | 2022-06-22 11:46:47 | nonfictions | 1 | 49908 | 2 | 0.733 | 68087.3 |
110 | 2022-05-19 13:34:00 | nonfictions | 1 | 49908 | 2 | 0.813 | 61387.5 |
109 | 2022-05-07 05:59:00 | nonfictions | 1 | 49908 | 2 | 0.750 | 66544.0 |
108 | 2022-01-22 21:49:38 | nonfictions | 1 | 49908 | 2 | 0.750 | 66544.0 |
107 | 2021-10-03 12:25:43 | nonfictions | 1 | 49908 | 2 | 0.843 | 59202.8 |
106 | 2021-06-30 21:52:03 | nonfictions | 1 | 49908 | 2 | 0.733 | 68087.3 |
105 | 2021-04-09 11:21:58 | nonfictions | 1 | 49908 | 2 | 0.876 | 56972.6 |
104 | 2021-03-30 20:56:42 | nonfictions | 1 | 49908 | 2 | 0.860 | 58032.6 |
103 | 2021-03-13 15:20:24 | nonfictions | 1 | 49908 | 2 | 0.736 | 67809.8 |
102 | 2021-01-24 05:01:17 | nonfictions | 1 | 49908 | 2 | 0.750 | 66544.0 |
101 | 2020-12-26 11:35:29 | nonfictions | 1 | 49908 | 2 | 0.766 | 65154.0 |
100 | 2020-12-25 23:11:46 | nonfictions | 1 | 49908 | 2 | 0.763 | 65410.2 |
99 | 2020-11-15 13:23:33 | nonfictions | 1 | 49908 | 2 | 0.826 | 60421.3 |
98 | 2020-11-04 20:48:21 | nonfictions | 1 | 49908 | 2 | 0.796 | 62698.5 |
97 | 2020-10-26 23:08:55 | nonfictions | 1 | 49908 | 2 | 0.750 | 66544.0 |
96 | 2020-09-22 18:13:56 | nonfictions | 1 | 49908 | 2 | 0.843 | 59202.8 |
95 | 2020-06-14 19:46:44 | nonfictions | 1 | 49908 | 2 | 0.890 | 56076.4 |
94 | 2020-06-11 20:14:31 | nonfictions | 1 | 49908 | 2 | 0.873 | 57168.4 |
93 | 2020-03-26 11:59:22 | nonfictions | 1 | 49908 | 2 | 0.906 | 55086.1 |
92 | 2020-03-26 05:31:26 | nonfictions | 1 | 49908 | 2 | 0.830 | 60130.1 |
91 | 2020-02-29 01:56:23 | nonfictions | 1 | 49908 | 2 | 0.890 | 56076.4 |
90 | 2020-02-28 23:48:00 | nonfictions | 1 | 49908 | 2 | 0.826 | 60421.3 |
89 | 2020-02-26 04:44:18 | nonfictions | 1 | 49908 | 2 | 1.860 | 26832.3 |
88 | 2020-02-24 12:03:33 | nonfictions | 1 | 49908 | 2 | 0.953 | 52369.4 |
87 | 2020-02-23 05:18:40 | nonfictions | 4 | 148819 | 176 | 9.796 | 15191.8 |
86 | 2020-02-22 13:05:58 | nonfictions | 4 | 148819 | 176 | 29.893 | 4978.4 |
85 | 2020-02-19 12:38:42 | nonfictions | 1 | 49908 | 2 | 0.920 | 54247.8 |
84 | 2020-02-10 07:38:57 | nonfictions | 1 | 49908 | 2 | 2.733 | 18261.3 |
83 | 2020-02-09 09:57:05 | nonfictions | 1 | 49908 | 2 | 2.953 | 16900.8 |
82 | 2020-01-31 07:16:07 | nonfictions | 1 | 49908 | 2 | 0.953 | 52369.4 |
81 | 2020-01-27 20:42:26 | nonfictions | 1 | 49908 | 2 | 1.813 | 27527.9 |
80 | 2020-01-26 16:19:15 | nonfictions | 1 | 49908 | 2 | 0.920 | 54247.8 |