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

143 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
marinated12251317(None) 
carinated123414271carinated
marginated14187341marginated
marinaded13276531marinaded
marinate103017781marinate_
marinates112516391marinates
carinate103320252carinate_
laminated122610282laminated
lariated91212062lari_ated
machinated1845662machinated
marginate12179602marginate_
marginates13168752marginates
marinade11259382marinade_
marinades12268982marinades
muriated1139792muri_ated
muricated1448242muricated
paginated13309462paginated
patinated123911412patinated
urinated9311612_urinated
vaginated14328152vaginated
variated121211392vari_ated
agitated1038413_agitated
alienated1047743_alienated
animated111612373_animated
arcuated1138803_arcuated
arointed939003_aroin_ted
aviated11310263_avi_ated
badinaged14113193badinaged
capitated14159043capitated
carbonated1547243carbonated
carinae94318593carina_e_
catenated1238923catenated
cavitated15177353cavitated
coronated123313323coronated
crenated113013913_crenated
deaminated1448013deaminated
dominated1339883dominated
echinated1546483echinated
emaciated1446933emaci_ated
emanated1139163ema__nated
emarginate1385453emarginate_
evaginated1575133evaginated
fabricated1845403fabricated
fainted114211723fa_in_ted
fascinated1645873fascinated
geminated1338553geminated
germinated1446563germinated
herniated1346013herniated
imbricated1744563imbricated
imprinted1445753imprin_ted
iodinated1146943iodinated
irrigated1176313irrigated
irritated1076133irritated
labiated11109303labi_ated
laminate103014633laminate_
laminates112712903laminates
lanated8313203la__nated
lancinated1345573lancinated
lapidated1345673lapidated
loricated1247903loricated
macerated142010533macerated
machinate1647953machinate_
machinates1747323machinates
maculated142411503maculated
magnate10512703ma_gnate_
magnates11511613ma_gnates
managed113212603ma__naged
manatee9317663ma__natee
mandated12310293ma_ndated
maranatha1452953maranatha
margented1346813margented
margined1237753margin__ed
marina84623413marina___
marinara1046493marina_ra
marinaras1145573marinaras
marinas93519403marina__s
marinating13410273marinating
marination12312813marination
marine84230413marin__e_
mariner93316003marin__er
marines93928033marin__es
marketed1537323mar_keted
marshaled1544643marshaled
marted94425213mar___ted
masticated1548233masticated
maturated1249173maturated
mediated123011873medi_ated
medicated15410073medicated
meditated1348083meditated
merited10313853meri__ted
metricated1547303metricated
militated1248803militated
minted94220583m__in_ted
minuted10329503m__inuted
mitigated1347083mitigated
mordanted1344413mordanted
motivated1545963motivated
muriate9313363muri_ate_
muriates10312083muri_ates
muricate12311113muricate_
mutilated1239453mutilated
myelinated1643353myelinated
narrated9310333nar_rated
navigated1445483navigated
nominated1239283nominated
paginate114012443paginate_
paginates123111373paginates
painted104214633pa_in_ted
parented11912213paren_ted
patinaed11407833patina_ed
patinate103016313patinate_
patinates113814703patinates
patriated1238543patri_ated
printed104016373_prin_ted
pronated11414053_pronated
radiated102512593radi_ated
radicated13410123radicated
resinated10413283resinated
ruinated939523_ruinated
ruminated1258663ruminated
sainted84114243sa_in_ted
salivated1337473salivated
sanitated1068993sanitated
saponated1245733saponated
satiated9311603sati_ated
seriated92717023seri_ated
sprinted113411163sprin_ted
striated93414153stri_ated
supinated1237883supinated
tainted83512423ta_in_ted
tartrated1096653tartrated
terminated1348163terminated
turbinated1344413turbinated
urinate7315363_urinate_
urinates8314133_urinates
vaccinated1855443vaccinated
vaginate123911083vaginate_
validated1446493validated
variate101316433vari_ate_
variates111214983vari_ates
variegated1543123variegated
variolated1445403variolated
warranted1345013warranted

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411437.73619214.2
3Display Results1431430.0632269.8
 (SQL Overall)1786911438.23521699.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.