History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"ryokans"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1122 | 2024-04-29 10:39:29 | ryokans | 2 | 107671 | 5 | 6.360 | 16929.4 |
1121 | 2024-04-29 10:38:04 | ryokans | 3 | 134027 | 97 | 7.780 | 17227.1 |
1120 | 2024-04-28 20:35:44 | ryokans | 3 | 134027 | 97 | 7.046 | 19021.7 |
1119 | 2024-04-28 20:35:47 | ryokans | 2 | 107671 | 5 | 3.500 | 30763.1 |
1118 | 2024-04-28 20:35:39 | ryokans | 1 | 69583 | 2 | 1.216 | 57222.9 |
1117 | 2024-04-27 08:46:40 | ryokans | 1 | 69583 | 2 | 1.216 | 57222.9 |
1116 | 2024-04-25 18:55:16 | ryokans | 4 | 151207 | 1460 | 25.126 | 6017.9 |
1115 | 2024-04-23 14:56:18 | ryokans | 4 | 151207 | 1460 | 16.830 | 8984.4 |
1114 | 2024-04-20 23:14:53 | ryokans | 4 | 151207 | 1460 | 30.223 | 5003.0 |
1113 | 2024-04-20 22:16:29 | ryokans | 4 | 151207 | 1460 | 53.440 | 2829.5 |
1112 | 2024-04-19 03:31:53 | ryokans | 4 | 151207 | 1460 | 17.703 | 8541.3 |
1111 | 2024-04-19 02:21:27 | ryokans | 4 | 151207 | 1460 | 13.190 | 11463.8 |
1110 | 2024-04-06 18:29:02 | ryokans | 4 | 151207 | 1460 | 12.076 | 12521.3 |
1109 | 2024-04-03 15:55:34 | ryokans | 2 | 107671 | 5 | 11.046 | 9747.5 |
1108 | 2024-04-03 15:55:10 | ryokans | 1 | 69583 | 2 | 2.643 | 26327.3 |
1107 | 2024-03-29 11:32:17 | ryokans | 2 | 107671 | 5 | 11.313 | 9517.5 |
1106 | 2024-03-29 11:32:16 | ryokans | 3 | 134027 | 97 | 10.360 | 12937.0 |
1105 | 2024-03-29 11:32:12 | ryokans | 1 | 69583 | 2 | 1.686 | 41271.1 |
1104 | 2024-03-29 02:48:55 | ryokans | 1 | 69583 | 2 | 1.280 | 54361.7 |
1103 | 2024-03-25 14:46:34 | ryokans | 2 | 107671 | 5 | 5.656 | 19036.6 |
1102 | 2024-03-25 14:45:49 | ryokans | 3 | 134027 | 97 | 5.623 | 23835.5 |
1101 | 2024-03-25 14:39:14 | ryokans | 4 | 151207 | 1460 | 11.143 | 13569.7 |
1100 | 2024-03-22 11:53:05 | ryokans | 4 | 151207 | 1460 | 19.800 | 7636.7 |
1099 | 2024-03-22 05:07:57 | ryokans | 4 | 151207 | 1460 | 21.936 | 6893.1 |
1098 | 2024-03-20 19:09:47 | ryokans | 4 | 151207 | 1460 | 16.550 | 9136.4 |
1097 | 2024-03-20 07:37:01 | ryokans | 4 | 151207 | 1460 | 16.343 | 9252.1 |
1096 | 2024-03-19 23:27:10 | ryokans | 4 | 151207 | 1460 | 12.000 | 12600.6 |
1095 | 2024-03-19 23:27:12 | ryokans | 2 | 107671 | 5 | 3.750 | 28712.3 |
1094 | 2024-03-19 23:27:00 | ryokans | 2 | 107671 | 5 | 3.296 | 32667.2 |
1093 | 2024-03-19 23:26:43 | ryokans | 3 | 134027 | 97 | 8.190 | 16364.7 |
1092 | 2024-03-19 23:26:20 | ryokans | 3 | 134027 | 97 | 7.000 | 19146.7 |
1091 | 2024-03-18 09:13:36 | ryokans | 3 | 134027 | 97 | 10.500 | 12764.5 |
1090 | 2024-03-18 09:13:39 | ryokans | 2 | 107671 | 5 | 3.436 | 31336.1 |
1089 | 2024-03-18 09:12:49 | ryokans | 1 | 69583 | 2 | 1.420 | 49002.1 |
1088 | 2024-02-18 20:03:20 | ryokans | 2 | 107671 | 5 | 2.920 | 36873.6 |
1087 | 2024-02-18 17:24:10 | ryokans | 4 | 151207 | 1460 | 11.953 | 12650.1 |
1086 | 2024-02-18 14:47:45 | ryokans | 3 | 134027 | 97 | 8.673 | 15453.4 |
1085 | 2024-02-18 10:16:40 | ryokans | 4 | 151207 | 1460 | 28.033 | 5393.9 |
1084 | 2024-02-16 10:53:29 | ryokans | 4 | 151207 | 1460 | 26.190 | 5773.5 |
1083 | 2024-02-16 10:53:43 | ryokans | 2 | 107671 | 5 | 11.203 | 9610.9 |
1082 | 2024-02-16 10:53:39 | ryokans | 3 | 134027 | 97 | 7.970 | 16816.4 |
1081 | 2024-02-16 08:23:31 | ryokans | 1 | 69583 | 2 | 1.220 | 57035.2 |
1080 | 2024-02-14 23:13:09 | ryokans | 1 | 69583 | 2 | 1.686 | 41271.1 |
1079 | 2024-01-31 22:25:08 | ryokans | 3 | 134027 | 97 | 14.280 | 9385.6 |
1078 | 2024-01-29 05:43:05 | ryokans | 3 | 134027 | 97 | 6.500 | 20619.5 |
1077 | 2024-01-26 13:26:59 | ryokans | 3 | 134027 | 97 | 13.313 | 10067.4 |
1076 | 2024-01-19 02:00:08 | ryokans | 2 | 107671 | 5 | 2.780 | 38730.6 |
1075 | 2024-01-17 21:08:01 | ryokans | 3 | 134027 | 97 | 6.266 | 21389.6 |
1074 | 2024-01-16 03:38:04 | ryokans | 1 | 69583 | 2 | 1.063 | 65459.1 |
1073 | 2024-01-06 00:54:32 | ryokans | 1 | 69583 | 2 | 1.093 | 63662.4 |
1072 | 2023-12-30 02:39:16 | ryokans | 1 | 69583 | 2 | 1.220 | 57035.2 |
1071 | 2023-12-13 09:39:05 | ryokans | 3 | 134027 | 97 | 6.093 | 21996.9 |
1070 | 2023-12-04 11:19:45 | ryokans | 4 | 151207 | 1460 | 9.626 | 15708.2 |
1069 | 2023-11-24 23:05:52 | ryokans | 1 | 69583 | 2 | 1.063 | 65459.1 |
1068 | 2023-11-12 02:45:56 | ryokans | 1 | 69583 | 2 | 1.093 | 63662.4 |
1067 | 2023-11-11 06:10:38 | ryokans | 1 | 69583 | 2 | 1.063 | 65459.1 |
1066 | 2023-10-29 05:20:58 | ryokans | 2 | 107671 | 5 | 2.796 | 38508.9 |
1065 | 2023-10-28 13:08:26 | ryokans | 3 | 134027 | 97 | 7.670 | 17474.2 |
1064 | 2023-09-30 03:49:09 | ryokans | 4 | 151207 | 1460 | 12.486 | 12110.1 |
1063 | 2023-09-20 07:25:23 | ryokans | 4 | 151207 | 1460 | 11.983 | 12618.5 |
1062 | 2023-09-14 21:26:38 | ryokans | 1 | 69583 | 2 | 1.063 | 65459.1 |
1061 | 2023-09-10 14:44:44 | ryokans | 4 | 151207 | 1460 | 15.376 | 9834.0 |
1060 | 2023-09-07 08:08:47 | ryokans | 4 | 151207 | 1460 | 15.703 | 9629.2 |
1059 | 2023-09-06 20:22:21 | ryokans | 4 | 151207 | 1460 | 11.000 | 13746.1 |
1058 | 2023-09-02 00:36:40 | ryokans | 4 | 151207 | 1460 | 12.153 | 12441.9 |
1057 | 2023-09-01 13:52:09 | ryokans | 4 | 151207 | 1460 | 9.576 | 15790.2 |
1056 | 2023-08-30 04:25:16 | ryokans | 1 | 69583 | 2 | 1.156 | 60192.9 |
1055 | 2023-08-29 18:28:42 | ryokans | 4 | 151207 | 1460 | 10.343 | 14619.3 |
1054 | 2023-08-26 23:13:10 | ryokans | 4 | 151207 | 1460 | 9.516 | 15889.8 |
1053 | 2023-08-20 16:38:15 | ryokans | 4 | 151207 | 1460 | 10.470 | 14441.9 |
1052 | 2023-08-06 08:06:30 | ryokans | 2 | 107671 | 5 | 2.750 | 39153.1 |
1051 | 2023-08-05 04:56:00 | ryokans | 3 | 134027 | 97 | 5.503 | 24355.3 |
1050 | 2023-08-01 07:25:41 | ryokans | 4 | 151207 | 1460 | 10.703 | 14127.5 |
1049 | 2023-07-30 18:39:36 | ryokans | 1 | 69583 | 2 | 1.063 | 65459.1 |
1048 | 2023-07-30 15:12:49 | ryokans | 4 | 151207 | 1460 | 11.140 | 13573.3 |
1047 | 2023-07-28 04:03:51 | ryokans | 4 | 151207 | 1460 | 11.830 | 12781.7 |
1046 | 2023-07-26 00:54:10 | ryokans | 4 | 151207 | 1460 | 10.610 | 14251.4 |
1045 | 2023-07-24 00:19:51 | ryokans | 4 | 151207 | 1460 | 12.783 | 11828.8 |
1044 | 2023-07-21 14:26:08 | ryokans | 4 | 151207 | 1460 | 11.533 | 13110.8 |
1043 | 2023-07-19 23:05:40 | ryokans | 4 | 151207 | 1460 | 12.126 | 12469.7 |
1042 | 2023-07-11 21:30:11 | ryokans | 4 | 151207 | 1460 | 11.390 | 13275.4 |
1041 | 2023-07-10 07:28:07 | ryokans | 4 | 151207 | 1460 | 10.986 | 13763.6 |
1040 | 2023-06-17 20:26:18 | ryokans | 4 | 151207 | 1460 | 9.610 | 15734.3 |
1039 | 2023-05-31 08:09:07 | ryokans | 1 | 69583 | 2 | 1.033 | 67360.1 |
1038 | 2023-05-18 17:59:13 | ryokans | 4 | 151207 | 1460 | 9.543 | 15844.8 |
1037 | 2023-05-18 01:45:37 | ryokans | 4 | 151207 | 1460 | 9.703 | 15583.5 |
1036 | 2023-05-13 13:08:25 | ryokans | 4 | 151207 | 1460 | 10.686 | 14150.0 |
1035 | 2023-05-02 21:20:30 | ryokans | 3 | 134027 | 97 | 5.500 | 24368.5 |
1034 | 2023-04-18 03:22:32 | ryokans | 2 | 107671 | 5 | 2.703 | 39833.9 |
1033 | 2023-04-12 23:02:34 | ryokans | 3 | 134027 | 97 | 6.046 | 22167.9 |
1032 | 2023-04-08 05:36:48 | ryokans | 3 | 134027 | 97 | 6.296 | 21287.6 |
1031 | 2023-03-24 23:13:41 | ryokans | 1 | 69583 | 2 | 1.063 | 65459.1 |
1030 | 2023-03-23 19:57:10 | ryokans | 4 | 151207 | 1460 | 20.656 | 7320.2 |
1029 | 2023-03-17 11:22:56 | ryokans | 1 | 69583 | 2 | 1.140 | 61037.7 |
1028 | 2023-03-05 19:14:51 | ryokans | 3 | 134027 | 97 | 6.330 | 21173.3 |
1027 | 2023-02-22 09:39:49 | ryokans | 4 | 151207 | 1460 | 9.466 | 15973.7 |
1026 | 2023-01-24 15:24:26 | ryokans | 2 | 107671 | 5 | 2.690 | 40026.4 |
1025 | 2023-01-19 03:23:49 | ryokans | 3 | 134027 | 97 | 6.233 | 21502.8 |
1024 | 2023-01-10 15:09:33 | ryokans | 1 | 69583 | 2 | 1.140 | 61037.7 |
1023 | 2022-12-13 13:52:31 | ryokans | 4 | 151207 | 1460 | 10.360 | 14595.3 |