History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"jailhouse"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
155 | 2024-04-13 18:36:27 | jailhouse | 2 | 121436 | 2 | 12.906 | 9409.3 |
154 | 2024-04-13 17:42:47 | jailhouse | 1 | 81242 | 2 | 1.940 | 41877.3 |
153 | 2024-04-10 18:32:31 | jailhouse | 4 | 165329 | 147 | 45.846 | 3606.2 |
152 | 2024-04-08 09:22:16 | jailhouse | 4 | 165329 | 147 | 44.126 | 3746.7 |
151 | 2024-04-08 09:22:17 | jailhouse | 3 | 148641 | 23 | 15.283 | 9725.9 |
150 | 2024-04-08 09:22:15 | jailhouse | 2 | 121436 | 2 | 8.000 | 15179.5 |
149 | 2024-04-08 06:08:55 | jailhouse | 1 | 81242 | 2 | 1.686 | 48186.2 |
148 | 2024-03-30 23:52:29 | jailhouse | 1 | 81242 | 2 | 2.406 | 33766.4 |
147 | 2024-03-27 08:30:00 | jailhouse | 3 | 148641 | 23 | 14.470 | 10272.4 |
146 | 2024-03-27 08:29:59 | jailhouse | 2 | 121436 | 2 | 10.626 | 11428.2 |
145 | 2024-03-27 07:22:22 | jailhouse | 1 | 81242 | 2 | 1.406 | 57782.4 |
144 | 2024-03-10 23:30:07 | jailhouse | 1 | 81242 | 2 | 1.453 | 55913.3 |
143 | 2024-03-09 07:28:21 | jailhouse | 4 | 165329 | 147 | 29.063 | 5688.6 |
142 | 2024-03-08 06:05:23 | jailhouse | 3 | 148641 | 23 | 15.266 | 9736.7 |
141 | 2024-03-06 06:33:26 | jailhouse | 3 | 148641 | 23 | 19.250 | 7721.6 |
140 | 2024-03-05 18:08:52 | jailhouse | 4 | 165329 | 147 | 36.830 | 4489.0 |
139 | 2024-03-05 18:08:59 | jailhouse | 2 | 121436 | 2 | 9.296 | 13063.3 |
138 | 2024-03-05 18:08:56 | jailhouse | 3 | 148641 | 23 | 10.703 | 13887.8 |
137 | 2024-03-05 16:08:38 | jailhouse | 1 | 81242 | 2 | 1.356 | 59913.0 |
136 | 2024-03-02 09:56:37 | jailhouse | 1 | 81242 | 2 | 4.423 | 18368.1 |
135 | 2024-02-29 07:21:58 | jailhouse | 1 | 81242 | 2 | 2.483 | 32719.3 |
134 | 2024-02-01 09:59:12 | jailhouse | 4 | 165329 | 147 | 14.096 | 11728.8 |
133 | 2024-02-01 09:58:40 | jailhouse | 3 | 148641 | 23 | 7.110 | 20905.9 |
132 | 2024-02-01 09:58:36 | jailhouse | 2 | 121436 | 2 | 3.376 | 35970.4 |
131 | 2024-02-01 09:52:00 | jailhouse | 1 | 81242 | 2 | 1.376 | 59042.2 |
130 | 2024-01-06 19:17:32 | jailhouse | 1 | 81242 | 2 | 1.373 | 59171.2 |
129 | 2023-12-29 21:31:29 | jailhouse | 1 | 81242 | 2 | 1.250 | 64993.6 |
128 | 2023-12-15 01:03:33 | jailhouse | 1 | 81242 | 2 | 2.593 | 31331.3 |
127 | 2023-10-30 15:50:22 | jailhouse | 1 | 81242 | 2 | 1.500 | 54161.3 |
126 | 2023-10-17 21:56:02 | jailhouse | 1 | 81242 | 2 | 1.440 | 56418.1 |
125 | 2023-08-23 13:49:59 | jailhouse | 1 | 81242 | 2 | 1.296 | 62686.7 |
124 | 2023-05-24 16:13:45 | jailhouse | 1 | 81242 | 2 | 1.340 | 60628.4 |
123 | 2023-03-18 14:13:03 | jailhouse | 1 | 81242 | 2 | 1.170 | 69437.6 |
122 | 2023-01-06 18:08:34 | jailhouse | 1 | 81242 | 2 | 2.346 | 34630.0 |
121 | 2022-10-02 05:18:46 | jailhouse | 1 | 81242 | 2 | 1.203 | 67532.8 |
120 | 2022-05-21 00:08:52 | jailhouse | 1 | 81242 | 2 | 1.233 | 65889.7 |
119 | 2022-05-18 18:37:05 | jailhouse | 1 | 81242 | 2 | 1.376 | 59042.2 |
118 | 2022-05-16 10:40:59 | jailhouse | 1 | 81242 | 2 | 1.516 | 53589.7 |
117 | 2021-03-16 09:02:02 | jailhouse | 1 | 81242 | 2 | 1.236 | 65729.8 |
116 | 2021-02-21 01:42:33 | jailhouse | 1 | 81242 | 2 | 1.390 | 58447.5 |
115 | 2021-02-19 08:48:00 | jailhouse | 1 | 81242 | 2 | 1.220 | 66591.8 |
114 | 2020-12-01 03:43:54 | jailhouse | 1 | 81242 | 2 | 1.326 | 61268.5 |
113 | 2020-11-08 14:19:11 | jailhouse | 1 | 81242 | 2 | 1.406 | 57782.4 |
112 | 2020-10-24 19:27:23 | jailhouse | 1 | 81242 | 2 | 1.220 | 66591.8 |
111 | 2020-10-24 02:41:53 | jailhouse | 1 | 81242 | 2 | 1.326 | 61268.5 |
110 | 2020-10-14 14:21:16 | jailhouse | 1 | 81242 | 2 | 1.266 | 64172.2 |
109 | 2020-03-25 23:01:31 | jailhouse | 1 | 81242 | 2 | 1.546 | 52549.8 |
108 | 2020-03-14 16:24:15 | jailhouse | 1 | 81242 | 2 | 1.216 | 66810.9 |
107 | 2020-02-28 19:40:37 | jailhouse | 1 | 81242 | 2 | 1.423 | 57092.1 |
106 | 2020-02-28 04:46:54 | jailhouse | 1 | 81242 | 2 | 1.326 | 61268.5 |
105 | 2020-02-10 04:36:47 | jailhouse | 1 | 81242 | 2 | 1.576 | 51549.5 |
104 | 2020-02-08 03:10:38 | jailhouse | 1 | 81242 | 2 | 1.486 | 54671.6 |
103 | 2020-02-07 20:15:15 | jailhouse | 1 | 81242 | 2 | 1.420 | 57212.7 |
102 | 2020-02-03 20:25:52 | jailhouse | 1 | 81242 | 2 | 1.360 | 59736.8 |
101 | 2020-01-22 18:35:47 | jailhouse | 1 | 81242 | 2 | 1.546 | 52549.8 |
100 | 2020-01-14 17:35:20 | jailhouse | 1 | 81242 | 2 | 1.343 | 60492.9 |
99 | 2020-01-07 21:26:32 | jailhouse | 1 | 81242 | 2 | 1.360 | 59736.8 |
98 | 2019-12-06 00:37:52 | jailhouse | 1 | 81242 | 2 | 1.250 | 64993.6 |
97 | 2019-09-03 21:45:48 | jailhouse | 1 | 81242 | 2 | 1.380 | 58871.0 |
96 | 2019-05-22 19:44:52 | jailhouse | 1 | 81242 | 2 | 1.313 | 61875.1 |
95 | 2019-01-25 11:22:24 | jailhouse | 1 | 81242 | 2 | 1.416 | 57374.3 |
94 | 2018-11-09 14:37:34 | jailhouse | 1 | 81242 | 2 | 1.356 | 59913.0 |
93 | 2018-09-21 14:34:26 | jailhouse | 1 | 81242 | 2 | 1.310 | 62016.8 |
92 | 2018-09-19 15:20:58 | jailhouse | 1 | 81242 | 2 | 1.246 | 65202.2 |
91 | 2018-06-17 15:27:07 | jailhouse | 1 | 81242 | 2 | 1.243 | 65359.6 |
90 | 2018-05-23 14:21:46 | jailhouse | 1 | 81242 | 2 | 1.226 | 66265.9 |
89 | 2018-04-15 21:49:32 | jailhouse | 1 | 81242 | 2 | 1.333 | 60946.7 |
88 | 2018-02-26 04:06:09 | jailhouse | 1 | 81242 | 2 | 1.656 | 49059.2 |
87 | 2018-01-04 02:43:56 | jailhouse | 1 | 81242 | 2 | 1.966 | 41323.5 |
86 | 2017-11-12 16:49:19 | jailhouse | 1 | 81242 | 2 | 2.416 | 33626.7 |
85 | 2017-11-11 06:37:57 | jailhouse | 1 | 81242 | 2 | 1.836 | 44249.5 |
84 | 2017-07-30 16:03:07 | jailhouse | 1 | 81242 | 2 | 2.090 | 38871.8 |
83 | 2017-07-30 09:36:29 | jailhouse | 4 | 165329 | 147 | 13.706 | 12062.5 |
82 | 2017-07-26 15:11:15 | jailhouse | 4 | 165329 | 147 | 20.180 | 8192.7 |
81 | 2017-07-21 10:11:02 | jailhouse | 3 | 148641 | 23 | 8.440 | 17611.5 |
80 | 2017-07-20 02:36:24 | jailhouse | 2 | 121436 | 2 | 4.180 | 29051.7 |
79 | 2017-07-18 18:08:10 | jailhouse | 1 | 81242 | 2 | 3.743 | 21705.0 |
78 | 2017-06-12 04:54:27 | jailhouse | 1 | 81242 | 2 | 1.923 | 42247.5 |
77 | 2017-05-30 11:29:01 | jailhouse | 1 | 81242 | 2 | 2.253 | 36059.5 |
76 | 2017-05-29 11:32:05 | jailhouse | 1 | 81242 | 2 | 1.566 | 51878.7 |
75 | 2017-04-18 12:29:14 | jailhouse | 1 | 81242 | 2 | 1.573 | 51647.8 |
74 | 2017-02-10 22:56:31 | jailhouse | 1 | 81242 | 2 | 1.630 | 49841.7 |
73 | 2016-10-31 16:35:42 | jailhouse | 1 | 81242 | 2 | 1.676 | 48473.7 |
72 | 2016-10-14 18:18:41 | jailhouse | 1 | 81242 | 2 | 1.660 | 48941.0 |
71 | 2016-10-02 21:20:18 | jailhouse | 1 | 81242 | 2 | 1.746 | 46530.4 |
70 | 2016-09-07 05:04:48 | jailhouse | 2 | 121436 | 2 | 5.416 | 22421.7 |
69 | 2016-08-30 15:59:56 | jailhouse | 1 | 81242 | 2 | 1.856 | 43772.6 |
68 | 2016-08-02 10:24:29 | jailhouse | 1 | 81242 | 2 | 2.086 | 38946.3 |
67 | 2016-07-30 11:13:04 | jailhouse | 1 | 81242 | 2 | 1.830 | 44394.5 |
66 | 2016-07-28 08:43:58 | jailhouse | 1 | 81242 | 2 | 4.046 | 20079.6 |
65 | 2016-07-12 01:20:51 | jailhouse | 1 | 81242 | 2 | 1.950 | 41662.6 |
64 | 2016-07-09 23:24:15 | jailhouse | 4 | 165329 | 147 | 22.573 | 7324.2 |
63 | 2016-06-29 11:48:12 | jailhouse | 1 | 81242 | 2 | 4.050 | 20059.8 |
62 | 2016-06-25 08:21:49 | jailhouse | 1 | 81242 | 2 | 2.180 | 37267.0 |
61 | 2016-06-19 10:13:21 | jailhouse | 3 | 148641 | 23 | 12.013 | 12373.3 |
60 | 2016-06-16 14:27:11 | jailhouse | 1 | 81242 | 2 | 2.003 | 40560.2 |
59 | 2016-05-17 10:20:39 | jailhouse | 1 | 81242 | 2 | 2.146 | 37857.4 |
58 | 2016-02-02 09:25:45 | jailhouse | 1 | 81242 | 2 | 1.370 | 59300.7 |
57 | 2016-01-11 08:04:17 | jailhouse | 4 | 165329 | 147 | 29.770 | 5553.5 |
56 | 2016-01-07 19:12:21 | jailhouse | 4 | 165329 | 147 | 12.540 | 13184.1 |