History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sirs"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
930 | 2024-04-27 01:26:22 | sirs | 2 | 29872 | 526 | 1.516 | 19704.5 |
929 | 2024-04-25 17:55:43 | sirs | 1 | 13983 | 18 | 0.250 | 55932.0 |
928 | 2024-04-13 07:44:50 | sirs | 2 | 29872 | 526 | 0.876 | 34100.5 |
927 | 2024-04-13 07:35:13 | sirs | 1 | 13983 | 18 | 0.250 | 55932.0 |
926 | 2024-04-10 11:12:32 | sirs | 2 | 29872 | 526 | 0.780 | 38297.4 |
925 | 2024-04-10 11:05:14 | sirs | 2 | 29872 | 526 | 1.516 | 19704.5 |
924 | 2024-04-10 11:05:12 | sirs | 2 | 29872 | 526 | 2.516 | 11872.8 |
923 | 2024-04-10 10:50:16 | sirs | 2 | 29872 | 526 | 2.703 | 11051.4 |
922 | 2024-04-10 10:50:16 | sirs | 1 | 13983 | 18 | 0.280 | 49939.3 |
921 | 2024-04-10 10:36:46 | sirs | 1 | 13983 | 18 | 0.623 | 22444.6 |
920 | 2024-04-04 23:34:57 | sirs | 2 | 29872 | 526 | 1.046 | 28558.3 |
919 | 2024-04-04 23:34:54 | sirs | 1 | 13983 | 18 | 0.390 | 35853.8 |
918 | 2024-04-04 23:34:39 | sirs | 2 | 29872 | 526 | 2.140 | 13958.9 |
917 | 2024-04-04 23:34:33 | sirs | 1 | 13983 | 18 | 0.300 | 46610.0 |
916 | 2024-04-02 20:21:08 | sirs | 1 | 13983 | 18 | 0.236 | 59250.0 |
915 | 2024-03-30 23:31:53 | sirs | 2 | 29872 | 526 | 1.296 | 23049.4 |
914 | 2024-03-30 23:20:45 | sirs | 1 | 13983 | 18 | 0.216 | 64736.1 |
913 | 2024-03-30 14:54:19 | sirs | 1 | 13983 | 18 | 0.516 | 27098.8 |
912 | 2024-03-26 23:09:51 | sirs | 1 | 13983 | 18 | 0.220 | 63559.1 |
911 | 2024-03-05 20:27:44 | sirs | 1 | 13983 | 18 | 0.860 | 16259.3 |
910 | 2024-03-02 18:18:08 | sirs | 2 | 29872 | 526 | 1.030 | 29001.9 |
909 | 2024-03-02 17:22:40 | sirs | 1 | 13983 | 18 | 0.220 | 63559.1 |
908 | 2024-02-29 22:07:16 | sirs | 1 | 13983 | 18 | 0.390 | 35853.8 |
907 | 2024-02-25 20:57:03 | sirs | 2 | 29872 | 526 | 0.890 | 33564.0 |
906 | 2024-02-25 20:56:21 | sirs | 1 | 13983 | 18 | 0.280 | 49939.3 |
905 | 2024-02-06 01:06:25 | sirs | 1 | 13983 | 18 | 0.266 | 52567.7 |
904 | 2024-02-03 03:01:26 | sirs | 1 | 13983 | 18 | 0.263 | 53167.3 |
903 | 2024-02-02 01:44:39 | sirs | 1 | 13983 | 18 | 0.250 | 55932.0 |
902 | 2024-01-28 13:21:03 | sirs | 1 | 13983 | 18 | 0.220 | 63559.1 |
901 | 2024-01-26 18:15:21 | sirs | 1 | 13983 | 18 | 0.263 | 53167.3 |
900 | 2024-01-24 06:33:43 | sirs | 1 | 13983 | 18 | 0.220 | 63559.1 |
899 | 2023-12-30 21:39:23 | sirs | 1 | 13983 | 18 | 0.250 | 55932.0 |
898 | 2023-12-26 14:20:20 | sirs | 1 | 13983 | 18 | 0.266 | 52567.7 |
897 | 2023-12-14 08:19:28 | sirs | 1 | 13983 | 18 | 0.233 | 60012.9 |
896 | 2023-12-12 18:55:47 | sirs | 2 | 29872 | 526 | 0.766 | 38997.4 |
895 | 2023-12-11 17:50:09 | sirs | 1 | 13983 | 18 | 0.233 | 60012.9 |
894 | 2023-12-10 10:39:21 | sirs | 1 | 13983 | 18 | 0.220 | 63559.1 |
893 | 2023-12-09 05:20:27 | sirs | 2 | 29872 | 526 | 0.766 | 38997.4 |
892 | 2023-12-06 06:59:44 | sirs | 1 | 13983 | 18 | 0.233 | 60012.9 |
891 | 2023-12-05 08:55:17 | sirs | 1 | 13983 | 18 | 0.250 | 55932.0 |
890 | 2023-12-03 17:09:43 | sirs | 2 | 29872 | 526 | 0.873 | 34217.6 |
889 | 2023-12-03 15:37:16 | sirs | 1 | 13983 | 18 | 0.220 | 63559.1 |
888 | 2023-11-27 07:48:27 | sirs | 1 | 13983 | 18 | 0.220 | 63559.1 |
887 | 2023-11-26 00:48:59 | sirs | 1 | 13983 | 18 | 0.250 | 55932.0 |
886 | 2023-11-24 00:18:03 | sirs | 1 | 13983 | 18 | 0.546 | 25609.9 |
885 | 2023-11-23 00:17:03 | sirs | 1 | 13983 | 18 | 0.216 | 64736.1 |
884 | 2023-11-20 01:24:39 | sirs | 2 | 29872 | 526 | 0.843 | 35435.3 |
883 | 2023-11-10 19:38:34 | sirs | 1 | 13983 | 18 | 0.250 | 55932.0 |
882 | 2023-11-08 23:55:38 | sirs | 1 | 13983 | 18 | 0.220 | 63559.1 |
881 | 2023-11-02 10:10:42 | sirs | 2 | 29872 | 526 | 0.766 | 38997.4 |
880 | 2023-10-28 10:14:23 | sirs | 1 | 13983 | 18 | 0.266 | 52567.7 |
879 | 2023-10-24 17:01:13 | sirs | 1 | 13983 | 18 | 0.216 | 64736.1 |
878 | 2023-10-23 23:24:57 | sirs | 1 | 13983 | 18 | 0.236 | 59250.0 |
877 | 2023-10-22 21:56:32 | sirs | 1 | 13983 | 18 | 0.216 | 64736.1 |
876 | 2023-10-21 03:40:33 | sirs | 2 | 29872 | 526 | 0.766 | 38997.4 |
875 | 2023-10-19 15:19:57 | sirs | 1 | 13983 | 18 | 0.250 | 55932.0 |
874 | 2023-10-18 12:16:10 | sirs | 1 | 13983 | 18 | 0.233 | 60012.9 |
873 | 2023-10-12 21:37:10 | sirs | 2 | 29872 | 526 | 1.923 | 15534.1 |
872 | 2023-10-10 11:56:56 | sirs | 1 | 13983 | 18 | 0.220 | 63559.1 |
871 | 2023-10-09 03:28:52 | sirs | 2 | 29872 | 526 | 0.860 | 34734.9 |
870 | 2023-10-08 01:31:53 | sirs | 1 | 13983 | 18 | 0.483 | 28950.3 |
869 | 2023-10-03 15:20:32 | sirs | 1 | 13983 | 18 | 0.220 | 63559.1 |
868 | 2023-09-27 04:18:26 | sirs | 2 | 29872 | 526 | 0.843 | 35435.3 |
867 | 2023-09-24 08:50:31 | sirs | 1 | 13983 | 18 | 0.513 | 27257.3 |
866 | 2023-09-22 22:51:40 | sirs | 1 | 13983 | 18 | 0.216 | 64736.1 |
865 | 2023-09-20 01:39:41 | sirs | 1 | 13983 | 18 | 0.220 | 63559.1 |
864 | 2023-09-11 17:43:03 | sirs | 2 | 29872 | 526 | 0.766 | 38997.4 |
863 | 2023-09-09 22:09:51 | sirs | 1 | 13983 | 18 | 0.236 | 59250.0 |
862 | 2023-09-08 02:07:21 | sirs | 1 | 13983 | 18 | 0.233 | 60012.9 |
861 | 2023-08-24 17:34:05 | sirs | 1 | 13983 | 18 | 0.250 | 55932.0 |
860 | 2023-08-19 19:26:46 | sirs | 1 | 13983 | 18 | 0.233 | 60012.9 |
859 | 2023-08-18 10:50:15 | sirs | 1 | 13983 | 18 | 0.236 | 59250.0 |
858 | 2023-07-11 22:05:12 | sirs | 1 | 13983 | 18 | 0.233 | 60012.9 |
857 | 2023-05-31 09:40:05 | sirs | 2 | 29872 | 526 | 0.843 | 35435.3 |
856 | 2023-05-21 03:33:50 | sirs | 1 | 13983 | 18 | 0.406 | 34440.9 |
855 | 2023-05-14 18:52:23 | sirs | 1 | 13983 | 18 | 0.250 | 55932.0 |
854 | 2023-03-31 14:51:15 | sirs | 1 | 13983 | 18 | 0.250 | 55932.0 |
853 | 2023-03-16 21:18:38 | sirs | 1 | 13983 | 18 | 0.233 | 60012.9 |
852 | 2023-03-09 04:56:08 | sirs | 2 | 29872 | 526 | 0.763 | 39150.7 |
851 | 2023-02-04 17:53:02 | sirs | 1 | 13983 | 18 | 0.236 | 59250.0 |
850 | 2023-01-04 21:02:57 | sirs | 1 | 13983 | 18 | 0.216 | 64736.1 |
849 | 2022-12-14 11:42:44 | sirs | 2 | 29872 | 526 | 0.750 | 39829.3 |
848 | 2022-10-25 12:23:02 | sirs | 1 | 13983 | 18 | 0.233 | 60012.9 |
847 | 2022-09-28 17:55:55 | sirs | 1 | 13983 | 18 | 0.220 | 63559.1 |
846 | 2022-09-11 18:15:37 | sirs | 1 | 13983 | 18 | 0.220 | 63559.1 |
845 | 2022-09-10 14:08:39 | sirs | 1 | 13983 | 18 | 0.220 | 63559.1 |
844 | 2022-09-03 11:04:42 | sirs | 1 | 13983 | 18 | 0.250 | 55932.0 |
843 | 2022-09-03 09:38:35 | sirs | 1 | 13983 | 18 | 0.216 | 64736.1 |
842 | 2022-08-26 06:09:17 | sirs | 1 | 13983 | 18 | 0.216 | 64736.1 |
841 | 2022-08-25 21:08:30 | sirs | 1 | 13983 | 18 | 0.220 | 63559.1 |
840 | 2022-08-18 07:02:37 | sirs | 1 | 13983 | 18 | 0.233 | 60012.9 |
839 | 2022-08-17 11:36:50 | sirs | 1 | 13983 | 18 | 0.470 | 29751.1 |
838 | 2022-08-15 08:29:38 | sirs | 1 | 13983 | 18 | 0.220 | 63559.1 |
837 | 2022-08-10 12:23:54 | sirs | 1 | 13983 | 18 | 0.233 | 60012.9 |
836 | 2022-08-09 05:35:34 | sirs | 1 | 13983 | 18 | 0.220 | 63559.1 |
835 | 2022-08-06 15:07:00 | sirs | 1 | 13983 | 18 | 0.250 | 55932.0 |
834 | 2022-08-02 12:42:28 | sirs | 2 | 29872 | 526 | 0.783 | 38150.7 |
833 | 2022-07-29 20:16:59 | sirs | 1 | 13983 | 18 | 0.220 | 63559.1 |
832 | 2022-07-29 04:44:27 | sirs | 1 | 13983 | 18 | 0.216 | 64736.1 |
831 | 2022-07-28 13:12:23 | sirs | 1 | 13983 | 18 | 0.216 | 64736.1 |