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

242 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
costrel931037(None) 
coistrel1046741coistrel
costrels1038931costrels
coistrels1145262coistrels
coistril1046762coistril
control9310692control
costae85319682costae_
costal85419512cost_al
costed95623112cost_ed
coster84331292cost_er
costers94128332costers
dottrel834462dottrel
hostel93914152host_el
kestrel1137112kestrel
nostril749302nostril
poitrel936192poitrel
rostral7311332rostral
wastrel1037552wastrel
astral66919283_astral
austral73411513austral
bestrew1248003bestrew
bistre83815023bistre_
bistred103311853bistred
bistres94017213bistres
boatel84314093boat_el
botel75121863bo_t_el
carrel84718633c_arrel
cartel85022533cart_el
caste75932363cast_e_
caster85232573cast_er
casters94729903casters
castes85631863cast_es
castle84918963castle_
castled104311513castled
castles94917733castles
central93114473central
centre84316643centre_
centred103411683centred
centres93817123centres
chattel12388893chattel
cisted95217523cist_ed
cistern93310703cistern
cistron9299883cistron
citral81113893c_itral
cloistral1143543cloistral
closure9278483closure_
closured11266353closured
closures10228953closures
coastal9411043coast_al
coasted104015953coast_ed
coaster94219043coast_er
coasters104317333coasters
coated94927043coat_ed
coatee84327223coat_ee
coatees93816553coatees
coater84329573coat_er
coaters93525793coaters
cockerel16107113cockerel
coffret15310073coffret
cohere112716993cohere_
cohered133514693cohered
coherer122912783coherer
coheres122917693coheres
coistrils1146423coistrils
coital84117053coit_al
colonel94213283colonel
colored10313473colored
colorer9312523colorer
colostral1145493colostral
colter84625093colt_er
colters93522443colters
columel1136273columel
colure8314163colure_
colures9315143colures
comfrey1734683comfrey
compel124412893co_mpel
comte96125473comt_e_
comtes106222813comt_es
construal1146793construal
construe1049053construe
construed1247313construed
construer1146913construer
construes11410133construes
conte76633203cont_e_
contes84432913cont_es
contra83314703contr_a
contrail10410983contrail
contras93015623contras
controls10311393controls
cooter85128613coot_er
cooters94525723cooters
cootie84223093cootie_
cooties93725733cooties
copter109822013copt_er
copters113621283copters
coral76033453co__ral
corbel103715973co_rbel
core67263113co__re_
cored85044223co__red
corer75538873co__rer
cores76361853co__res
cormel103815603co_rmel
cornel84020053co_rnel
coronel94515223coronel
corral83616253co_rral
cortex15311473cort_ex
cosec96320183cos__ec
coses76949493cos__es
coset75748843cos__et
cosey106226713cos__ey
coshed124217543cos_hed
cosher114819903cos_her
coshered14610293coshered
coshers123618183coshers
coshes115022783cos_hes
cosie74728263cos_ie_
cosied94819883cos_ied
cosier84423753cos_ier
cosies84932153cos_ies
cosine83823513cosine_
cosines94122673cosines
cosset84125863cos_set
cost68057943cost___
costa75523733cost__a
costally1339733costally
costar85518613cost_ar
costard104113353costard
costards113510793costards
costarred1244703costarred
costars94218013costars
costate94019273costate
costing104323023costing
costive12312843costive
costively1746353costively
costless10310003costless
costlier1038523costlier
costly114012333cost_ly
costs77231143cost__s
costume1157853costume
costumed1365033costumed
costumer1275103costumer
costumes1258013costumes
costumey1563523costumey
cote66648733co_t_e_
coted85033853co_t_ed
cotes76347843co_t_es
cottae84615703cottae_
cotter84926673co_tter
cottered112511733cottered
cotters94323443cotters
cottier93814173cottier
counsel948543counsel
courted103514923courted
courter94516483courter
couter84930223cout_er
couters93827303couters
couther123914633couther
couture9310623couture_
coutures10311993coutures
covered133315293covered
coverer123113523coverer
cowered133214653cowered
crosstree1145073crosstree
doggrel1033883doggrel
dossel74813643dos_sel
dottel73610893do_ttel
dotterel945063dotterel
dottrels963493dottrels
estral64716513_estral
foster94322223fost_er
fostered122210453fostered
fosterer11239523fosterer
fosters104220103fosters
gastral8329553gastral
gastrea847243gastrea
goitre7349003goitre_
goitres8389563goitres
gomerel1036393gomerel
gospel936533gos_pel
hosel86024813hos__el
hosted105020343host_ed
hostels103712313host_els
hostile10312553hostile
hostler103411023hostler
hotel85520753ho_t_el
jostle13319863jostle_
jostled15267083jostled
jostler14288223jostler
jostles143411143jostles
kestrels1235813kestrels
listel64214743list_el
losel54419423los__el
lustral7339653lustral
lustre64011683lustre_
lustred8359053lustred
lustres73013233lustres
minstrel1046913minstrel
mistral91013643mistral
mongrel1036333mongrel
morel75729093mo__rel
moste75925083most_e_
motel76623243mo_t_el
nostrils848183nostrils
nostrum946953nostrum
osprey1134883_osprey
osteal6312963_osteal
ostler63312193_ostler
outre53922203_outre_
pastel85918713past_el
petrel83111533_petrel
peytrel1264253peytrel
poitrels1035243poitrels
postal84317533post_al
posted93722493post_ed
posteen93512623posteen
poster84129173post_er
postern93615613postern
posters93928013posters
postie84123963postie_
posties93128813posties
postmen113110423postmen
postoral10311723postoral
postural1049203postural
posture9313253posture_
postured1139493postured
posturer1038923posturer
postures10313783postures
roster64329083rost_er
rosters73727543rosters
rostra6310933rostr_a
rostrum947213rostrum
sorel56231443__sorel
sorrel6413553so_rrel
steel55721993__steel
streel64214023__streel
strep77120853__strep
strew89220663__strew
unsteel738793unsteel
vestral104111013vestral
wastrels1136203wastrels
zoster153715853zost_er
zosters163015413zosters

Search took 9 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.423422437.4
2DLD Change Limit1340272427.62317581.9
3Display Results2422420.0803025.0
 (SQL Overall)1786912428.12621990.0
 
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.