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

255 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
jumbal175846(None) 
jumbals18106531jumbals
bubal94218212bu_bal
cymbal15236912cymbal
gimbal11228812gimbal
gumball1266832gumball
juba134916982ju_ba_
jubas144614222ju_bas
jubbah2034352jubbah
jugal135612402ju_gal
jumble174012652jumble
jumbo164311072jumb_o
jumbos17379122jumbos
jural125120482ju_ral
lumbar103610592lumbar
numbat10312082numbat
rumba93612512rumba_
rumbas102512012rumbas
sambal105215182sambal
timbal102510752timbal
tombal102311022tombal
tubal75517202tu_bal
tymbal13236822tymbal
umbel93612842_umbel
umbral1038632_umbral
adumbral1342343adumbral
atabal839743atabal
audial7312993audial
aural54428963au_ral
bal56662723___bal
barbal104016663barbal
bombax1935753bombax
brumal1049503brum_al
bubale104014623bu_bale
bubals103513843bu_bals
bubba84311803bubba_
bubbas94110703bubbas
buccal1248243buccal
bulbar1039583bulbar
bulbel104510683bulbel
bulbil10389573bulbil
bulbul10348073bulbul
bumble124216893bumble
bumboat1349023bumboat
bummalo1353793bummalo
burial84117623burial
bursal84414823bursal
busbar1038453busbar
cabal95222153_cabal
cambial134010763cambial
cembali13156043cembali
cembalo13145533cembalo
comal95125133com_al
combat12316753combat
cumber124016703cumber
cumbia12379893cumbia
cumbias13338963cumbias
cuneal8611513cuneal
curial84019153curial
curtal83914543curtal
cuspal1037883cuspal
cymbals16236143cymbals
domal85619203dom_al
dual55928173du__al
ducal84816423du_cal
ductal938993ductal
duma75524453dum_a_
dumas85420433dum_as
dumb97124103dumb__
dumbed124012083dumbed
dumber114414173dumber
dumbly14399603dumbly
dumbo105614063dumb_o
dumbos114111083dumbos
dumbs105915753dumb_s
dumka12438833dumka_
dural64923893du_ral
durbar968723durbar
embalm1236653_embalm
embar94011603_embar
embay123410603_embay
fubar1039923fu_bar
fugal95613033fu_gal
fumble133214263fumble
fungal10388733fungal
gamba106018513gamba_
gambas115817513gambas
gambol1138223gambol
gimbals12257823gimbals
gimmal11247513gimmal
global937663global
gumballs1345313gumballs
gumbo104413583gumb_o
gumboil1244373gumboil
gumbos114610873gumbos
gumma105313103gumma_
gummas114810513gummas
hamal104623113ham_al
hammal134512063hammal
hemal104419803hem_al
herbal112513493herbal
human102716033hum_an
humble133615053humble
humbly164010523humbly
humbug1434803humbug
humeral1238563humeral
humoral1237973humoral
hymnal1434913hymnal
imbalm1246323_imbalm
jacal14313703j_acal
jackal1937613jackal
jamb155523853jamb__
jambe165314753jamb_e
jambeau1843773jambeau
jambed184811403jambed
jambes175914053jambes
jambs166014623jamb_s
jebel145612143j_ebel
jingal1498593jingal
joual12311653j_oual
journal1484963journal
jovial1636543jovial
jubbahs2143623jubbahs
jube136322783ju_b_e
jubes145420743ju_bes
jubhah2142803jubhah
jubile152910263ju_bile
judas134911883ju_das
juga126417323ju_ga_
jugful1734603jugful
jugula1434983jugula
jumbled19379963jumbled
jumbler183910273jumbler
jumbles183013323jumbles
jumbuck2443273jumbuck
jump156621723jum__p
jumpable2143953jumpable
jumped183511553jumped
jumper173612373jumper
jumpily2174983jumpily
jumps165116493jum_ps
jumpy195712813jum_py
junta123713673junta_
juntas134210503juntas
jura116024893ju_ra_
jurat124829323ju_rat
jurel124516333ju_rel
juvenal1743393juvenal
kummel14266173kummel
limba95414983limba_
limbas105313203limbas
luma65527523lum_a_
lumas75622913lum_as
lumbago1243833lumbago
lumbars11289763lumbars
lumber103817773lumber
lumenal9307273lumenal
luminal93711003luminal
luteal64411483luteal
mamba116317523mamba_
mambas125716243mambas
mammal95112753mammal
meal65643173__meal
mimbar1297493mimbar
mughal1236273mughal
mumble123614343mumble
mumbly15319463mumbly
mural75225113mu_ral
mutual838503mutual
nuchal11218873nuchal
numb85520613numb__
numbats1137673numbats
numbed114111443numbed
number103913223number
numbly134410663numbly
numbs94913093numb_s
numeral939083numeral
outbawl1237473outbawl
pibal95217323_pibal
pulpal10408453pulpal
puma85424123pum_a_
pumas95121563pum_as
pummel12278043pummel
pupal97616873pu_pal
quezal2435143quezal
ramal74622243ram_al
rambla103510933rambla
rhumba13375553rhumba_
rhumbas14305163rhumbas
rubel75416833ru_bel
rugal65916093ru_gal
rumbaed12287493rumbaed
rumble103718813rumble
rumbly134412163rumbly
ruminal9289993ruminal
rural55821173ru_ral
rurban849043rurban
sabal75422483_sabal
samba95618773samba_
sambals115213483sambals
sambar103914163sambar
sambas104219263sambas
scumbag1443573scumbag
suba64926603su_ba_
subah106015213su_bah
subas74724073su_bas
sulcal8311273sulcal
sumac99514883sum_ac
summa94713313summa_
summae103911013summae
summas104313163summas
sural55931263su_ral
symbol1336083symbol
tamal73522623tam_al
tambac122210243tambac
tambak14249263tambak
tambala1138023tambala
timbale11248803timbale
timbals11239533timbals
timbral11237193timbral
tombac12258883tombac
tombak14237753tombak
tribal8611133tribal
tuba65422363tu_ba_
tubae74716643tu_bae
tubas75119583tu_bas
tumble103215643tumble
tumbrel11406853tumbrel
tumbril11256403tumbril
tumoral938133tumoral
turban8310483turban
tussal6288323tussal
tymbals14265723tymbals
umbels104510593_umbels
umber94617593_umber
umbo85516663_umb_o
umbonal1144383_umbonal
umbos94613073_umbos
umbra948513_umbra
umbrae1038683_umbrae
umbras1038643_umbras
umiac938963_umiac
umiak1137673_umiak
umiaq1656823_umiaq
unbale83616403_unbale
unban72114333_unban
unbar71913613_unbar
urban72013863_urban
ureal56722683_ureal
urial54823023_urial
usual5310183_usual
uveal84411073_uveal
verbal112513663verbal
vulval12417663vulval
wombat1339863wombat

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.376475242.0
2DLD Change Limit1127162555.15621861.1
3Display Results2552550.0763355.3
 (SQL Overall)1786912555.60831863.6
 
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.