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
animaters11129951animaters
agemates111110022agemates
agitates9310872agitates
amirates101114792amirates
animacies1348582animacies
animals94111702anima_ls
animas84418722anima__s
animately1445122animately
animatism1348012animatism
animatist11410992animatist
animato91610622animat_o
animator101410292animator
animators111210412animators
animes84719592anim__es
animuses1037982animuses
annates72415422an_nates
aviates10313062avi_ates
bandmates1447922bandmates
climates12311962climates
inmates92715762in_mates
intimates111013302intimates
nidates8311882_nidates
primates121515932primates
reanimates1247842reanimates
sanitates9611732sanitates
abates85825033a__bates
abdicates1448153abdicates
ablates92416903a_blates
abnegates1244943abnegates
acclimates1645913acclimates
acetates102013063acetates
acierates11310793acierates
activates1449683activates
actuates10310303actuates
acylates1339743acylates
adulates9311913adulates
aerates74627483a_erates
agametes1147293agametes
agates76121333a__gates
agemate101210583agemate_
agitate8312063agitate_
agitated1038413agitated
agnates82813183a_gnates
airdates939713airdates
alates64833963a__lates
alginates10310123alginates
aliases7914493ali_ases
alidades1037003alidades
alienates9310683alienates
amazes175613473a__mazes
amidases1136643amidases
amirate91115953amirate_
amniotes1036603amni_otes
anabases1038083anabases
analytes11169203analytes
anatases839793anatases
andantes9310853andantes
anemones10249473anemones
anemoses10159433anemoses
angulates10310853angulates
anilines8415143anilines
anilities9516003anilities
anima74620073anima___
animacy1446103anima_cy
animal85016253anima__l
animalic1258133animalic
animalier1145933animalier
animaliers1244303animaliers
animalism1358613animalism
animalist11511643animalist
animalities1348973animalities
animalizes2148203animalizes
animally1368643animally
animatedly1653163animatedly
animateness1355683animateness
animating12312503animating
animation11313683animation
animations12312193animations
animatisms1446623animatisms
animatists1246873animatists
anime75423203anim__e_
animis84615943anim__is
animisms12328393animisms
animists103010633animists
animus84211613anim__us
anises64826693ani__ses
anisettes946673anisettes
anisoles81010123anisoles
anlaces92313733an_laces
anlages82414103an_lages
anlases72514903an_lases
annotates977293annotates
anolytes11169203anolytes
anomalies1149273anomalies
anomies93316993anom_ies
ansate64517863an_sate_
ansated84214003an_sated
anteater8311603anteater
anteaters939333anteaters
antedates1048603antedates
antes56334323an___tes
antidotes1049533antidotes
antimale10312463antimale_
antimasks1545733antimasks
antimatter1245303antimatter
antimatters1354333antimatters
antimeres11410893antimeres
antiquates1957463antiquates
ariettes8411353ariettes
aspirates1139613aspirates
automates11412053automates
aviate9315203avi_ate_
aviated11310263avi_ated
axites134913833axi__tes
azimuths2241363azimuths
bandmate1347973bandmate_
bedmates1349183bedmates
bromates12413133bromates
bunkmates1743673bunkmates
cabinmates1643883cabinmates
califates14310113califates
candidates1446303candidates
canulates11312863canulates
casemates1349513casemates
cavitates14168963cavitates
climate11312833climate_
climaxes1944613climaxes
coinmates1348323coinmates
comates114123633_comates
craniates11310653crani_ates
cremates124215983cremates
decimates14410693decimates
dilates83220653_dilates
emirates101214843emirates
enates64026423en__ates
epilates10313503epilates
estimates11911353estimates
exanimate1845663exanimate_
fixates1737383_fixates
formates132814293formates
frigates12310923frigates
gemmates13307673gemmates
grimaces1355383grimaces
hamates122917673_hamates
humates122813193_humates
images91411463__images
imamates1237653imamates
imitates10310503imitates
inanimate1146993inanimate_
indicates12312583indicates
inflates11512193inflates
ingates82716893in_gates
ingrates9514153ingrates
initiates9411183initiates
inmate82917353in_mate_
instates81615823instates
intimate101013823intimate_
intimated121010883intimated
intimater111110573intimater
intimaters1297853intimaters
kalifates1646133kalifates
labiates101011513labi_ates
laminates112712903laminates
lancinates1247153lancinates
lapidates1247143lapidates
ligates82318373_ligates
limites92915453_limites
mandates11314093man_dates
marinates112516383marinates
mates75251363___mates
maximites2045313maximites
minimaxes2043933minimaxes
mismates121114553mismates
naiades838213nai_ades
naivetes1145113naivetes
narrates8312753narrates
nates55238333_n__ates
navigates1345873navigates
negates83215833_negates
nictates1039583_nictates
nidate7313783_nidate_
nidated939863_nidated
niobates1037273_niobates
nites55736343_ni__tes
nitrates82516203_nitrates
nizamates2043263_nizamates
nonimages1244823nonimages
notates72817483_notates
nutates73214973_nutates
opiates9312143opi_ates
oxidates1636333oxidates
paginates123111363paginates
patinates113814693patinates
pirates93020323_pirates
primages13159273primages
primate111516283primate_
privates131812373privates
racemates1348853racemates
radiates92415293radi_ates
radicates12412073radicates
reanimate1148083reanimate_
reanimated1347003reanimated
reimages1138373reimages
remates93827103_remates
ruinates8311883ruinates
salivates1239293salivates
sanitate8612043sanitate_
sanitated1068993sanitated
satiates8314633sati_ates
shipmates1645943shipmates
sinuates8310953sinuates
sonicates11410383sonicates
stomates10313343stomates
summates122610483summates
tannates81911953tan_nates
tunicates11268743tunicates
ultimates1148433ultimates
uncrates10314553uncrates
unifaces1346393unifaces
unitages938273unitages
unites65024853uni__tes
unmakes132810793un_makes
unmated103317023un_mated
unstates81314993unstates
urinates8314133urinates
validates1338243validates
vanadates1345133vanadates
variates111214973vari_ates
xanthates1945653xanthates
zincates1937733zincates

Search took 9 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.1531167915.0
2DLD Change Limit1461622347.78318779.6
3Display Results2342340.0932516.1
 (SQL Overall)1786912348.02922255.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.