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

444 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
gumbos11461087(None) 
dumbos114111081dumbos
gombos114311091gombos
gumbo104413581gumbo_
jumbos17379121jumbos
umbos94613071_umbos
ambos95321252_ambos
bimbos124610522bimbos
combos125316612combos
dumbo105614062dumbo_
dumbs105915752dumb_s
gambas115817512gambas
gambes116318312gambes
gambol1138222gambol
gambols1238592gambols
gambs105721122gamb_s
gobos86219382g_obos
gombo105814042gombo_
guacos94410312guacos
guanos73811992guanos
guiros7389092guiros
gumboil1244372gumboil
gumboils1343892gumboils
gumboot1246492gumboot
gumboots1344252gumboots
gummas114810512gummas
gummose1235332gummose
gummous1236262gummous
gums75030942gum__s
jumbo164311072jumbo_
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
gabbros12124653gabbros
gabs76740423g_ab_s
gamas85431363gam_as
gamays126310913gamays
gamb96331843gamb__
gamba106018513gamb_a
gambados1444153gambados
gambe106219213gamb_e
gambia115912253gambia
gambias125010733gambias
gambir11509773gambir
gambirs12359083gambirs
gambit114714213gambit
gambits12399723gambits
gamble115417183gamble
gambles124016203gambles
gamboge1335583gamboge
gamboges1435653gamboges
gamers94420833gamers
games86238553gam_es
gamins94420043gamins
gammas115714693gammas
gammon1138903gammon
gammons1237973gammons
gamps105323713gam_ps
gams76648883gam__s
gamuts958783gamuts
garbs86321413garb_s
gauchos1345903gauchos
gaums86217073gaum__s
gazabos1944453gazabos
gazebos1933493gazebos
gazoos163010223gazoos
geckos13457433geckos
gemot84024233gem_ot
gemots93712153gemots
gems75329113gem__s
gemsbok1642063gemsbok
gemsboks1742013gemsboks
genros74211333genros
geums85414113geum__s
gibbon1135323gibbon
gibbons1234983gibbons
gibbose1244083gibbose
gibbous1265333gibbous
gibes84422523g_ibes
gibs75529273g_ib_s
gimbal11228813gimbal
gimbals12257823gimbals
gimels938893gimels
gimmes113010903gimmes
gimps105915203gim_ps
giros65722653g_iros
gismos957183gismos
gizmos1844133gizmos
glebes95512243glebes
globes94314543globes
globose1035543globose
globous1036503globous
globs85616403glob_s
glumes94516813glum_es
glums84621423glum__s
gobo76126903g_obo_
goboes95914443g_oboes
gobs76935573g_ob_s
gogos77516523g_ogos
gomers94116883gomers
goos57644913g__oos
gos47155133g___os
grabs85719693grab_s
grebes93813613grebes
gregos847533gregos
grubs86312603grub_s
grumble12349233grumble
grumbles13288873grumbles
grumbly15355403grumbly
grumes94415553grum_es
grumose1035723grum_ose
grumous1086613grumous
grumps114510573grum_ps
guaco85012163guaco_
guano69213983guano_
guans64419443gu_ans
guards84611573guards
guars65021053gu_ars
guavas1037163guavas
gucks123917303gu_cks
gudes74520813gu_des
guenon736403guenon
guenons836563guenons
guess64213363gu_ess
guests74311203guests
guffs124414823gu_ffs
guides84118283guides
guidon837373guidon
guidons936623guidons
guids75516153gu_ids
guilds8388353guilds
guiles73919283guiles
guilts74111233guilts
guimpes1245073guimpes
guiro63712093guiro_
guises74216313guises
gulags837543gulags
gules64831043gu_les
gulfs94915303gu_lfs
gulls65222983gu_lls
gulps84715073gu_lps
guls55930853gu__ls
gum67439533gum___
gumball1266833gumball
gumballs1345313gumballs
gumbotil1342073gumbotil
gumbotils1451743gumbotils
gumdrop1342513gumdrop
gumdrops1442823gumdrops
gumless10228273gumless
gumma105313103gum_ma
gummed123811663gummed
gummer114615453gummer
gummers123712203gummers
gummoses1344743gummoses
gummosis1343713gummosis
gummy135413653gum_my
gumshoe1343663gumshoe
gumshoes1444123gumshoes
gumwood14114043gumwood
gumwoods15123923gumwoods
gunboat1047363gunboat
gunboats1144823gunboats
gundog935793gundog
gundogs1034603gundogs
gunks104517723gu_nks
guns55533483gu__ns
gurges84716863gurges
gurus64318193gu_rus
gushes104719033gushes
gusto65414643gusto_
gustoes879873gustoes
gusts65722793gu_sts
guts56637253gu__ts
guvs85816813gu__vs
guyot9314523gu_yot
guyots1036003guyots
guys85019643gu__ys
gybes115012723g_ybes
gyms107514593gym__s
gyros95616483g_yros
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
jambes175914053jambes
jambs166014623jamb_s
jubas144614223ju_bas
jubes145420743ju_bes
jucos144111713ju_cos
judos134711733ju_dos
jumbal1758463jumbal
jumbals18106533jumbals
jumble174012653jumble
jumbles183013323jumbles
jumps165116493jum_ps
juncos15449233juncos
juntos134110843juntos
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_
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
urbs65922053_urb_s
wombs125813343womb_s
yobbos1335963yobbos
zombis1936283zombis

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.420425454.8
2DLD Change Limit1127164445.67319868.9
3Display Results4444440.1562846.2
 (SQL Overall)1786914446.24928595.1
 
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.