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

381 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
schorl117981(None) 
school11410721school
schorls1248351schorls
shorl84720251s_horl
ceorl7410922_ceorl
choral115118492_choral
chord115917262_chord
chore105126762_chore
churl105913882_churl
ichor1039482ichor_
ichors11310422ichors
schools1249112schools
schrod1247882schrod
schul102510412sch_ul
score75526742sc_ore
scorn75817452sc_orn
scowl1012012972sc_owl
scroll8310172scroll
shoal83920272s_hoal
shool84523152s_hool
shore85432652s_hore
shorls94516202s_horls
shorn85722182s_horn
short85040532s_hort
whorl114612452_whorl
abhor10411063abhor_
abhors11410623abhors
accord1178843accord
achiral12109183achiral
achoo10315083acho_o
acorn75616623ac_orn
actor71116083actor_
actorly1246423actorly
actors81016773actors
anchor113911973anchor_
anchors123912953anchors
ashore9414613ashore
awhirl1264673awhirl
behowl1445533behowl
carl65144783_c_arl
carol75128613_carol
ceorls848163_ceorls
char95132153_char_
chard116124743_chard
chare105231983_chare
chark144222713_chark
charm126124663_charm
charr104821783_charr
chars105936643_chars
chart105038283_chart
chary135023133_chary
chert105232103_chert
chiel104918973_chiel
chill105619873_chill
chiral114614413_chiral
chirk144516183_chirk
chirm125317063_chirm
chiro105320343_chiro
chirp124717163_chirp
chirr105015903_chirr
chiru105317153_chiru
chloral12169983_chloral
chock164316613_chock
choir105313603_choir
choirs114911883_choirs
choke145118023_choke
choky175711223_choky
chola104718033_chola
cholla113911023_cholla
cholo105217973_cholo
chomp144815663_chomp
chon96627793_cho_n
chook146015043_chook
chop116024923_cho_p
chops125019873_chops
chorale124313353_chorale
chorals124614113_chorals
chordal13449883_chordal
chords125214633_chords
chorea115216093_chorea
choreal124412223_choreal
chored125321883_chored
chores114828023_chores
chorial124214143_chorial
choric133515903_choric
chortle124210443_chortle
chorus115014773_chorus
chose105925403_chose
chott103923933_chott
chow125820993_cho_w
chows135618203_chows
churls115411073_churls
churn105113103_churn
churr104512853_churr
coal66939253_c_oal
cohort1110720263cohort
coil66439653_c_oil
col59360353_c_o_l
cool66940493_c_ool
cor59960943_c_or_
coral76033453_c_oral
cord76740923_c_ord
core67263113_c_ore
corf95941483_c_orf
cork106635693_c_ork
corm85735383_c_orm
corn69945813_c_orn
cors66656443_c_ors
cory96941513_c_ory
cowl97530813_c_owl
crore74922873_crore
curl66035053_c_url
dehorn10439653dehorn
dehort104618103dehort
echard1249223echard
echo96615953echo__
echoed125211163echoed
echoer114011103echoer
echoers12459693echoers
echoes114715523echoes
echoey14397853echoey
echoic1339043echoic
echos105216463echo_s
ephor10310013ephor_
ephoral1248403ephoral
ephori1139603ephori
ephors11311403ephors
eschar1136533eschar_
eschars1237183eschars
escort84616483esc_ort
exhort16410803exhort
ghoul959053_ghoul
harl75740003__harl
herl75834553__herl
hora76136563__hora
horal86328683__horal
horn76735613__horn
howl107625693__howl
hurl76029933__hurl
ischial1246423ischial
isochor1244743isochor_
isochore1355863isochore
isochors1355673isochors
ocher104516103ocher_
ochers113915303ochers
ochery14319443ochery
ochone11311293ochone
ochre103411593och_re
ochry13346933och_ry
reschool1344133reschool
safrol937283safrol
salol55222143salo_l
sapor75119253sapor_
sapors84118813sapors
satori6415843satori
savor85417943savor_
savors95616103savors
savory124310563savory
saxhorn1744223saxhorn
scall74420373sc_all
scar66434203sc_ar_
scare75334463sc_are
scarf105427143sc_arf
scarp95724103sc_arp
scarry116311183scarry
scars75433533sc_ars
scart76139773sc_art
scary105222593sc_ary
scaur75814903scaur_
scaurs85512053scaurs
schav1338313sch_av
schavs1436493schavs
schema1388373schema
scheme1379633scheme
scherzi2143583scherzi
scherzo2153943scherzo
schism1338173schism
schist11312653schist
schizo20115993schizo
schizy23115043schizy
schlep1347093schlep
schlock18235873schlock
schlub1355003schlub
schmalz2345293schmalz
schmo124510203sch_mo
schmoe13328333schmoe
schmoes14308543schmoes
schmoos14347513schmoos
schmos13379153schmos
schnook1654483schnook
schnorkel1842193schnorkel
schnoz2035653schnoz
schnozz2042733schnozz
scholar1236953scholar
scholarly1743453scholarly
scholars1336683scholars
scholia1237833scholia
schooled1447053schooled
schrik15206703schrik
schrods1337433schrods
schtik15185423schtik
schuit1139563schuit
schuln11256233schuln
schuls11299853schuls
schuss11186733schuss
schwa13426843sch_wa
schwas14396983schwas
scion72214993scio_n
scions82612243scions
sclera838893sclera
scleral937863scleral
scoff134413343sc_off
scold85414863sc_old
scone74621833sc_one
scooch13228123scooch
scoop95617163sc_oop
scoops105414363scoops
scoot75729153sc_oot
scoots85315943scoots
scop85925523sc_o_p
scope94821483sc_ope
scops95820193sc_ops
scorch13198093sc_orch
scored94621133sc_ored
scorer84818263sc_orer
scores84725923sc_ores
scoria8513503sc_oria
scorns85713023sc_orns
scot66242613sc_o_t
scots74025913sc_ots
scour75315533sc_our
scours84913593scours
scout75031453sc_out
scow96021423sc_o_w
scowls11549593sc_owls
scows106617803sc_ows
scrawl11208093scrawl
scrod85115073scro_d
scrods94111613scrods
scrolls938063scrolls
scroop10299783scroop
scrota8310203scrota
scrotal938493scrotal
scry96017763sc__ry
scull75315763sc_ull
scurf104719323sc_urf
scurril945113scurril
scurry11419593scurry
sector83415933sector_
sectoral10109543sectoral
sectors93116453sectors
senhor93010813senhor_
senhora10348673senhora
senhors103512133senhors
senor53822803senor_
senora63216163senora
senors63620793senors
shall85024053s_hall
shard96125963s_hard
share86437083s_hare
shark126225023s_hark
sharn84823703s_harn
sharp104922533s_harp
shaul85418103s_haul
shawl116217573s_hawl
sheal84927703s_heal
shell84424123s_hell
sheol84318373s_heol
sherd96321153s_herd
shiel811023773s_hiel
shill85325333s_hill
shire84727133s_hire
shirk124817843s_hirk
shirr84716923s_hirr
shirt84533903s_hirt
shoals94215793s_hoals
shoaly124010773s_hoaly
shoat85633953s_hoat
shock144917033s_hock
shod86225063s_ho_d
shoe75933443s_ho_e
shoed95723013s_hoed
shoer84722163s_hoer
shoers94518333s_hoers
shoes85429663s_hoes
shog86025143s_ho_g
shogi95014013s_hogi
shogs95319713s_hogs
shoji15419963s_hoji
shone83725983s_hone
shoo75929893s_ho_o
shook124920163s_hook
shools94919013s_hools
shoon84022013s_hoon
shoos84226363s_hoos
shoot84235913s_hoot
shop95629843s_ho_p
shops104222903s_hops
shoran94016043s_horan
shored105723653s_hored
shores94830413s_hores
shortly13387573s_hortly
shorts95321743s_horts
shorty124313203s_horty
shot76150263s_ho_t
shote85526103s_hote
shots84730853s_hots
shott85332193s_hott
should1038033s_hould
shout85433173s_hout
shove114421043s_hove
shovel124611323s_hovel
show106229193s_ho_w
shown115216483s_hown
shows115324583s_hows
showy145714013s_howy
shoyu1138913s_hoyu
shri76021703s_h_ri
shul75823153s_h_ul
skirl96012913s_kirl
skoal93811463s_koal
skort94925643s_kort
snarl54921083s_narl
snool55118643s_nool
snore55424953s_nore
snort54833753s_nort
soil46138833s__oil
sokol94612293soko_l
sol37256623s__o_l
sopor74016493sopor_
sopors85215203sopors
sora45746913s__ora
sorb68333043s__orb
sord56237203s__ord
sore47059533s__ore
sorel56231443s__orel
sori46039843s__ori
sorn46641063s__orn
sororal7310653sororal
sort46264813s__ort
sotol54917653soto_l
soul46435713s__oul
spheral1238423spheral
sphere113313663sphere
sphery14318883sphery
splore81611303splore
spoil75818653s_poil
spool75219043s_pool
spoor75016353spoor_
spoors84014033spoors
sporal82915453s_poral
spore75428593s_pore
sport75935983s_port
sterol6613333sterol
stool55619893s_tool
store56333813s_tore
stork96819693s_tork
storm76520403s_torm
story86723033s_tory
stroll6311603stroll
suboral92011993suboral
suborn8310013suborn
succor1036623succor_
succors1137413succors
succory1444643succory
sudor6312623sudor_
sudoral8148543sudoral
sudors7311103sudors
swirl84514143s_wirl
sword95214123s_word
swore84920823s_wore
sworn86115313s_worn
thirl85416823_thirl
thorn85318703_thorn
thoro86217873_thoro
thorp104414263_thorp
thurl84912683_thurl
whirl114913823_whirl
whore116018043_whore
whorls124410163_whorls
whort114623693_whort

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.406440125.6
2DLD Change Limit1127163815.36021029.1
3Display Results3813810.1233097.6
 (SQL Overall)1786913815.88930343.2
 
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.