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

189 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
animated11161237(None) 
animate91617211animate_
animater101512391animater
animates101316421animates
agitated1038412agitated
animatedly1653162animatedly
animately1445122animately
animaters11129972animaters
animato91610622animat_o
animator101410292animator
ansated84214002an_sated
aviated11310262avi_ated
intimated121010892intimated
nidated939862_nidated
reanimated1347002reanimated
sanitated1068992sanitated
unmated103317022un_mated
abated95918453a__bated
abdicated1547013abdicated
ablated102513443a_blated
abnegated1344163abnegated
acclimated1745153acclimated
acerated113113983acerated
acetated112010683acetated
acierated1238283acierated
activated1567883activated
actuated1138743actuated
acylated1437873acylated
admitted1234763admitted
adulated1039753adulated
aerated85322373a_erated
agemate101210583agemate_
agemates111110023agemates
agisted938203agi_sted
agitate8312063agitate_
agitates9310883agitates
aimed85626053a_im__ed
airted74214503a_i_rted
alated75625143a__lated
alienated1047743alienated
alighted1347673alighted
alimented1245313alimented
amazed18519313a__mazed
amirate91115953amirate_
amirates101114793amirates
aneared8512743an_eared
angulated1139223angulated
anima74620073anima___
animacies1348593animacies
animacy1446103anima_cy
animal85016253anima__l
animalic1258153animalic
animalier1145933animalier
animalized2247013animalized
animally1368643animally
animals94111703anima_ls
animas84418723anima__s
animating12312503animating
animation11313683animation
animatism1348013animatism
animatist11411003animatist
animators111210423animators
anime75423203anim__e_
animes84719593anim__es
animuses1037983animuses
aniseed839403ani_seed
annates72415423an_nates
annealed936343annealed
annotated1095613annotated
annulated1038603annulated
anointed938343anointed
ansate64517863an_sate_
anteater8311603anteater
anted66328243an___ted
antedated1146703antedated
antidoted1146723antidoted
antimale10312463antimale_
antimatter1245303antimatter
antiquated2055483antiquated
arcuated1138803arcuated
aspirated1247703aspirated
aurated83817793a_urated
automated1248813automated
aviate9315203avi_ate_
aviates10313063avi_ates
bandmate1347973bandmate_
bandmates1447923bandmates
bromated1339173bromated
canulated12310673canulated
capitated14159043capitated
carinated123414263carinated
casemated1446953casemated
cavitated15177353cavitated
climate11312833climate_
climates12311973climates
climaxed2043113climaxed
cremated133412963cremated
decimated1548953decimated
dilated93115823_dilated
epilated11310753epilated
estimated12109443estimated
exanimate1845663exanimate_
fixated1835533_fixated
gemmated14336293gemmated
grimaced1463313grimaced
imaged1097763__imaged
imitated1138263imitated
inanimate1146993inanimate_
indicated13310953indicated
inflated12410863inflated
initiated10510113initiated
inmate82917363in_mate_
inmates92715783in_mates
instated91613343instated
intimate101013833intimate_
intimater111110583intimater
intimates111013313intimates
knighted1745123knighted
knitted12337423kni_tted
labiated11109303labi_ated
laminated122610283laminated
lanated8313203lan__ated
lancinated1345573lancinated
lapidated1345673lapidated
lariated91212063lari_ated
ligated92414143_ligated
limited102310233_limited
lineated9711063lineated
mandated12310293man_dated
marinated122513173marinated
mated85537783___mated
mismated131111333mismated
narrated9310323narrated
navigated1445483navigated
negated93413233_negated
nictated1137793_nictated
nidate7313783_nidate_
nidates8311893_nidates
nimmed11368573_nim_med
nitrated92213153_nitrated
notated82713663_notated
nutated83113423_nutated
opiated1039483opi_ated
oxidated1745033oxidated
paginated13309463paginated
palmated132511003palmated
patinated123911413patinated
pinnated11338553pinnated
pirated102515613_pirated
plicated13310643plicated
primate111516283primate_
primates121515933primates
radiated102512593radi_ated
radicated13410123radicated
reanimate1148083reanimate_
reanimates1247853reanimates
reimaged1246173reimaged
remated103522473_remated
ruinated939523ruinated
salivated1337473salivated
sanitate8612043sanitate_
sanitates9611733sanitates
satiated9311603sati_ated
sinuated938413sinuated
sonicated1248453sonicated
spicated13309903spicated
summated13298833summated
tunicated12257493tunicated
ultimated1247313ultimated
unabated11310133unabated
unamazed2035883unamazed
unbated103317733un_bated
uncoated11314963uncoated
uncrated11416313uncrated
undated93118463un_dated
ungated92717213un_gated
unheated121514553unheated
unimbued1343073unimbued
united74421543uni__ted
unlimited1245923unlimited
unmatted1138293un_matted
unrated82621553un_rated
unsated83419933un_sated
unseated91317683unseated
unstated91615813unstated
urinated9311613urinated
vaginated14328153vaginated
validated1446493validated
variated121211393vari_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 Filter1786911461620.420425454.8
2DLD Change Limit1461621896.84621350.0
3Display Results1891890.0762486.8
 (SQL Overall)1786911897.34224338.2
 
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.