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 “lixiviations” 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.

84 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
lixiviations225276(None) 
lixiviation2182951lixiviation_
lixiviating2251962lixiviati_ng
exuviations2195693_exuviations
illuviations1553053illuviations
initiations11410723_initiations
laciniations1445913laciniations
limitations1348183limi_tations
litigations1247333liti_gations
lixiviates2042303lixiviat__es
pixilations2045333pixi_lations
titivations1446263titiv_ations
activations1669264activ_ations
affiliations1844184affiliations
alleviations1554494alleviations
aviations12311554___aviations
bloviations1643754_bloviations
ciliations121111004__ciliations
citifications2048544citifications
civilisations1853644civilisations
civilizations2747274civilizations
derivations15611494deriv_ations
deviations14311164__deviations
digitizations2447084digitizations
divinations15128414divi_nations
elicitations1446804elici_tations
eliminations1447614elimi_nations
eluviations14115794_eluviations
estivations1449274estiv_ations
expiations1959664_ex_piations
exuviation20116344_exuviation_
filiations13119094__filiations
fimbriations1943344fimbriations
fixations1936354fix___ations
humiliations1784554humiliations
illuviation1453574illuviation_
imitations1259964_imi_tations
initiation10412104_initiation_
invitations1449054_invitations
laciniation1346634laciniation_
laicizations2347414laici_zations
laminations1339804lami_nations
latinizations22159014latinizations
lavations1238974l__av_ations
laxations1637624lax___ations
legislations1343754legislations
legitimations1654794legitimations
levigations1546214levi_gations
levitations1448294levi_tations
libations112510444l__i_bations
liberations1358944li_berations
librations12149064l__ibrations
ligations102111994l__i_gations
lignifications20135114lignifications
limitation1249154limi_tation_
lineations1039544l__ineations
lionizations2147124lionizations
liquations1945624l__iquations
liquidations2242794liquidations
literations11610584li_terations
lithifications22134794lithifications
litigation1148174liti_gation_
lixiviate1942674lixiviat___e
lixiviated2152164lixiviat__ed
luxations1637274lux___ations
maximizations3354884maximizations
minimizations26136554minimizations
mitigations1447624miti_gations
motivations1647094motiv_ations
nidifications1946944nidifications
obviations1545464__obviations
officiations2053504officiations
oxidations1845444_oxi_dations
pixilation1945914pixi_lation_
privations15310104_priv_ations
salivations1448734saliv_ations
sibilations13127934sibi_lations
titillations1244444titillations
titivation1347034titiv_ation_
vilifications2166744vilifications
vinifications2177694vinifications
visitations1447674visi_tations
vitiations1338744__vitiations
vivifications2486124vivifications

Search took 8 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 Filter1786911247900.390458182.1
2DLD Change Limit124790846.58018965.0
3Display Results84840.0631333.3
 (SQL Overall)178691847.03325407.5
 
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.