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

506 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
scoria851349(None) 
coria75828321_coria
scoriae9310901scoriae
scotia8310791scotia
aporia8315862aporia
ceria75125352_ceria
cobia94117512_cobia
curia74523772_curia
gloria71910542gloria
noria55722182_noria
scholia1237822scholia
schrik15206702schrik
scorch13198092scorch
score75526732scor_e
scored94621132scored
scorer84818252scorer
scores84725922scores
scorify1535202scorify
scoring103117212scoring
scorn75817442scor_n
scorns85713022scorns
scotias939742scotias
scrim95419722sc_rim
scrip96619192sc_rip
scrota8310182scrota
sharia93116722sharia
shortia1048182shortia
sora45746912s_or_a
sori46039832s_ori_
sorta57125412s_orta
stria55723202s_tria
syconia1248302syconia
thoria93012882thoria
acacia10311353acacia
acari75020283acari_
acarid95017073acarid
acedia9310393acedia
acholia1239973acholia
acorn75616623acor_n
acorns85013013acorns
acrid86920103ac_rid
acromia1139963acromia
agora6914333agor_a
agria65517143_agria
alodia71112453alodia
anopia83412393anopia
anoxia133510023anoxia
anuria6313123anuria
aorta55922573_aorta
aporias9315153aporias
aria46245423__aria
ascarid103910723ascarid
ascaris93613323ascaris
ascidia1046683ascidia
ascorbic1443333ascorbic
asteria7316173asteria
atonia63816513atonia
atria56022343_atria
boccia12338793boccia
bora66141633_bor_a
boric98024223_boric
cardia9916373_cardia
carina84325323_carina
cerias83321983_cerias
ceric94023093_ceric
chia96026623_c_hia
chorea115216083chorea
chorial124214143chorial
choric133515893choric
ciboria1147043ciboria
cilia73016763_cilia
circa9311403_circa
coala77521123_coala
cobias104014993_cobias
cobra95214403_cobra
coca88030643_co_ca
cocoa98517883_cocoa
coda77029343_co_da
codeia94112193_codeia
coif96337913_co_if
coil66439653_co_il
coin66645353_co_in
coir66327243_co_ir
coirs75221053_coirs
cola66541393_co_la
colic95726173_colic
colin76231693_colin
colza165112983_colza
coma87134853_co_ma
comic114721813_comic
comix163513203_comix
comma114514793_comma
conga85419873_conga
coni65534803_coni_
conic95329793_conic
conin76232723_conin
copra98115463_copra
cor59960943_cor__
coral76033453_coral
corban10314693_corban
corbie103618203_corbie
corbina111911453_corbina
corby125018533_corby
cord76740923_cor_d
cordial10312943_cordial
cords86030623_cords
core67263113_cor_e
cored85044223_cored
coremia11310363_coremia
corer75538873_corer
cores76361853_cores
corf95941483_cor_f
corgi8316083_corgi
corgis9314413_corgis
coring94433963_coring
corium10315723_corium
cork106635693_cor_k
corks116028273_corks
corky145221153_corky
corm85735373_cor_m
corms95626223_corms
corn69945813_cor_n
cornea84018923_cornea
corns76034763_corns
cornu75921323_cornu
cornua85411903_cornua
corny106023273_corny
corona83817403_corona
corps95927043_corps
corral83616253_corral
corrida1078503_corrida
corrie83621223_corrie
cors66656443_cor_s
corsac10410173_corsac
corse75036183_corse
cortin82423153_cortin
cortina91915973_cortina
corvid12310473_corvid
corvina12229503_corvina
cory96941513_cor_y
coryza2074583_coryza
cosie74728263_cosie
costa75523733_costa
cotta75818573_cotta
covin105621123_covin
cowrie113814283_cowrie
coxa136922963_co_xa
cozie163519123_cozie
crib86323583_c_rib
cris66233433_c_ris
crit65743713_c_rit
curiae84518373_curiae
curial84019153_curial
curie74533043_curie
curio74221213_curio
dorsa64617283_dorsa
ectopia1147693ectopia
emporia1148753emporia
encomia1147983encomia
escort84616483escor_t
escorts9418403escorts
exordia1544983exordia
feria85922713_feria
flora85317103flor_a
florid10311453florid
florin9312653florin
folia83618933_folia
fora75937393_for_a
glorias81610323glorias
gonia64117533_gonia
hora76136553_hor_a
hydria13227903hydria
iconic10411593iconic
ischia1136393isc_hia
ixora1236913ixor_a
kerria10339913kerria
kora86431553_kor_a
korai97018513_korai
korma115913073_korma
latria62313593latria
lochia1158313lochia
logia68116603_logia
lorica8310443_lorica
loris55329153_loris
maria75032883_maria
moira71012023_moira
mora66641273_mor_a
myopia13318443myopia
nori47133143_nori_
norias65518203_norias
noris54928273_noris
nutria639913nutria
obia67923113__obia
ocarina948023ocarina
ochrea11316643ochrea
ocrea73311823oc_rea
ohia75719363__ohia
oorie53026363_oorie
ora37250833__or_a
orca65522773__orca
orra46120723__orra
peloria9310953peloria
phobia13278593phobia
podia8415283_podia
poori74816233poori_
pooris83916843pooris
propria1149933propria
pyuria1136953pyuria
ria36745503___ria
sabra75317853sabr_a
sacra74516993sacr_a
sacraria1047393sacraria
salvia93310753salvia
sangria838113sangria
sari45444043s_ari_
sarin55239253s_arin
saris54544953s_aris
satori6415833satori_
satoris7317243satoris
saurian739913saurian
scandia1038063scandia
scar66434203scar__
scarab10310063scarab
scarce104013633scarce
scare75334463scar_e
scared95227293scared
scarer84524603scarer
scares85033003scares
scarey115016983scarey
scarf105427143scar_f
scarfs114714683scarfs
scarier94017873scarier
scarify1537443scarify
scarily12311703scarily
scaring103421973scaring
scarp95724103scar_p
scarph13429603scarph
scarps104718603scarps
scarry116311183scarry
scars75433533scar_s
scart76139773scar_t
scarts85321493scarts
scary105222593scar_y
scena74815783sc_ena
scenic10510513scenic
schema1388373schema
schorl1179803schor_l
schorls1248353schorls
schriks16185743schriks
schrod1247883schrod
schtik15185413schtik
schuit1139563schuit
schwa13426843sc_hwa
scilla8310943scilla
sciurid1044923sciurid
sclera838883sclera
scoff134413343sco_ff
scoffs14347503scoffs
scold85414863sco_ld
scolds95011233scolds
scolex1538243scolex
scolioma1243383scolioma
scombrid1543373scombrid
sconce104711723sconce
scone74621833sco_ne
scones84521303scones
scooch13228123scooch
scoop95617163sco_op
scoops105414363scoops
scoot75729143sco_ot
scoots85315933scoots
scop85925523sco__p
scope94821483sco_pe
scoped115116653scoped
scopes104719593scopes
scoping123513823scoping
scops95820193sco_ps
scopula1154993scopula
scorepad1363383scorepad
scorers94115313scorers
scorned10229953scorned
scorner9259763scorner
scorning1169133scorning
scorpion1244803scorpion
scot66242603sco__t
scotch13207513scotch
scoter83815473scoter
scotoma1155953scotoma
scotopia1245723scotopia
scots74025903sco_ts
scottie937453scottie
scour75315533sco_ur
scoured103811153scoured
scourer93910433scourer
scourge1035653scourge
scouring112810853scouring
scours84913593scours
scouse84113633scouse
scout75031453sco_ut
scouth115011153scouth
scouts84817943scouts
scow96021423sco__w
scowed124413823scowed
scowing133812093scowing
scowl1012012973sco_wl
scowls11549593scowls
scows106617803sco_ws
scrag85916173sc_rag
scram910621613sc_ram
scrap97120403sc_rap
screak125311053sc_reak
scream104814243sc_ream
scree720031703sc_ree
screw109318533sc_rew
scribal1137963sc_ribal
scribe104613533sc_ribe
scried95817303sc_ried
scries85226823sc_ries
scrimp125110583sc_rimp
scrims104615933sc_rims
scrips105316033sc_rips
script105717903sc_ript
scrive115414943sc_rive
scrod85115063sc_rod
scrods94111603scrods
scroll8310163scroll
scroop10299773scroop
scrotal938483scrotal
scrub94914203sc_rub
scrum95418193sc_rum
scry96017763sc_r_y
scuba94211593sc_uba
scudi85112163scudi_
scurf104719323scur_f
scurfs113210813scurfs
scurfy14338763scurfy
scurril945103scurril
scurry11419583scurry
scurvy14386103scurvy
scuta75815753sc_uta
sectorial111110013sectorial
senopia949223senopia
senora63216153senor_a
senorita848283senorita
sensoria8117533sensoria
sepia75318673s_epia
sera46141393s_er_a
serai56830163s_erai
serial64625853s_erial
serif84132133s_erif
serin55434443s_erin
serosa6313023serosa
shariah132210533shariah
sharias102516003sharias
sharif122917113sharif
sherif122915233sherif
sherpa1138093sherpa
shogi95014003shogi_
shogis103810933shogis
shoji15419953shoji_
shojis16348483shojis
shoran94016033shoran
shore85432643shor_e
shored105723643shored
shores94830403shores
shoring112820063shoring
shorl84720243shor_l
shorls94516193shorls
shorn85722173shor_n
short85040523shor_t
shortias1148083shortias
shortie10411333shortie
shorts95321733shorts
shorty124313193shorty
shri76021693s_hri_
shris84221443s_hris
sierra637313sierra
sinopia947733sinopia
sirra54416323s_irra
skort94925633skor_t
skorts104211293skorts
sloid64619703slo_id
snore55424953snor_e
snored74819543snored
snorer64316763snorer
snores64324323snores
snoring83917203snoring
snort54833753snor_t
snorts64116503snorts
soba64927923s_o_ba
soca66330053s_o_ca
social8813333s_ocial
soda56329383s_o_da
sodic84917483s_odic
sofa75625603s_o_fa
softa86415183s_ofta
soil46138823s_o_il
soja115619513s_o_ja
sola45541863s_o_la
solaria7312493solaria
soli46637003s_oli_
solid65025073s_olid
soma65635293s_o_ma
sonic75225283s_onic
soras55041013s_oras
sorb68333043s_or_b
sorbic10310383s_orbic
sorbs75022103s_orbs
sord56237203s_or_d
sordid83411153s_ordid
sords64527803s_ords
sore47059533s_or_e
sored66141783s_ored
sorel56231443s_orel
sorer56236573s_orer
sores55454283s_ores
sorgo64719723s_orgo
soring74731883s_oring
sorn46641063s_or_n
sorns55028423s_orns
sorry84618253s_orry
sort46264813s_or_t
sortie63621983s_ortie
sorts54536663s_orts
sorus54527583s_orus
soya75724433s_o_ya
sozin14514533s_ozin
sparid94016933sparid
spirea84015633spirea
spirit83519923spirit
spoil75818643spo_il
sporal82915453sporal
spore75428593spor_e
spored94821793spored
spores84726613spores
sporing104319413sporing
sporoid102310723sporoid
sporran936743sporran
sport75935983spor_t
sportif1238793sportif
sports84619183sports
sporty115112493sporty
sprig85617743s_prig
sprit76736403s_prit
sri35634003s__ri_
sris45434153s__ris
stadia7312143stadia
steric8317063steric
sterna63712763sterna
stoa45425913sto__a
stoai55417863stoai_
stogie7311313stogie
stoic7317243sto_ic
stolid74213173stolid
stoma75918273sto_ma
storax1389783storax
store56333813stor_e
stored75524213stored
storer64721673storer
stores65533663stores
storey95217613storey
storied8515163storied
stories7324273stories
storing83921123storing
stork96819693stor_k
storks106115953storks
storm76520383stor_m
storms85814633storms
stormy115510733stormy
story86723033stor_y
stotin63215053stotin
stourie7469343stourie
striae65422273s_triae
strip77524333s_trip
stroma84313073stroma
suctorial11117723suctorial
suctorian11106503suctorian
sudaria847973sudaria
supra73614253supr_a
sura45740293s_ur_a
surra55521343s_urra
sutra54217933sutr_a
sword95214113swor_d
swords104510803swords
swore84920813swor_e
sworn86115303swor_n
sycosis1238813sycosis
synovia1345523synovia
thorias102312053thorias
thoric114314033thoric
tora47545993_tor_a
tori47542153_tori_
toric76529313_toric
torii55521593_torii
torta55925353_torta
tsooris734693tsooris
tsoris63411193tsoris
utopia8107883utopia
uxorial1446323uxorial
varia85824203_varia
victoria1346313victoria
yttria954803yttria
zoaria1548383zoaria
zori137722923_zori_
zoril143916693_zoril
zoris145320013_zoris

Search took 8 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.1401276364.3
2DLD Change Limit1127165066.98316141.5
3Display Results5065060.3301533.3
 (SQL Overall)1786915067.45323975.7
 
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.