Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “titanates” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

56 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
titanates97609(None) 
titanate897171titanate_
titanites997411titanites
titanite898432titanite_
titivates1246432titivates
titrates82314662tit_rates
catenates11311813catenates
citrates102315093cit_rates
cyanates13238433_cyanates
detonates10310433detonates
divagates1444733divagates
emanates10311333_emanates
imamates1237663_imamates
intonates9410243intonates
iterates81317823_iterates
khanates1535733_khanates
litanies8310993litan_ies
literates91415653literates
litigates1048003litigates
mitigates1248253mitigates
nitrates82516223nit_rates
nizamates2043273nizamates
patinates113814693patinates
pitapats1244443pitapat_s
situates8310373sit_uates
stagnates1046733_stagnates
sultanates1045233sultanates
tannates81911953t_annates
tantalates10106703tantalates
tetanies8513553tetan_ies
tetanises979873tetanises
tetanizes1889843tetanizes
tetanuses984613tetanuses
thanages12107623t_hanages
thanatos1165123t_hanatos
thionates12106663thionates
tinplates1147773tinplates
tisanes7311853tisan__es
titaness836723titan_ess
titanesses1037253titanesses
titanias847103titan_ias
titanisms1147423titanisms
titaniums1144763titaniums
titanous846553titan_ous
titans63414913titan___s
titillates1045133titillates
titivate1146803titivate_
titivated1345443titivated
titrants838483titran_t_s
titrate72215573tit_rate_
titrated92611683tit_rated
tittivates1353323tittivates
tribunates1244173tribunates
triturates1046763triturates
vicarates1487623vicarates
vitiates112311433vit_iates

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911486410.423422437.4
2DLD Change Limit148641566.48322927.8
3Display Results56560.0331697.0
 (SQL Overall)178691566.93925751.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.