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

241 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
coastal941103(None) 
costal85419511co_stal
bicoastal1352202bicoastal
borstal939042borstal
cantal84122032c_antal
casual81112862c_asual
chaetal1238282chaetal
chasmal14158212chasmal
coaeval1245182coaeval
coast75236262coast__
coastally1446492coastally
coasted104015942coasted
coaster94219032coaster
coasts85719132coast_s
coattail1045302coattail
coaxal15387302coa_xal
coaxial16157002coaxial
coital84117052co_ital
costa75523732co_sta_
costae85319682co_stae
costar85518612co_star
crestal9312132crestal
crustal939022crustal
crystal1237432crystal
postal84317532po_stal
aortal65217513ao_rtal
artal55525473__artal
astral66919283__astral
basal75722283_bas_al
boast75935703boast__
boasted104113743boasted
boaster94616433boaster
boastful1344853boastful
boasts85017923boast_s
boatel84314093boa_tel
bobstay1443983bobstay
borstals1037463borstals
cabal95222153c_a_bal
cadastral1243053cadastral
caecal103713733c_aecal
caftan111710123c_aftan
canal75428043c_a_nal
canasta938363canasta_
canastas1037693canastas
cantala94114673c_antala
cantals93919573c_antals
canthal12410053c_anthal
capital112311523capital
capstan1137903capstan
captan101613343c_aptan
carnal83919203c_arnal
carpal103716253c_arpal
cartel85022533c_artel
casa65630863c_as_a_
casas75327843c_as_as
casbah1337903c_asbah
cashaw14439793c_ashaw
casita82913703c_asita_
casitas93312043c_asitas
cast67159903c_ast__
castable121613973c_astable
caste75932363c_ast_e
caster85232573c_aster
castes85631863c_astes
castle84918963c_astle
castor84418533c_astor
casts77237793c_ast_s
casuals91410523c_asuals
catalo8314853c_a_talo
cattail939173c_attail
cattalo938423c_attalo
caudal91611483c_audal
causal81413203c_ausal
censual937663censual
cental84420963c_ental
cesta75419483c_esta_
cestas85018543c_estas
chaeta11310683chaeta_
chaetae1238603chaetae
chaste114617393chast_e
chastely1635813chastely
chasten124312403chasten
chaster124718503chaster
chattel12388893chattel
chiasmal15285023chiasmal
chital114313883c_hital
clast76030583clast__
clastic113013953clastic
clasts84817293clast_s
clausal936273clausal
claustral1143453claustral
cloacal1135163cloa_cal
cloistral1143543cloistral
coact96130573coact__
coacted123611603coacted
coactor1139113coactor
coacts105314323coact_s
coaevals1344553coaevals
coagula1045403coagula
coal66939253co___al
coala77521123coa_la_
coalas87418963coa_las
coapt96131523coapt__
coapted123911493coapted
coapts104614003coapt_s
coasters104317303coasters
coasting113615503coasting
coastland1243683coastland
coastward1543543coastward
coat67558343coa_t__
coated94927033coa_ted
coatee84327213coa_tee
coater84329553coa_ter
coati75624633coa_t_i
coatis85122593coa_tis
coats75634993coa_t_s
coattails1144843coattails
coccal9310223co_ccal
cocktail1645353cocktail
coequal1844933coequal
coeval1138893co_eval
coistrel1046733coistrel
coistril1046743coistril
colossal1045553colossal
colostral1145483colostral
comal95125133co__mal
comical13312223comical
comitial1248693comitial
conceal113313013conceal
conchal144211583conchal
congeal104011683congeal
conical11316203conical
consol82614113cons_ol
constable13310993constable
constant10515593constant
construal1146783construal
consul82312303cons_ul
copal95621783co__pal
copastor1246343copastor
coral76033453co__ral
cordial10312933cordial
corneal94414503corneal
cornstalk1543943cornstalk
cornual94210173cornual
coronal94115763coronal
corral83616253co_rral
corsac10410173cors_ac
coryzal2154813coryzal
cost68057943co_st__
costally1339723co_stally
costard104113353co_stard
costars94217993co_stars
costate94019273co_state
costed95623113co_sted
coster84331293co_ster
costly114012333co_stly
costrel9310363co_strel
costs77231143co_st_s
cotan71521783co__tan
cotidal1038453cotidal
cotta75818573co_tta_
cottae84615703co_ttae
cottar84613813co_ttar
cottas84615573co_ttas
coxal146116673co__xal
craal74117753cra__al
cranial92114683cranial
crissal937413crissal
crista8311803crista_
cristae9310603cristae
crosstalk1543893crosstalk
cryptal1445683cryptal
crystals1347163crystals
cubital1137103cubital
cuesta838513cuesta_
cuestas957933cuestas
curtal83914543c_urtal
cuspal1037883c_uspal
diastral946983diastral
distal73615763_distal
dorsal74613943dors_al
dossal75510303do_ssal
dotal64919623do__tal
fatal84819373_fa_tal
festal94213563_festal
foetal9311883fo_etal
fontal9313143fo_ntal
forestal11410283forestal
fractal1237623fractal
gastral8329553_gastral
hartal9415473_hartal
hiatal9310193hia_tal
hosta85917833ho_sta_
hostas94515823ho_stas
hostel93914153ho_stel
instal6712183_instal
loadstar943363loadstar
locustal10325223locustal
loessal744393loessal
meatal84114733mea_tal
miasmal1176743miasmal
mortal84616853mo_rtal
nasal56217593_nas_al
nasial6413283_nasial
natal53921493_na_tal
notal55221353no__tal
oast47156323_oast__
oasts56529183_oast_s
octal71214723_o_ctal
octantal1044563octantal
osteal6312953_o_steal
pascal10812373_pascal
pasta76624533_pasta_
pastas85422873_pastas
pastel85918713_pastel
pastil85018323_pastil
phaseal1245673phaseal
plastral1046913plastral
portal84218463po_rtal
postals93716373po_stals
quantal16367893quantal
rascal8511123_rascal
ratal55025113_ra_tal
roast56230143roast__
roasted83912663roasted
roaster74116663roaster
roasts64915413roast_s
rostral7311313ro_stral
somital939403somital
sonantal886263sonantal
statal61613223sta_tal
toast55831013toast__
toasted84011923toasted
toaster74414463toaster
toasts65914993toast_s
toasty9509563toast_y
total55321823to__tal
vasal85516293_vas_al
vassal979243_vassal
vestal94615573_vestal
zoarial1646923zoarial

Search took 10 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.1561145455.1
2DLD Change Limit1340272418.98314920.1
3Display Results2412410.0962510.4
 (SQL Overall)1786912419.23519349.3
 
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.