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

302 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
schorls124835(None) 
schools1249111schools
schorl1179811schorl_
shorls94516201s_horls
ceorls848162_ceorls
chorals124614112_chorals
chords125214632_chords
chores114828022_chores
chorus115014772_chorus
churls115411072_churls
ichors11310422ichor_s
school11410722school_
schrods1337432schrods
schuls11299852sch_uls
scores84725922sc_ores
scorns85713022sc_orns
scowls11549592sc_owls
scrolls938062scrolls
shoals94215792s_hoals
shools94919012s_hools
shores94830412s_hores
shorl84720252s_horl_
shorts95321742s_horts
whorls124410162_whorls
abhors11410623abhor_s
accords1247243accords
acorns85013013ac_orns
actorly1246413actorly
actors81016763actor_s
anchors123912953anchor_s
behowls1534443behowls
carls77037423_c_arls
carols85124983_carols
ceorl7410923_ceorl_
charas114223613_charas
chards125119733_chards
chares115631803_chares
charks155219703_charks
charms135218843_charms
charrs115219193_charrs
chars105936643_char_s
charts115823093_charts
cherts115617233_cherts
chiels115115933_chiels
chills114717703_chills
chirks155414843_chirks
chirms135113983_chirms
chiros114617773_chiros
chirps135414003_chirps
chirrs114514983_chirrs
chirus114615693_chirus
chlorals13148033_chlorals
chocks174815313_chocks
choirs114911883_choirs
chokes154917383_chokes
chola104718033_cho_la
cholas114818003_cholas
cholla113911023_cholla
chollas123811353_chollas
cholo105217973_cho_lo
cholos114716853_cholos
chomps155112223_chomps
chooks155312793_chooks
chops125019873_cho_ps
choral115118493_choral
chorale124313353_chorale
chorales133712883_chorales
chord115917263_chor_d
chore105126763_chor_e
chorea115216083_chorea
choreas124414203_choreas
chored125321883_chored
choric133515903_choric
chortle124210443_chortle
chortles133611323_chortles
choses115825133_choses
chotts113610993_chotts
chows135618203_cho_ws
churl105913883_churl_
churns114910233_churns
churrs115111513_churrs
coals76129603_c_oals
cohorts123411103cohorts
coils75030083_c_oils
cols66553083_c_o_ls
cools75632633_c_ools
corals85325143_c_orals
cords86030623_c_ords
cores76361853_c_ores
corks116028273_c_orks
corms95626223_c_orms
corns76034763_c_orns
corps95927043_c_orps
cors66656443_c_or_s
cowls106922213_c_owls
crores86121163_crores
curls74927103_c_urls
dehorns11428363dehorns
dehorts11379773dehorts
echards1337963echards
echoers12459693echoers
echoes114715523echo_es
echos105216463echo__s
ephors11311403ephor_s
eschars1237173eschar_s
escorts9418403esc_orts
exhorts1746313exhorts
ghouls1036043_ghouls
harls85634503__harls
herls85226433__herls
hols76946293__ho_ls
horas86333103__horas
horns86125333__horns
howls116219223__howls
hurls86522713__hurls
ichor1039483ichor__
ichorous1346983ichorous
isochores1456093isochores
isochors1355673isochor_s
ochers113915303ocher_s
ochres113510833och_res
ochrous1237943ochrous
reschools1444083reschools
safrols1036863safrols
salols64017873salo_ls
sapors84118813sapor_s
satoris7317253satoris
savors95616103savor_s
saxhorns1843833saxhorns
scalls84218203sc_alls
scares85033003sc_ares
scarfs114714683sc_arfs
scarps104718603sc_arps
scars75433533sc_ar_s
scarts85321493sc_arts
scaurs85512053scaur_s
schavs1436493sch_avs
schemas1468163schemas
schemes1489663schemes
scherzi2143583scherzi
scherzo2153943scherzo
scherzos2243703scherzos
schisms1437173schisms
schists1248543schists
schizos21115433schizos
schleps1445483schleps
schlocks19245693schlocks
schlubs1443193schlubs
schmalz2345293schmalz
schmoes14308543schmoes
schmoos14347513schmoos
schmos13379153sch_mos
schnaps1443703schnaps
schnooks1754243schnooks
schnorkels1951773schnorkels
schnozes2244493schnozes
scholar1236953scholar
scholarly1743453scholarly
scholars1336683scholars
scholia1237833scholia
schooled1447053schooled
schrik15206703sch_rik
schriks16185743schriks
schrod1247883sch_rod
schtiks16184743schtiks
schuits1235823schuits
schul102510413sch_ul_
schuln11256233sch_uln
schuss11186733sch_uss
schwas14396983sch_was
scions82612243scio_ns
scleras948223scleras
scoffs14347503sc_offs
scold85414863sc_o_ld
scolds95011233sc_olds
scones84521303sc_ones
scoops105414363sc_oops
scoots85315943sc_oots
scopes104719593sc_opes
scops95820193sc_o_ps
scorch13198093sc_orch
score75526743sc_or_e
scored94621133sc_ored
scorer84818263sc_orer
scorers94115323sc_orers
scoria8513503sc_oria
scorn75817453sc_or_n
scots74025913sc_o_ts
scours84913593sc_ours
scouts84817943sc_outs
scowl1012012973sc_owl_
scows106617803sc_o_ws
scrawls12177283scrawls
scrods94111613scro_ds
scroll8310173scro_ll
scroops11288253scroops
sculls84613883sc_ulls
scurfs113210813sc_urfs
sectors93116453sector_s
senhoras11278283senhoras
senhores112810993senhores
senhors103512133senhor_s
senoras72714953senoras
senores73218113senores
senors63620793senor_s
shards104319173s_hards
shares95236413s_hares
sharks135019723s_harks
sharns95516983s_harns
sharps115516083s_harps
shauls94913113s_hauls
shawls125411973s_hawls
sheals94420643s_heals
shells94319523s_hells
sheols94614163s_heols
sherds105614723s_herds
shiels95418923s_hiels
shills94519613s_hills
shires95225573s_hires
shirks134814123s_hirks
shirrs94413173s_hirrs
shirts94918343s_hirts
shoal83920273s_hoal_
shoaly124010773s_hoaly
shoats94117083s_hoats
shocks154414583s_hocks
shoers94518333s_hoers
shoes85429663s_ho_es
shogis103810943s_hogis
shogs95319713s_ho_gs
shojis16348493s_hojis
shooks134515633s_hooks
shool84523153s_hool_
shoos84226363s_ho_os
shoots94619363s_hoots
shops104222903s_ho_ps
shoran94016043s_horan
shorans102812413s_horans
shore85432653s_hor_e
shored105723653s_hored
shorn85722183s_hor_n
short85040533s_hor_t
shortly13387573s_hortly
shorty124313203s_horty
shotes95321913s_hotes
shots84730853s_ho_ts
shotts93614703s_hotts
should1038033s_hould
shouts94017723s_houts
shovels13378393s_hovels
shoves124919423s_hoves
shows115324583s_ho_ws
shoyus1266003s_hoyus
shris84221453s_h_ris
shuls85319713s_h_uls
skirls10449823s_kirls
skoals10438243s_koals
skorts104211303s_korts
snarls64016873s_narls
snools65715883s_nools
snores64324323s_nores
snorts64116503s_norts
soils55327983s__oils
sokols10399093soko_ls
sols45448163s__o_ls
sopors85215203sopor_s
soras55041013s__oras
sorbs75022103s__orbs
sords64527803s__ords
sorels63921163s__orels
sores55454283s__ores
sorns55028423s__orns
sorts54536663s__orts
sorus54527583s__orus
sotols63714473soto_ls
souls55127363s__ouls
spheres123114353spheres
splores91910953splores
spoils84614533s_poils
spools85115913s_pools
spoors84014033spoor_s
spores84726613s_pores
sports84619183s_ports
sterols7313443sterols
stools65117023s_tools
stores65533663s_tores
storks106115953s_torks
storms85814633s_torms
strolls739183strolls
suborns939493suborns
succors1137413succor_s
sudors7311103sudor_s
swirls94010133s_wirls
swords104510803s_words
thirls95012063_thirls
thorns95314103_thorns
thorps113610893_thorps
thurls9418713_thurls
whirls124710533_whirls
whores125617103_whores
whorl114612453_whorl_
whorts125111433_whorts

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 Filter1786911340270.420425454.8
2DLD Change Limit1340273026.89319443.9
3Display Results3023020.1062849.1
 (SQL Overall)1786913027.41924085.6
 
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.