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

365 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
jumbos1737912(None) 
dumbos114111081dumbos
gumbos114610871gumbos
jumbo164311071jumbo_
umbos94613071_umbos
ambos95321252_ambos
bimbos124610522bimbos
combos125316612combos
dumbo105614062dumbo_
dumbs105915752dumb_s
gombos114311092gombos
gumbo104413582gumbo_
jambes175914052jambes
jambs166014622jamb_s
jubas144614222ju_bas
jubes145420742ju_bes
jucos144111712ju_cos
judos134711732ju_dos
jumbal1758462jumbal
jumbals18106532jumbals
jumble174012652jumble
jumbles183013322jumbles
jumps165116492jum_ps
juncos15449232juncos
juntos134110842juntos
limbos104712142limbos
mambos125414492mambos
numbs94913092numb_s
rumbas102512012rumbas
sambos104315192sambos
sumos75720092sum_os
turbos8910782turbos
umbo85516662_umbo_
abmhos1334973abmhos
abos67734413__abos
adobos9438453adobos
ambo88225143_ambo_
ammos94815823_ammos
audios72312283audios
ausubos942943ausubos
autos56523323au_tos
bamboo12310013bamboo
bamboos1348753bamboos
bilbos105011203bilbos
bimbo114811873bimbo_
bimboes13498733bimboes
bombes124916823bombes
bombs115818823bomb_s
bos57966813___bos
bubbas94110703bubbas
bubo85621913bu_bo_
buboes104513993bu_boes
bubs86235503bu_b_s
bubus95115453bu_bus
buckos143710893buckos
buffos14447853buffos
bulbous1138293bulbous
bulbs96016933bulb_s
bumble124216893bumble
bumbles134016843bumbles
bumboat1349023bumboat
bumboats1445183bumboats
bumfs125414053bum_fs
bumphs15467103bumphs
bumps115921143bum_ps
bums85934593bum__s
buncos104011593buncos
bunkos124210323bunkos
burbot10815653burbot
burbots1168673burbots
burbs95423493burb_s
burros85114993burros
busboy13307443busboy
busboys14325023busboys
buteos84913413buteos
cameos105818003cameos
camos95927613cam_os
campos125217953campos
carbos105122263carbos
combes125321733combes
combo114519433combo_
combs116122963comb_s
compos124818803compos
crambos1336783crambos
crumbs12409233crumb_s
cubes95028163cu_bes
cubs85832383cu_b_s
cumber124016703cumber
cumbers134515413cumbers
cumbia12379893cumbia
cumbias13338963cumbias
cumbrous1446173cumbrous
cumins103314933cumins
curbs94821653curb_s
curios83218333curios
cussos84210003cussos
custos84014313custos
demobs11429483demobs
demos86022993dem_os
dubs78432193du_b_s
dumas85420433dum_as
dumb97124103dumb__
dumbed124012083dumbed
dumber114414173dumber
dumbest1238743dumbest
dumbly14399603dumbly
dumps105220103dum_ps
duomos936823duomos
duos56728133du__os
duros65422693du_ros
embosk1464863_embosk
emboss1087383_emboss
embow1297563_embow
embows1396823_embows
euros54920243eu_ros
fubs96328793fu_b_s
fugios1037583fugios
fumble133214263fumble
fumbles143514413fumbles
fumers113613383fumers
fumes105224703fum_es
fumets114311813fumets
fynbos1433283fynbos
gambas115817513gambas
gambes116318313gambes
gambol1138223gambol
gambols1238593gambols
gambs105721123gamb_s
gobos86219383_gobos
gombo105814043gombo_
guacos94410313guacos
guanos73811993guanos
guiros7389093guiros
gumboil1244373gumboil
gumboils1343893gumboils
gumboot1246493gumboot
gumboots1344253gumboots
gummas114810513gummas
gummose1235333gummose
gummous1236263gummous
gums75030943gum__s
hobos106321353_hobos
hommos13128503hommos
homos105921783hom_os
hubs96027143hu_b_s
hullos94916293hullos
humans112312433humans
humble133615053humble
humbles143215803humbles
humbly164010523humbly
humbug1434803humbug
humbugs1534243humbugs
hummus1336243hummus
humor101110513hum_or
humors11129633humors
humphs16528163humphs
humps126322803hum_ps
hums96831423hum__s
humus106215073hum_us
iambs95815063iamb_s
iambus10468903iambus
jabot14321513j_abot
jabots1538883j_abots
jabs135830093j_ab_s
jamb155523853jamb__
jambe165314753jamb_e
jambed184811403jambed
jams135231073jam__s
jatos125116823j_atos
jazzbos2442033jazzbos
jellos134714283jellos
jerboa1535633jerboa
jerboas1636163jerboas
jibbs16609743j_ibbs
jibes145520323j_ibes
jibs136724083j_ib_s
jobs136529433j_ob_s
jockos19527563jockos
jomon14610083jom_on
journos14134943journos
juba134916983ju_b_a
jubbah2034353jubbah
jubbahs2143623jubbahs
jube136322783ju_b_e
juco134716203ju_co_
judas134911883ju_das
judges153713463judges
judo125315303ju_do_
jugs125525603ju__gs
jugums16104673jugums
juices1549423juices
jujubes1542083jujubes
jujus11347463ju_jus
jukebox2741383jukebox
jukes165319103ju_kes
jukus16398673ju_kus
juleps1535623juleps
jumbled19379963jumbled
jumbler183910273jumbler
jumblers19358323jumblers
jumbuck2443273jumbuck
jumbucks2542953jumbucks
jump156621723jum__p
jumped183511553jumped
jumper173612373jumper
jumpers18399843jumpers
jumpoff2442243jumpoff
jumpoffs2541203jumpoffs
jumpy195712813jum_py
junco144612203junco_
juncoes16338073juncoes
junior1386143junior
juniors1475783juniors
junks164815973ju_nks
juntas134210503juntas
junto125114563junto_
jupes145218553ju_pes
jupon14479193ju_pon
jupons15377803jupons
jurats134213203jurats
jurels133710583jurels
juries134120633juries
juror1239563ju_ror
jurors1338283jurors
jus106930223ju___s
justs124918263ju_sts
jutes125125133ju_tes
juts115930163ju__ts
kobos115616893_kobos
kombus1435523kombus
kudos105011253ku_dos
kumiss1235923kumiss
kumys1435933kum_ys
kussos10336423kussos
lambs95921413lamb_s
lesbos837403lesbos
limbas105313203limbas
limbo95614813limbo_
limbs96118943limb_s
limbus105710383limbus
limos75320813lim_os
lobos75921843_lobos
lubes74727993lu_bes
lumas75622913lum_as
lumbagos1343073lumbagos
lumbar103610593lumbar
lumbars11289763lumbars
lumber103817773lumber
lumbers113815913lumbers
lumens85013973lumens
lummox1733053lummox
lumps95624983lum_ps
lums65734243lum__s
mambas125716243mambas
mambo115215743mambo_
mamboes135011823mamboes
memos95719113mem_os
mhos95517773__mhos
mimeos104511543mimeos
mobs85737373__mobs
moos66051303__moos
mos57067123__m_os
mumble123614343mumble
mumbles133014433mumbles
mumbly15319463mumbly
mumms85513153mum_ms
mumps115619103mum_ps
mums85732773mum__s
mumus95517283mum_us
mungos94311373mungos
nelumbos1241723nelumbos
nimbus10377283nimbus
nomos75919743nom_os
nubs65927143nu_b_s
numb85520613numb__
numbat10312083numbat
numbats1137673numbats
numbed114111443numbed
number103913223number
numbers113711243numbers
numbest1138793numbest
numbles113814273numbles
numbly134410663numbly
outbox1537463outbox
ouzos143210413ou_zos
ovibos1145463ovibos
plumbous1444283plumbous
plumbs12459333plumb_s
pomos95321583pom_os
pubes94423403pu_bes
pubis94616473pu_bis
pubs85029213pu_b_s
pueblos1134843pueblos
pumas95121563pum_as
pumelos11196093pumelos
pumps115520603pum_ps
puntos85915793puntos
rhumbas14305163rhumbas
rhumbs13366773rhumb_s
romeos84013173romeos
rubes74928413ru_bes
rubs66133493ru_b_s
rubus76415063ru_bus
rumba93612513rumb_a
rumble103718813rumble
rumbles114018393rumbles
rumbly134412163rumbly
rumens83611813rumens
rumor71011323rum_or
rumors81110403rumors
rumps95922293rum_ps
rumpus10458893rumpus
rums64833473rum__s
sambas104219263sambas
sambo95118013sambo_
sjambok2242303sjambok
sjamboks2342233sjamboks
subas74724073su_bas
subs66037123su_b_s
sumacs105512103sumacs
summas104313163summas
summon1037623summon
summons1158003summons
sumo67326313sum_o_
sumps95023433sum_ps
sums65837583sum__s
sunbow1145823sunbow
sunbows1236023sunbows
symbol1336083symbol
symbols1435523symbols
tempos103812293tempos
thumbs13377443thumb_s
tomboy1358213tomboy
tomboys1435713tomboys
tombs97818733tomb_s
tubas75119583tu_bas
tubes74826453tu_bes
tubs65430063tu_b_s
tumble103215643tumble
tumbles113816023tumbles
tumor71110693tum_or
tumors8810613tumors
tumps95420793tum_ps
turbo71015043turbo_
turbot8914263turbot
turbots988023turbots
udos56619903_u_dos
umbel93612843_umbel
umbels104510593_umbels
umber94617593_umber
umbers104215213_umbers
umbles103817493_umbles
umbones1138013_umbones
umbra948513_umbra
umbras1038643_umbras
umps85721943_um_ps
unbox1438753_unbox
uncos74117033_uncos
upbow1245613_upbow
upbows1384683_upbows
updos8389513_updos
urbs65922063_urb_s
wombs125813343womb_s
yobbos1335963yobbos
zombis1936283zombis

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.393454684.5
2DLD Change Limit1127163654.57624632.0
3Display Results3653650.1103318.2
 (SQL Overall)1786913655.07935182.3
 
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.