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

234 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
animates10131642(None) 
animate91617211animate_
animated111612371animated
animater101512391animater
animaters11129971animaters
agemates111110022agemates
agitates9310882agitates
amirates101114792amirates
animacies1348592animacies
animals94111702anima_ls
animas84418722anima__s
animately1445122animately
animatism1348012animatism
animatist11411002animatist
animato91610622animat_o
animator101410292animator
animators111210422animators
animes84719592anim__es
animuses1037982animuses
annates72415422an_nates
aviates10313062avi_ates
bandmates1447922bandmates
climates12311972climates
inmates92715782in_mates
intimates111013312intimates
nidates8311892_nidates
primates121515932primates
reanimates1247852reanimates
sanitates9611732sanitates
abates85825033a__bates
abdicates1448153abdicates
ablates92416903a_blates
abnegates1244943abnegates
acclimates1645913acclimates
acetates102013063acetates
acierates11310813acierates
activates1449683activates
actuates10310313actuates
acylates1339743acylates
adulates9311913adulates
aerates74627493a_erates
agametes1147293agametes
agates76121343a__gates
agemate101210583agemate_
agitate8312063agitate_
agitated1038413agitated
agnates82813193a_gnates
airdates939723airdates
alates64833963a__lates
alginates10310123alginates
aliases7914493ali_ases
alidades1037003alidades
alienates9310683alienates
amazes175613473a__mazes
amidases1136653amidases
amirate91115953amirate_
amniotes1036603amni_otes
anabases1038083anabases
analytes11169203analytes
anatases839793anatases
andantes9310853andantes
anemones10249473anemones
anemoses10159433anemoses
angulates10310863angulates
anilines8415143anilines
anilities9516003anilities
anima74620073anima___
animacy1446103anima_cy
animal85016253anima__l
animalic1258153animalic
animalier1145933animalier
animaliers1244313animaliers
animalism1358613animalism
animalist11511643animalist
animalities1348993animalities
animalizes2148203animalizes
animally1368643animally
animatedly1653163animatedly
animateness1355693animateness
animating12312503animating
animation11313683animation
animations12312193animations
animatisms1446633animatisms
animatists1246883animatists
anime75423203anim__e_
animis84615943anim__is
animisms12328393animisms
animists103010633animists
animus84211613anim__us
anises64826693ani__ses
anisettes946673anisettes
anisoles81010123anisoles
anlaces92313733an_laces
anlages82414113an_lages
anlases72514903an_lases
annotates977293annotates
anolytes11169213anolytes
anomalies1149283anomalies
anomies93316993anom_ies
ansate64517863an_sate_
ansated84214003an_sated
anteater8311603anteater
anteaters939343anteaters
antedates1048613antedates
antes56334323an___tes
antidotes1049533antidotes
antimale10312463antimale_
antimasks1545733antimasks
antimatter1245303antimatter
antimatters1354333antimatters
antimeres11410893antimeres
antiquates1957463antiquates
ariettes8411353ariettes
aspirates1139613aspirates
automates11412053automates
aviate9315203avi_ate_
aviated11310263avi_ated
axites134913833axi__tes
azimuths2241363azimuths
bandmate1347973bandmate_
bedmates1349183bedmates
bromates12413143bromates
bunkmates1743673bunkmates
cabinmates1643893cabinmates
califates14310113califates
candidates1446303candidates
canulates11312873canulates
casemates1349523casemates
cavitates14168963cavitates
climate11312833climate_
climaxes1944613climaxes
coinmates1348343coinmates
comates114123643_comates
craniates11310653crani_ates
cremates124216003cremates
decimates14410693decimates
dilates83220663_dilates
emirates101214853emirates
enates64026433en__ates
epilates10313503epilates
estimates11911363estimates
exanimate1845663exanimate_
fixates1737393_fixates
formates132814293formates
frigates12310933frigates
gemmates13307673gemmates
grimaces1355383grimaces
hamates122917683_hamates
humates122813193_humates
images91411463__images
imamates1237663imamates
imitates10310503imitates
inanimate1146993inanimate_
indicates12312583indicates
inflates11512193inflates
ingates82716913in_gates
ingrates9514173ingrates
initiates9411183initiates
inmate82917363in_mate_
instates81615833instates
intimate101013833intimate_
intimated121010893intimated
intimater111110583intimater
intimaters1297853intimaters
kalifates1646133kalifates
labiates101011513labi_ates
laminates112712903laminates
lancinates1247153lancinates
lapidates1247143lapidates
ligates82318383_ligates
limites92915453_limites
mandates11314093man_dates
marinates112516383marinates
mates75251363___mates
maximites2045313maximites
minimaxes2043943minimaxes
mismates121114563mismates
naiades838213nai_ades
naivetes1145113naivetes
narrates8312763narrates
nates55238333_n__ates
navigates1345873navigates
negates83215843_negates
nictates1039593_nictates
nidate7313783_nidate_
nidated939863_nidated
niobates1037283_niobates
nites55736343_ni__tes
nitrates82516223_nitrates
nizamates2043273_nizamates
nonimages1244823nonimages
notates72817483_notates
nutates73214973_nutates
opiates9312143opi_ates
oxidates1636333oxidates
paginates123111363paginates
patinates113814693patinates
pirates93020333_pirates
primages13159273primages
primate111516283primate_
privates131812373privates
racemates1348853racemates
radiates92415293radi_ates
radicates12412073radicates
reanimate1148083reanimate_
reanimated1347003reanimated
reimages1138373reimages
remates93827113_remates
ruinates8311883ruinates
salivates1239293salivates
sanitate8612043sanitate_
sanitated1068993sanitated
satiates8314633sati_ates
shipmates1645953shipmates
sinuates8310963sinuates
sonicates11410383sonicates
stomates10313343stomates
summates122610493summates
tannates81911953tan_nates
tunicates11268743tunicates
ultimates1148433ultimates
uncrates10314563uncrates
unifaces1346393unifaces
unitages938273unitages
unites65024853uni__tes
unmakes132810793un_makes
unmated103317023un_mated
unstates81314993unstates
urinates8314133urinates
validates1338243validates
vanadates1345133vanadates
variates111214983vari_ates
xanthates1945653xanthates
zincates1937743zincates

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.406440125.6
2DLD Change Limit1461622346.59622159.2
3Display Results2342340.1062207.5
 (SQL Overall)1786912347.10825139.4
 
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.