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

104 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
afghan133387(None) 
afghani1442531afghani
afghans1443571afghans
afghanis1542862afghanis
agha87417302a_gha_
aghas97014872a_ghas
ataghan1144652ataghan
adman84517903a_dman
afar76720783af__ar
affiant1348433affiant
affray1534973affray
afloat9315153afloat
aga410447233a_g_a_
again65218123a_gain
agar58726413a_g_ar
agas55938843a_g_as
aghast105711373a_ghast
agin56132713a_g_in
agma77623263a_gma_
agmas85919873a_gmas
agon56531883a_g_on
aha611246643a__ha_
aidman92410623aidman
airman82414223airman
ajowan1634893ajowan
alan46844083a__lan
alga57927603alg_a_
algae65319623alg_ae
algal66518223alg_al
algas65624933alg_as
algin65718763alg_in
aloha8513613aloha_
alohas9411703alohas
alpha1049653alpha_
alphas1139513alphas
ameban1039093ameban
anga56831353ang_a_
angas65827983ang_as
angina7413133angina
anuran64313243anuran
apian75018333a_pian
apogean1045443apogean
archean1269123archean
archon11311753archon
argal65023393arg_al
argon65520593arg_on
arhat8327093a_rhat
arshin9312173arshin
ashcan1135843ashcan
ashen87818673a_shen
ashman1148383ashman
ataghans1244263ataghans
ataman81013063ataman
atman75520143a_tman
aught95120703augh_t
aughts104710243aughts
avgas96912133avg_as
avian84616053a_vian
axeman1538103axeman
axman144813183a_xman
azan136521783a__zan
bagman114613813bagman
barchan1469133barchan
began86319573beg_an
bogan87519003bog_an
caftan111710123caf_tan
darshan1167063darshan
fagin9216573fag_in
fan67158863_f__an
flan76134183_f_lan
fohn106116553_foh_n
furan84320013_furan
gagman103811243gagman
gan48060133__g_an
ghat86435283__ghat
gran56335013__gran
guan55325583__guan
hangman1337813hangman
hogan97817703hog_an
kaftan13185823kaf_tan
khan115819143__khan
lagan66520343lag_an
langshan1244533langshan
legman949653legman
ligan67920283lig_an
lignan75510323lignan
lochan1139093lochan
logan68123283log_an
magian9312833magian
mughal1236273mughal
offhand1742883offhand
ogham1138253_ogham
organ6915393org_an
orphan1137733orphan
pagan86121163pag_an
pechan13511543pechan
raglan73711503raglan
ragman94013713ragman
than76128773__than
vegan95114153veg_an
wangan10311223wang_an
wigan95114393wig_an
xanthan1736013xanthan
yataghan1542313yataghan

Search took 7 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.420425454.8
2DLD Change Limit1127161045.65619928.6
3Display Results1041040.0333151.5
 (SQL Overall)1786911046.10929250.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.