History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"observatory"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
166 | 2024-05-24 04:09:54 | observatory | 3 | 121633 | 10 | 10.966 | 11091.8 |
165 | 2024-05-24 04:09:55 | observatory | 2 | 86808 | 2 | 3.890 | 22315.7 |
164 | 2024-05-24 04:09:45 | observatory | 1 | 49908 | 1 | 2.030 | 24585.2 |
163 | 2024-05-22 01:25:16 | observatory | 5 | 164607 | 211 | 25.753 | 6391.8 |
162 | 2024-05-21 21:30:25 | observatory | 5 | 164607 | 211 | 46.986 | 3503.3 |
161 | 2024-05-21 21:30:23 | observatory | 4 | 148819 | 40 | 15.113 | 9847.1 |
160 | 2024-05-21 08:44:18 | observatory | 5 | 164607 | 211 | 46.080 | 3572.2 |
159 | 2024-05-21 07:56:46 | observatory | 5 | 164607 | 211 | 50.410 | 3265.4 |
158 | 2024-05-21 07:56:51 | observatory | 4 | 148819 | 40 | 18.250 | 8154.5 |
157 | 2024-05-21 07:56:55 | observatory | 3 | 121633 | 10 | 14.110 | 8620.3 |
156 | 2024-05-21 07:56:58 | observatory | 2 | 86808 | 2 | 8.436 | 10290.2 |
155 | 2024-05-21 07:52:22 | observatory | 1 | 49908 | 1 | 2.720 | 18348.5 |
154 | 2024-05-06 05:38:27 | observatory | 4 | 148819 | 40 | 14.143 | 10522.4 |
153 | 2024-05-06 05:37:39 | observatory | 1 | 49908 | 1 | 0.856 | 58303.7 |
152 | 2024-05-06 05:37:27 | observatory | 2 | 86808 | 2 | 3.983 | 21794.6 |
151 | 2024-05-01 17:26:57 | observatory | 1 | 49908 | 1 | 1.936 | 25778.9 |
150 | 2024-05-01 17:26:50 | observatory | 2 | 86808 | 2 | 2.500 | 34723.2 |
149 | 2024-05-01 11:45:11 | observatory | 4 | 148819 | 40 | 32.876 | 4526.7 |
148 | 2024-05-01 11:45:25 | observatory | 3 | 121633 | 10 | 16.660 | 7300.9 |
147 | 2024-05-01 11:45:12 | observatory | 4 | 148819 | 40 | 12.893 | 11542.6 |
146 | 2024-05-01 11:45:16 | observatory | 2 | 86808 | 2 | 3.640 | 23848.4 |
145 | 2024-05-01 11:43:56 | observatory | 1 | 49908 | 1 | 3.000 | 16636.0 |
144 | 2024-04-23 12:05:11 | observatory | 3 | 121633 | 10 | 6.000 | 20272.2 |
143 | 2024-04-20 17:15:10 | observatory | 3 | 121633 | 10 | 6.203 | 19608.7 |
142 | 2024-04-15 08:12:38 | observatory | 2 | 86808 | 2 | 6.203 | 13994.5 |
141 | 2024-04-15 08:12:32 | observatory | 3 | 121633 | 10 | 8.376 | 14521.6 |
140 | 2024-04-07 20:25:56 | observatory | 1 | 49908 | 1 | 1.860 | 26832.3 |
139 | 2024-04-07 09:29:29 | observatory | 3 | 121633 | 10 | 12.686 | 9588.0 |
138 | 2024-04-07 09:29:32 | observatory | 2 | 86808 | 2 | 7.313 | 11870.4 |
137 | 2024-04-07 09:27:53 | observatory | 1 | 49908 | 1 | 2.796 | 17849.8 |
136 | 2024-04-07 09:24:32 | observatory | 4 | 148819 | 40 | 29.986 | 4962.9 |
135 | 2024-04-07 00:26:15 | observatory | 4 | 148819 | 40 | 50.846 | 2926.9 |
134 | 2024-04-01 01:23:33 | observatory | 4 | 148819 | 40 | 32.956 | 4515.7 |
133 | 2024-03-30 05:52:42 | observatory | 5 | 164607 | 211 | 54.656 | 3011.7 |
132 | 2024-03-29 12:20:53 | observatory | 5 | 164607 | 211 | 47.550 | 3461.8 |
131 | 2024-03-29 12:20:58 | observatory | 3 | 121633 | 10 | 17.826 | 6823.3 |
130 | 2024-03-29 12:20:54 | observatory | 4 | 148819 | 40 | 20.533 | 7247.8 |
129 | 2024-03-29 12:20:56 | observatory | 2 | 86808 | 2 | 2.703 | 32115.4 |
128 | 2024-03-29 12:20:05 | observatory | 1 | 49908 | 1 | 1.920 | 25993.8 |
127 | 2024-03-24 07:02:31 | observatory | 1 | 49908 | 1 | 2.483 | 20099.9 |
126 | 2024-03-01 19:17:59 | observatory | 3 | 121633 | 10 | 17.016 | 7148.2 |
125 | 2024-03-01 19:17:56 | observatory | 2 | 86808 | 2 | 6.690 | 12975.8 |
124 | 2024-02-23 11:07:30 | observatory | 4 | 148819 | 40 | 10.580 | 14066.1 |
123 | 2024-02-20 14:05:04 | observatory | 3 | 121633 | 10 | 6.110 | 19907.2 |
122 | 2024-02-20 14:05:03 | observatory | 2 | 86808 | 2 | 2.670 | 32512.4 |
121 | 2024-02-20 01:54:47 | observatory | 1 | 49908 | 1 | 4.593 | 10866.1 |
120 | 2024-02-19 01:55:08 | observatory | 3 | 121633 | 10 | 15.343 | 7927.6 |
119 | 2024-02-19 01:55:07 | observatory | 2 | 86808 | 2 | 6.406 | 13551.0 |
118 | 2024-02-18 19:41:55 | observatory | 1 | 49908 | 1 | 0.733 | 68087.3 |
117 | 2024-02-18 11:54:12 | observatory | 4 | 148819 | 40 | 34.390 | 4327.4 |
116 | 2024-02-18 11:12:16 | observatory | 4 | 148819 | 40 | 24.126 | 6168.4 |
115 | 2024-02-18 05:58:03 | observatory | 5 | 164607 | 211 | 22.203 | 7413.7 |
114 | 2024-02-18 05:51:00 | observatory | 5 | 164607 | 211 | 53.766 | 3061.5 |
113 | 2024-02-17 04:32:48 | observatory | 4 | 148819 | 40 | 17.940 | 8295.4 |
112 | 2024-02-16 23:07:55 | observatory | 4 | 148819 | 40 | 18.093 | 8225.2 |
111 | 2024-02-15 13:41:46 | observatory | 5 | 164607 | 211 | 17.906 | 9192.8 |
110 | 2024-02-15 13:41:47 | observatory | 4 | 148819 | 40 | 12.313 | 12086.3 |
109 | 2024-02-15 13:41:47 | observatory | 3 | 121633 | 10 | 7.263 | 16746.9 |
108 | 2024-02-15 13:41:46 | observatory | 2 | 86808 | 2 | 5.220 | 16629.9 |
107 | 2024-02-15 13:39:54 | observatory | 1 | 49908 | 1 | 0.750 | 66544.0 |
106 | 2024-02-11 23:24:53 | observatory | 1 | 49908 | 1 | 2.500 | 19963.2 |
105 | 2023-12-18 18:52:26 | observatory | 1 | 49908 | 1 | 0.796 | 62698.5 |
104 | 2023-12-14 17:07:03 | observatory | 1 | 49908 | 1 | 0.720 | 69316.7 |
103 | 2023-12-13 05:21:29 | observatory | 1 | 49908 | 1 | 0.766 | 65154.0 |
102 | 2023-10-27 08:16:32 | observatory | 1 | 49908 | 1 | 0.830 | 60130.1 |
101 | 2023-10-11 14:23:36 | observatory | 1 | 49908 | 1 | 0.766 | 65154.0 |
100 | 2023-10-05 00:59:54 | observatory | 1 | 49908 | 1 | 0.750 | 66544.0 |
99 | 2023-08-02 20:30:07 | observatory | 1 | 49908 | 1 | 0.813 | 61387.5 |
98 | 2023-06-06 01:19:09 | observatory | 1 | 49908 | 1 | 0.720 | 69316.7 |
97 | 2023-06-02 18:01:14 | observatory | 1 | 49908 | 1 | 0.810 | 61614.8 |
96 | 2023-04-26 18:34:29 | observatory | 1 | 49908 | 1 | 1.390 | 35905.0 |
95 | 2023-02-17 09:08:05 | observatory | 1 | 49908 | 1 | 0.813 | 61387.5 |
94 | 2023-01-24 05:27:55 | observatory | 1 | 49908 | 1 | 0.716 | 69703.9 |
93 | 2022-09-04 02:03:12 | observatory | 1 | 49908 | 1 | 0.783 | 63739.5 |
92 | 2022-04-03 16:35:51 | observatory | 1 | 49908 | 1 | 0.813 | 61387.5 |
91 | 2021-11-23 15:20:09 | observatory | 1 | 49908 | 1 | 0.796 | 62698.5 |
90 | 2021-07-17 08:43:24 | observatory | 1 | 49908 | 1 | 0.716 | 69703.9 |
89 | 2021-04-14 13:57:34 | observatory | 1 | 49908 | 1 | 0.840 | 59414.3 |
88 | 2021-03-20 23:31:39 | observatory | 1 | 49908 | 1 | 1.690 | 29531.4 |
87 | 2021-01-30 12:41:43 | observatory | 1 | 49908 | 1 | 0.736 | 67809.8 |
86 | 2021-01-02 13:38:31 | observatory | 1 | 49908 | 1 | 0.750 | 66544.0 |
85 | 2020-12-28 09:15:16 | observatory | 1 | 49908 | 1 | 0.766 | 65154.0 |
84 | 2020-11-11 02:59:04 | observatory | 1 | 49908 | 1 | 1.093 | 45661.5 |
83 | 2020-11-11 00:46:31 | observatory | 1 | 49908 | 1 | 0.796 | 62698.5 |
82 | 2020-09-20 21:33:14 | observatory | 1 | 49908 | 1 | 0.766 | 65154.0 |
81 | 2020-05-20 03:13:45 | observatory | 1 | 49908 | 1 | 0.796 | 62698.5 |
80 | 2020-03-26 13:07:05 | observatory | 1 | 49908 | 1 | 0.860 | 58032.6 |
79 | 2020-02-16 00:55:38 | observatory | 1 | 49908 | 1 | 0.843 | 59202.8 |
78 | 2020-02-15 13:15:55 | observatory | 1 | 49908 | 1 | 2.720 | 18348.5 |
77 | 2020-02-13 02:59:31 | observatory | 1 | 49908 | 1 | 0.843 | 59202.8 |
76 | 2020-02-10 08:13:02 | observatory | 1 | 49908 | 1 | 0.796 | 62698.5 |
75 | 2020-02-09 21:26:58 | observatory | 1 | 49908 | 1 | 0.873 | 57168.4 |
74 | 2020-02-08 08:49:00 | observatory | 1 | 49908 | 1 | 0.906 | 55086.1 |
73 | 2020-02-02 12:15:58 | observatory | 1 | 49908 | 1 | 0.826 | 60421.3 |
72 | 2020-01-30 19:38:52 | observatory | 1 | 49908 | 1 | 1.656 | 30137.7 |
71 | 2020-01-17 10:51:13 | observatory | 1 | 49908 | 1 | 0.890 | 56076.4 |
70 | 2020-01-09 01:48:02 | observatory | 1 | 49908 | 1 | 0.936 | 53320.5 |
69 | 2020-01-07 13:24:09 | observatory | 1 | 49908 | 1 | 1.720 | 29016.3 |
68 | 2020-01-04 19:42:26 | observatory | 1 | 49908 | 1 | 0.796 | 62698.5 |
67 | 2019-10-26 05:17:18 | observatory | 1 | 49908 | 1 | 0.830 | 60130.1 |