History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"rob"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
2126 | 2024-04-26 23:32:13 | rob | 1 | 5146 | 25 | 0.093 | 55333.3 |
2125 | 2024-04-25 22:51:28 | rob | 2 | 14084 | 423 | 0.893 | 15771.6 |
2124 | 2024-04-23 13:23:21 | rob | 1 | 5146 | 25 | 0.093 | 55333.3 |
2123 | 2024-04-21 05:52:50 | rob | 2 | 14084 | 423 | 0.466 | 30223.2 |
2122 | 2024-04-19 00:37:32 | rob | 2 | 14084 | 423 | 0.360 | 39122.2 |
2121 | 2024-04-16 19:41:08 | rob | 2 | 14084 | 423 | 0.873 | 16132.9 |
2120 | 2024-04-15 01:21:22 | rob | 1 | 5146 | 25 | 0.173 | 29745.7 |
2119 | 2024-04-14 14:22:14 | rob | 2 | 14084 | 423 | 0.656 | 21469.5 |
2118 | 2024-04-12 16:33:44 | rob | 2 | 14084 | 423 | 1.093 | 12885.6 |
2117 | 2024-04-12 10:06:56 | rob | 1 | 5146 | 25 | 0.313 | 16440.9 |
2116 | 2024-04-12 09:26:41 | rob | 1 | 5146 | 25 | 0.076 | 67710.5 |
2115 | 2024-04-12 08:20:10 | rob | 1 | 5146 | 25 | 0.266 | 19345.9 |
2114 | 2024-04-04 05:03:28 | rob | 1 | 5146 | 25 | 0.076 | 67710.5 |
2113 | 2024-04-03 20:10:34 | rob | 2 | 14084 | 423 | 0.893 | 15771.6 |
2112 | 2024-04-03 20:10:27 | rob | 1 | 5146 | 25 | 0.126 | 40841.3 |
2111 | 2024-04-03 20:10:13 | rob | 2 | 14084 | 423 | 0.906 | 15545.3 |
2110 | 2024-04-03 20:05:18 | rob | 1 | 5146 | 25 | 0.233 | 22085.8 |
2109 | 2024-04-03 18:28:30 | rob | 2 | 14084 | 423 | 0.390 | 36112.8 |
2108 | 2024-04-02 17:38:46 | rob | 1 | 5146 | 25 | 0.203 | 25349.8 |
2107 | 2024-04-01 15:31:07 | rob | 1 | 5146 | 25 | 0.203 | 25349.8 |
2106 | 2024-04-01 06:51:00 | rob | 2 | 14084 | 423 | 0.406 | 34689.7 |
2105 | 2024-03-30 11:29:05 | rob | 2 | 14084 | 423 | 0.420 | 33533.3 |
2104 | 2024-03-26 18:52:03 | rob | 1 | 5146 | 25 | 0.093 | 55333.3 |
2103 | 2024-03-16 17:32:43 | rob | 1 | 5146 | 25 | 0.110 | 46781.8 |
2102 | 2024-03-05 03:10:56 | rob | 2 | 14084 | 423 | 1.360 | 10355.9 |
2101 | 2024-03-04 15:46:09 | rob | 2 | 14084 | 423 | 0.906 | 15545.3 |
2100 | 2024-03-03 21:27:28 | rob | 2 | 14084 | 423 | 0.436 | 32302.8 |
2099 | 2024-03-03 20:09:44 | rob | 1 | 5146 | 25 | 0.093 | 55333.3 |
2098 | 2024-03-03 14:06:25 | rob | 2 | 14084 | 423 | 0.406 | 34689.7 |
2097 | 2024-03-02 16:43:28 | rob | 1 | 5146 | 25 | 0.186 | 27666.7 |
2096 | 2024-03-02 15:40:46 | rob | 2 | 14084 | 423 | 1.373 | 10257.8 |
2095 | 2024-03-02 14:20:30 | rob | 2 | 14084 | 423 | 0.470 | 29966.0 |
2094 | 2024-03-02 12:50:23 | rob | 1 | 5146 | 25 | 0.110 | 46781.8 |
2093 | 2024-03-01 14:33:32 | rob | 2 | 14084 | 423 | 0.906 | 15545.3 |
2092 | 2024-02-25 16:05:18 | rob | 1 | 5146 | 25 | 0.076 | 67710.5 |
2091 | 2024-02-02 19:52:04 | rob | 1 | 5146 | 25 | 0.080 | 64325.0 |
2090 | 2024-02-02 14:13:35 | rob | 1 | 5146 | 25 | 0.076 | 67710.5 |
2089 | 2024-01-27 20:09:16 | rob | 2 | 14084 | 423 | 0.390 | 36112.8 |
2088 | 2024-01-27 17:39:19 | rob | 1 | 5146 | 25 | 0.093 | 55333.3 |
2087 | 2024-01-26 13:12:47 | rob | 1 | 5146 | 25 | 0.093 | 55333.3 |
2086 | 2024-01-25 23:19:57 | rob | 1 | 5146 | 25 | 0.093 | 55333.3 |
2085 | 2024-01-25 22:05:50 | rob | 2 | 14084 | 423 | 0.483 | 29159.4 |
2084 | 2024-01-02 16:26:05 | rob | 1 | 5146 | 25 | 0.080 | 64325.0 |
2083 | 2024-01-01 04:20:15 | rob | 1 | 5146 | 25 | 0.106 | 48547.2 |
2082 | 2023-12-23 03:14:20 | rob | 1 | 5146 | 25 | 0.080 | 64325.0 |
2081 | 2023-12-02 07:23:17 | rob | 1 | 5146 | 25 | 0.076 | 67710.5 |
2080 | 2023-11-23 10:49:20 | rob | 2 | 14084 | 423 | 0.360 | 39122.2 |
2079 | 2023-11-22 07:44:39 | rob | 1 | 5146 | 25 | 0.093 | 55333.3 |
2078 | 2023-11-18 01:52:37 | rob | 2 | 14084 | 423 | 0.390 | 36112.8 |
2077 | 2023-11-10 17:26:22 | rob | 1 | 5146 | 25 | 0.080 | 64325.0 |
2076 | 2023-11-09 23:46:48 | rob | 2 | 14084 | 423 | 0.376 | 37457.4 |
2075 | 2023-11-09 00:19:21 | rob | 1 | 5146 | 25 | 0.076 | 67710.5 |
2074 | 2023-11-07 08:18:42 | rob | 1 | 5146 | 25 | 0.063 | 81682.5 |
2073 | 2023-11-06 15:25:50 | rob | 1 | 5146 | 25 | 0.080 | 64325.0 |
2072 | 2023-11-06 10:38:09 | rob | 2 | 14084 | 423 | 0.330 | 42678.8 |
2071 | 2023-10-31 22:43:11 | rob | 1 | 5146 | 25 | 0.186 | 27666.7 |
2070 | 2023-10-27 07:13:53 | rob | 1 | 5146 | 25 | 0.076 | 67710.5 |
2069 | 2023-10-19 21:35:43 | rob | 1 | 5146 | 25 | 0.093 | 55333.3 |
2068 | 2023-10-17 02:06:53 | rob | 1 | 5146 | 25 | 0.080 | 64325.0 |
2067 | 2023-10-16 21:41:22 | rob | 2 | 14084 | 423 | 0.390 | 36112.8 |
2066 | 2023-10-16 13:18:46 | rob | 2 | 14084 | 423 | 0.406 | 34689.7 |
2065 | 2023-10-10 20:46:31 | rob | 1 | 5146 | 25 | 0.093 | 55333.3 |
2064 | 2023-10-10 15:16:42 | rob | 1 | 5146 | 25 | 0.076 | 67710.5 |
2063 | 2023-10-03 17:41:20 | rob | 1 | 5146 | 25 | 0.076 | 67710.5 |
2062 | 2023-10-03 10:23:46 | rob | 2 | 14084 | 423 | 0.876 | 16077.6 |
2061 | 2023-10-02 19:26:58 | rob | 2 | 14084 | 423 | 0.360 | 39122.2 |
2060 | 2023-09-28 01:43:18 | rob | 2 | 14084 | 423 | 0.423 | 33295.5 |
2059 | 2023-09-27 07:19:05 | rob | 2 | 14084 | 423 | 0.343 | 41061.2 |
2058 | 2023-09-25 18:55:56 | rob | 2 | 14084 | 423 | 0.346 | 40705.2 |
2057 | 2023-09-23 13:17:15 | rob | 2 | 14084 | 423 | 0.420 | 33533.3 |
2056 | 2023-09-23 11:40:37 | rob | 1 | 5146 | 25 | 0.156 | 32987.2 |
2055 | 2023-09-21 14:59:18 | rob | 2 | 14084 | 423 | 0.343 | 41061.2 |
2054 | 2023-09-20 08:17:55 | rob | 2 | 14084 | 423 | 0.656 | 21469.5 |
2053 | 2023-09-20 07:48:26 | rob | 2 | 14084 | 423 | 0.343 | 41061.2 |
2052 | 2023-09-19 07:36:44 | rob | 2 | 14084 | 423 | 0.360 | 39122.2 |
2051 | 2023-09-17 12:05:45 | rob | 2 | 14084 | 423 | 0.843 | 16707.0 |
2050 | 2023-09-15 04:27:06 | rob | 2 | 14084 | 423 | 0.360 | 39122.2 |
2049 | 2023-09-13 19:40:24 | rob | 1 | 5146 | 25 | 0.076 | 67710.5 |
2048 | 2023-09-11 06:29:46 | rob | 1 | 5146 | 25 | 0.093 | 55333.3 |
2047 | 2023-09-03 06:54:49 | rob | 2 | 14084 | 423 | 0.376 | 37457.4 |
2046 | 2023-09-01 22:33:55 | rob | 2 | 14084 | 423 | 0.343 | 41061.2 |
2045 | 2023-08-30 05:40:35 | rob | 2 | 14084 | 423 | 0.343 | 41061.2 |
2044 | 2023-08-27 02:45:06 | rob | 2 | 14084 | 423 | 0.423 | 33295.5 |
2043 | 2023-08-26 05:15:50 | rob | 2 | 14084 | 423 | 0.406 | 34689.7 |
2042 | 2023-08-24 12:54:38 | rob | 2 | 14084 | 423 | 0.373 | 37758.7 |
2041 | 2023-08-22 05:41:22 | rob | 2 | 14084 | 423 | 0.373 | 37758.7 |
2040 | 2023-08-20 06:01:30 | rob | 2 | 14084 | 423 | 0.373 | 37758.7 |
2039 | 2023-08-19 04:14:40 | rob | 2 | 14084 | 423 | 0.360 | 39122.2 |
2038 | 2023-08-18 09:19:32 | rob | 2 | 14084 | 423 | 0.343 | 41061.2 |
2037 | 2023-08-11 19:49:12 | rob | 2 | 14084 | 423 | 0.343 | 41061.2 |
2036 | 2023-08-09 15:08:29 | rob | 1 | 5146 | 25 | 0.090 | 57177.8 |
2035 | 2023-08-08 19:47:32 | rob | 2 | 14084 | 423 | 0.376 | 37457.4 |
2034 | 2023-08-07 15:09:54 | rob | 1 | 5146 | 25 | 0.093 | 55333.3 |
2033 | 2023-08-07 00:51:58 | rob | 2 | 14084 | 423 | 0.343 | 41061.2 |
2032 | 2023-08-05 11:28:24 | rob | 2 | 14084 | 423 | 0.763 | 18458.7 |
2031 | 2023-08-03 11:51:56 | rob | 2 | 14084 | 423 | 0.376 | 37457.4 |
2030 | 2023-08-02 05:04:15 | rob | 2 | 14084 | 423 | 0.390 | 36112.8 |
2029 | 2023-08-02 00:36:48 | rob | 2 | 14084 | 423 | 0.390 | 36112.8 |
2028 | 2023-07-31 02:36:32 | rob | 2 | 14084 | 423 | 0.343 | 41061.2 |
2027 | 2023-07-29 01:35:25 | rob | 2 | 14084 | 423 | 0.373 | 37758.7 |