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

133 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
amatory123864(None) 
abator84512732abator_
abators94413102abators
aleatory1148832aleatory
amatol838692amato_l
amatols938182amatols
anatomy1246232anatomy
damnatory1544142damnatory
fumatory1644922fumatory
lavatory1445702lavatory
natatory1146612natatory
oratory1039402oratory
abater85518123abater_
abaters95115203abaters
ablator939863ablator_
ablators1069893ablators
actor71116083a_ctor_
actorly1246423a_ctorly
actors81016773a_ctors
adaptor1034953adaptor_
adaptors1145263adaptors
additory1344263additory
adulatory1346313adulatory
aerator7314853aerator_
aerators8315623aerators
agatoid948623agatoid
alary86123443ala__ry
alastor739673alastor_
alastors8311223alastors
amadou977613amado_u
amadous1038503amadous
amarone9311203amarone
amateur933893amateur
amateurs1043653amateurs
amative12311733amative
amazon1736833amazo_n
amazons1836653amazons
ambary134010543am_bary
ambery133811133am_bery
ambry123512103am__bry
ambulatory1744413ambulatory
amendatory1653123amendatory
amity10416093amit__y
amort75832203am__ort
amphora1446923amphora
anagogy12174443anagogy
analogy11177853analogy
animator101410293animator_
animators111210423animators
apathy1437033apat_hy
armature10106973armature
armory114211473a_rmory
artery9911453a_rtery
astony9510523a_stony
atomy107415193__atomy
atony87218853__atony
atopy106813393__atopy
attorn6310793a_ttorn
auditory1245703auditory
avatar937523avatar_
avatars1036443avatars
aviator10229683aviator_
aviators11169923aviators
calory11312843_calory
citatory1347213citatory
crematory1647223crematory
datary10310243_datary
defamatory1943493defamatory
dilatory12279283dilatory
eatery95316353_eatery
enactory1346153enactory
factory15108353factory
flavory1644743flavory
fumitory1643893fumitory
gator64416043_gator_
gators74115843_gators
gyratory1544173gyratory
history1339423history
imagery13124203imagery
juratory1845183juratory
lamasery1343953lamasery
laudatory1344603laudatory
major145212923_major_
majorly1943153_majorly
majors154511093_majors
mandatory1545253mandatory
manor78023933_manor_
manors84420883_manors
marry104821693_ma_rry
martyry1533373martyry
masonry1244123_masonry
mastery124214323mastery
mater74438863_mater_
maters85032393_maters
matey107022663_mat_ey
matron83918313_matron
mattery123810713mattery
mature8313473_mature
mayor106616623_mayor_
mayors115714193_mayors
memory1338803_memory
minatory1338553minatory
moory105115793_m_oory
moratory1347823moratory
motor75317293_motor_
motors84616603_motors
nugatory1245273nugatory
oblatory1345803oblatory
orator6314533orator_
orators7313823orators
palpatory1645233palpatory
placatory1645723placatory
potatory1348413potatory
rectory123512733rectory
rogatory1246153rogatory
rotatory1147213rotatory
saltatory1245633saltatory
satori6415843_satori
savory124310563_savory
stator64015483stator_
stators73915583stators
story86723033__story
suasory1046043suasory
sudatory1245843sudatory
tomatoey1344103tomatoey
tory75840543___tory
vanitory1445733vanitory
vapory14398763_vapory
viator93211843viator_
viators102712033viators
victory15326983victory
vomitory1644413vomitory
watery123914503_watery

Search took 7 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.390458182.1
2DLD Change Limit1340271335.92322628.2
3Display Results1331330.0632111.1
 (SQL Overall)1786911336.37628025.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.