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

291 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
aghast10571137(None) 
aghas97014871aghas_
ghast95621221_ghast
agas55938842ag_as_
ageist7315382ageist
agha87417302agha__
agist66325582ag_ist
agmas85919872agmas_
arhat8327092arha_t
arhats9312972arhats
avast85519362a_vast
gast56052562_g_ast
ghat86435282_gha_t
ghats95818612_ghats
ghaut95919432_ghaut
ghost96318762_ghost
hast76259482__hast
aahs716428563aah_s_
aas310975393a__as_
abaft10318063a_baft
abas68642083a_bas_
abase76023483a_base
abash106016513a_bash
abbas95918643abbas_
ablaut8313263ablaut
ablest84721833ablest
abreast9311283abreast
abwatt11410673abwatt
accost101112263accost
aches106132293aches_
achiest12315193achiest
adapt81218553a_dapt
adjust1447183adjust
admass957143admass
adust64117453a_dust
afghan1333873afgha_n
afghani1442533afghani
afghans1443573afghans
aga410447233ag_a__
again65218123ag_ain
against838383against
agama85815583ag_ama
agamas97413453agamas_
agape85614843ag_ape
agar58726413ag_a_r
agars66120643ag_ars
agate66525153ag_ate
agave95314033ag_ave
agaze156113663ag_aze
ageism968803ageism
ageists848493ageists
agent65829643ag_ent
agents74816293agents
agers65027853agers_
ages55844593ag_es_
aggada955223aggada
aggadot1045183aggadot
agios65919863agios_
agism84614063ag_ism
agists75713173ag_ists
agitas7310593agitas_
aglare7312433aglare
aglet65534143ag_let
aglets73915683aglets
agma77623263agma__
agnail739533agnail
agnate73314883agnate
agonist82615403agonist
agons66423783agons_
agoras7613343agoras_
agorot7415003agorot
agrafe1038093agrafe
agrias74315393agrias_
ags47551663ag__s_
agues64919053agues_
aguish1059283aguish
aha611246643a_ha__
ahis76135383a_his_
ahs68644823a_h_s_
airest63825263airest
alant55742293a_lant
alas46358123a_las_
albas75925393albas_
alfas87219043alfas_
algas65624933algas_
alias55834603alias_
alist56136783a_list
almas76629773almas_
almost81014433almost
alohas9411703alohas_
alphas1139513alphas_
amahs107819063amahs_
amas67746293a_mas_
amass77119683a_mass
amias75831473amias_
amidst94913233amidst
anas46649863a_nas_
anenst63514983anenst
angas65827993angas_
angst6415503a_ngst
anlas55626933anlas_
annas55824883annas_
anoas57226493anoas_
antas55432033antas_
aorist64827873aorist
apart74330673a_part
aphasia122510873aphasia
aphasic142810063aphasic
aphis105917133aphis_
aptest82917513aptest
aquas142412613aquas_
archaist1349863archaist
areas55935773areas_
arias55438023arias_
arrant6623253arrant
arras55626133arras_
arrest63722633arrest
artist64125543artist
ashes86230613ashes_
ashiest10313963ashiest
askant10412713askant
aslant6317753aslant
asphalt1248083asphalt
assist6314603assist
atheist10314063atheist
athirst1037873athirst
athwart1348683athwart
atlas55821583atlas_
atmas75721013atmas_
attest62618613attest
aught95120703augh__t
aughts104710243aughts_
august739203august
auras55932563auras_
aurist65027253aurist
autist64324943autist
avant86224663a_vant
avgas96912133avgas_
await85524493a_wait
awash116613163a_wash
ayahs116813523ayahs_
bagass938933bag_ass
ballast9313993ballast
barghest1447913barghest
bast66362413__bast
beast76338643_beast
behest11314613behest
blast76532573_blast
boast75935703_boast
breast8319633breast
bypast13117373bypast
cagiest102916433cagiest
cast67159903__cast
chant105932693_chant
chapt125827643_chapt
chart105038283_chart
chase105127123_chase
chasm125518793_chasm
chaste114617393_chaste
chat95546133_cha_t
chats105730093_chats
chest104926143_chest
clast76030583_clast
coast75236273_coast
cohost115217213cohost
dachas124113253dachas_
daggas937973daggas_
demast9517063demast
dicast9315573dicast
dynast1088223dynast
east46659103__east
egest65222343eg_est
egoist7612283egoist
ephas10311543ephas_
exhaust1744243exhaust
fantast10311703fantast
fast77052313__fast
feast85932723_feast
gainst74914703gainst
gait56150193_g_ait
galas65731643galas_
gamas85431363gamas_
gamest94919933gamest
gas48870253_g_as_
gash86833023_g_ash
gashest114813413gashest
gasp76227333_g_asp
gasts66628633_g_asts
gat46880513_g_a_t
gats56753443_g_ats
gayest104314333gayest
geest64829623_geest
gest56149133_g_est
ghastly14354563_ghastly
ghauts10447783_ghauts
ghazi1837443_ghazi
ghis85020163_ghis_
ghosts10489273_ghosts
ghosty13467213_ghosty
giant65430593_giant
gist56046763_g_ist
glass65518133_glass
glost65422933_glost
gnash9449833_gnash
gnat56034433_gna_t
gnats65217713_gnats
goas55239943_goas_
goat56250833_goa_t
goats65527303_goats
graft95327203_graft
grant64840023_grant
grasp84814483_grasp
grass66125203_grass
grat55651283_gra_t
grist65529873_grist
guest65225923_guest
gust55240703_g_ust
hadst93220223__hadst
haet75659503__haet
haft105941843__haft
hahas117118443hahas_
halt76056303__halt
hant75461593__hant
hart76865773__hart
has67372653__has_
hash106936503__hash
hasp96627293__hasp
haste85927863__haste
hasty115718763__hasty
hat67289963__ha_t
hats76858253__hats
haut75949733__haut
hest75950773__hest
highest1439563highest
hist76551543__hist
host77852833__host
jagras1438463jagras_
kashas133311903kashas_
khat116730723_kha_t
khats125316013_khats
lambast11129893lambast
last46260323__last
least56134883_least
magmas115512503magmas_
mast65959963__mast
nachas114914193nachas_
nighest11310693nighest
oast47156323__oast
oblast8613663oblast
ogham1138253ogha_m
oghamist1444753oghamist
oghams1245853oghams
orgiast837463orgiast
pachas135017143pachas_
pageant10312783pageant
pashas115117063pashas_
past65959013__past
phase104617213_phase
phat95837863_pha_t
ragas65326063rag_as_
rashest103916873rashest
recast83422773recast
rehash1237433rehash
repast83520633repast
roast56230143_roast
sagas66025883sag_as_
sagest74920263sag_est
sagiest82617993sagiest
schist11312653schist
shaft115725273_shaft
shalt85534493_shalt
shat76456603_sha_t
shist84829613_shist
tachist12613293tachist
taggant9310223taggant
that75639323_tha_t
toast55831013_toast
ughs85410973ugh_s_
uncast84215713uncast
unhasty1344283unhasty
unhat81119263unha_t
unhats91110623unhats
upcast102710093upcast
vagrant11410663vagrant
vaguest1137333vaguest
vast75045123__vast
wast75655853__wast
what105434073_wha_t
whats117718993_whats
whist115322953_whist
yeast85327943_yeast

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 Filter1786911127160.826216332.9
2DLD Change Limit1127162917.62614780.5
3Display Results2912910.0933129.0
 (SQL Overall)1786912918.54520911.8
 
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.