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

292 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
doblon93801(None) 
doblons1037041doblons
dobson936591dobson
colon78630192co_lon
diobolon1143192diobolon
dobbin11339522dobbin
dobla84913642dobl_a
doblas93812292doblas
doblones1136762doblones
dobro84412212dobro_
dobros93910232dobros
dobsons1036202dobsons
dollop9259362dollop
dolor67617962do_lor
donjon1436462donjon
doubloon1143272doubloon
goblin939502goblin
oblong935382_oblong
orlon5415002_orlon
solon55026132so_lon
aboon74918703_aboon
adobo84711593adob_o_
adobos9438453adob_os
azlon144312873_azlon
baboon103613913baboon
ballon84117493ballon
belon73924113_belon
billon83713833billon
blin67228173__blin
blob86027093__blob
bloc85023273__bloc
blog75723823__blog
blond85618373__blond
blot65842323__blot
blow95827193__blow
blown105716673__blown
bobbin93410733bobbin
bollox1548743bollox
bolo65535953bo_lo_
bolos75531373bo_los
bolson8410683bolson
bonbon10310073bonbon
boon67142173__boon
boron76727143bo_ron
boson76019733bo_son
boston8513043boston
bouton8311533bouton
clon66232483__clon
coble94823173cobl_e
cobles104622883cobles
cocoon10312263cocoon
codlin94516443codlin
codon86522853co_don
coelom10310423coelom
cogon89120903co_gon
colin76231693co_lin
collop107312313collop
colog86619933co_log
colone85425003co_lone
coloni85619203co_loni
colons86028683co_lons
colony115417273co_lony
color76123743co_lor
common12310803common
coon67248943co__on
coplot10518273coplot
cordon95017293cordon
cotton8312993cotton
coupon102810993coupon
dacron94310693dacron
daemon9279593daemon
dahoon1039053dahoon
daikon11217243daikon
daimon9259713daimon
dalton7311273dalton
damson938063damson
daylong1233973daylong
deacon9510423deacon
debone93714783deb_one
debtor938333debtor
demon86520313d_emon
deploy1237583deploy
devon95113683d_evon
dialog837973dialog
diglot83014333diglot
diobol936883diob_ol
diobolons1243123diobolons
diobols1036543diobols
diploe9810153diploe
diplont10311693diplont
diuron738573diuron
doable93115243doabl_e
dobber114015423dobber
dobbins12379533dobbins
dobby136013633dob_by
dobie84920333dob_ie
dobies94422093dobies
dobra85013103dob_ra
dobras94811913dobras
doby106022163dob__y
doctor938993doctor
dodo66024913do_do_
dodos75819393do_dos
dogdom1186363dogdom
doggo84410703doggo_
doggone1035683doggone
dogleg936323dogleg
doiled84817293doiled
doily95321033doil_y
dojo126016143do_jo_
dojos135111793do_jos
dol47150653do_l__
dolce85816683do_lce
dolci84912603do_lci
dole56550003do_l_e
doled75430913do_led
doles67843753do_les
doling84923133do_ling
doll56632493do_l_l
dollar74110983dollar
dolled83518073dolled
dolling93817373dolling
dollops10287963dollops
dolls66126923do_lls
dolly96125203do_lly
dolma86214173do_lma
dolman95312403dolman
dolmen93911373dolmen
dolors75115313do_lors
dolour75710133do_lour
dols56943053do_l_s
dolt56649423do_l_t
dolts65626313do_lts
domain9511323domain
domino92611493domino
don46757653d___on
donjons1536733donjons
donor64418193do_nor
doodoo8108893doodoo
doolee73018953doolee
doolie73916833doolie
dooly94821803dool_y
doom76430073do__om
door56928513do__or
doowop1283853doowop
dormin9312313dormin
double94013993doubl_e
doubled11289953doubled
doubler103110083doubler
doubles103113353doubles
doublet103914033doublet
doubleton1252843doubleton
doubling1238153doubling
doubloons1242823doubloons
doubly12328963doubl_y
doula65717773doul_a
doulas75114993doulas
doven94718553do_ven
down86427493do__wn
doyen95014413do_yen
doyley13487283doyley
doyly124514013doyl_y
dozen155017473do_zen
dragon838843dragon
dromon939363dromon
drylot1037403drylot
dubbin11329263dubbin
dunlin739723dunlin
duolog835803duolog
durion7510963durion
ebon66821103_eb_on
eidolon844913eido_lon
eobiont959943eobiont
etalon648973etalon
felon84619293_felon
foison948933foison
follow124010353follow
forlorn1096423forlorn
gabion93211033gabion
gaboon93211773gaboon
gallon73715813gallon
gibbon1135323gibbon
gibson935123gibson
goban84414073gob_an
goblet93219483goblet
goblins1039243goblins
gobo76126903gob_o_
gobony1236913gob_ony
gobos86219383gob_os
godson857383godson
gonion73612833gonion
goon57236173go__on
gorgon8310243gorgon
halon86124863_halon
hobnob1335133hobnob
hobo97026083hob_o_
hobos106321353hob_os
hollo84822163hollo_
holloa94914823holloa
holloo94415253holloo
hollos95320633hollos
hollow124212663hollow
jomon14610083jo_mon
kobo107422103kob_o_
kobold1365963kobold
kobos115616893kob_os
kolo87026223ko_lo_
kolos94921213ko_los
lobo67229863lob_o_
lobos75921843lob_os
logion76013723logion
logon615922313lo_gon
lollop8238783lollop
loon47344793lo__on
lotion65716523lotion
melon73922083_melon
merlon83012353merlon
mobled113213183mobled
moon67140813mo__on
morion86217733morion
moron76925423mo_ron
motion85217553motion
mouflon12104083mouflon
moulin8313283moulin
mouton8410853mouton
noble74420993nobl_e
nobler83713453nobler
nobles83319723nobles
nobly105314403nobl_y
nolo46229313no_lo_
nolos54423353no_los
noon47134623no__on
notion64516583notion
nylon82910513_nylon
oblongs1033533_oblongs
oboe66822943_ob_oe
obol65220613_ob_ol
obole75917143_obole
oboli73712873_oboli
obols73715863_obols
odeon6411483_odeon
onion54320973_onion
oolong738073_oolong
orlons6411013_orlons
orlop7410903_orlop
pelon74423213_pelon
phylon14318033phylon
poblano1145093poblano
poboy121612223pob_oy
poison8312223poison
pollen83416453pollen
polo66236633po_lo_
polos76129913po_los
pompon1238943pompon
ponton83217643ponton
poon67341263po__on
poplin10413483poplin
potion84519573potion
pylon103614003_pylon
ribbon1036533ribbon
robalo838933robalo_
robalos937683robalos
robbin103611183robbin
robin74820283rob_in
roble75223023robl_e
robles85321693robles
robot7325973rob_ot
ronion63315643ronion
ronyon9309133ronyon
salon55228553_salon
solan55328153so_lan
solion6616383solion
solo45538943so_lo_
solons65120023so_lons
solos54830793so_los
soon46240503so__on
stolon64112073stolon
sublot82315523sublot
talon55824113_talon
teflon937453teflon
tiglon737923tiglon
tolan55124013to_lan
toon47740633to__on
toyon86715673to_yon
voudon1035873voudon
weblog1234223weblog
wonton93410963wonton
woolen93111373woolen
yobbo1237873yobbo_
yobbos1335963yobbos
youpon11366003youpon
zoon137326983zo__on

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.1401276364.3
2DLD Change Limit1127162925.26621404.5
3Display Results2922920.0933139.8
 (SQL Overall)1786912925.49932495.2
 
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.