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

371 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
sored6614178(None) 
bored85034301bored
cored85044221cored
gored75227081gored
pored85234511pored
scored94621131scored
sered65737291sered
shored105723641shored
shred98125611shred
sired66134281sired
snored74819541snored
soared74324291soared
soled65835171soled
sorbed94916511sorbed
sord56237201sor_d
sore47059531sore_
sorel56231441sorel
sorer56236571sorer
sores55454281sores
sorned74820041sorned
sorted74523711sorted
soured74921861soured
sowed94933861sowed
spored94821791spored
stored75524211stored
acred87126352acred
adored84714232adored
aired66032922aired
bared85144482bared
boded95124962boded
boned85133242boned
booed85127272booed
bore66051332bore_
borer75131272borer
bores76448252bores
borked135117292borked
bowed114533422bowed
boxed154318612boxed
bred75130972_bred
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_
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
red46755802__red
roared75015392roared
robed85323732robed
roped84630802roped
rosed65930342rosed
roved95323552roved
rowed94034322rowed
sabed86526812sabed
sabred95916532sabred
sacred94917102sacred
saned65636272saned
sard55344242sar_d
saree55044662saree
sarod65325872sarod
sated66238532sated
saved95127112saved
savored1158342savored
sawed95628402sawed
sayed96127142sayed
scared95227292scared
scoped115116652scoped
score75526732score_
scorer84818252scorer
scores84725922scores
scorned10229952scorned
scoured103811152scoured
scowed124413822scowed
scree720031702scree
screed95718922screed
screw109318532screw
scried95817302scried
scrod85115062scrod
seared75232842seared
seed55549482s_eed
sere46153472sere_
serer55935502serer
seres55448892seres
serged84118762serged
served104616812served
sewed95325162sewed
sexed136618542sexed
shared105829062shared
shed86536152s_hed
sherd96321152sherd
shied96125492shied
shoed95723002shoed
shooed103916072shooed
shore85432642shore_
shores94830402shores
shorted113614392shorted
shoved134214272shoved
showed135016962showed
shreds105613052shreds
shrew119720162shrew
shrewd136810772shrewd
sided74825952sided
siped84927682siped
sire46150412sire_
siree55238812siree
siren54525822siren
sires55945372sires
sited65130742sited
sized155519242sized
skeed105018982skeed
skied104417752skied
skyed13529922skyed
sled55334372s_led
sloped94216852sloped
slowed104617072slowed
slued64220512slued
smoked134311722smoked
snared74824552snared
sned56026052s_ned
snore55424952snore_
snorer64316762snorer
snores64324312snores
snorted83813492snorted
snowed104613612snowed
soaked114717592soaked
soaped95817972soaped
soarer64522242soarer
sobbed113516262sobbed
sober74822402sober
sobered102912432sobered
socked134721502socked
sod46053702so__d
sodded94113302sodded
sogged95518522sogged
soiled73822472soiled
soiree62919482soiree
soke85436262soke_
sokes95031422sokes
sold54837412so_ld
sole46053672sole_
solei55624332solei
soles55547922soles
solid65025072solid
soloed74515742soloed
solved105312932solved
some66040382some_
sonde64622832sonde
sone46649982sone_
sones55444142sones
sooey84522432sooey
sooted73922582sooted
sopped114819902sopped
sora45746912sor_a
soras55041012soras
sorb68333042sor_b
sorbet83924072sorbet
sorbs75022102sorbs
sordid83411152sordid
sords64527802sords
sorels63921162sorels
sorely94618002sorely
sorest65027992sorest
sorgo64719722sorgo
sori46039832sor_i
sorn46641062sor_n
sorner64720382sorner
sorns55028412sorns
sorrel6413542sorrel
sorry84618252sorry
sort46264812sor_t
sorta57125412sorta
sorter64425082sorter
sortied83314092sortied
sorts54536662sorts
sorus54527582sorus
sotted74121392sotted
souled75419822souled
sound64420022sound
souped95017672souped
sourced1038452sourced
sourer63620212sourer
soused74822982soused
sower85229312sower
spaed85522272spaed
spared95427482spared
sped76031492s_ped
speed85526622speed
spied85427712spied
spired94921862spired
spoked134413892spoked
spoored104411292spoored
spore75428592spore_
spores84726612spores
sported104015432sported
spread9312532spread
spree74830862spree
spued84918472spued
stared75429872stared
steed66024942steed
stied65723032stied
stoked114718292stoked
stoled74521592stoled
stoned75923142stoned
stoped94721012stoped
store56333812store_
storer64721672storer
stores65533642stores
storey95217612storey
storied8515162storied
stormed1039042stormed
stowed105817202stowed
strep77120852strep
strew89220652strew
styed95815482styed
sued56537932s_ued
surd56433812sur_d
sure45447412sure_
surer54833092surer
surfed103814462surfed
surged84118882surged
sword95214112swor_d
swore84920812swore_
syren85216742syren
tared69340052tared
tired65228902tired
toed56137042to_ed
toked105626492toked
toled65934922toled
toned65435342toned
toped85631312toped
tore47359322tore_
tores55352672tores
toted64929482toted
toured74216152toured
towed95134582towed
toyed96019802toyed
tsores65113662tsores
tyred95816432tyred
visored1138142visored
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 Limit538003711.59333772.8
3Display Results3713710.1103372.7
 (SQL Overall)1786913711.79699493.9
 
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.