History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"glasshouse"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
164 | 2024-04-18 17:35:26 | glasshouse | 4 | 161450 | 79 | 31.736 | 5087.3 |
163 | 2024-04-16 11:13:23 | glasshouse | 4 | 161450 | 79 | 50.190 | 3216.8 |
162 | 2024-04-16 09:50:53 | glasshouse | 5 | 173545 | 386 | 45.910 | 3780.1 |
161 | 2024-04-14 23:34:56 | glasshouse | 5 | 173545 | 386 | 66.126 | 2624.5 |
160 | 2024-04-14 19:23:57 | glasshouse | 4 | 161450 | 79 | 22.923 | 7043.1 |
159 | 2024-04-14 14:04:21 | glasshouse | 4 | 161450 | 79 | 29.143 | 5539.9 |
158 | 2024-04-14 10:34:18 | glasshouse | 4 | 161450 | 79 | 37.113 | 4350.2 |
157 | 2024-04-14 10:16:28 | glasshouse | 4 | 161450 | 79 | 30.690 | 5260.7 |
156 | 2024-04-13 22:22:35 | glasshouse | 4 | 161450 | 79 | 44.736 | 3609.0 |
155 | 2024-04-13 18:57:23 | glasshouse | 5 | 173545 | 386 | 63.486 | 2733.6 |
154 | 2024-04-13 18:57:22 | glasshouse | 4 | 161450 | 79 | 36.486 | 4425.0 |
153 | 2024-04-13 18:57:14 | glasshouse | 3 | 140603 | 11 | 8.110 | 17337.0 |
152 | 2024-04-13 18:57:09 | glasshouse | 2 | 108824 | 3 | 11.876 | 9163.4 |
151 | 2024-04-13 17:44:31 | glasshouse | 1 | 67641 | 2 | 1.466 | 46139.8 |
150 | 2024-03-30 23:51:50 | glasshouse | 1 | 67641 | 2 | 1.156 | 58513.0 |
149 | 2024-03-10 21:51:03 | glasshouse | 1 | 67641 | 2 | 1.153 | 58665.2 |
148 | 2024-03-04 21:21:19 | glasshouse | 5 | 173545 | 386 | 31.860 | 5447.1 |
147 | 2024-03-02 10:46:55 | glasshouse | 5 | 173545 | 386 | 54.846 | 3164.2 |
146 | 2024-02-20 04:59:18 | glasshouse | 4 | 161450 | 79 | 29.156 | 5537.5 |
145 | 2024-02-19 09:22:43 | glasshouse | 5 | 173545 | 386 | 17.563 | 9881.3 |
144 | 2024-02-19 01:24:11 | glasshouse | 4 | 161450 | 79 | 26.563 | 6078.0 |
143 | 2024-02-18 23:43:13 | glasshouse | 4 | 161450 | 79 | 27.313 | 5911.1 |
142 | 2024-02-18 11:33:59 | glasshouse | 5 | 173545 | 386 | 38.673 | 4487.5 |
141 | 2024-02-18 11:34:03 | glasshouse | 4 | 161450 | 79 | 33.550 | 4812.2 |
140 | 2024-02-18 11:34:03 | glasshouse | 3 | 140603 | 11 | 22.113 | 6358.4 |
139 | 2024-02-18 11:34:01 | glasshouse | 2 | 108824 | 3 | 7.860 | 13845.3 |
138 | 2024-02-18 04:56:49 | glasshouse | 1 | 67641 | 2 | 2.266 | 29850.4 |
137 | 2024-02-11 07:20:45 | glasshouse | 1 | 67641 | 2 | 1.170 | 57812.8 |
136 | 2024-02-08 15:09:46 | glasshouse | 1 | 67641 | 2 | 2.483 | 27241.6 |
135 | 2024-02-01 09:56:00 | glasshouse | 1 | 67641 | 2 | 0.953 | 70976.9 |
134 | 2024-02-01 09:55:35 | glasshouse | 1 | 67641 | 2 | 1.143 | 59178.5 |
133 | 2024-01-09 03:37:08 | glasshouse | 1 | 67641 | 2 | 1.096 | 61716.2 |
132 | 2024-01-04 10:53:42 | glasshouse | 3 | 140603 | 11 | 6.420 | 21900.8 |
131 | 2023-12-14 01:36:31 | glasshouse | 1 | 67641 | 2 | 1.000 | 67641.0 |
130 | 2023-11-11 19:19:11 | glasshouse | 1 | 67641 | 2 | 1.110 | 60937.8 |
129 | 2023-11-02 00:27:04 | glasshouse | 1 | 67641 | 2 | 1.076 | 62863.4 |
128 | 2023-10-10 02:03:17 | glasshouse | 3 | 140603 | 11 | 6.403 | 21958.9 |
127 | 2023-09-30 12:17:56 | glasshouse | 1 | 67641 | 2 | 1.060 | 63812.3 |
126 | 2023-09-29 22:09:11 | glasshouse | 1 | 67641 | 2 | 1.093 | 61885.6 |
125 | 2023-07-27 05:44:46 | glasshouse | 1 | 67641 | 2 | 1.876 | 36056.0 |
124 | 2023-07-21 06:14:06 | glasshouse | 3 | 140603 | 11 | 6.093 | 23076.2 |
123 | 2023-05-03 00:22:00 | glasshouse | 1 | 67641 | 2 | 1.123 | 60232.4 |
122 | 2023-04-23 10:26:01 | glasshouse | 1 | 67641 | 2 | 0.966 | 70021.7 |
121 | 2023-04-03 15:55:47 | glasshouse | 3 | 140603 | 11 | 5.156 | 27269.8 |
120 | 2023-02-15 20:15:06 | glasshouse | 1 | 67641 | 2 | 0.970 | 69733.0 |
119 | 2022-12-30 15:32:41 | glasshouse | 3 | 140603 | 11 | 5.360 | 26231.9 |
118 | 2022-12-13 17:50:04 | glasshouse | 1 | 67641 | 2 | 0.953 | 70976.9 |
117 | 2022-12-12 01:28:59 | glasshouse | 1 | 67641 | 2 | 1.140 | 59334.2 |
116 | 2022-08-29 13:54:29 | glasshouse | 3 | 140603 | 11 | 5.580 | 25197.7 |
115 | 2022-08-19 16:47:58 | glasshouse | 1 | 67641 | 2 | 0.936 | 72266.0 |
114 | 2022-08-17 07:02:01 | glasshouse | 1 | 67641 | 2 | 1.186 | 57032.9 |
113 | 2022-07-05 00:28:08 | glasshouse | 1 | 67641 | 2 | 1.000 | 67641.0 |
112 | 2022-06-29 13:01:50 | glasshouse | 2 | 108824 | 3 | 2.580 | 42179.8 |
111 | 2022-04-07 16:28:54 | glasshouse | 5 | 173545 | 386 | 16.686 | 10400.6 |
110 | 2022-04-05 21:59:08 | glasshouse | 1 | 67641 | 2 | 1.126 | 60071.9 |
109 | 2022-03-30 17:30:35 | glasshouse | 3 | 140603 | 11 | 7.250 | 19393.5 |
108 | 2022-01-31 22:22:34 | glasshouse | 1 | 67641 | 2 | 1.076 | 62863.4 |
107 | 2022-01-05 08:58:50 | glasshouse | 1 | 67641 | 2 | 1.076 | 62863.4 |
106 | 2021-12-30 05:37:50 | glasshouse | 3 | 140603 | 11 | 5.236 | 26853.1 |
105 | 2021-12-16 11:24:50 | glasshouse | 1 | 67641 | 2 | 0.970 | 69733.0 |
104 | 2021-11-20 03:11:16 | glasshouse | 1 | 67641 | 2 | 1.046 | 64666.3 |
103 | 2021-09-12 22:55:53 | glasshouse | 1 | 67641 | 2 | 1.106 | 61158.2 |
102 | 2021-05-23 13:13:14 | glasshouse | 1 | 67641 | 2 | 1.000 | 67641.0 |
101 | 2021-04-13 04:56:25 | glasshouse | 2 | 108824 | 3 | 2.576 | 42245.3 |
100 | 2021-03-16 23:31:39 | glasshouse | 2 | 108824 | 3 | 2.533 | 42962.5 |
99 | 2021-02-26 09:31:29 | glasshouse | 5 | 173545 | 386 | 14.440 | 12018.4 |
98 | 2021-02-25 12:46:38 | glasshouse | 1 | 67641 | 2 | 1.076 | 62863.4 |
97 | 2021-02-19 22:52:47 | glasshouse | 2 | 108824 | 3 | 2.640 | 41221.2 |
96 | 2021-01-31 09:13:37 | glasshouse | 1 | 67641 | 2 | 1.140 | 59334.2 |
95 | 2021-01-03 22:05:39 | glasshouse | 1 | 67641 | 2 | 1.016 | 66575.8 |
94 | 2020-12-06 23:05:14 | glasshouse | 1 | 67641 | 2 | 0.983 | 68810.8 |
93 | 2020-10-22 16:14:49 | glasshouse | 1 | 67641 | 2 | 1.580 | 42810.8 |
92 | 2020-10-18 17:39:26 | glasshouse | 1 | 67641 | 2 | 1.080 | 62630.6 |
91 | 2020-09-03 11:36:25 | glasshouse | 1 | 67641 | 2 | 1.123 | 60232.4 |
90 | 2020-08-21 01:47:53 | glasshouse | 1 | 67641 | 2 | 0.983 | 68810.8 |
89 | 2020-07-31 06:45:00 | glasshouse | 1 | 67641 | 2 | 1.140 | 59334.2 |
88 | 2020-06-16 11:39:24 | glasshouse | 1 | 67641 | 2 | 1.063 | 63632.2 |
87 | 2020-03-27 23:54:33 | glasshouse | 1 | 67641 | 2 | 1.123 | 60232.4 |
86 | 2020-02-26 07:12:17 | glasshouse | 1 | 67641 | 2 | 2.440 | 27721.7 |
85 | 2020-02-13 21:08:44 | glasshouse | 1 | 67641 | 2 | 2.470 | 27385.0 |
84 | 2020-02-10 02:06:23 | glasshouse | 1 | 67641 | 2 | 1.140 | 59334.2 |
83 | 2020-02-06 02:48:08 | glasshouse | 1 | 67641 | 2 | 2.456 | 27541.1 |
82 | 2020-02-04 01:34:00 | glasshouse | 1 | 67641 | 2 | 1.296 | 52192.1 |
81 | 2020-01-23 18:01:00 | glasshouse | 1 | 67641 | 2 | 2.530 | 26735.6 |
80 | 2020-01-17 18:26:44 | glasshouse | 1 | 67641 | 2 | 1.250 | 54112.8 |
79 | 2020-01-06 13:17:01 | glasshouse | 1 | 67641 | 2 | 1.296 | 52192.1 |
78 | 2019-11-24 09:55:24 | glasshouse | 1 | 67641 | 2 | 1.080 | 62630.6 |
77 | 2019-08-22 12:31:46 | glasshouse | 1 | 67641 | 2 | 1.093 | 61885.6 |
76 | 2019-04-30 17:24:42 | glasshouse | 1 | 67641 | 2 | 1.016 | 66575.8 |
75 | 2019-04-08 01:56:13 | glasshouse | 1 | 67641 | 2 | 0.970 | 69733.0 |
74 | 2019-03-07 02:24:52 | glasshouse | 1 | 67641 | 2 | 0.980 | 69021.4 |
73 | 2018-12-25 14:41:52 | glasshouse | 1 | 67641 | 2 | 0.990 | 68324.2 |
72 | 2018-07-30 05:23:54 | glasshouse | 1 | 67641 | 2 | 0.973 | 69518.0 |
71 | 2018-03-06 12:04:48 | glasshouse | 1 | 67641 | 2 | 2.100 | 32210.0 |
70 | 2018-03-03 15:04:53 | glasshouse | 1 | 67641 | 2 | 1.330 | 50857.9 |
69 | 2018-02-20 13:31:56 | glasshouse | 1 | 67641 | 2 | 1.396 | 48453.4 |
68 | 2018-02-18 10:36:32 | glasshouse | 1 | 67641 | 2 | 1.470 | 46014.3 |
67 | 2018-02-05 17:57:49 | glasshouse | 1 | 67641 | 2 | 1.383 | 48908.9 |
66 | 2018-02-03 15:06:38 | glasshouse | 1 | 67641 | 2 | 1.346 | 50253.3 |
65 | 2017-12-21 10:03:34 | glasshouse | 1 | 67641 | 2 | 1.823 | 37104.2 |