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

500 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
plumbs1245933(None) 
plumb114514071plumb_
plumes104318131plumes
plumps124612611plumps
plums94619951plum_s
alums75720602alum_s
aplombs1343262aplombs
blubs95818152blu_bs
blumes105917792blumes
blurbs10489312blurbs
climbs12498722climbs
clubs95415102clu_bs
clumps1215314642clumps
crumbs12409232crumbs
dumbs105915752_dumbs
flubs105515442flu_bs
flumes115119732flumes
flumps135112502flumps
glumes94516812glumes
glums84621422glum_s
lambs95921412_lambs
limbs96118932_limbs
lumas75622912_lumas
lumps95624982_lumps
lums65734242_lum_s
numbs94913092_numbs
plebs95814582pl_ebs
plucks14379732plucks
plugs85213492plu_gs
plum85122102plum__
plumbed14317272plumbed
plumber13339982plumber
plumbers14418512plumbers
plumbic1543962plumbic
plumbism1643812plumbism
plumbous1444282plumbous
plumbum1543732plumbum
plumbums1642942plumbums
plume94819462plum_e
plumed114412882plumed
plummy15375662plummy
plumose1135962plumose
plump115315262plum_p
plumy124213232plum_y
plunks124711162plunks
plus66324832plu__s
pluses83618072pluses
pubs85029212p_u_bs
pumas95121562p_umas
pumps115520602p_umps
replumbs1442182replumbs
rhumbs13366772rhumbs
slubs74719532slu_bs
slumps104313582slumps
slums74623432slum_s
slurbs8439742slurbs
thumbs13377442thumbs
alamos8415003alamos
albs68628573al__bs
albums10198273album_s
algums9208043algum_s
almas76629773al_mas
almes75126543al_mes
alms65834923al_m_s
almuds9378773almuds
almugs9396423almugs
alum65227613alum__
alumin8513543alumin
alumins9512983alumins
alumna857343alumna
alumni856753alumni
alumnus935223alumnus
aplomb1236203aplomb_
arums75517833arum_s
bedumbs1433633bedumbs
benumbs1333543benumbs
blabs95619633bl_abs
blames105121863blames
blams95023853blam_s
blebs96416153bl_ebs
blimps12588153blimps
blobs95620033bl_obs
blub85324873blu_b_
blues75127043blu_es
bluets87215493bluets
blueys11419523blueys
bluffs14388373bluffs
blume95619893blum_e
blumed114313643blumed
blunts84512893blunts
blurb95214903blurb_
blurs74619083blu_rs
blurts84412643blurts
bombs115818823_bombs
brumby15385953brumby
brumes106417073brumes
bubs86235493_bu_bs
bulbs96016933_bulbs
bumfs125414053_bumfs
bumps115921143_bumps
bums85934593_bum_s
burbs95423493_burbs
chimbs153910303chimbs
chubs125412623chu_bs
chumps154313823chumps
chums125015833chum_s
clamps124515083clamps
clams95127673clam_s
climb115413593climb_
climes104720003climes
clomb115714703clomb_
clomps125212233clomps
club85819473clu_b_
clubby1534683clubby
clucks144512073clucks
clues74623033clu_es
clumber134011443clumber
clumbers143910393clumbers
clump115517453clum_p
clumpy15409573clumpy
clumsy13326193clumsy
clunks124811013clunks
columns1136473columns
combs116122963_combs
coombs124210193coombs
crumb114313593crumb_
crumby15408113crumby
crumps124514343crumps
cubs85832383_cu_bs
culms95314193culm_s
curbs94821653_curbs
daubs85014563dau_bs
deplumes1334943deplumes
doumas95314813doumas
doums85417643doum_s
drubs85913833dru_bs
drums85415873drum_s
dubs78432193_du_bs
dumas85420433_dumas
dumb97124103_dumb_
dumbo105614063_dumbo
dumbos114111083_dumbos
dumps105220103_dumps
elemis8312383elemis
elms67322703el_m_s
eludes75417683eludes
elutes64020313elutes
exurbs1534423exurbs
flabs105818643fl_abs
flambe13489153flambe
flambes14419503flambes
flames114723693flames
flams105125013flam_s
flub95721883flu_b_
flues84626923flu_es
fluffs11347783fluffs
fluids10349423fluids
flukes135114193flukes
flume106021173flum_e
flumed124915263flumed
flump124614723flum_p
flunks13469863flunks
fluors94311373fluors
flus75626543flu__s
flutes95421783flutes
fluxes165212933fluxes
fluyts12367153fluyts
frumps13479783frumps
fubs96328793_fu_bs
fumes105224703_fumes
gambs105721123_gambs
gaums86217073gaum_s
geums85414113geum_s
glams85822933glam_s
glimes94717523glimes
glims87417673glim_s
globs85616403gl_obs
gloms85219783glom_s
glomus9468093glomus
gluers75011153gluers
glues65125683glu_es
glugs75214283glu_gs
glum75825103glum__
glume85120463glum_e
glumly12356623glumly
glumpy14527193glumpy
gluons738503gluons
glutes74517673glutes
gluts66120133glu_ts
grubs86312603gru_bs
grumes94415553grumes
grumps114510573grumps
gumbo104413583_gumbo
gumbos114610873_gumbos
gums75030943_gum_s
hubs96027143_hu_bs
humps126322803_humps
hums96831423_hum_s
humus106215073_humus
iambs95815053_iambs
illumes9327673illumes
jambs166014623_jambs
jumbo164311073_jumbo
jumbos17379123_jumbos
jumps165116493_jumps
kluges11389563kluges
koumis1237613koumis
koumys1543303koumys
kumys1435933_kumys
labs67145123_l_abs
lamas75532793_lamas
lamb86832143_lamb_
lamby125114843_lamby
lames75445543_lames
lamps95624833_lamps
lams66552263_lam_s
libs66732753_l_ibs
limas75627633_limas
limb85429373_limb_
limba95414973_limba
limbas105313193_limbas
limbi96513793_limbi
limbo95614803_limbo
limbos104712133_limbos
limbus105710373_limbus
limby125714063_limby
limes75636503_limes
limns75718393_limns
limos75320813_limos
limps95522673_limps
llamas888973llamas
lobs66441083_l_obs
loumas84812333loumas
luaus54514903_luaus
lube64731563_lu_be
lubes74727993_lubes
luces75528433_luces
lucks115723563_lucks
ludes65728853_ludes
lues45943553_lu_es
luffs114516283_luffs
luges65928753_luges
lugs55233523_lu_gs
lulls54119653_lulls
lulus54315163_lulus
lum55542933_lum__
luma65527523_lum_a
lumbar103610593_lumbar
lumbars11289763_lumbars
lumber103817773_lumber
lumbers113815913_lumbers
lumen75220903_lumen
lumens85013973_lumens
lump86531703_lum_p
lumpy126615913_lumpy
lunas55025013_lunas
lunes55337773_lunes
lungs65223883_lungs
lunks94822453_lunks
lunts55826903_lunts
lupus74512523_lupus
lures56138533_lures
lurks95218743_lurks
lusts55022803_lusts
lusus54813873_lusus
lutes55836663_lutes
luvs75818503_lu_vs
luxes124921503_luxes
mumms85513153_mumms
mumps115619103_mumps
mums85732773_mum_s
mumus95517283_mumus
nelumbo1142663nelumbo
nelumbos1241723nelumbos
neumes83112623neumes
neums75414253neum_s
nubs65927143_nu_bs
numb85520613_numb_
oleums8358783oleum_s
opiums10307073opium_s
pablums1345123pablum_s
palms94921753palm_s
pams85641763p_am_s
pauses84621473pauses
peplums13145503peplum_s
perms95524513perm_s
phuts104613503phu_ts
pilules9510623pilules
pilus75921063pilu__s
pimas94725103p_imas
pimps114616983p_imps
places104323703places
placks144414153placks
plages94520153plages
plaids94312443plaids
plains85019593plains
plaits83816473plaits
planes85028083planes
planks124116753planks
plans75731273pl_ans
plants84921803plants
plasmas113010753plasmas
plasms103711333plasms
plates85432243plates
plats75531373pl_ats
platys11459853platys
playas114612283playas
plays106320773pl_ays
plazas17409913plazas
pleads94613953pleads
pleas75627033pl_eas
pleats85218593pleats
pleb86123813pl_eb_
plebe95014873pl_ebe
plebes104313623plebes
plenums1136533plenum_s
pleons84213343pleons
pleuras937413pleuras
plews105415353pl_ews
plexes155313533plexes
plexus15377283plexus
pliers84715153pliers
plies74526513pl_ies
plinks124913263plinks
plods85719293pl_ods
plonks124210423plonks
plops95920333pl_ops
plots75025673pl_ots
ploughs13526103ploughs
plows105419903pl_ows
ploys105816593pl_oys
pluck134212303plu_ck
plucky17406583plucky
plug74915993plu__g
plumage1245503plumage
plumages1335653plumages
plumate1149803plumate
plumbago1542013plumbago
plumbagos1641673plumbagos
plumbeous1542903plumbeous
plumbery17315533plumbery
plumbing15286433plumbing
plumbings16213363plumbings
plumbisms1742943plumbisms
plumbness1543133plumbness
plumier113510043plumier
plumiest122110293plumiest
pluming123412043pluming
plummer13298523plummer
plummest14276413plummest
plummet13278353plummet
plummets14304773plummets
plumped14318643plumped
plumpen13276403plumpen
plumpens14304953plumpens
plumper13318773plumper
plumpers14357293plumpers
plumpest14236353plumpest
plumpish17164733plumpish
plumply1634223plumply
plumule1134303plumule
plumules1234663plumules
plunge93811053plunge
plunges104011613plunges
plunk114514403plu_nk
plunky15377953plunky
plural839823plural
plurals936913plurals
plush105614713plu_sh
plushes124313673plushes
plushy14406973plushy
plusses93510693plusses
plutei8408903plutei
pluteus9326243pluteus
pluton838853pluton
plutons938343plutons
plyers114912983plyers
pneumas1145103pneumas
poems95715553poem_s
pomes94833933p_omes
pomos95321583p_omos
pomps115316193p_omps
poms87037743p_om_s
pouffs14418123pouffs
poufs105616063pou_fs
poults84613483poults
pounds93714383pounds
pours74623183pou_rs
pouts75530323pou_ts
prams96125513pram_s
primas104418103primas
primes104225263primes
primos104514423primos
primps124711823primps
prims95425933prim_s
primus103712173primus
promos105116423promos
proms95426403prom_s
prudes94215443prudes
prunes83419063prunes
prunus8399363prunus
pub76037693p_u_b_
pubes94423403p_ubes
pubis94616463p_ubis
puces94924633p_uces
pucks134322103p_ucks
puds75630513p_u_ds
puffs134114933p_uffs
pugs76332773p_u_gs
pujas145513323p_ujas
pukes114523023p_ukes
pulers83820283pulers
pules74538813p_ules
pulis74225603p_ulis
pulls74425053p_ulls
pulps95116483p_ulps
puls65437563p_u_ls
pulses83818663pulses
puma85424123p_um_a
pump105726853p_um_p
punas74826753p_unas
pungs85422223p_ungs
punks114822683p_unks
puns66641483p_u_ns
punts75828003p_unts
pupas95219283p_upas
pups86032233p_u_ps
pupus94614043p_upus
puris75332023p_uris
purls74723353p_urls
purrs75320433p_urrs
purs65641043p_u_rs
pus55547843p_u__s
puses75532203p_uses
puss64830133p_u_ss
puts65641753p_u_ts
putts75719273p_utts
relumes9612513relumes
replumb1343393replumb_
rhombs13336493rhombs
rhumb12438653rhumb_
rhumba13375553rhumba
rhumbas14305163rhumbas
rubs66133493_ru_bs
rumba93612513_rumba
rumbas102512013_rumbas
rumps95922293_rumps
rums64833473_rum_s
scums95017423scum_s
shlubs11386733shlu_bs
shlumps1434143shlumps
slabs75322643sl_abs
slams74927903slam_s
slimes84722043slimes
slims75423653slim_s
slobs74419873sl_obs
slub65428033slu_b_
slues54527173slu_es
sluffs12349583sluffs
slugs64618563slu_gs
slum65430513slum__
slumber113811003slumber
slumbers123110273slumbers
slumism1136513slumism
slummy13325863slummy
slump94816633slum_p
slurb74116323slurb_
slurps84410003slurps
slurs54123373slu_rs
sluts54523983slu_ts
snubs75412553snu_bs
solums85211333solum_s
spumes1021314883spumes
squabs17429323squabs
squibs17317443squibs
stubs75016073stu_bs
stumps104912283stumps
stums75320083stum_s
subs66037123_su_bs
sumos75720093_sumos
sumps95023433_sumps
sums65837583_sum_s
thumb124511283thumb_
thumps13449353thumps
tombs97818733_tombs
trumps104611883trumps
tubs65430063_tu_bs
tumps95420793_tumps
ulamas8910453ulamas
ulemas888963ulemas
ulus45622563ulu__s
umbo85516653__umbo
umbos94613063__umbos
umps85721943__umps
upclimbs1641363upclimbs
urbs65922053__urbs
volumes12298233volumes
whumps16427093whumps
wombs125813343_wombs
ylems1039263ylem_s

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 Filter1786911127160.1431249587.4
2DLD Change Limit1127165005.86019234.8
3Display Results5005000.1563205.1
 (SQL Overall)1786915006.15929013.0
 
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.