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

269 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
animate9161721(None) 
animated111612371animated
animater101512391animater
animates101316421animates
animato91610621animato
agemate101210582agemate
agitate8312062agitate
amirate91115952amirate
anima74620072anima__
animacy1446102animacy
animal85016252anima_l
animals94111702animals
animas84418722anima_s
animately1445122animately
animaters11129972animaters
animator101410292animator
anime75423202anim__e
ansate64517862an_sate
antimale10312462antimale
aviate9315202avi_ate
bandmate1347972bandmate
climate11312832climate
exanimate1845662exanimate
inanimate1146992inanimate
inmate82917362in_mate
intimate101013832intimate
nidate7313782_nidate
primate111516282primate
reanimate1148082reanimate
sanitate8612042sanitate
abate76627843a__bate
abdicate1348903abdicate
ablate82219213a_blate
abnegate1144863abnegate
acclimate1546233acclimate
acerate92818913acerate
acetate92514753acetate
acierate10311813acierate
activate13510373activate
actuate9311443actuate
acuate8315633a_cuate
acylate12310533acylate
adnate72913483a_dnate
adulate8313233adulate
aerate64830553a_erate
agamete1037403agamete
agate66525153a__gate
agemates111110023agemates
agitated1038413agitated
agitates9310883agitates
agitato856573agitato
agminate1139243agminate
agnate73314883a_gnate
airdate8311323airdate
alate55340333a__late
alginate9310693alginate
alidade936993alidade
alienate8311553alienate
amaze166016603a__maze
amidase1036733amidase
amirates101114793amirates
amniote936963amni_ote
analyte10158813analyte
anatase738943anatase
andante8311273andante
anemone9119453anemone
angiomata1254143angiomata
angulate9312013angulate
anile54634463ani__le
aniline7418473aniline
anility10312723anility
animacies1348593animacies
animalic1258153animalic
animalier1145933animalier
animality1447803animality
animalize2048553animalize
animally1368643animally
animatedly1653163animatedly
animating12312513animating
animation11313683animation
animatism1348013animatism
animatist11411003animatist
animators111210423animators
animes84719593anim_es
animi74016663anim__i
animis84615943anim_is
animism113510213animism
animist93815173animist
animists103010633animists
animus84211613anim_us
animuses1037983animuses
anise55129703ani__se
anisette846773anisette
anisole71010833anisole
anlace82513923an_lace
anlage72514233an_lage
annates72415423an_nates
annotate877713annotate
annulate8310923annulate
anolyte10159003anolyte
anomaly1238843anomaly
anomie83215963anom_ie
ansae55720973an_sa_e
ansated84214003an_sated
antae56828293an_ta_e
ante46538903an___te
anteater8311603anteater
antedate949693antedate
antidote949723antidote
antifat10314253antifat_
antiman9313883antima_n
antimask1446573antimask
antimatter1245303antimatter
antimere10410683antimere
antimine10714753antimine
antiquate1888033antiquate
antirape10410113antirape
antistate9410143antistate
anymore1256243anymore
arcuate9311963arcuate
ariette7312373ariette
arillate8412993arillate
aristae7312533aristae
aristate8312133aristate
aspirate1039943aspirate
aurate64426473a_urate
aureate72515283aureate
automate10411943automate
aviated11310263avi_ated
aviates10313063avi_ates
axite125218253axi__te
azimuth2141843azimuth
bandmates1447923bandmates
bedmate1239433bedmate
binate8419773_binate
bromate11313553bromate
bunkmate1643963bunkmate
cabinmate1544093cabinmate
califate13310483califate
candidate1356663candidate
canulate10314553canulate
capitate121712183capitate
carinate103320253carinate
casemate1239843casemate
cavitate13159833cavitate
climates12311973climates
cnidae978143cnida_e
coinmate1239063coinmate
comate104124843_comate
craniate10312563crani_ate
cremate113816183cremate
decimate13411123decimate
dilate73220693_dilate
emirate91015833emirate
enate54428153en__ate
enemata948013enemata
enigmata1143663enigmata
epilate9314283epilate
estimate10912003estimate
fermate122813003fermate
fixate1638733_fixate
formate123115093formate
frigate11311063frigate
gemmate12418383gemmate
grimace1255083grimace
hamate113319833_hamate
handmade1545963handmade
humate113214443_humate
image81411293__image
imamate1138103imamate
imitate9310873imitate
indicate11313353indicate
inflate10312313inflate
ingate73018243in_gate
ingrate8715123ingrate
initiate8412693initiate
inmates92715783in_mates
innate63917313in_nate
instate71616483instate
intimae9109753intima_e
intimated121010893intimated
intimater111110583intimater
intimates111013313intimates
irate55627983__irate
kalifate1556493kalifate
labiate91313573labi_ate
laminate103014633laminate
lanate6421263lan__ate
lancinate1147803lancinate
lapidate1157903lapidate
ligate72519253_ligate
limbate1139213_limbate
lineate7815153lineate
mammate104411273mammate
mandate10315573man_date
manmade1237963man_made
marinate103017783marinate
mate65154223___mate
maximite1955853maximite
misate81222693_misate
mismate111415353mismate
naivete1055663naivete
narrate7313493narrate
navigate1246073navigate
negate72915573_negate
nictate9310223_nictate
nidated939863_nidated
nidates8311893_nidates
nimble103412943_nimble
niobate937703_niobate
nite45943583_ni__te
nitrate72017013_nitrate
nizamate1943533_nizamate
nonimage1144883nonimage
notate63217863_notate
nutate63017373_nutate
opiate8513463opi_ate
oxidate1537023oxidate
paginate114012443paginate
palmate113215233palmate
patinate103016313patinate
pinnate93613743pinnate
pirate82322883_pirate
plicate11314513plicate
plumate1149803plumate
primage12169143primage
primates121515933primates
private121513263private
quinate16511573quinate
racemate1239063racemate
radiate83416313radi_ate
radicate11412873radicate
ramate83921693_ramate
reanimated1347003reanimated
reanimates1247853reanimates
reimage1037913reimage
remate84428683_remate
ruinate7312833ruinate
salivate11310013salivate
sanitated1068993sanitated
sanitates9611733sanitates
satiate7315403sati_ate
shipmate1546153shipmate
sigmate10710143sigmate
sinuate7412163sinuate
sonicate10310933sonicate
spicate113214193spicate
spinate93114813spinate
stomate9313123stomate
summate113611663summate
tannate71813523tan_nate
tunicate103310043tunicate
ultimate1049203ultimate
uncinate10312393uncinate
uncrate9415953uncrate
uniface1236953uniface
unitage838993unitage
unite54828383uni__te
unmade92911063un_made
unmake122811213un_make
unmated103317023un_mated
unstate71916213unstate
urinate7315363urinate
vaginate123911083vaginate
validate1239003validate
vanadate1245513vanadate
variate101316433vari_ate
xanthate1845713xanthate
zincate1838533zincate

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272697.25018486.5
3Display Results2692690.0932892.5
 (SQL Overall)1786912697.74923059.9
 
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.