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 “ghats” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

194 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
ghats9581861(None) 
chats105730091chats
gats56753441g_ats
ghast95621221ghast
ghat86435281ghat_
ghauts10447781ghauts
gnats65217711gnats
goats65527301goats
hats76858251_hats
khats125316011khats
whats117718991whats
aghas97014872agha_s
aghast105711372aghast
arhats9312972arhats
bahts105617802bahts
bats66962332_bats
beats76042242beats
bhuts105812952bhuts
blats75132502blats
boats75635152boats
brats75336012brats
cats66356342_cats
chads116122232chads
chais107530312chais
chams126028502chams
chants115020392chants
chaos105622862chaos
chaps125326062chaps
chars105936642chars
charts115823092charts
chat95546132chat_
chaws135022462chaws
chays135319742chays
cheats114519542cheats
chits105424572chits
coats75635002coats
dhaks13479702dhaks
dhals95415442dhals
doats65224882doats
drats66628372drats
eats47054872_eats
fats76252502_fats
feats86432752feats
fiats85324482fiats
flats86429742flats
frats86829672frats
gabs76740422g_abs
gads67843382g_ads
gaes56348032g_aes
gags66441062g_ags
gaits65726012gaits
gals57946502g_als
gams76648882g_ams
gaps76042972g_aps
gars55750742g_ars
gas48870252g_a_s
gast56052562g_ast
gasts66628632gasts
gat46880512g_at_
gate55746572g_ate
gates65939512g_ates
gays87338022g_ays
gears64628692gears
gelts65924612gelts
gents65729612gents
gests66028812gests
getas65421482getas
gets55442482g_ets
ghaut95919432ghaut
ghazi1837442ghazi
ghazis1935202ghazis
ghees95215552ghees
ghis85020162gh_is
ghost96318762ghost
ghosts10489272ghosts
giants74713502giants
gifts96214962gifts
gilts64924262gilts
girts65423622girts
gists66026192gists
gits55744592g_its
glads75620612glads
glams85822932glams
glans65125832glans
glass65518132glass
gloats74515422gloats
gluts66120132gluts
gnars66718852gnars
gnat56034432gnat_
gnaws96311142gnaws
goads77022852goads
goals65521292goals
goas55239942goa_s
goat56250832goat_
gouts64826172gouts
grabs85719692grabs
grads75625752grads
grafts105013252grafts
grams85327312grams
grans64832542grans
grants73722472grants
grass66125202grass
grat55651282grat_
grate64932882grate
grates75429892grates
gratis74819242gratis
grays95621332grays
greats76318392greats
grits65529582grits
groats74816652groats
grots65025852grots
guans64419442guans
guars65021052guars
gusts65722792gusts
guts56637252g_uts
haes77651022_haes
haets86525122_haets
hafts116219462_hafts
hags86740842_hags
hahs108333362_hahs
halts85230102_halts
hams96446132_hams
hants86335402_hants
haps96443462_haps
harts88441592_harts
has67372652_ha_s
hast76259482_hast
hat67289962_hat_
hate78450172_hate
hates86742572_hates
hath105933912_hath
haws106439442_haws
hays106138072_hays
heats85838402heats
hets75547202_hets
hits75545132_hits
hots78349332_hots
huts76737442_huts
ikats95311152ikats
kats85944332_kats
khafs15648842khafs
khans124615172khans
khat116730722khat_
khets124913432khets
kyats125012442kyats
lats45962702_lats
mats65460292_mats
meats75034052meats
moats75827642moats
neats55931902neats
oats46554212_oats
oghams1245852oghams
pats66460852_pats
peats76140192peats
phat95837862phat_
phots105418502phots
phuts104613502phuts
plats75531372plats
prats76333392prats
qats135331342_qats
rats46260372_rats
scats75930602scats
seats54844342seats
shads95124482shads
shafts125411442shafts
shags95123862shags
shahs115919512shahs
shams105829412shams
shat76456602shat_
shaws116226262shaws
shays116021432shays
shits84731172shits
shoats94117082shoats
shots84730852shots
shuts85622482shuts
skats94621542skats
slats55436902slats
spats75031382spats
stats55933362stats
swats85726862swats
tats46858132_tats
teats55636812teats
that75639322that_
thaws116515462thaws
twats86616602twats
unhats91110622unhats
vats76841742_vats
wats77555882_wats
whams135515642whams
whaps135115162whaps
what105434072what_
wheats125013222wheats
whets115019612whets
whits115923822whits

Search took 3 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 Filter178691538000.313570897.8
2DLD Change Limit538001941.67032215.6
3Display Results1941940.0633079.4
 (SQL Overall)1786911942.04687336.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.