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

173 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
patinates11381469(None) 
paginates123111361paginates
patinate103016311patinate_
patinated123911411patinated
catenates11311812catenates
laminates112712902laminates
marinates112516382marinates
paginate114012442paginate_
paginated13309462paginated
palatinates1345002palatinates
patinae95414402patina_e_
patinaed11407832patina_ed
patinas96318522patina__s
patines95225762patin__es
patinizes20710332patinizes
patriates11311362patriates
satiates8314632sati_ates
activates1449683activates
agitates9310883_agitates
agnates82813193_a_gnates
alginates10310123alginates
alienates9310683_alienates
amirates101114793_amirates
animates101316423_animates
annates72415423_a_nnates
apatites10311293apati__tes
atlantes838553_atlantes
aviates10313063_avi_ates
badinages13124873badinages
bastinades1344603bastinades
batistes1039713bati_stes
cabinmates1643893cabinmates
califates14310113califates
captivates1745493captivates
carinate103320253carinate_
carinated123414273carinated
caseinates1247443caseinates
castigates1347553castigates
catenate10312833catenate_
catenated1238913catenated
catkinate1545823catkinate_
cavitates14168963cavitates
deaminates1349383deaminates
detonates10310433detonates
dominates12311743dominates
estimates11911363estimates
estivates12109753estivates
evaginates1475993evaginates
expatiates1944893expati_ates
fascinates1547153fascinates
festinates1348943festinates
geminates12310043geminates
intimates111013313intimates
intonates9410243intonates
iodinates1048203iodinates
kainites1238793ka_inites
kalifates1646133kalifates
labiates101011513labi_ates
laminate103014633laminate_
laminated122610283laminated
lancinates1247153lancinates
lapidates1247143lapidates
latinas74416463latina__s
latinities10410163latinities
latinizes18610153latinizes
litigates1048003litigates
machinates1747323machinates
magnates11511613ma_gnates
marginates13168743marginates
marinades12268973marinades
marinate103017783marinate_
marinated122513173marinated
masticates1449843masticates
matinees102110423matin_ees
maturates11311763maturates
mitigates1248253mitigates
motivates1447073motivates
mutilates11310953mutilates
navigates1345873navigates
nominates11311053nominates
ordinates1049003ordinates
ostinatos946173ostinatos
painches1588913pa_inches
painted104214633pa_in_ted
painter93814563pa_in_ter
painters103013023pa_in_ters
paints85921833pa_in_t_s
palates93624943pa__lates
palatinate1245603palatinate_
palinodes1245883palinodes
palisades1245613palisades
palliates11311033palliates
palmitates1445453palmitates
palpates122613063pa_lpates
palpitates1445303palpitates
parietes10714543pari_etes
passivates1544963passivates
pastinas103712153pastina__s
pastorates12410153pastorates
patencies1349173patencies
patented1188893paten_ted
patentee1099943paten_tee
patentees1196543patentees
patents94815203paten_t_s
patiences1367433patiences
patienter1145553patienter
patientest1245713patientest
patients1088763patient_s
patina86022193patina___
patinating1339883patinating
patination12312573patination
patinations13411003patinations
patine85328123patin__e_
patined105114783patin__ed
patinize19610773patinize_
patinized2178823patinized
patins87528783patin___s
patriate10311933patriate_
patriated1238533patriated
patriciates1545323patriciates
patronages1374973patronages
pawnages1435313pa_wnages
pectinate1349553pectinate_
penates93321603p__enates
pepsinates1446373pepsinates
petites93820203peti__tes
phenates13611583p_henates
phonates13410643p_honates
pinatas93711503p__inatas
pinites9319533p__inites
pirates93020333p__irates
platinas103610313platina__s
platinizes2147793platinizes
pointes93216753p_oin_tes
pollinates1247303pollinates
potentates12106333potentates
primates121515933p_rimates
privates131812373p_rivates
pronates10418373p_ronates
protonates12411693protonates
rabbinates1444513rabbinates
radiates92415293radi_ates
radicates12412073radicates
raffinates1644363raffinates
ratines75328583ratin__es
rationales1049313rationales
ratites74920683rati__tes
resinates9314763resinates
retinites9313503retinites
ruinates8311883_ruinates
ruminates11410193ruminates
salivates1239293salivates
sanitates9611733sanitates
satiate7315403sati_ate_
satiated9311603sati_ated
satinets8311733satinet_s
satinettes1043923satinettes
saturates9811603saturates
stagnates1046733stagnates
supinates1139553supinates
tannates81911953ta_nnates
titanates976093titanates
titivates1246433titivates
ultimates1148433ultimates
urinates8314133_urinates
urticates1148893urticates
vaccinates1746563vaccinates
vaginate123911083vaginate_
vaginated14328153vaginated
validates1338243validates
variates111214983vari_ates
vaticinates1643923vaticinates
vitiates112311433viti_ates

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.420425454.8
2DLD Change Limit1486411736.56322648.3
3Display Results1731730.0802162.5
 (SQL Overall)1786911737.06325299.6
 
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.