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

217 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
dobsons103620(None) 
doblons1037041doblons
dobson936591dobson_
bolsons969482bolsons
bosons85016652bo_sons
damsons1038012damsons
dobbins12379532dobbins
doblon938012doblon_
doblones1136762doblones
dobros93910232dobro_s
donjons1536732donjons
foisons1047612foisons
gibsons1045042gibsons
godsons966662godsons
poisons9310352poisons
adobos9438453adob_o_s
advowsons165983advowsons
arsons63917213_arsons
baboons113211083baboons
bisons83914373_bisons
blousons1054403blousons
bobbins103410343bobbins
bolson8410683bolson_
bonbons1139333bonbons
boons75031913__boons
borons85520543bo_rons
bosoms104913053bo_soms
boson76019733bo_son_
bostons9312903bostons
bosuns8439383bo_suns
boutons9310783boutons
cocoons11310563cocoons
codons96119463co_dons
cogons96818113co_gons
colons86028683co_lons
commons13311043commons
consols92914073consols
coons76737283co__ons
cordons104415763cordons
cottons9312193cottons
coupons112710563coupons
cousins9516003cousins
dacrons103211033dacrons
daemons10269233daemons
dahoons1137753dahoons
daikons12186693daikons
daimons10249323daimons
daltons8310403daltons
damson938063damson_
dapsone1038463dapsone
dapsones1138383dapsones
deacons10310393deacons
debone93714783deb_one
debones103315113deb_ones
debtors1038533debtors
demons94917723d_emons
devons104512253d_evons
diobolons1243123diobolons
diobols1036543diob_ols
dipsos95310053dipso_s
disowns1136733d_isowns
diurons838823diurons
dobbers123513253dobbers
dobbies124113063dobbies
dobbin11339523dobbin_
dobies94422093dob_ies
doblas93812293dob_las
dobras94811913dob_ras
dobro84412213dobro__
dobsonfly185963dobsonfly
doctors1039993doctors
dodoes85716103do_does
dodos75819393do_do_s
doeskins1344903doeskins
dogdoms1295423dogdoms
doggone1035683doggone
doggones1135713doggones
dojos135111793do_jo_s
dollops10287963dollops
dolmans10479683dolmans
dolmens10388693dolmens
dolors75115313do_lors
domains10510873domains
dominos103210193dominos
donjon1436463donjon_
donors75115793do_nors
dons56048703d___ons
doodoos9107623doodoos
dooms85321343do__oms
doors65022133do__ors
doowops1363943doowops
dormins10311273dormins
dorsals84110843dorsals
dorsels84412573dorsels
dorsers83516303dorsers
dosers75723633do_sers
doses65938503do_s_es
dosing83920273do_sing
doss56235043do_s__s
dossals8379293dossals
dossels85511603dossels
dossers84516233dossers
dosses76126273do_sses
dossils8669773dossils
dossing93313273dossing
doubloons1242823doubloons
dousers84817273dousers
douses74928933dous_es
dousing93315763dousing
dovens104413903do_vens
downs94918573do__wns
dowsers115013533dowsers
dowses105718303dows_es
dowsing123411123dowsing
doyens104810223do_yens
dozens164612463do_zens
dragons938383dragons
dromons1038193dromons
dubbins12358803dubbins
dubious1036893dubious
duopsony1442033duopsony
durions839963durions
ebons74316093_eb_ons
eobiont959943eobiont
eobionts1043983eobionts
eosins64419163eo_sins
foison948933foison_
gabions102410053gabions
gaboons10289903gaboons
gibbons1234983gibbons
gibson935123gibson_
gobans94412043gob_ans
goblins1039243goblins
goboes95914443gob_oes
gobony1236913gob_ony
gobos86219383gob_o_s
godson857383godson_
goons65326773go__ons
gorgons938853gorgons
gossans836783gossans
gossoons944893gossoons
grisons838993grisons
hobnobs1443603hobnobs
hoboes114717443hob_oes
hobos106321353hob_o_s
hysons1237633_hysons
johnsons1842383johnsons
kelsons1137323kelsons
kobos115616893kob_o_s
lessons73811023lessons
lobos75921843lob_o_s
logions86211293logions
logons79818173lo_gons
loons55731723lo__ons
loosens716310953loosens
lotions74614763lotions
masons83916513_masons
mesons83215843_mesons
monsoons1047343monsoons
moons75331003mo__ons
morions94014643morions
morons84919543mo_rons
motions94215003motions
moutons9410313moutons
nelsons738003nelsons
noons54125283no__ons
notions74014483notions
oblong935383_oblong
oblongs1033533_oblongs
oboes75717713_ob_oes
obols73715863_ob_ols
obsess845943_obsess
odeons739023_odeons
onions64016433_onions
opsins8411713_opsins
orisons7310563orisons
orlons6411013_orlons
parsons93516873parsons
persons93717013persons
poboys1397313pob_oys
pocosons1266103pocosons
podsols1056513podsols
poison8312223poison_
pompons1338553pompons
pontons93315553pontons
poons75430973po__ons
potions93417423potions
prisons9313223prisons
ramsons939563ramsons
reasons72514943reasons
ribbons1136253ribbons
robbins112811063robbins
robins83617453rob_ins
robots8313153rob_ots
ronions73313343ronions
ronyons10258433ronyons
rosins64521863ro_sins
seasons72614233seasons
solions7513753solions
solons65120023so_lons
sons46049553___sons
sponsons1045813sponsons
telsons739223telsons
tocsins939963tocsins
toons55027533to__ons
torsions839183torsions
torsos64815733torso_s
toyons95512133to_yons
unisons748423unisons
voudons1135323voudons
weasons102310583weasons
wontons103310533wontons
worsens104610263worsens
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.406440125.6
2DLD Change Limit1340272177.07618941.1
3Display Results2172170.0802712.5
 (SQL Overall)1786912177.56223630.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.