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

330 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
bored8503430(None) 
bared85144481bared
boded95124961boded
boned85133241boned
booed85127271booed
bore66051331bore_
borer75131271borer
bores76448251bores
borked135117291borked
bowed114533421bowed
boxed154318611boxed
bred75130971b_red
cored85044221cored
gored75227081gored
pored85234511pored
sored66141781sored
aboded104912512aboded
aborted10310422aborted
acred87126352acred
adored84714232adored
aired66032922aired
arbored103811602arbored
baaed85218162baaed
baked126130772baked
baled85436442baled
baned85436352baned
barbed115121312barbed
bard75648862bar_d
barde85330772barde
barded105426422barded
bare65460522bare_
barer74535802barer
bares75457132bares
barfed125416382barfed
barged105822642barged
barked135027312barked
barned95623582barned
barred95725792barred
based85331582based
bated85935532bated
bayed115423022bayed
bed67950622b__ed
beret74946362beret
bermed115217722bermed
bided95424962bided
biked125320032biked
biped104718832biped
bird76128312bir_d
birded104414302birded
birled94416992birled
birred94713202birred
blared95018242blared
bled75729312b_led
bleed85019802bleed
blowed125016692blowed
blued84520322blued
board85523002board
boarded113910502boarded
boated94221972boated
bobbed104315832bobbed
bod67055542bo__d
bode75838752bode_
bodes84935102bodes
bodied103814582bodied
boffed15369482boffed
bogey115220232bogey
bogged116019282bogged
bohea105013732bohea
boiled95020952boiled
bold75432812bo_ld
bole66448692bole_
boles75448602boles
bolled94722652bolled
bolted94617802bolted
bombed134113872bombed
bond75334362bo_nd
bonded104719952bonded
bone65949322bone_
boner75133082boner
bones76446532bones
boney105227312boney
bonged105719602bonged
bonked135517312bonked
boobed114514872boobed
booked135319502booked
boomed115318132boomed
booted94822732booted
boozed184813832boozed
bopped134413402bopped
bora66141632bor_a
boral75831702boral
boras75938302boras
borated104116362borated
borax145918722borax
bordel94514572bordel
border94419972border
boreal84817212boreal
boreas85421732boreas
boredom1236932boredom
boreen8314312boreen
borers85122682borers
boric98024222boric
boride9415902boride
bork106933822bor_k
borks115727702borks
born67338412bor_n
borne77926792borne
boron76727142boron
bort65960962bor_t
borts76735452borts
borty105522832borty
bortz165722202bortz
bossed94816532bossed
botel75121862botel
bound84819582bound
boused95322882boused
bovid111011622bovid
bowel105621202bowel
bower107328182bower
bowered133113042bowered
bowled125018132bowled
bowsed125715972bowsed
boxer145016522boxer
boxes145625072boxes
brad75234342b_rad
bread85523112b_read
brede85520502b_rede
bree67241262b_ree
breed85526692breed
bren65629562b_ren
brew95023562b_rew
broad84817692broad
brood84620242brood
browed125216392browed
buoyed1236692buoyed
burd75534262bur_d
buret77444012buret
buried94822372buried
burked135220882burked
burled94825382burled
burned95818962burned
burped116215502burped
burred95820722burred
bused85624492bused
byre95023852byre_
byres104421382byres
byrled12437172byrled
cared86050092cared
cered85227442cered
chored125321882chored
coded95433182coded
coed77140542co_ed
coked124730692coked
coled85540752coled
coned86040052coned
cooed84534342cooed
coped105036842coped
cord76740922cor_d
corded105923352corded
core67263112core_
corer75538872corer
cores76361852cores
corked135020782corked
corned95224522corned
coted85033852coted
coved115027372coved
cowed115637842cowed
coxed154322812coxed
coyed114623802coyed
cred76530882_cred
cured85932132cured
dared75935012dared
doled75430912doled
domed95423262domed
doped95326712doped
dore56353302dore_
dosed76626912dosed
doted75227072doted
dowed104632612dowed
dozed165619352dozed
dured75025402dured
eared65139502eared
erred65915672erred
fared95842342fared
fired94829742fired
forced126316522forced
ford86835492for_d
forded115020392forded
fore78351472fore_
foredo10510822foredo
fores85847102fores
forged115519322forged
forked145217142forked
formed125021172formed
foxed165115212foxed
gore55744962gore_
gores65740372gores
gorged95016982gorged
gormed105013832gormed
gyred105114092gyred
hared95742182hared
hired95226262hired
hoed87837982ho_ed
hoked135326992hoked
holed95634132holed
homed115425422homed
honed95332262honed
hoped115628182hoped
horde94623052horde
horded115420482horded
horned105718702horned
horsed105321082horsed
hosed95830982hosed
ired55131872_ired
joked175217912joked
jowed164724422jowed
joyed164811832joyed
kore85834162kore_
labored102810242labored
lobed86022132lobed
looed64626132looed
loped85128332loped
lord55032082lor_d
lorded84916732lorded
lore45850352lore_
lores55045402lores
loured74617402loured
loved95021362loved
lowed95233902lowed
loxed135017052loxed
lured65427492lured
mired85729222mired
mooed85123982mooed
moored93814172moored
moped105424732moped
more67154522more_
morel75729092morel
mores76249642mores
moved114218152moved
mowed113629012mowed
mured85726702mured
normed95014542normed
nosed65524552nosed
noted65123842noted
oared65030652oared
odored8399222odored
ohed87825182_ohed
oohed94214212oohed
oozed154214262oozed
oped76230152_oped
orad56031692_orad
orbed85516192_orbed
ore36661832_ore_
oread64619602_oread
ores46056682_ores
owed86833872_owed
pared86946762pared
poked125425392poked
poled84934842poled
pooed85226242pooed
pore66451262pore_
pores75849032pores
porked134717622porked
ported94223242ported
posed85828412posed
poured95116742poured
poxed154817862poxed
rared65738322rared
rebored105015882rebored
red46755802__red
roared75015392roared
robed85323732robed
roped84630802roped
rosed65930342rosed
roved95323552roved
rowed94034322rowed
scored94621132scored
sered65737292sered
shored105723642shored
shred98125612shred
sired66134282sired
snored74819542snored
soared74324292soared
soled65835172soled
sorbed94916512sorbed
sord56237202sor_d
sore47059532sore_
sorel56231442sorel
sorer56236572sorer
sores55454282sores
sorned74820042sorned
sorted74523712sorted
soured74921862soured
sowed94933862sowed
spored94821792spored
stored75524212stored
tabored102810562tabored
tared69340052tared
tired65228902tired
toed56137042to_ed
toked105626492toked
toled65934922toled
toned65435342toned
toped85631312toped
tore47359322tore_
tores55352672tores
toted64929482toted
toured74216152toured
towed95134582towed
toyed96019802toyed
tyred95816432tyred
voled95323722voled
voted93919142voted
vowed124424572vowed
wared96339872wared
whored135512122whored
wired95327642wired
wooed94419872wooed
word89832002wor_d
worded114316622worded
wore77144672wore_
worked145314702worked
world96915362world
wormed124314302wormed
wowed124023772wowed
yoked134821622yoked
yore76335942yore_
yores85031322yores
yowed1253025182yowed
zoned154020262zoned

Search took 2 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.0931921408.6
2DLD Change Limit538003301.67332157.8
3Display Results3303300.0933548.4
 (SQL Overall)1786913301.85996122.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.