History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bookshelves"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
175 | 2024-06-05 05:45:17 | bookshelves | 3 | 121633 | 4 | 16.860 | 7214.3 |
174 | 2024-05-27 09:14:37 | bookshelves | 3 | 121633 | 4 | 18.080 | 6727.5 |
173 | 2024-05-27 09:14:37 | bookshelves | 2 | 86808 | 1 | 5.623 | 15438.0 |
172 | 2024-05-27 09:14:18 | bookshelves | 1 | 49908 | 1 | 1.750 | 28518.9 |
171 | 2024-05-23 03:49:26 | bookshelves | 4 | 148819 | 15 | 15.250 | 9758.6 |
170 | 2024-05-19 14:27:55 | bookshelves | 2 | 86808 | 1 | 5.596 | 15512.5 |
169 | 2024-05-19 14:26:21 | bookshelves | 1 | 49908 | 1 | 1.920 | 25993.8 |
168 | 2024-05-13 16:01:19 | bookshelves | 4 | 148819 | 15 | 16.203 | 9184.7 |
167 | 2024-05-13 16:01:19 | bookshelves | 3 | 121633 | 4 | 12.376 | 9828.1 |
166 | 2024-05-13 16:01:22 | bookshelves | 2 | 86808 | 1 | 8.720 | 9955.0 |
165 | 2024-05-13 16:00:09 | bookshelves | 1 | 49908 | 1 | 1.483 | 33653.4 |
164 | 2024-05-13 02:29:07 | bookshelves | 2 | 86808 | 1 | 10.623 | 8171.7 |
163 | 2024-05-13 02:23:58 | bookshelves | 1 | 49908 | 1 | 0.890 | 56076.4 |
162 | 2024-05-11 16:20:14 | bookshelves | 1 | 49908 | 1 | 1.906 | 26184.7 |
161 | 2024-05-05 12:23:27 | bookshelves | 5 | 164607 | 128 | 15.970 | 10307.3 |
160 | 2024-05-04 09:41:42 | bookshelves | 5 | 164607 | 128 | 17.203 | 9568.5 |
159 | 2024-04-27 18:05:44 | bookshelves | 4 | 148819 | 15 | 14.893 | 9992.5 |
158 | 2024-04-26 14:09:16 | bookshelves | 1 | 49908 | 1 | 0.733 | 68087.3 |
157 | 2024-04-22 02:25:46 | bookshelves | 4 | 148819 | 15 | 25.296 | 5883.1 |
156 | 2024-04-22 02:25:57 | bookshelves | 3 | 121633 | 4 | 8.436 | 14418.3 |
155 | 2024-04-22 02:25:52 | bookshelves | 2 | 86808 | 1 | 4.330 | 20048.0 |
154 | 2024-04-22 02:25:33 | bookshelves | 1 | 49908 | 1 | 1.250 | 39926.4 |
153 | 2024-04-03 19:56:58 | bookshelves | 4 | 148819 | 15 | 32.923 | 4520.2 |
152 | 2024-03-27 11:48:09 | bookshelves | 1 | 49908 | 1 | 0.873 | 57168.4 |
151 | 2024-03-27 03:17:08 | bookshelves | 4 | 148819 | 15 | 21.360 | 6967.2 |
150 | 2024-03-26 19:50:16 | bookshelves | 4 | 148819 | 15 | 29.003 | 5131.2 |
149 | 2024-03-26 19:50:19 | bookshelves | 3 | 121633 | 4 | 7.656 | 15887.3 |
148 | 2024-03-26 19:50:11 | bookshelves | 2 | 86808 | 1 | 7.033 | 12343.0 |
147 | 2024-03-26 18:13:01 | bookshelves | 1 | 49908 | 1 | 0.860 | 58032.6 |
146 | 2024-03-22 20:34:16 | bookshelves | 1 | 49908 | 1 | 1.876 | 26603.4 |
145 | 2024-03-22 20:33:55 | bookshelves | 1 | 49908 | 1 | 2.813 | 17741.9 |
144 | 2024-02-26 05:58:36 | bookshelves | 3 | 121633 | 4 | 16.076 | 7566.1 |
143 | 2024-02-22 13:27:43 | bookshelves | 5 | 164607 | 128 | 56.003 | 2939.3 |
142 | 2024-02-21 14:11:32 | bookshelves | 5 | 164607 | 128 | 22.860 | 7200.7 |
141 | 2024-02-20 02:21:45 | bookshelves | 5 | 164607 | 128 | 35.346 | 4657.0 |
140 | 2024-02-20 02:21:45 | bookshelves | 4 | 148819 | 15 | 19.360 | 7686.9 |
139 | 2024-02-20 02:21:45 | bookshelves | 2 | 86808 | 1 | 5.376 | 16147.3 |
138 | 2024-02-19 19:26:15 | bookshelves | 1 | 49908 | 1 | 0.856 | 58303.7 |
137 | 2024-02-19 15:43:28 | bookshelves | 3 | 121633 | 4 | 5.750 | 21153.6 |
136 | 2024-02-15 13:30:26 | bookshelves | 3 | 121633 | 4 | 5.826 | 20877.6 |
135 | 2024-02-12 01:42:23 | bookshelves | 1 | 49908 | 1 | 2.846 | 17536.2 |
134 | 2024-02-12 00:28:01 | bookshelves | 3 | 121633 | 4 | 10.406 | 11688.7 |
133 | 2024-02-10 10:23:16 | bookshelves | 3 | 121633 | 4 | 13.483 | 9021.2 |
132 | 2024-02-10 10:23:13 | bookshelves | 2 | 86808 | 1 | 7.033 | 12343.0 |
131 | 2024-02-10 09:49:02 | bookshelves | 1 | 49908 | 1 | 0.810 | 61614.8 |
130 | 2024-01-24 11:42:38 | bookshelves | 4 | 148819 | 15 | 12.046 | 12354.2 |
129 | 2024-01-24 11:42:32 | bookshelves | 3 | 121633 | 4 | 11.656 | 10435.2 |
128 | 2024-01-24 11:42:24 | bookshelves | 2 | 86808 | 1 | 5.186 | 16738.9 |
127 | 2024-01-19 11:47:41 | bookshelves | 3 | 121633 | 4 | 4.826 | 25203.7 |
126 | 2024-01-06 08:21:31 | bookshelves | 1 | 49908 | 1 | 0.813 | 61387.5 |
125 | 2024-01-05 15:17:49 | bookshelves | 1 | 49908 | 1 | 0.780 | 63984.6 |
124 | 2023-12-27 19:24:19 | bookshelves | 5 | 164607 | 128 | 14.003 | 11755.1 |
123 | 2023-12-04 05:10:38 | bookshelves | 5 | 164607 | 128 | 14.453 | 11389.1 |
122 | 2023-11-25 06:02:05 | bookshelves | 5 | 164607 | 128 | 13.420 | 12265.8 |
121 | 2023-11-19 16:31:25 | bookshelves | 1 | 49908 | 1 | 0.736 | 67809.8 |
120 | 2023-11-06 19:33:53 | bookshelves | 5 | 164607 | 128 | 18.566 | 8866.0 |
119 | 2023-10-31 21:01:51 | bookshelves | 3 | 121633 | 4 | 4.156 | 29266.8 |
118 | 2023-10-30 03:40:27 | bookshelves | 1 | 49908 | 1 | 0.750 | 66544.0 |
117 | 2023-09-29 18:55:25 | bookshelves | 5 | 164607 | 128 | 14.940 | 11017.9 |
116 | 2023-08-23 23:27:21 | bookshelves | 1 | 49908 | 1 | 0.720 | 69316.7 |
115 | 2023-08-08 03:25:24 | bookshelves | 3 | 121633 | 4 | 4.140 | 29380.0 |
114 | 2023-07-10 21:24:35 | bookshelves | 5 | 164607 | 128 | 12.080 | 13626.4 |
113 | 2023-06-19 05:53:03 | bookshelves | 1 | 49908 | 1 | 0.720 | 69316.7 |
112 | 2023-05-26 19:21:02 | bookshelves | 1 | 49908 | 1 | 0.720 | 69316.7 |
111 | 2023-04-18 19:42:05 | bookshelves | 3 | 121633 | 4 | 4.123 | 29501.1 |
110 | 2023-03-30 02:14:33 | bookshelves | 5 | 164607 | 128 | 12.173 | 13522.3 |
109 | 2023-03-21 09:58:49 | bookshelves | 1 | 49908 | 1 | 0.720 | 69316.7 |
108 | 2023-01-24 07:40:55 | bookshelves | 1 | 49908 | 1 | 0.796 | 62698.5 |
107 | 2023-01-21 14:02:47 | bookshelves | 3 | 121633 | 4 | 4.076 | 29841.3 |
106 | 2023-01-06 11:53:02 | bookshelves | 1 | 49908 | 1 | 0.720 | 69316.7 |
105 | 2022-12-28 12:41:40 | bookshelves | 5 | 164607 | 128 | 14.876 | 11065.3 |
104 | 2022-11-01 09:39:17 | bookshelves | 3 | 121633 | 4 | 5.283 | 23023.5 |
103 | 2022-10-03 04:33:30 | bookshelves | 1 | 49908 | 1 | 0.796 | 62698.5 |
102 | 2022-09-05 22:54:56 | bookshelves | 1 | 49908 | 1 | 0.830 | 60130.1 |
101 | 2022-09-01 10:19:52 | bookshelves | 1 | 49908 | 1 | 0.826 | 60421.3 |
100 | 2022-08-29 18:24:06 | bookshelves | 5 | 164607 | 128 | 12.033 | 13679.6 |
99 | 2022-08-14 22:46:11 | bookshelves | 1 | 49908 | 1 | 0.733 | 68087.3 |
98 | 2022-06-02 12:50:52 | bookshelves | 3 | 121633 | 4 | 4.453 | 27314.8 |
97 | 2022-05-20 23:49:30 | bookshelves | 1 | 49908 | 1 | 0.796 | 62698.5 |
96 | 2022-03-24 11:52:44 | bookshelves | 5 | 164607 | 128 | 14.656 | 11231.4 |
95 | 2022-03-07 09:19:00 | bookshelves | 1 | 49908 | 1 | 0.923 | 54071.5 |
94 | 2022-03-03 22:45:29 | bookshelves | 1 | 49908 | 1 | 0.796 | 62698.5 |
93 | 2022-02-08 21:21:35 | bookshelves | 1 | 49908 | 1 | 0.813 | 61387.5 |
92 | 2022-02-06 17:08:27 | bookshelves | 1 | 49908 | 1 | 0.810 | 61614.8 |
91 | 2021-11-28 11:01:14 | bookshelves | 1 | 49908 | 1 | 1.156 | 43173.0 |
90 | 2021-11-26 09:13:18 | bookshelves | 1 | 49908 | 1 | 0.843 | 59202.8 |
89 | 2021-10-08 10:13:02 | bookshelves | 1 | 49908 | 1 | 0.766 | 65154.0 |
88 | 2021-10-05 20:23:33 | bookshelves | 1 | 49908 | 1 | 0.813 | 61387.5 |
87 | 2021-10-05 04:46:30 | bookshelves | 1 | 49908 | 1 | 0.830 | 60130.1 |
86 | 2021-09-03 15:27:32 | bookshelves | 1 | 49908 | 1 | 0.830 | 60130.1 |
85 | 2021-08-17 02:25:42 | bookshelves | 1 | 49908 | 1 | 0.716 | 69703.9 |
84 | 2021-06-12 16:32:22 | bookshelves | 1 | 49908 | 1 | 0.720 | 69316.7 |
83 | 2021-03-27 20:37:36 | bookshelves | 1 | 49908 | 1 | 0.813 | 61387.5 |
82 | 2021-03-03 03:23:04 | bookshelves | 1 | 49908 | 1 | 0.750 | 66544.0 |
81 | 2021-02-06 02:31:13 | bookshelves | 1 | 49908 | 1 | 0.796 | 62698.5 |
80 | 2020-10-30 14:38:50 | bookshelves | 1 | 49908 | 1 | 1.890 | 26406.3 |
79 | 2020-10-28 19:41:08 | bookshelves | 1 | 49908 | 1 | 0.796 | 62698.5 |
78 | 2020-10-27 02:58:17 | bookshelves | 1 | 49908 | 1 | 0.830 | 60130.1 |
77 | 2020-06-13 10:03:54 | bookshelves | 1 | 49908 | 1 | 0.830 | 60130.1 |
76 | 2020-03-28 13:59:21 | bookshelves | 1 | 49908 | 1 | 0.846 | 58992.9 |