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

245 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
amounts93704(None) 
amount8414481amount_
mounts84115071_mounts
abounds10217082abounds
accounts1285842accounts
aments85219802am_ents
amounted1135532amounted
amours83512662amou_rs
anoints7311062anoints
aroints7313132aroints
aroynts1036632aroynts
aunts55227632a__unts
counts84618272_counts
demounts1135472demounts
founts94313382_founts
moults84713702_moults
mounds93915132_mounds
mount74128062_mount_
remounts1036372remounts
seamounts1143682seamounts
abducts1265313abducts
abluents1045463abluents
aborts84916183abo_rts
abound9239863aboun_d
about75229083abou_t_
absents93510723absents
abuts75417073a_bu_ts
accents113511233accents
account11109043account_
acorns85013013acorn_s
acquits1857293acquits
adducts1174603adducts
adjoints16103873adjoints
adjuncts1842463adjuncts
adjusts1544513adjusts
adnouns835453adnoun_s
adonis7314063ado_nis
adopts998083ado_pts
adorns74212613adorn_s
adults7299953a_dults
advents11309473advents
aeons57624653aeo_n_s
agents74816293a_gents
agones75719863ago_nes
agons66423783ago_n_s
agouti7388773agou_ti
agoutis8286873agoutis
agouty10366913agou_ty
alants67722023a_lants
almonds10127953almo_nds
aloins65022203aloin_s
ambients1246053ambients
ambits103713413am_bits
amboinas1246033amboinas
ambones11312683ambones
amboynas1543233amboynas
amends94713283am_ends
amens75624843am_en_s
ament76036543am_ent_
amiantus1044383amiantus
amines84727983am_ines
amins75534323am_in_s
ammines11312673ammines
amoebas1135963amoebas
amoks11413553amo__ks
amoles84122193amo_les
among85813303amo_n_g
amongst1045363amo_ngst
amorist9317643amorist
amorists10411333amorists
amorous9311133amorous
amort75832203amo_rt_
amosite9313163amosite
amosites10311233amosites
amounting1236643amounting
amour75014853amou__r
ampoules1275853ampoules
ampules1189433ampules
ampuls1098893ampu_ls
amucks1466003am_ucks
amulets939923amulets
amus65529613am_u__s
amuses85117943am_uses
anoint6423633anoint_
ants47243473a___nts
apolunes1045293apolunes
appoints1286403appoints
argents84014853argents
armours9389853armou_rs
aroint6328153aroint_
around72712413aroun_d
arouses74921293arouses
aroynt9312893aroynt_
arpents93613083arpents
ascents93812553ascents
assents74512223assents
astounds964233astounds
atones65225773ato_nes
attunes737823attunes
aunt46553653a__unt_
aunty85919813a__unty
avaunt959603avaunt_
avocets1235453avocets
avosets1036663avosets
awmous1157713awmou__s
axones134614513axo_nes
axons125517933axo_n_s
azons146518253azo_n_s
bionts8612393bio_nts
blunts84512893_blunts
bounds94415803_bounds
bounty113411073_bounty
bouts75131313_bou_ts
brunts85215453_brunts
bunts75729803__bunts
campouts1436823campou_ts
catamounts1452293catamounts
chaunts1267083chaunts
clouts87017203clou_ts
count74932053_count_
county114313323_county
courts84216173_courts
cunts76125123__cunts
daunts75014083_daunts
demount1049743demount_
dimouts1037893dimou_ts
dismounts1275283dismounts
donuts7410583_donuts
doubts968733_doubts
dunts65828413__dunts
famous11412393famou__s
flaunts1056133flaunts
flouts94315273flou_ts
foments122912053foments
fonts86124753_fo_nts
founds104814193_founds
fount84727033_fount_
fronts94415793fro_nts
gamuts958783gam_u_ts
glouts74414713glou_ts
gouts64826173_gou_ts
grounds9228313grounds
grouts75015613grou_ts
grunts75511853_grunts
haunts95614393_haunts
hounds104413133_hounds
hunts86826173__hunts
immunes1136083immunes
impounds1344123impounds
jaunts137511883_jaunts
joints133811453_joints
jousts135011273_jousts
knouts10438313knou_ts
laments94314853lam_ents
layouts1046483layou_ts
loments93413473loments
louts56330273_lou_ts
lunts55826903__lunts
mahouts1237143mahou_ts
manhunts1344043manhunts
maunds9519653_maunds
mauts75927193_mau_ts
mints76834043_m_ints
moans74624373_moan_s
moats75827643_mo_ats
molts76032093_mo_lts
moments113113123_moments
monas74732153_mo_nas
monks116123393_mo_nks
monos75930863_mo_nos
mons68152263_mo_n_s
monte75829773_mo_nte
montes84226933_mo_ntes
month104818423_mo_nth
months113812933_mo_nths
moons75331003_moon_s
moots75831663_mo_ots
morns75527443_morn_s
morts75533563_mo_rts
mosts76028543_mo_sts
motets84216193_motets
mots66853163_mo__ts
motts76527003_mo_tts
moues75732843_mou_es
moulds94910993_moulds
moult74728723_moult_
mound83918313_moun_d
mounted103611533_mounted
mounter93713173_mounter
mounters103712503_mounters
mourns84111013_mourns
mouses85531423_mouses
mouth105420293_mou_th
mouths115214533_mouths
munis75022003_m_unis
muns65535923_m_un_s
muons75816173_muon_s
musts75527443_m_usts
muts64839983_m_u_ts
mutts75120253_m_utts
nouns56717313_noun_s
ousts55225703__ousts
outs45746963__ou_ts
paramounts1443893paramounts
payouts1247303payou_ts
points85618533_points
poults84613483_poults
pounds93714383_pounds
pouts75530323_pou_ts
punts75828003__punts
ragouts838543ragou_ts
ramonas9311093ramo_nas
ramous8417113ramou__s
recounts1038773recounts
remount9512283remount_
romaunts1043693romaunts
rounds73615623_rounds
rousts617016723_rousts
routs57133413_rou_ts
runts55927633__runts
scouts84817943scou_ts
seamount1047923seamount_
shouts94017723shou_ts
shunts95712023_shunts
smolts84411883smo_lts
smuts75415713sm_u_ts
snouts64915873snou_ts
sounds74616183_sounds
spouts85115113spou_ts
stounds8377823stounds
stouts65019003stou_ts
strunts7429543strunts
stunts65615253_stunts
surmounts1143443surmounts
swounds11405643swounds
swouns9358243swoun_s
taunts65715663_taunts
touts54830393_tou_ts
trouts66116633trou_ts
vaunts95212623_vaunts
wonts87621543_wo_nts
wounds103811633_wounds
yamuns11336513yam_un_s
youngs1035383_youngs
zounds164310173_zounds

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.406440125.6
2DLD Change Limit1340272456.84319586.0
3Display Results2452450.0932634.4
 (SQL Overall)1786912457.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.