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

111 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
amateur93389(None) 
amateurs1043651amateurs
abater85518122abate_r
auteur6107942a_uteur
mater74438862_mate_r
abaser86414343abase_r
abate76627843abate__
abated95918453abate_d
abaters95115203abaters
abates85825033abate_s
abator84512723abat_or
acuter84412863acute_r
adapter1036173adapte_r
after85719793a_fte_r
agate66525153agate__
agates76121343agate_s
alate55340333alate__
alated75625153alate_d
alates64833973alate_s
alter54828503a_lte_r
amadou977613amadou_
amadous1038503amadous
amasser9418733amasser
amateurish1552063amateurish
amateurism1452483amateurism
amative12311733amative
amatol838693amat_ol
amatols938183amatols
amatory1238643amatory
amaze166016603amaze__
amazed18519313amaze_d
amazes175613473amaze_s
ambeer104511603am_beer
amber94523213am_be_r
ambler104916453amble_r
ameer75618983am__eer
ammeter1148393ammeter
amour75014853am__our
ampler104313303ample_r
amuser84712623amuse_r
animater101512393animate_r
apter76120203a_pte_r
armature10106973armat_ure
aster55434893a_ste_r
auteurs7137503a_uteurs
avatar937523avat_ar
awaiter1057443awaite_r
beater84729393beate_r
boater84622093boate_r
cater74840723_cate_r
coater84329573coate_r
crater85026643crate_r
damager1157983damage_r
dater65332313_date_r
eater54639843_eate_r
elater64724203elate_r
emoter85415193emote_r
feater95224053feate_r
flaneur1034183flaneur
frater94520593frate_r
gater64533653_gate_r
grater74625443grate_r
hamate113319833hamate__
hamates122917683hamate_s
hamster12810423hamste_r
hater85034753_hate_r
hauteur1033893hauteur
heater94828303heate_r
imager9108123image_r
irater65218353irate_r
krater104014313krate_r
lamster9109913lamste_r
later54843923_late_r
macer912126943_mace_r
maker114127813_make_r
makeup1434863_makeup
maser75029973_mase_r
masseur935703masseur
master84831343maste_r
mate65154223_mate__
mated85537783_mate_d
maters85032393_maters
mates75251363_mate_s
matey107022663_mate_y
mateys115610943_mateys
matier84321523_matier
matter84325343_matter
mature8313473_mat_ure
mazer165722423_maze_r
meteor84910073_meteor
meter75130323_mete_r
miter75734793_mite_r
muter74525543_mute_r
neater64424313neate_r
oater55433733_oate_r
pater74740723_pate_r
plater84427693plate_r
prater84825353prate_r
ramate83921693ramate__
rater54943283_rate_r
saboteur1042003saboteur
seater64534163seate_r
secateur1042923secateur
skater105015493skate_r
slater64429183slate_r
smarter94113133smarte_r
smatter93613333smatter
smiter83616413smite_r
stater64427563state_r
tater54138613_tate_r
water84733313_wate_r

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.423422437.4
2DLD Change Limit1340271117.32618294.7
3Display Results1111110.0502220.0
 (SQL Overall)1786911117.79922912.0
 
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.