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

139 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
patinated12391141(None) 
paginated13309461paginated
patinaed11407831patina_ed
patinate103016311patinate_
patinates113814701patinates
carinated123414272carinated
catenated1238922catenated
laminated122610282laminated
marinated122513172marinated
paginate114012442paginate_
paginates123111372paginates
painted104214632pa_in_ted
patented1188892paten_ted
patinae95414402patina_e_
patined105114782patin__ed
patinized2178822patinized
patriated1238542patriated
satiated9311602sati_ated
vaginated14328152vaginated
activated1567883activated
agitated1038413_agitated
alienated1047743_alienated
animated111612373_animated
aviated11310273_avi_ated
badinaged14113193badinaged
bastinaded1443433bastinaded
capitated14159043capitated
captivated1844763captivated
carinate103320253carinate_
castigated1446323castigated
catenate10312833catenate_
catenates11311813catenates
catkinate1545823catkinate_
cavitated15177353cavitated
deaminated1448013deaminated
detonated1138213detonated
dominated1339883dominated
echinated1546483echinated
estimated12109443estimated
estivated13108323estivated
evaginated1575133evaginated
expatiated2044203expati_ated
extincted1943343extincted
fainted114211723fa_in_ted
fascinated1645873fascinated
festinated1447533festinated
geminated1338553geminated
intimated121010893intimated
intonated1048303intonated
iodinated1146943iodinated
labiated11109303labi_ated
laminate103014633laminate_
laminates112712903laminates
lanated8313203la__nated
lancinated1345573lancinated
lapidated1345673lapidated
lariated91212063lari_ated
latinized1988533latinized
litigated1146563litigated
machinated1845663machinated
marginated14187343marginated
marinaded13276533marinaded
marinate103017783marinate_
marinates112516393marinates
masticated1548233masticated
maturated1249173maturated
mitigated1347083mitigated
motivated1545963motivated
mutilated1239453mutilated
navigated1445483navigated
nominated1239283nominated
pained95622853pa_in__ed
painter93814563pa_in_ter
palatinate1245603palatinate_
palatinates1345013palatinates
palisaded1343563palisaded
palliated1238503palliated
palmated132511003pa_lmated
palpated13249763pa_lpated
palpitated1544233palpitated
panted95024823pa__n_ted
parented11912213paren_ted
passivated1644143passivated
patentee1099943paten_tee
patienter1145563patienter
patina86022193patina___
patinas96318533patina__s
patinating1339883patinating
patination12312573patination
patine85328123patin__e_
patines95225773patin__es
patinize19610773patinize_
patinizes20710343patinizes
patriate10311933patriate_
patriates11311373patriates
patted94724683pat___ted
pectinate1349553pectinate_
pennated11299543p_ennated
pepsinated1545233pepsinated
phonated1447893p_honated
pinnated11338553p_innated
pirated102515613p__irated
pixilated1944543pixilated
platinized2246913platinized
plicated13310643p_licated
pointed103813983p_oin_ted
pollinated1345823pollinated
printed104016373p_rin_ted
pronated11414053p_ronated
protonated1348593protonated
radiated102512593radi_ated
radicated13410123radicated
resinated10413283resinated
retinted94414363retin_ted
ruinated939523_ruinated
ruminated1258663ruminated
sainted84114243sa_in_ted
salivated1337473salivated
sanitated1068993sanitated
saponated1245733saponated
satiate7315403sati_ate_
satiates8314633sati_ates
saturated1039003saturated
stagnated1145143stagnated
stinted82914193_stin_ted
supinated1237883supinated
tainted83512423ta_in_ted
tincted1037273__tincted
tinted74419533__tin_ted
titivated1345443titivated
ultimated1247313ultimated
urinated9311613_urinated
urticated1247713urticated
vaccinated1855443vaccinated
vaginate123911083vaginate_
validated1446493validated
variated121211393vari_ated
vaticinated1753433vaticinated
vitiated12289223viti_ated

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.440406115.9
2DLD Change Limit1486411397.17020731.0
3Display Results1391390.0632206.3
 (SQL Overall)1786911397.67323288.3
 
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.