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

159 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
tympans1423681(None) 
tampans113310981tampans
tympan13257011tympan_
tympana14255851tympana
tympani14275921tympani
tympano14245281tympano
tympany17254601tympany
sampans112411002sampans
taipans9269552taipans
tampan102512322tampan_
tampons112711562tampons
tarpans92513532tarpans
teopans939202teopans
timpana11226132timpana
timpani11266152timpani
timpano11235862timpano
tomans85419132tom_ans
trapans92812462trapans
trepans92311592trepans
tymbals14265722tymbals
tympanal15243282tympanal
tympanic17234082tympanic
tympanies1644262tympanies
tympanist1644322tympanist
tympanum1742372tympanum
tympanums1851952tympanums
atamans9710433atam_ans
atmans84413963atm_ans
bedpans1237173bedpans
bemeans1148743bemeans
bemoans1138253bemoans
bypass1345043by_pass
caymans14349513caym_ans
company1619711143company
compas125817063compa_s
compass13379563compass
cyans105714813cy__ans
cymars13599153cym_ars
cymas126417883cym_a_s
cymbals16236143cymbals
cymlins1436693cymlins
damans94715983dam_ans
dampens12348563dampens
demeans1039723demeans
etymons1244153etym_ons
frypans1544053frypans
humans112312433hum_ans
hymens1437993hym_ens
hymnals1543523hymnals
hymns1337523hym__ns
impawns1433323_impawns
inspans937803inspans
japans1539823_japans
lampads12477623lampads
lampas106615953lampa_s
lemans85316393lem_ans
limans84816303lim_ans
limpas105513083limpa_s
lumpens11298263lumpens
lymphs1635053lymp_hs
mans66354553__m_ans
means75831233__means
moans74624373__moans
nymphos1744083nymphos
nymphs1633503nymp_hs
oompahs1434263oompahs
pampas124913993pampa_s
pampeans1444703pampeans
pans65855733___pans
pompano1345203pompano
pompanos1445243pompanos
pompons1338553pompons
pyrans11411063py_rans
rampant11312173rampant
remans84823003rem_ans
romans84620243rom_ans
ryokans1443293ryokans
sampan102511893sampan_
simians959203simians
somans84619303som_ans
spans74528733__spans
stewpans1343713stewpans
sylvans13235893sylvans
taipan82410663taipan_
tamals84116633tam_als
tambacs13219363tambacs
tambaks15218153tambaks
tameins9311423tameins
tampala1136613tampala
tampalas1245473tampalas
tampers113516743tampers
tamping122815813tamping
tampions12358123tampions
tampon102911233tampon_
tamps95524083tamp__s
tans46154823t___ans
tapas74627713t_apa_s
tarpan82814293tarpan_
tarpons92612213tarpons
tartans72615823tartans
tarzans16329923tarzans
tempehs14325153tempehs
tempers113513013tempers
temping122710693temping
templars1255263templars
temples112610893temples
tempos103812293temp_os
temps95417133temp__s
tempts10439453temp_ts
tenpins9410073tenpins
teopan839353teopan_
tepals85415043t_epals
tepas76521683t_epa_s
tiepins939463tiepins
timbals11239533timbals
timpanist1345373timpanist
timpanum1442563timpanum
timpanums1542013timpanums
titans63414913t_itans
titians72710453titians
tolans64319273t_olans
toman75724053tom_an_
tombacs13248443tombacs
tombaks15246863tombaks
tomcats11127773tomcats
tompions12267003tompions
toucans937583toucans
trans54933043t__rans
trapan82412973trapan_
trepan82511673trepan_
trepang10257293trepang
trepangs11205403trepangs
triptans1047363triptans
tropins93116313tropins
tumping123114243tumping
tumps95420793tump__s
turbans939563turbans
tycoons1235173tycoons
tymbal13236823tymba_l
tympanists1743103tympanists
tympanites1743233tympanites
typal105311153ty_pa_l
types105721063ty_p_es
typhons1537083typhons
typhus14395713ty_phus
typing124110583ty_ping
typos106015813ty_p_os
typps12549303ty_p_ps
tyrant9315333ty_rant
tyrants1037453ty_rants
unmans82211993unm_ans
womans114613653wom_ans
xylans1635883xy_lans
yapons114411773_yapons
yeans86624883_y_eans
yuans84613323_y_uans
yulans958673_yulans
yupons11398353_yupons
zymosans2243223zymosans

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271595.97022450.1
3Display Results1591590.0463456.5
 (SQL Overall)1786911596.42227824.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.