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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

129 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
planation1131012(None) 
placation1339771placation
planations1238721planations
plantation1248531plantation
clavation1447002clavation
emanation11910782emanation
explanation2045262explanation
lavation1139972_lavation
laxation1538422_laxation
lunation8311922_lunation
palmation13310222palmation
palpation1339072palpation
phonation1439392phonation
pinnation1138012pinnation
placations1438582placations
planarian1147112planarian
plankton1443852plankt_on
plantain1047902plantai_n
plantations1347472plantations
plication13311682plication
pronation11415702pronation
adnation9310783_adnation
agnation9311723_agnation
alation72920553__alation
alienation1048793alienation
aplanatic1344903aplanati_c
carnation11312943carnation
clavations1546183clavations
cognation12310753cognation
conation101420883_conation
connation11314263connation
crenation11412923crenation
damnation1238403damnation
darnation1039823darnation
dealation10313003dealation
dilatation1147393dilatation
donation91513783_donation
elation73620453el__ation
elevation1239233elevation
elongation1145353elongation
emanations1289593emanations
enation73419233__enation
explanations2144623explanations
explantation2153973explantation
floatation1344683floatation
flotation1267813flotation
glaciation1346583glaciation
gradation11107713gradation
halation11313853_halation
illation8311943il_lation
implantation1653353implantation
inanition947293inanition
lactation11310813_lactation
lallation939493_lallation
lamination12311223_lamination
laudation1088133_laudation
lavations1238973_lavations
laxations1637623_laxations
legation92412933_legation
lenition8310083_lenition
libation102411363_libation
ligation92313093_ligation
lineation9310763_lineation
lobation102110553_lobation
location102113913_location
lunations9310723_lunations
luxation1538233_luxation
natation81513933_natation
nation64322803___nation
nunnation9126563nunnation
ozonation1845673ozonation
paction112713963p_a_ction
pagination1348993pagination
palliation1248503palliation
palmations1438733palmations
palpations1437653palpations
parathion1446173p_arathion
patination12312573patination
peltation11312963peltation
phonathon1743443phonathon
phonations1538313phonations
pinnations1236883pinnations
placating1438513placating
placative1646223placative
placentation1694153placentation
planaria1047353planari_a
planarians1245193planarians
planarias1147403planarias
planarity1445323planarity
planate9314573planat__e
planetoid1245503planetoid
planktons1543673plankt_ons
plantains1147493plantains
planting113515383plan_ting
plastron1046913pla_stron
platoon938953pl__atoon
plications14310493plications
pollination1348013pollination
potation101716783p_otation
predation12313463predation
prenotion1149173prenotion
privation14311173privation
probation13412183probation
profanation16186103profanation
pronations12314033pronations
proration11415983proration
pulsation1137143pulsation
punition1038373p_unition
pupation1269503p_upation
purgation1247393purgation
relaxation1746453relaxation
replantation1445523replantation
ruination9311273ruination
saltation9312003saltation
salvation1239293salvation
sanction1049533_sanction
scalation11311073scalation
spallation1247023spallation
stagnation1145543stagnation
tarnation9310093tarnation
taxation1537993_taxation
ululation938093ululation
urination9312173urination
vacation131911893_vacation
vallation1239753vallation
valuation1249973valuation
venation11513503_venation
vernation12311083vernation
zonation171410723_zonation

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 Filter1786911486410.403443402.0
2DLD Change Limit1486411297.16020759.9
3Display Results1291290.0602150.0
 (SQL Overall)1786911297.62323441.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.