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

293 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
schrod124788(None) 
schrods1337431schrods
scrod85115061sc_rod
chord115917262_chord
ochred12328002ochred
ochroid1357902ochroid
sarod65325872s_arod
scared95227292scared
schmo124510202schmo_
schmoe13328332schmoe
schmos13379152schmos
schnoz2035642schnoz
school11410722school
schorl1179802schorl
schrik15206702schrik
scored94621132scored
scrods94111602sc_rods
shod86225052s_h_od
shred98125612s_hred
shroud1038762s_hroud
acarid95017063acarid
acaroid103512303acaroid
accord1178843accord
ached119227833ach_ed
achoo10315083ach_oo
acred87126353ac_red
acrid86920103ac_rid
ascared10399523ascared
ascarid103910713ascarid
card710245873_car_d
cared86050093_cared
carob95325223_carob
carol75128613_carol
carom95025563_carom
cered85227443_cered
cero66329453_cero_
ceros74726073_ceros
chad105525503_ch_ad
chao95727313_chao_
chaos105622863_chaos
chard116124743_chard
chared125423693_chared
chid106626403_ch_id
child114516223_child
chiro105320343_chiro_
chiros114617773_chiros
chon96627793_ch_on
chook146015043_chook
chop116024923_ch_op
chords125214633_chords
chore105126763_chore
chored125321883_chored
choroid13311793_choroid
chow125820993_ch_ow
chroma132912473_chroma
chrome133214813_chrome
chromed153510923_chromed
chromo132811013_chromo
chromy16309903_chromy
clod76124613_c_lod
cod69660123_c__od
cord76740923_cor_d
cored85044223_cored
corody12149703_corody
cred76530883_c_red
croc85723733_c_roc
crop87628633_c_rop
crow96428133_c_row
crowd115815623_c_rowd
crud75219613_c_rud
curd77634983_cur_d
cured85932133_cured
echard1249223echard
eched116919223ech_ed
echo96615953ech_o_
echoed125211153echoed
echos105216463ech_os
emerod9139213emerod
ephod1139123eph_od
escrow1135913esc_row
euchred13106163euchred
hod76852463__h_od
hood85132333__hood
hotrod1048793hotrod
ichor1039473ich_or
ichors11310413ichors
isochron1343653isochron
nimrod934873nimrod
ochered132610283ochered
ochre103411593ochr_e
ochrea11316643ochrea
ochres113510833ochres
ochrous1237933ochrous
ochry13346933ochr_y
octroi837363octroi
prod76129503__prod
pushrod1343703pushrod
ramrod936833ramrod
rod47953893___rod
sabred95916533sabred
sacred94917103sacred
safrol937283safrol
sard55344243s_ar_d
sarode75317513s_arode
sarods74918573s_arods
saros55238063s_aros
scad75725763sc__ad
scald84818123sc_ald
scaled94822443scaled
scaped115519553scaped
scar66434203scar__
scarab10310063scarab
scarce104013633scarce
scare75334463scar_e
scarer84524603scarer
scares85033003scares
scarey115016983scarey
scarf105427143scar_f
scarfed134711183scarfed
scarfs114714683scarfs
scarp95724103scar_p
scarped124314393scarped
scarph13429603scarph
scarps104718603scarps
scarred104512633scarred
scarry116311183scarry
scars75433533scar_s
scart76139773scar_t
scarted104816123scarted
scarts85321493scarts
scary105222593scar_y
scend85516293sc_end
schav1338313sch_av
schavs1436493schavs
schema1388373schema
scheme1379633scheme
schemed1577753schemed
scherzi2143573scherzi
scherzo2153933scherzo
scherzos2243693scherzos
schism1338173schism
schist11312653schist
schizo20115993schizo
schizoid2344353schizoid
schizos21115423schizos
schizy23115043schizy
schlep1347093schlep
schlock18235873schlock
schlub1355003schlub
schmoes14308543schmoes
schmoos14347513schmoos
schnook1654483schnook
schnozz2042723schnozz
schooled1447043schooled
schools1249113schools
schorls1248353schorls
schriks16185743schriks
schtik15185413schtik
schuit1139563schuit
schul102510413sch_ul
schuln11256233schuln
schuls11299853schuls
schuss11186733schuss
schwa13426843sch_wa
schwas14396983schwas
scion72214993sc_ion
sciurid1044923sciurid
sciuroid1144403sciuroid
scleroid1147203scleroid
scold85414863sc_old
scoop95617163sc_oop
scoot75729143sc_oot
scop85925523sc__op
scoped115116653scoped
scorch13198093scorch
score75526733scor_e
scorer84818253scorer
scores84725923scores
scoria8513483scoria
scorn75817443scor_n
scorned10229953scorned
scorns85713013scorns
scot66242603sc__ot
scoured103811153scoured
scow96021423sc__ow
scowed124413823scowed
scrag85916173sc_rag
scram910621613sc_ram
scrap97120403sc_rap
scree720031703sc_ree
screed95718923screed
screw109318533sc_rew
scried95817303scried
scrim95419723sc_rim
scrip96619193sc_rip
scroll8310163sc_roll
scroop10299773scroop
scrota8310183sc_rota
scrub94914203sc_rub
scrum95418193sc_rum
scry96017763sc_r_y
scud76221283sc__ud
scudo85412213scudo_
scurf104719323scur_f
scurfs113210813scurfs
scurfy14338763scurfy
scurry11419583scurry
scurvy14386103scurvy
seared75232843seared
secured1059723secured
sered65737293s_ered
serow86720443s_erow
shad86230913s_h_ad
shard96125963s_hard
shared105829063shared
shed86536153s_h_ed
shend94719973s_hend
sheol84318363s_heol
sherd96321153s_herd
shied96125493s_hied
shmo95318093s_hmo_
shoe75933433s_h_oe
shoed95723003s_hoed
shog86025133s_h_og
shoo75929883s_h_oo
shooed103916073s_hooed
shook124920153s_hook
shool84523143s_hool
shoon84022003s_hoon
shoos84226353s_hoos
shoot84235893s_hoot
shop95629833s_h_op
shore85432643s_hore
shored105723643shored
shorl84720243s_horl
shorn85722173s_horn
short85040523s_hort
shot76150243s_h_ot
show106229183s_h_ow
shreds105613053s_hreds
shrew119720163s_hrew
shrewd136810773s_hrewd
shri76021693s_hr_i
shris84221443s_hris
shroff1538493s_hroff
shrouds1136013s_hrouds
shrove125412223s_hrove
shrub104814893s_hrub
shrug94512513s_hrug
sired66134283s_ired
snared74824553snared
snood64616163s_nood
snored74819543snored
soared74324293soared
sod46053703s___od
sonhood1168313sonhood
sord56237203s_or_d
sored66141783s_ored
sorrow9339443sorrow
soured74921863soured
spared95427483spared
sparid94016933sparid
sparoid102311533sparoid
sphered133512313sphered
spheroid1447283spheroid
spired94921863spired
spiroid10219823spiroid
spored94821793spored
sporoid102310723sporoid
stared75429873stared
steroid81314853steroid
sterol6613323sterol
stood65517713s_tood
stored75524213stored
strode75215973s_trode
strop77422243s_trop
stroud7310383s_troud
strow88920573s_trow
stroy87720393s_troy
surd56433813s_ur_d
sward94221463swar_d
sword95214113swor_d
synchro1544543synchro_
synchros1645203synchros
synod9610283s_ynod
thro77726423_thro_
throb109816853_throb
throe89321423_throe
throw118719733_throw
trod57627953__trod
unhood1039233unhood
untrod769853untrod
uphroe1136083uphroe

Search took 6 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.1231452772.4
2DLD Change Limit1127162935.56320261.7
3Display Results2932930.0933150.5
 (SQL Overall)1786912935.77930920.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.