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 “borer” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

263 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
borer7513127(None) 
barer74535801barer
boner75133081boner
border94419971border
bore66051331bore_
bored85034301bored
borers85122681borers
bores76448251bores
bower107328181bower
boxer145016521boxer
corer75538871corer
sorer56236591sorer
aborter939932aborter
adorer74713452adorer
airer54927892airer
baker115629542baker
baler75635282baler
barber104419322barber
bare65460522bare_
bared85144482bared
bares75457132bares
barker124822862barker
barre75929552barre
barter85525382barter
baser74828922baser
bearer85323912bearer
beer65635992b_eer
beret74946362beret
bider85728382bider
bier65531842b_ier
biker116022562biker
biner75930692biner
birder94915492birder
birler85715082birler
birr66022372bir_r
biter75030032biter
blower115316572blower
bluer74918492bluer
boar66134292bo_ar
boarder103910322boarder
boater84622092boater
bobber95016742bobber
bode75838762bode_
boded95124962boded
bodes84935102bodes
bogey115220232bogey
bohea105013732bohea
boiler84319272boiler
bolar75123472bolar
bolder94820932bolder
bole66448692bole_
bolero8412092bolero
boles75448602boles
bolter83920752bolter
bomber125014652bomber
bonder95324782bonder
bone65949322bone_
boned85133242boned
boners84825432boners
bones76446532bones
boney105227312boney
bonier84321992bonier
bonzer175313672bonzer
booed85127272booed
booger94816552booger
booker124719192booker
boomer104618512boomer
boor66130682bo_or
boozer174815962boozer
bopper123813832bopper
bora66141632bor_a
boral75831702boral
boras75938302boras
borax145918722borax
bordel94514572bordel
borders104317532borders
boreal84817212boreal
boreas85421742boreas
boreen8314312boreen
boric98024222boric
bork106933822bor_k
borked135117292borked
borks115727702borks
born67338412bor_n
borne77926792borne
boron76727142boron
bort65960962bor_t
borts76735452borts
borty105522832borty
bortz165722202bortz
bosker123813652bosker
botel75121862botel
bother115218062bother
bowed114533422bowed
bowel105621202bowel
bowers115523702bowers
bowery146012112bowery
bowler114217312bowler
bowyer14368922bowyer
boxed154318612boxed
boxers155013482boxers
boxes145625072boxes
boxier154311742boxier
boyar106013762boyar
bred75130972b_red
bree67241262b_ree
bren65629562b_ren
brew95023562b_rew
brier74527402brier
broker124314242broker
brr56921922b_r_r
brrr65312292b_rrr
buret77444012buret
burger94020792burger
burier84324652burier
burker125221172burker
burler84723832burler
burner83819202burner
burr65631232bur_r
burrer83718472burrer
buyer105013092buyer
byre95023852byre_
byres104421382byres
carer74942332carer
coder86134222coder
comer95832692comer
cooer74831012cooer
coper95336092coper
corder94322882corder
core67263112core_
cored85044222cored
corers85231072corers
cores76361852cores
corker124720852corker
corner84625622corner
cover105430772cover
cower104531772cower
coyer105222842coyer
curer75030752curer
darer65230792darer
direr64927072direr
doer57734702do_er
doper86128392doper
dore56353302dore_
dormer94415902dormer
dorper94314572dorper
dorr56627722dor_r
dorser74819182dorser
doser66228562doser
doter65428622doter
dourer74215272dourer
dower95027702dower
dozer158419272dozer
farer86733142farer
firer811229252firer
forcer114917342forcer
fore78351472fore_
fores85847102fores
forger104820772forger
forker134717902forker
former114221402former
foyer116416552foyer
goer56827102go_er
gofer94814282gofer
gomer85220652gomer
goner66025162goner
gore55744962gore_
gored75227082gored
gores65740372gores
gorger86116982gorger
gorier73719372gorier
hirer85423122hirer
hoer76533982ho_er
homer105828452homer
honer85332092honer
hoper105829142hoper
hoser811529762hoser
hover115524132hover
joker165715892joker
kore85834172kore_
laborer9249512laborer
loner55431042loner
loper75129232loper
lore45850352lore_
lores55045402lores
loser54728672loser
lover85526452lover
lower85830412lower
lurer54625312lurer
merer75126232merer
moper94925922moper
more67154522more_
morel75729092morel
mores76249642mores
mover104220862mover
mower104523452mower
noter55025642noter
omer67028392_omer
order65019362_order
ore36661832_ore_
ores46056682_ores
ormer75218372_ormer
over77227342_over
oyer75927652_oyer
parer75839902parer
poker115122882poker
poler74431792poler
poorer82613992poorer
pore66451262pore_
pored85234512pored
pores75849032pores
porker124917542porker
porter84224412porter
poser75128772poser
pourer84516042pourer
power105325952power
purer75127902purer
rarer54731702rarer
roarer63914332roarer
roger64521412roger
roper75431912roper
rover85527372rover
rower85430492rower
scorer84818262scorer
serer55935512serer
snorer64316762snorer
soarer64522242soarer
sober74822412sober
sore47059532sore_
sored66141782sored
sorel56231442sorel
sores55454282sores
sorner64720392sorner
sorter64425092sorter
sourer63620212sourer
sower85229312sower
storer64721672storer
surer54833102surer
taborer9269292taborer
toker95924912toker
toner55336242toner
toper75231022toper
tore47359322tore_
torero6313202torero
tores55352672tores
torr45630902tor_r
toter55932132toter
tourer64115072tourer
tower85729202tower
toyer84521552toyer
vomer105517382vomer
voter85121052voter
vower115220792vower
wirer85124952wirer
wooer84316692wooer
wore77144672wore_
worker134715112worker
wormer114514912wormer
worser95117522worser
yarer84321572yarer
yore76335942yore_
yores85031322yores
zoner144520342zoner

Search took 3 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 Filter178691538000.360496363.9
2DLD Change Limit538002631.73331044.4
3Display Results2632630.1401878.6
 (SQL Overall)1786912632.23380022.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.