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

128 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
trangam103935(None) 
trangams1147201trangams
grandam1139392grandam
tanga64923692t_anga_
tangram1038072t_angram
transom948822transom
amalgam1244923amalgam
anga56831353__anga_
angas65827983__angas
bantam10314063_bantam
crania82418433crania_
cranial92114683cranial
cranium11911103cranium
fanga96119623_fanga_
fangas105017193_fangas
graham1237853gra_ham
grana65722093gran_a_
grandad1038453grandad
grandame1247113grandame
grandams1237123grandams
granddam1344693granddam
grandma1136913grandma
grange83716203grang_e
granger93514213granger
granges93516523granges
granum9310913gran_um
gringa838553gringa_
gringas938043gringas
hangar104114513_hangar
lingam95112353_lingam
manga85026203_manga_
mangas94122923_mangas
mridangam1581713mridangam
orang65119943orang__
orange74016323orang_e
oranges84215333oranges
orangey11388833orangey
orangs74116033orang_s
orangy105111233orang_y
panga85323533_panga_
pangas99921103_pangas
pangram1239023_pangram
praam94815613pra__am
prang84820323prang__
pranged114512553pranged
prangs94816233prang_s
raga55930813_ra_ga_
ragas65326063_ra_gas
randan7315253_randan
random92513553_random
rang56939163_rang__
range64728413_rang_e
ranged84824313_ranged
ranger73925523_ranger
ranges73826923_ranges
rangy95320383_rang_y
ransom82410943_ransom
sanga66023793_sanga_
sangar73617683_sangar
sangas75222653_sangas
strang75718313strang__
strange85416343strang_e
stranger94715103stranger
stranges94516763stranges
strangle98411503strangle
taiga64115663t_aiga_
taigas73712563t_aigas
tandem9311403t_andem
tang56138673t_ang__
tanged84622493t_anged
tangle74019953t_angle
tangly104413913t_angly
tango66921173t_ang_o
tangos74216303t_angos
tangrams1136163t_angrams
tangs65028343t_ang_s
tangy94519933t_ang_y
tanka93817483t_anka_
tankas104613763t_ankas
tarantas839193tarantas
tarnal63716503tarn_al
teargas837013teargas
thanage11117943thanage
tonga65619693t_onga_
tongas74315523t_ongas
tragi64717173tra_g_i
tragic93811543tra_gic
tragus749233tra_gus
trainman1046233trainman
trainway1444223trainway
tram67034553tr___am
tramcar1135593tramcar
tramway1544863tramway
trance84718763tran_ce
tranced104414173tranced
trances93919643trances
tranche123312223tranche
trank96222423tran__k
tranks104017763tran_ks
tranny94210863tran_ny
tranq145416893tran__q
tranqs155210313tran_qs
trans54933043tran__s
transact1049823transact
transit7317163transit
transoms1048933transoms
trapan82412973tra_pan
trauma838803trauma_
traumas938593traumas
triangle935533triangle
trigram1077763trigram
trinal6516963trin_al
trona54118953tron_a_
tronas63816903tron_as
twang94511853twang__
twanged12387273twanged
twanger11327433twanger
twangle1145803twangle
twangs10358093twang_s
twangy13386983twang_y
urania62516123urania_
uranias72113813uranias
uranism91112513uranism
uranium9610023uranium
wangan10311223_wangan
wrang94716113wrang__
wrangle1137383wrangle
wrangs104611913wrang_s

Search took 8 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 Limit1340271287.15618729.3
3Display Results1281280.0462782.6
 (SQL Overall)1786911287.35824285.3
 
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.