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

261 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
doblons103704(None) 
doblon938011doblon_
doblones1136761doblones
dobsons1036201dobsons
colons86028682co_lons
diobolons1243122diobolons
dobbins12379532dobbins
doblas93812292dobl_as
dobros93910232dobro_s
dobson936592dobson_
dollops10287962dollops
dolors75115312do_lors
donjons1536732donjons
doubloons1242822doubloons
goblins1039242goblins
oblong935382_oblong
oblongs1033532_oblongs
orlons6411012_orlons
solons65120022so_lons
ablins8316193_ablins
adobos9438453adob_o_s
aiblins9311473aiblins
azlons154110423_azlons
baboons113211073baboons
ballons93916963ballons
belons84119413_belons
billons93013363billons
blobs95620033__blobs
blocs95219653__blocs
blogs85319233__blogs
blond85618373__blond
blonds95213343__blonds
blots75626173__blots
blows105423833__blows
bobbins103410343bobbins
bolos75531373bo_lo_s
bolsons969483bolsons
bonbons1139333bonbons
boons75031913__boons
borons85520543bo_rons
bosons85016653bo_sons
bostons9312903bostons
boutons9310783boutons
clons75228133__clons
cobles104622883cobl_es
cocoons11310563cocoons
codlins104116243codlins
codons96119463co_dons
coeloms1139063coeloms
cogons96818113co_gons
colins85229043co_lins
collins93419833collins
collops112611753collops
cologs96517353co_logs
colon78630193co_lon_
colone85425003co_lone
colones96124433co_lones
coloni85619203co_loni
colonus94413443co_lonus
colony115417273co_lony
colors86622373co_lors
commons13311043commons
coons76737283co__ons
coplots11511593coplots
cordons104415763cordons
cottons9312193cottons
coupons112710563coupons
dacrons103211033dacrons
daemons10269233daemons
dahoons1137753dahoons
daikons12186693daikons
daimons10249323daimons
daltons8310403daltons
damsons1038013damsons
daylong1233973daylong
deacons10310393deacons
debone93714783deb_one
debones103315113deb_ones
debtors1038533debtors
demons94917723d_emons
deploys1336523deploys
devons104512253d_evons
dialogs938103dialogs
diglots9299503diglots
diobolon1143193diobolon_
diobols1036543diob_ols
diploes101111493diploes
diplont10311693diplont
diplonts1146473diplonts
diurons838823diurons
dobbers123513243dobbers
dobbies124113063dobbies
dobbin11339523dobbin_
dobies94422093dob_ies
dobla84913643dobl__a
dobras94811913dob_ras
dobro84412213dobro__
doctors1039993doctors
dodoes85716103do_does
dodos75819393do_do_s
dogdoms1295423dogdoms
doggone1035683doggone
doggones1135713doggones
doglegs1034783doglegs
doilies84017363doilies
dojos135111793do_jo_s
doles67843753do_l_es
doling84923133do_ling
dollars83311023dollars
dollies83620983dollies
dolling93817373dolling
dollop9259363dollo_p
dolls66126923do_l_ls
dolmans10479683dolmans
dolmas95213043do_lmas
dolmens10388693dolmens
dolor67617963do_lo_r
dolour75710133do_lour
dolours8438823do_lours
dols56943053do_l__s
dolts65626313do_l_ts
domains10510873domains
dominos103210193dominos
donjon1436463donjon_
donors75115793do_nors
dons56048703d___ons
doodoos9107623doodoos
doolees83711613doolees
doolies83920713doolies
dooms85321343do__oms
doors65022133do__ors
doowops1363943doowops
dormins10311273dormins
doublers11288503doublers
doubles103113353doubl_es
doubletons1352863doubletons
doublets11257363doublets
doubling1238153doubling
doubloon1143273doubloon
doulas75114993doul_as
dovens104413903do_vens
downs94918573do__wns
doyens104810223do_yens
doyleys14384923doyleys
doylies114512573doylies
dozens164612463do_zens
dragons938383dragons
dromons1038193dromons
drylots1143743drylots
dubbins12358803dubbins
dubious1036893dubious
dunlins849553dunlins
duologs935363duologs
durions839963durions
ebons74316093_eb_ons
eidolons944983eido_lons
eobiont959943eobiont
eobionts1043983eobionts
etalons739073etalons
felons93615763_felons
foisons1047613foisons
follows13409923follows
gabions102410053gabions
gaboons10289893gaboons
gallons83015953gallons
gibbons1234983gibbons
gibsons1045043gibsons
gobans94412043gob_ans
goblets103210183goblets
goblin939503goblin_
goboes95914443gob_oes
gobony1236913gob_ony
gobos86219373gob_o_s
godsons966663godsons
goons65326773go__ons
gorgons938853gorgons
halons95720713_halons
hobnobs1443603hobnobs
hoboes114717443hob_oes
hobos106321353hob_o_s
holloas103814943holloas
holloes103818193holloes
holloos104013583holloos
hollos95320633hollo_s
hollows134412333hollows
jobless16237563jobless
kobolds1474343kobolds
kobos115616893kob_o_s
kolos94921213ko_lo_s
lobos75921843lob_o_s
logions86211293logions
logons79818173lo_gons
lollops9227443lollops
loons55731723lo__ons
lotions74614763lotions
melons84117713_melons
merlons93311273merlons
moons75331003mo__ons
morions94014643morions
morons84919543mo_rons
motions94215003motions
mouflons13133653mouflons
moulins9312703moulins
moutons9410313moutons
nobles83319723nobl_es
nolos54423353no_lo_s
noons54125283no__ons
notions74014483notions
nylons9267973_nylons
oboes75717713_ob_oes
oboles83815833_oboles
obols73715863_ob_ols
obolus8378813_obolus
odeons739023_odeons
onions64016433_onions
oodlins83210513oodlins
oolong738073_oolong
oolongs845953_oolongs
orlon5415003_orlon_
orlops847303_orlops
poblano1145093poblano
poblanos1244993poblanos
poboys1397313pob_oys
poisons9310353poisons
pollens93713303pollens
polos76129913po_lo_s
pompons1338553pompons
pontons93315553pontons
poons75430973po__ons
poplins11313153poplins
potions93417423potions
pylons113011243_pylons
ribbons1136253ribbons
robalos937683robalo_s
robbins112811063robbins
robins83617453rob_ins
robles85321693robl_es
robots8313153rob_ots
ronions73313343ronions
ronyons10258433ronyons
salons63823693_salons
solans64122493so_lans
solions7513753solions
solon55026133so_lon_
solos54830793so_lo_s
stolons73410243stolons
sublots92410913sublots
talons64019433_talons
teflons1036543teflons
tiglons837343tiglons
tolans64319273to_lans
toons55027533to__ons
toyons95512133to_yons
voudons1135323voudons
weblogs1334223weblogs
wontons103310533wontons
woolens10398843woolens
yobboes1445583yobboes
yobbos1335963yobbo_s
youpons12265983youpons
zoons144919693zo__ons

Search took 8 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272616.86019537.5
3Display Results2612610.0932806.5
 (SQL Overall)1786912617.10925135.9
 
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.