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

160 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
dorbug103495(None) 
dorbugs1132981dorbugs
debug94210062d_ebug
dorsum947622dorsum
drug65718132d_r_ug
adoring9412523adoring
airbag956963airbag
airbus848343airbus
barbut104617003barbut
bedbug12193973bedbug
boring94724873boring
borough1344513borough
bug65340743___bug
corban10314693corban
corbel103715973corbel
corbie103618203corbie
corby125018533corb_y
coring94433963coring
corium10315723corium
cornu75921323cornu_
cornua85411903cornua
cornus84816563cornus
corpus106015293corpus
darb76033533darb__
darbar959953darbar
darbs85323263darb_s
daring84928683daring
debag94212303d_ebag
debugs10467823d_ebugs
debut86024143d_ebut
deorbit1048173deorbit
derby114715343derb_y
dibbuk1543503dibbuk
dirdum1036033dirdum
dirtbag1143023dirtbag
disbud10165713disbud
doable93115243doable
dobber114015423dobber
dobbin11339523dobbin
dobby136013633do_bby
dobie84920333do_bie
dobla84913643do_bla
dobra85013103do_bra
dobras94811913dobras
dobro84412213do_bro
dobros93910233dobros
doby106022163do_b_y
dog57449753do___g
dogleg936323dogleg
doing74923583do_ing
doling84923133doling
dolour75710133dolour
doming104218393doming
dong66031653do__ng
donut6324513do_nut
doobie94712683doobie
doofus1036163doofus
doping103919463doping
dor47253923dor___
dorado838813dorado
dore56353303dor__e
dories75232363dories
dork96531463dor__k
dorks105724443dor_ks
dorky135518743dor_ky
dorm76834633dor__m
dormer94415903dormer
dormie9312623dormie
dormin9312313dormin
dorms85723843dor_ms
dormy115817473dor_my
dorp76028053dor__p
dorper94314573dorper
dorps85419223dor_ps
dorr56627723dor__r
dorrs65520593dor_rs
dors56747603dor__s
dorsa64617283dor_sa
dorsad8408973dorsad
dorsal74613943dorsal
dorsel75315503dorsel
dorser74819183dorser
dorty96220813dor_ty
dory85836233dor__y
dosing83920273dosing
doting84821913doting
double94013993double
doubly12328963doubly
doubt8720093doub_t
doubts968733doubts
dough105217383do__ugh
doum76226673do__um
dour56330433do__ur
doux125817983do__ux
dowing114221513dowing
dozing174214193dozing
drag64825053d_r_ag
dreg66821653d_r_eg
drogue8938333drogue
drouk1039433d_rouk
drub75920133d_r_ub
drubs85913833d_rubs
drugs75214653d_r_ugs
drum76521593d_r_um
dug58138693d___ug
durbar968723durbar
during84419403during
durum8513203dur_um
dybbuk1841753dybbuk
earbud936283earbud
firebug1383793firebug
forb97131333forb__
forbad122710503forbad
forbid123312433forbid
forbs105720803forb_s
forby135317673forb_y
forbye14427883forbye
forum108318763for_um
frug86517103_fr_ug
goldbug1242103goldbug
goring84119573goring
homburg1543073homburg
humbug1434803humbug
jorum145513743jor_um
kombu1347243kombu_
kombus1435523kombus
korun9411923kor_un
lovebug1342033lovebug
morbid112511463morbid
morgue938113morgue
mudbug1243253mudbug
odorful1143483odorful
odorous837663odorous
orang65119943_orang
orb55736863_orb__
orbed85516193_orbed
orbing93312363_orbing
orbit73622063_orbit
orbs66626253_orb_s
orby97519603_orb_y
poring94227273poring
porous84419483porous
redbug10165473redbug
rug46039153__r_ug
shrug94512513shr_ug
sorb68333043sorb__
sorbed94916523sorbed
sorbet83924083sorbet
sorbic10310393sorbic
sorbing102815263sorbing
sorbs75022103sorb_s
soring74731883soring
sorus54527583sor_us
sprug85313893spr_ug
torous64319033torous
torque15237673torque
torus54329763tor_us
trug55720043_tr_ug
workbag1742923workbag
workup1534323workup

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 Limit1127161605.25021469.7
3Display Results1601600.0463478.3
 (SQL Overall)1786911605.67231504.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.