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

399 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
ampuls109889(None) 
ampul91110851ampul_
ampule10710611ampule
ampules1189431ampules
amours83512662amours
ample94720302amp_le
amply125012912amp_ly
ampoule11116602ampoule
ampoules1275852ampoules
amps86230342amp__s
ampulla1164302ampulla
amus65529612am_u_s
amyls104512692am_yls
annuls64711732annuls
appals104812942appals
appels104312792appels
appulse1134672appulse
armfuls1275012armfuls
campus125213922campu_s
hamauls12387812hamauls
impels10389522impels
impulse1135112impulse
mauls76524952_mauls
puls65437562__puls
wampums16314212wampums
wampus13499012wampu_s
aals49941143a__als
abuts75417073a_buts
acyls104211523a_cyls
adult63520653a_dult
adults7299953a_dults
afoul8510193afoul_
agues64919053a_gues
ahull84010313a_hull
ails45654713a__ils
aimful1166703aimful_
albums10198273albums
aldols7109713aldols
algums9208043algums
alkyls13465723alkyls
alls46740923a__lls
allyls9437273allyls
almuds9378773almuds
almugs9396423almugs
alphas1139513alphas
alphyls15113953alphyls
alps65529243alp__s
als36663023a___ls
alula5317093a_lula
alums75720603a_lums
amahs107819063am_ahs
amas67746293am__as
amass77119683am_ass
amatols938183amatols
amazes175613473amazes
ambers104519583ambers
ambits103713413ambits
amble95924643am_ble
ambles105121863ambles
ambos95321253am_bos
ambush1336113ambush
amebas10311453amebas
ameers84015573ameers
amends94713283amends
amens75624843am_ens
aments85219803aments
amias75831473am_ias
amices105018013amices
amicus103810003amicus
amides95722663amides
amidols10457563amidols
amids85627513am_ids
amies76837693am_ies
amigas95912173amigas
amigos94511213amigos
amines84727983amines
amins75534323am_ins
amirs75924923am_irs
amis66445323am__is
amiss75823073am_iss
ammos94815823am_mos
amnios84912523amnios
amoks11413553am_oks
amole75724593am_ole
amoles84122193amoles
amount8414483amount
amounts937043amounts
amour75014853amou_r
amp77541023amp___
amped104820513amp_ed
ampere10514413ampere
amperes11313983amperes
amping114317573amping
ampler104313303ampler
amplest11312333amplest
ampullae1253773ampullae
ampullar1253133ampullar
amputee1148863amputee
amputees1245103amputees
amu58237323am_u__
amuck1389563am_uck
amucks1466003amucks
amulet8419573am_ulet
amulets939923am_ulets
amuse75920833am_use
amuses85117943amuses
amyl95515103am_yl_
amylum1344693amylum
amylums1473613amylums
angels74416173angels
anils56326723a_nils
ankus91410683anku_s
annals66415923annals
annuals7388193annuals
annul55813383annul_
annuli6459053annuli
annulus7426613annulus
anus47131113a_nu_s
anvils9219713anvils
apers76629133a_pers
apes66047433a_p_es
aphis105917133a_phis
apods86316343a_pods
apos65433823a_p_os
appal95315223appal_
appall10379743appall
appalls11337743appalls
appeals11378673appeals
appel94615893appel_
apple94517673a_pple
apples104315763apples
apply125111393a_pply
apps86319693a_p_ps
appulses1234893appulses
apres75426403a_pres
apses76823913a_pses
apsis75718293a_psis
aptly105111813a_ptly
aquas142412613a_quas
arcus76918863arcu_s
argals75517713argals
argils75213623argils
argols74514613argols
argues74516413argues
argus66716543argu_s
ariels65119373ariels
arils58732203a_rils
armful1167163armful_
armours9389853armours
armpits1157133armpits
arpens84814823arpens
artels66216233artels
arums75517833a_rums
aryls87015813a_ryls
ascus75013583ascu_s
aspens85013353aspens
aspers86220313aspers
aspics104211563aspics
aspis74618143asp_is
asps65622093asp__s
atolls65511353atolls
augurs7399963augurs
auks85525263a__uks
auld54125363a__uld
aurums849383aurums
avails939693avails
avulse935843a_vulse
awful1178143awful_
awls75926093a__wls
awmous1157713awmou_s
awols84713523a_wols
axels126313633a_xels
axils127217503a_xils
babuls105413643babuls
bagfuls1334753bagfuls
camails11311753camails
camels105217083cam_els
campers134220293campers
camphols1746243camphols
campily1638273campily
campos125217953camp_os
campouts1436823campouts
camps116330263camp__s
campuses1437773campuses
canfuls1248423canfuls
capfuls1436523capfuls
carfuls1249133carfuls
carpals113414633carpals
carpels115315463carpels
carpus105514303carpu_s
cauls75727773_cauls
compels133210883compels
copals105018943copals
copula102812043copula
copulas113811563copulas
cupels10310203cupels
cupfuls1444343cupfuls
cupula10328433cupula
cupule103410723cupule
cupules113210263cupules
dampens12348563dampens
dampers123915693dampers
damply14337893damp_ly
damps105220413damp__s
damsels10126703damsels
earfuls1036863earfuls
emails84412343emails
emeus76913333emeu_s
empale102611263empale
empales112411433empales
emus66821683em_u_s
expels1547173expels
expulse1674513expulse
famous11412393famou_s
famuli1136763fam_uli
famulus1235043fam_ulus
fouls87221433_fouls
gambols1238593gambols
gamps105323713gamp__s
gamuts958783gam_uts
ghouls1036043ghouls
grampus12356313grampu_s
guls55930853__guls
hamals114816823ham_als
hamaul114210873hamaul_
hammals14409223hammals
hampers143616953hampers
hamuli1137063ham_uli
hamulus1235323ham_ulus
hatfuls1386023hatfuls
hauls86123733_hauls
iambus10468903iambu_s
imaums10106303imaums
imbues1037983imbues
impala10256933impala
impalas11236953impalas
impale102811663impale
impales113311763impales
impel95711773impel_
impis96213853imp_is
imply124911843imp_ly
imps86221123imp__s
impugn1143163impugn
impugns1243333impugns
impulsed1334003impulsed
impulses1235223impulses
impure1038383impure
impute1038043impute
imputes1138083imputes
inputs837703inputs
jarfuls1754773jarfuls
lampads12477623lampads
lampas106615953lamp_as
lampers113817333lampers
lamps95624833lamp__s
lapels83712043lapels
lapfuls1234503lapfuls
lupus74512523lupu_s
macula103013673macula
maculas113114023maculas
macule104115273macule
macules114015133macules
magus85318753magu_s
maills84215283maills
mails76037783_mails
malls76233433_malls
mamluks1543313mamluks
mammals10389273mammals
manuals9311213manuals
manus75924933manu_s
maple95521143map_le
maples104819423maples
maps86141053map__s
maquis17249483maquis
marls75535163_marls
mauds85519273_mauds
maul64830723_maul_
mauts75927193_mauts
meals75933373_meals
mells75031333_mells
mels65941533_m_els
merls77423903_merls
mewls105813233_mewls
miauls8178713miauls
mills75435053_mills
mils66045333_m_ils
moguls948553moguls
moils76125753_moils
molls75129783_molls
mols65948573_m_ols
mools76027173_mools
moues75732843_moues
mould86015753_mould
moulds94910993_moulds
moult74728723_moult
moults84713703_moults
muds75530653_m_uds
mugs76232043_m_ugs
mule65236973_m_ule
mules75034293_m_ules
mull65128803_m_ull
mulls75124153_mulls
mums85732773_m_ums
muns65535923_m_uns
mus55946753_m_u_s
muss64933763_m_uss
muts64839983_m_uts
nopals84914023nopals
opals75718353_opals
opus66420593_opu_s
palmfuls1543473palmfuls
palpus104210283palpu_s
pals66951353__pals
pampas124913993pamp_as
pampers133615933pampers
panfuls1237173panfuls
pappus9408373pappu_s
papula103011113papula
papule102212133papule
papules112411573papules
peepuls1134923peepuls
peplus10138343peplus
piculs103511753piculs
pipals104213643pipals
plus66324833__plus
pols66044563__pols
pubs85029213__pubs
puds75630513__puds
pugs76332773__pugs
pul56138063__pul_
pula65129373__pula
pule65040953__pule
pules74538813__pules
puli65527623__puli
pulis74225603__pulis
pull64731663__pull
pulls74425053__pulls
pulp84825353__pulp
pulps95116483__pulps
pulse74219973__pulse
puns66641483__puns
pupils10389913pupils
pups86032233__pups
pupus94614043pupu_s
purls74723353__purls
purs65641043__purs
pus55547843__pu_s
puss64830133__puss
puts65641753__puts
ramous8417113ramou_s
rampole1139693rampole
rampoles1238893rampoles
ramps96224633ramp__s
ramtils938413ramtils
ramus76418283ram_u_s
rappels11448803rappels
repels84318763repels
repulse938193repulse
rumpus10458893rumpu_s
sambals115213483sambals
samburs11369343samburs
samiels939763samiels
sampans112411003sampans
sample104215013samp_le
samples112815453samples
samps96124673samp__s
sauls55128123_sauls
schuls11299853schuls
sepals85217373sepals
shauls94913113shauls
shuls85319713_shuls
smalls84514123smalls
smells83914743smells
smuts75415713sm_uts
souls55127363_souls
spuds85113673_spuds
spues75025383_spues
spurs74621523_spurs
tamals84116633tam_als
tamburs11288613tamburs
tampala1136613tampala
tampalas1245473tampalas
tampans113310983tampans
tampers113516743tampers
tampons112711563tampons
tamps95524083tamp__s
tepals85415043tepals
umbels104510593umbels
umps85721943ump__s
vampers143111623vampers
vamps125415483vamp__s
vatfuls1384853vatfuls
wamefuls1643863wamefuls
wammus13426733wammu_s
wampum15406053wampu_m
wampuses1534113wampuses
wamus105514683wam_u_s
wauls86120553_wauls
yamuns11336513yam_uns

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127163995.09322131.6
3Display Results3993990.1263166.7
 (SQL Overall)1786913995.60931857.9
 
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.