History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"playhouse"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
149 | 2024-04-18 18:26:40 | playhouse | 1 | 81242 | 2 | 1.623 | 50056.7 |
148 | 2024-04-02 02:44:51 | playhouse | 1 | 81242 | 2 | 1.296 | 62686.7 |
147 | 2024-03-30 23:51:53 | playhouse | 1 | 81242 | 2 | 1.533 | 52995.4 |
146 | 2024-03-27 12:48:57 | playhouse | 3 | 148641 | 22 | 16.190 | 9181.0 |
145 | 2024-03-27 08:30:03 | playhouse | 2 | 121436 | 2 | 9.500 | 12782.7 |
144 | 2024-03-27 07:21:57 | playhouse | 1 | 81242 | 2 | 1.403 | 57905.9 |
143 | 2024-03-26 19:43:58 | playhouse | 3 | 148641 | 22 | 22.656 | 6560.8 |
142 | 2024-03-26 19:43:54 | playhouse | 2 | 121436 | 2 | 16.423 | 7394.3 |
141 | 2024-03-26 16:55:35 | playhouse | 1 | 81242 | 2 | 1.420 | 57212.7 |
140 | 2024-03-11 01:56:52 | playhouse | 4 | 165329 | 186 | 16.970 | 9742.4 |
139 | 2024-03-07 13:57:23 | playhouse | 1 | 81242 | 2 | 1.453 | 55913.3 |
138 | 2024-03-07 13:24:12 | playhouse | 4 | 165329 | 186 | 17.843 | 9265.8 |
137 | 2024-03-04 19:24:21 | playhouse | 4 | 165329 | 186 | 15.126 | 10930.1 |
136 | 2024-03-02 09:55:12 | playhouse | 1 | 81242 | 2 | 1.423 | 57092.1 |
135 | 2024-02-27 05:16:48 | playhouse | 1 | 81242 | 2 | 1.513 | 53696.0 |
134 | 2024-02-18 12:27:05 | playhouse | 3 | 148641 | 22 | 22.063 | 6737.1 |
133 | 2024-02-16 05:15:50 | playhouse | 3 | 148641 | 22 | 15.563 | 9550.9 |
132 | 2024-02-11 05:21:48 | playhouse | 2 | 121436 | 2 | 4.000 | 30359.0 |
131 | 2024-02-11 03:20:32 | playhouse | 1 | 81242 | 2 | 1.233 | 65889.7 |
130 | 2024-02-10 11:51:15 | playhouse | 4 | 165329 | 186 | 23.516 | 7030.5 |
129 | 2024-02-07 18:22:19 | playhouse | 4 | 165329 | 186 | 21.520 | 7682.6 |
128 | 2024-02-01 09:58:32 | playhouse | 3 | 148641 | 22 | 6.970 | 21325.8 |
127 | 2024-02-01 09:58:28 | playhouse | 2 | 121436 | 2 | 3.970 | 30588.4 |
126 | 2024-02-01 09:52:20 | playhouse | 1 | 81242 | 2 | 1.263 | 64324.6 |
125 | 2024-01-25 18:09:28 | playhouse | 1 | 81242 | 2 | 1.546 | 52549.8 |
124 | 2024-01-08 09:50:48 | playhouse | 1 | 81242 | 2 | 1.390 | 58447.5 |
123 | 2023-12-30 13:59:15 | playhouse | 1 | 81242 | 2 | 1.373 | 59171.2 |
122 | 2023-12-22 14:32:12 | playhouse | 1 | 81242 | 2 | 1.250 | 64993.6 |
121 | 2023-11-26 05:07:05 | playhouse | 4 | 165329 | 186 | 11.623 | 14224.3 |
120 | 2023-10-18 09:49:38 | playhouse | 1 | 81242 | 2 | 1.390 | 58447.5 |
119 | 2023-10-11 06:18:43 | playhouse | 1 | 81242 | 2 | 1.500 | 54161.3 |
118 | 2023-08-25 06:59:08 | playhouse | 4 | 165329 | 186 | 10.346 | 15980.0 |
117 | 2023-08-11 12:30:17 | playhouse | 1 | 81242 | 2 | 1.343 | 60492.9 |
116 | 2023-08-09 12:03:10 | playhouse | 1 | 81242 | 2 | 1.250 | 64993.6 |
115 | 2023-08-07 05:42:33 | playhouse | 1 | 81242 | 2 | 1.250 | 64993.6 |
114 | 2023-07-05 00:08:42 | playhouse | 1 | 81242 | 2 | 1.360 | 59736.8 |
113 | 2023-05-08 22:39:49 | playhouse | 4 | 165329 | 186 | 10.076 | 16408.2 |
112 | 2023-05-06 09:48:39 | playhouse | 1 | 81242 | 2 | 1.343 | 60492.9 |
111 | 2023-03-22 14:21:36 | playhouse | 1 | 81242 | 2 | 1.233 | 65889.7 |
110 | 2023-02-28 02:36:44 | playhouse | 1 | 81242 | 2 | 1.190 | 68270.6 |
109 | 2023-02-13 04:41:03 | playhouse | 4 | 165329 | 186 | 10.046 | 16457.2 |
108 | 2022-12-24 21:18:26 | playhouse | 1 | 81242 | 2 | 1.203 | 67532.8 |
107 | 2022-11-24 14:55:24 | playhouse | 4 | 165329 | 186 | 9.983 | 16561.1 |
106 | 2022-10-27 06:36:23 | playhouse | 1 | 81242 | 2 | 1.203 | 67532.8 |
105 | 2022-10-23 17:29:43 | playhouse | 1 | 81242 | 2 | 1.343 | 60492.9 |
104 | 2022-09-13 04:28:22 | playhouse | 1 | 81242 | 2 | 1.376 | 59042.2 |
103 | 2022-07-19 06:11:32 | playhouse | 1 | 81242 | 2 | 1.313 | 61875.1 |
102 | 2022-05-31 23:29:26 | playhouse | 1 | 81242 | 2 | 1.216 | 66810.9 |
101 | 2022-04-17 17:30:26 | playhouse | 4 | 165329 | 186 | 11.640 | 14203.5 |
100 | 2022-04-15 13:48:52 | playhouse | 4 | 165329 | 186 | 10.830 | 15265.8 |
99 | 2022-03-16 17:19:31 | playhouse | 1 | 81242 | 2 | 1.423 | 57092.1 |
98 | 2022-01-10 15:08:04 | playhouse | 1 | 81242 | 2 | 1.470 | 55266.7 |
97 | 2021-12-24 20:02:14 | playhouse | 1 | 81242 | 2 | 1.436 | 56575.2 |
96 | 2021-12-21 01:23:15 | playhouse | 4 | 165329 | 186 | 11.610 | 14240.2 |
95 | 2021-12-18 22:40:29 | playhouse | 4 | 165329 | 186 | 10.423 | 15861.9 |
94 | 2021-10-27 15:13:54 | playhouse | 1 | 81242 | 2 | 1.406 | 57782.4 |
93 | 2021-10-25 13:53:39 | playhouse | 1 | 81242 | 2 | 1.376 | 59042.2 |
92 | 2021-10-05 10:26:08 | playhouse | 4 | 165329 | 186 | 11.190 | 14774.7 |
91 | 2021-10-02 21:36:28 | playhouse | 1 | 81242 | 2 | 1.250 | 64993.6 |
90 | 2021-09-30 17:53:01 | playhouse | 1 | 81242 | 2 | 1.266 | 64172.2 |
89 | 2021-09-05 12:46:25 | playhouse | 1 | 81242 | 2 | 1.330 | 61084.2 |
88 | 2021-05-19 04:12:33 | playhouse | 1 | 81242 | 2 | 1.596 | 50903.5 |
87 | 2021-04-05 09:53:42 | playhouse | 1 | 81242 | 2 | 1.373 | 59171.2 |
86 | 2021-02-22 06:14:02 | playhouse | 4 | 165329 | 186 | 11.390 | 14515.3 |
85 | 2021-02-08 13:06:29 | playhouse | 1 | 81242 | 2 | 1.326 | 61268.5 |
84 | 2021-01-20 20:58:39 | playhouse | 1 | 81242 | 2 | 1.236 | 65729.8 |
83 | 2020-11-06 18:27:48 | playhouse | 1 | 81242 | 2 | 1.343 | 60492.9 |
82 | 2020-11-02 22:01:05 | playhouse | 1 | 81242 | 2 | 1.343 | 60492.9 |
81 | 2020-10-31 22:33:38 | playhouse | 1 | 81242 | 2 | 1.483 | 54782.2 |
80 | 2020-10-24 18:51:14 | playhouse | 1 | 81242 | 2 | 1.436 | 56575.2 |
79 | 2020-07-16 23:04:21 | playhouse | 1 | 81242 | 2 | 1.453 | 55913.3 |
78 | 2020-04-15 04:28:56 | playhouse | 1 | 81242 | 2 | 1.250 | 64993.6 |
77 | 2020-03-25 12:24:32 | playhouse | 1 | 81242 | 2 | 2.966 | 27391.1 |
76 | 2020-02-19 06:45:36 | playhouse | 1 | 81242 | 2 | 2.033 | 39961.6 |
75 | 2020-02-07 02:20:30 | playhouse | 1 | 81242 | 2 | 1.453 | 55913.3 |
74 | 2020-02-04 14:19:38 | playhouse | 1 | 81242 | 2 | 1.813 | 44810.8 |
73 | 2020-02-03 23:10:32 | playhouse | 1 | 81242 | 2 | 3.923 | 20709.2 |
72 | 2020-02-03 22:23:58 | playhouse | 1 | 81242 | 2 | 3.173 | 25604.2 |
71 | 2020-02-02 01:32:59 | playhouse | 1 | 81242 | 2 | 3.110 | 26122.8 |
70 | 2020-01-19 17:14:00 | playhouse | 1 | 81242 | 2 | 1.203 | 67532.8 |
69 | 2020-01-07 21:22:12 | playhouse | 1 | 81242 | 2 | 1.483 | 54782.2 |
68 | 2020-01-04 20:51:34 | playhouse | 1 | 81242 | 2 | 1.516 | 53589.7 |
67 | 2019-12-28 10:15:39 | playhouse | 1 | 81242 | 2 | 1.263 | 64324.6 |
66 | 2019-09-27 21:31:52 | playhouse | 1 | 81242 | 2 | 1.120 | 72537.5 |
65 | 2019-06-15 15:56:24 | playhouse | 1 | 81242 | 2 | 1.346 | 60358.1 |
64 | 2019-02-25 02:50:03 | playhouse | 1 | 81242 | 2 | 1.260 | 64477.8 |
63 | 2019-01-05 06:12:58 | playhouse | 1 | 81242 | 2 | 1.196 | 67928.1 |
62 | 2018-12-24 16:42:11 | playhouse | 1 | 81242 | 2 | 1.453 | 55913.3 |
61 | 2018-12-05 19:05:27 | playhouse | 1 | 81242 | 2 | 1.200 | 67701.7 |
60 | 2018-11-11 01:41:48 | playhouse | 1 | 81242 | 2 | 1.316 | 61734.0 |
59 | 2018-11-02 06:24:04 | playhouse | 1 | 81242 | 2 | 1.190 | 68270.6 |
58 | 2018-10-28 04:05:15 | playhouse | 1 | 81242 | 2 | 1.313 | 61875.1 |
57 | 2018-07-29 07:56:24 | playhouse | 1 | 81242 | 2 | 1.253 | 64838.0 |
56 | 2018-07-26 16:21:41 | playhouse | 1 | 81242 | 2 | 1.210 | 67142.1 |
55 | 2018-03-21 20:09:26 | playhouse | 1 | 81242 | 2 | 1.803 | 45059.3 |
54 | 2018-03-19 11:08:35 | playhouse | 1 | 81242 | 2 | 1.766 | 46003.4 |
53 | 2017-11-22 23:42:11 | playhouse | 1 | 81242 | 2 | 1.710 | 47509.9 |
52 | 2017-11-22 23:22:47 | playhouse | 1 | 81242 | 2 | 1.740 | 46690.8 |
51 | 2017-11-17 03:33:20 | playhouse | 1 | 81242 | 2 | 1.930 | 42094.3 |
50 | 2017-06-10 09:08:45 | playhouse | 1 | 81242 | 2 | 1.896 | 42849.2 |