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 “lixiviation” with Change Limit: [1] [2] [3] [4] [5]

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

86 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
lixiviation218295(None) 
lixiviations2252761lixiviations
lixiviating2251962lixiviating
exuviation20116343_exuviation
illuviation1453573illuviation
initiation10412103_initiation
laciniation1346633laciniation
limitation1249153limi_tation
litigation1148173liti_gation
lixiviate1942673lixiviat__e
lixiviated2152163lixiviat_ed
lixiviates2042303lixiviat_es
pixilation1945913pixi_lation
titivation1347033titiv_ation
activation15610134activ_ation
affiliation1744854affiliation
alleviation1454654alleviation
aviation11312744___aviation
bloviation1544004_bloviation
ciliation111112494__ciliation
citification1949154citification
civilisation1753944civilisation
civilization2647614civilization
derivation14712784deriv_ation
deviation13312394__deviation
digitization2347684digitization
divination14139234divi_nation
elicitation1347534elici_tation
elimination1348534elimi_nation
eluviation1376614_eluviation
estivation1349814estiv_ation
expiation18710424_ex_piation
exuviations2195694_exuviations
filiation121110244__filiation
fimbriation1843554fimbriation
fixation1837074fix___ation
humiliation1675194humiliation
illuviations1553054illuviations
imitation11510854_imi_tation
initiations11410724_initiations
invitation13410024_invitation
laciniations1445914laciniations
laicization2247904laici_zation
lamination12311224lami_nation
latinization21139524latinization
lavation1139974l__av_ation
laxation1538424lax___ation
legislation1244284legislation
legitimation1555164legitimation
levigation1447024levi_gation
levitation1349444levi_tation
libation102411364l__i_bation
liberation1269994li_beration
libration111510164l__ibration
ligation92313094l__i_gation
lignification19125704lignification
limitations1348184limi_tations
lineation9310764l__ineation
lionization2047884lionization
liquation1846554l__iquation
liquidation2143184liquidation
literation10511414li_teration
lithification21105164lithification
litigations1247334liti_gations
lixivia1743054lixivia____
lixivial1842944lixivia___l
luxation1538234lux___ation
maximization3255214maximization
minimization25127194minimization
mitigation1348644miti_gation
motivation1548084motiv_ation
nidification1847454nidification
obviation1446094__obviation
officiation1943834officiation
oxidation1746324_oxi_dation
pixilations2045334pixi_lations
privation14311174_priv_ation
salivation1349814saliv_ation
sibilation12128774sibi_lation
titillation1145044titillation
titivations1446264titiv_ations
vilification2077124vilification
vinification2068234vinification
visitation1348594visi_tation
vitiation1239564__vitiation
vivification2366344vivification

Search took 9 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 Filter1786911488190.423422437.4
2DLD Change Limit148819867.73319244.7
3Display Results86860.0461869.6
 (SQL Overall)178691868.20221786.3
 
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.