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

277 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
boffin1435905(None) 
biffin14369101biffin
boffing16339981boffing
boffins15329071boffins
bowfin14338351bowfin
coffin14339811coffin
baffing164011602baffing
biffing163510012biffing
biffins15358532biffins
bobbin93410732bobbin
bodkin1338922bodkin
boff124727332boff__
boffed15369482boffed
boffo136010372boff_o
boffos14568192boffos
boffs134915502boff_s
boudin9412372boudin
bowfins15267702bowfins
buffi136112202buffi_
buffing163411392buffing
coffing163811252coffing
coffins153110192coffins
doffing15357792doffing
muffin14298872muffin
offing13368642_offing
puffin141149002puffin
soffit1237882soffit
tiffin12327932tiffin
affine12310503_affine
affix1836003_affix
baff124632273baff__
baffed154812173baffed
baffies153612943baffies
baffle14399873baffle
baffling1756053baffling
baffs134718053baff_s
baffy165511923baff_y
barfing134615093barfing
basin75026923b_asin
beduin939713beduin
beefing133911473beefing
befit105222663b_efit
begin85117353b_egin
benzin1738933benzin
berlin83116373berlin
biff125026893biff__
biffed15449883biffed
biffies152710853biffies
biffs134814413biff_s
biffy164711133biff_y
bifid11910703b_ifid
biggin103710603biggin
bin56658643b___in
biotin83215833biotin
blain75421793b_lain
blin67228173b__lin
bloodfin1443393bloodfin
bluefin1245123bluefin
bluffing17275493bluffing
boating103721303boating
bobbing113113193bobbing
bobbins103410343bobbins
bocci113512713bocci_
boccia12338793boccia
boccie123311453boccie
boccis123911133boccis
boding104320063bo_ding
bodkins1438313bodkins
bodying1438973bodying
boffola1543463boffola
bogan87519003bo_gan
bogging123615753bogging
bogie89524103bo_gie
boil66335183bo__il
boiling103819673boiling
boing84725553bo__ing
boink115516333bo__ink
bolling103820883bolling
bollix1538053bollix
bolson8410683bolson
bolting104416763bolting
bombing143211393bombing
bonbon10310073bonbon
bonding113318433bonding
bonfire1287063bonfire
bonging113316373bonging
boning94223293bo_ning
bonking144116373bonking
bonnie85314853bonnie
boobie104015293boobie
boobing123613913boobing
boogie93515993boogie
booing94521643bo_oing
bookie123516003bookie
booking143618383booking
booming123716223booming
boomkin1545363boomkin
boon67142173bo__on
bootie85421163bootie
booting103821363booting
boozing194012163boozing
bopping143512033bopping
boreen8314313boreen
boric98024223bo_ric
boring94724873bo_ring
borking144716173borking
born67338413bo__rn
boron76727143bo_ron
boson76019733bo_son
bossing103714603bossing
boston8513043boston
bosun75113593bo_sun
botfly1436093botfly
botulin947653botulin
boudins10311313boudins
bouffant1643683bouffant
bouffe14438313bouffe
bouffes15388633bouffes
bougie93613273bougie
bourn75518483bo_urn
boursin938283boursin
bousing103718043bousing
bouton8311533bouton
bovid111011623bo_vid
bovine11712433bo_vine
bowing124723063bo_wing
bowline123613113bowline
bowling133916493bowling
bowman13129853bowman
bowmen1399853bowmen
bowsing134012503bowsing
boxfish2285543boxfish
boxful18145273boxful
boxing163915153bo_xing
brain76229383b_rain
brin67038193b__rin
bromin102615693bromin
brucin1049133brucin
bruin75818333b_ruin
buff125229863buff__
buffed154313143buffed
buffer144512683buffer
buffet143113783buffet
buffier1568403buffier
buffo135112183buff_o
buffoon1543713buffoon
buffos14447853buffos
buffs135519513buff_s
buffy165013373buff_y
bumkin14308083bumkin
burin75626063b_urin
buskin123811493buskin
caffein1535333caffein
cocain101315013cocain
cochin131313203cochin
codein94916723codein
codlin94516443codlin
coff126930783coff__
coffee144113743coffee
coffer144112863coffer
coffined1735993coffined
coffle14359043coffle
coffling1736483coffling
coffs134916303coff_s
coiffing1755933coiffing
coifing133213893coifing
coin66645353co__in
cojoin1539503cojoin
colin76231693co_lin
comfit133112423comfit
confine12315583confine
confit113316403confit
conin76232723co_nin
cortin82423153cortin
cousin8517163cousin
covin105621123co_vin
cuffing163210253cuffing
daffing15369733daffing
dobbin11339523dobbin
doff116225783doff__
doffed14428503doffed
doffer133911353doffer
doffs125614333doff_s
domain9511323domain
dormin9312313dormin
elfin84312463_elfin
eosin55220923eo_sin
fain75840563__fain
feoffing1432963feoffing
fin66458033___fin
foin77231563__foin
gaffing15379733gaffing
goblin939503goblin
goffer13409513goffer
golfing12368943golfing
goofing123510633goofing
griffin1434513griffin
haffit1538533haffit
hoddin11369943hoddin
hoofing143912553hoofing
huffing17278833huffing
iodin64419353io_din
join116724833jo__in
kaffir16345303kaffir
loafing11319793loafing
lobefin1244603lobefin
lofting113311313lofting
login66025003lo_gin
loin46838723lo__in
lomein8410203lomein
luffing143310103luffing
maffia14327203maffia
miffing16298403miffing
moulin8313283moulin
muffing163210403muffing
muffins15308343muffins
naffing14359033naffing
noggin8288883noggin
nonfan948293nonfan
obtain839183obtain
off96331633_off__
offal1136243_offal
offed12359163_offed
offend13365663_offend
offer114311383_offer
office1435693_office
offings14285833_offings
offish15137273_offish
offline1345783_offline
offs107117013_off_s
often84611413_often
olefin937583olefin
olein5316003_olein
opsin7613473_opsin
orcin72716573_orcin
orpin73415533_orpin
poplin10413483poplin
postin83521033postin
puffing162910943puffing
puffins15278913puffins
raffia12287703raffia
redfin10310223redfin
reffing143712173reffing
riffing144011273riffing
robbin103611183robbin
robin74820283ro_bin
rolfing113710653rolfing
roofie93411173roofie
roofing113814353roofing
rosin55325313ro_sin
ruffian1344133ruffian
ruffing143210843ruffing
scoffing17275943scoffing
soffits1335093soffits
soften9429493soften
softie93312483softie
sozin14514543so_zin
suffix1935233suffix
taffia12286903taffia
tiffing14339383tiffing
tiffins13327983tiffins
tocsin8311003tocsin
toff105929903toff__
toffee123311013toffee
toffies133210213toffies
toffs116016723toff_s
toffy145310283toff_y
toxin124716713to_xin
uncoffin1643083uncoffin
waffie15338563waffie
waffing173710243waffing
wolfing14277893wolfing
woofing14349893woofing
yaffing17337823yaffing
yogin98317743yo_gin
zaffir21395513zaffir
zoftig1932973zoftig

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.390458182.1
2DLD Change Limit1127162775.08022188.2
3Display Results2772770.0932978.5
 (SQL Overall)1786912775.56332121.3
 
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.