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

259 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
boner7513308(None) 
biner75930691biner
bonder95324781bonder
bone65949321bone_
boned85133241boned
boners84825431boners
bones76446531bones
boney105227311boney
bonier84321991bonier
bonzer175313671bonzer
borer75131271borer
bower107328181bower
boxer145016521boxer
goner66025161goner
honer85332091honer
loner55431041loner
toner55336241toner
zoner144520341zoner
atoner64817192atoner
baker115629542baker
baler75635272baler
bander93928222bander
bane65250432bane_
baned85436352baned
banes74945582banes
banger94423632banger
banker124222732banker
banner84421502banner
banter84825332banter
barer74535802barer
baser74828922baser
beer65635992b_eer
bender95223302bender
bene66439492bene_
benes75536232benes
bider85728372bider
bier65531832b_ier
biker116022562biker
binder94422872binder
bine66650862bine_
biners85023632biners
bines76946792bines
binger94923452binger
biter75030032biter
blonder104011942blonder
blower115316572blower
bluer74918492bluer
boar66134292bo_ar
boater84622092boater
bobber95016742bobber
bode75838752bode_
boded95124962boded
bodes84935102bodes
bogey115220232bogey
bohea105013732bohea
boiler84319272boiler
bolar75123472bolar
bolder94820932bolder
bole66448692bole_
bolero8412092bolero
boles75448602boles
bolter83920752bolter
bomber125014652bomber
bond75334362bon_d
bonded104719952bonded
bonders104120662bonders
bonds86126842bonds
boneyer1237402boneyer
bong75633412bon_g
bonged105719602bonged
bongo85720942bongo
bongs87828422bongs
bonk105531712bon_k
bonked135517312bonked
bonkers134015302bonkers
bonks116326462bonks
bonne75124712bonne
bonnes85621452bonnes
bonnet85524632bonnet
bonnier94711312bonnier
bonny105816622bonny
bonus75324322bonus
bony96732082bon_y
bonze165119352bonze
bonzes175116102bonzes
booed85127272booed
booger94816552booger
booker124719192booker
boomer104618512boomer
boor66130682bo_or
boozer174815962boozer
bopper123813832bopper
border94419972border
bore66051332bore_
bored85034302bored
borers85122682borers
bores76448252bores
borne77926792borne_
bosker123813652bosker
botel75121862botel
bother115218062bother
bouncer113811332bouncer
bounder104215532bounder
bowed114533422bowed
bowel105621202bowel
bowers115523702bowers
bowery146012112bowery
bowler114217312bowler
bowyer14368922bowyer
boxed154318612boxed
boxers155013482boxers
boxes145625072boxes
boxier154311742boxier
boyar106013762boyar
brier74527402brier
briner84519042briner
broker124314242broker
bronzer18348492bronzer
browner124911642browner
bunker124519372bunker
bunter85020382bunter
burner83819202burner
buyer105013092buyer
caner75334772caner
cloner84418092cloner
coder86134222coder
coiner84323782coiner
comer95832692comer
cone67256962cone_
coned86040052coned
cones76457422cones
coney105932882coney
confer114018682confer
conger95024272conger
conker124721552conker
conner84423962conner
cooer74831012cooer
coper95336092coper
corer75538872corer
corner84625622corner
cover105430772cover
cower104531772cower
coyer105222842coyer
deboner103110482deboner
diner65632902diner
doer57734702do_er
done55747912done_
donee66931012donee
donor64418192donor
doper86128392doper
doser66228562doser
doter65428622doter
dower95027702dower
downer104414922downer
dozer158419272dozer
droner74717672droner
finer85431562finer
fonder104120062fonder
foyer116416552foyer
goer56827102go_er
gofer94814282gofer
gomer85220652gomer
gone55639042gone_
gonef95221292gonef
goners74420172goners
hoer76533982ho_er
homer105828452homer
hone77549322hone_
honed95332262honed
honers94324972honers
hones88144492hones
honey115629912honey
honker134117462honker
honor85718622honor
hoper105829142hoper
hoser811529762hoser
hover115524132hover
inner54920632inner
ironer64216452ironer
joiner134114132joiner
joker165715892joker
jones125028182jones
kroner104612572kroner
liner55938922liner
loaner64416502loaner
lone45849132lone_
loners64225812loners
longer75823202longer
loper75129232loper
loser54728672loser
lover85526452lover
lower85830412lower
miner76933542miner
moaner84415112moaner
money104826842money
monger94418332monger
mooner85317832mooner
moper94925922moper
mover104220862mover
mower104523452mower
none45743172none_
nones55639132nones
nonet54540842nonet
noter55025642noter
omer67028392_omer
one37050912_one_
onery8414122_onery
ones46146532_ones
over77227342_over
owner84613312owner
oyer75927652_oyer
poker115122882poker
poler74431792poler
ponder94521692ponder
pone65747532pone_
pones74547042pones
poser75128772poser
power105325952power
roger64521412roger
roper75431912roper
rover85527372rover
rower85430492rower
saner54334322saner
sober74822412sober
sonar56523422sonar
sonder73623522sonder
sone46649982sone_
sones55444142sones
sooner64220462sooner
sorer56236592sorer
sorner64720392sorner
sower85229312sower
stoner65823202stoner
toker95924912toker
tone46953742tone_
toned65435342toned
toners64128002toners
tones56048662tones
toney86027412toney
tonger74719682tonger
tonier65520712tonier
tonner64819202tonner
toper75231022toper
toter55932132toter
tower85729202tower
toyer84521552toyer
tuner56022682tuner
vomer105517382vomer
voter85121052voter
vower115220792vower
wonder103617812wonder
wonner95114442wonner
wooer84316692wooer
yonder103214132yonder
yonker134110852yonker
zone135231082zone_
zoned154020262zoned
zoners155115992zoners
zones145528042zones

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.310576422.6
2DLD Change Limit538002591.61033416.1
3Display Results2592590.0634111.1
 (SQL Overall)1786912591.98390111.4
 
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.