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

106 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
agist6632558(None) 
ageist7315381ageist
agism84614061agism
agists75713171agists
alist56136781alist
gist56046761_gist
adit56443652adi_t
adits66523712adits
adust64117452adust
aegis6316782aegis_
against838382against
agas55938842agas_
ageism968802ageism
ageists848492ageists
agent65829642agent
ages55844592ages_
aghast105711372aghast
agile65122262agile
agin56132712agi_n
aging77026352aging
agio57828452agi_o
agios65919862agios
agisms9399392agisms
agisted938202agisted
agita6315422agita
aglet65534142aglet
agonist82615402agonist
ags47551662ag_s_
aguish1059282aguish
ahis76135382ahis_
airt45757782a_irt
ais39083572a_is_
ait38093902a_i_t
aits46355532a_its
alit46155692ali_t
amidst94913232amidst
amis66445322amis_
amiss75823072amiss
angst6415492angst
anis45746462anis_
anise55129702anise
aorist64827872aorist
apish105116632apish
arise56436432arise
arista6415292arista
aristo6414032aristo
artist64125542artist
assist6314602assist
atilt54828472atilt
august739202august
aurist65027252aurist
autist64324942autist
avast85519362avast
aviso85713962aviso
axis116127912axis_
cagiest102916432cagiest
cist67244962_cist
deist64633592deist
egest65222342egest
egis56520652egis_
egoist7612282egoist
exist124618942exist
feist86230072feist
fist76248422_fist
foist85730972foist
gainst74914692gainst
gait56150192gai_t
gaits65726012gaits
gast56052562_gast
gest56149132_gest
gift86735792_gift
gilt56348542_gilt
girt56646422_girt
gists66026192_gists
git46266052_gi_t
gits55744592_gits
grist65529872grist
gust55240702_gust
heist87030912heist
hist76551542_hist
hoist86433212hoist
imagist1077332imagist
joist125125652joist
kist86540792_kist
legist71315252legist
list47055342_list
maist75535682maist
mist66154532_mist
moist76033582moist
neist54628442neist
odist6421912odist
papist102618742papist
racist82822792racist
ragis66325602ragis_
rapist82520672rapist
sadist74221352sadist
sagest74920262sagest
sagiest82617982sagiest
shist84829612shist
tanist6324592tanist
twist86820982twist
waist86132382waist
whist115322952whist
wist78049292_wist
wrist84827562wrist
yagis95416572yagis_

Search took 4 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.186960704.3
2DLD Change Limit538001063.20316796.8
3Display Results1061060.0631682.5
 (SQL Overall)1786911063.45251764.5
 
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.