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

195 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
tympan1325701(None) 
tampan102512321tampan
tympana14255851tympana
tympani14275921tympani
tympano14245281tympano
tympans14236811tympans
tympany17254601tympany
sampan102511892sampan
taipan82410662taipan
tampans113310982tampans
tampon102911232tampon
tarpan82814292tarpan
teopan839352teopan
timpana11226132timpana
timpani11266152timpani
timpano11235862timpano
toman75724052tom_an
trapan82412972trapan
trepan82511672trepan
tymbal13236822tymbal
tympanal15243282tympanal
tympanic17234082tympanic
tympanum1742372tympanum
typal105311152ty_pal
adman84517903adm_an
ataman81013063atam_an
atman75520143atm_an
axman144813183axm_an
bayman133712703baym_an
bedpan1137583bedpan
bemean10410683bemean
bemoan10310253bemoan
cayman133613213caym_an
company1619711143company
compas125817063compas
cyan96419623cy__an
cyma116715843cym_a_
cymae126713013cym_ae
cymar125711263cym_ar
cymas126417883cym_as
cymbal15236913cymbal
cymlin1337313cymlin
daman84821163dam_an
dampen114310593dampen
demean9510563demean
etyma1036583etym_a_
etymon1134693etym_on
flyman14326423flym_an
frypan1434543frypan
hempen1338963hempen
human102716033hum_an
hymen13311043hym_en
hymn12311313hym__n
hymnal1434913hymnal
impawn1333263_impawn
inspan837513inspan
japan14411233_japan
lampad114510033lampad
lampas106615953lampas
layman113511303laym_an
leman75622603lem_an
liman75921603lim_an
limpa97014463limpa_
limpas105513083limpas
lumpen104010663lumpen
lymph1547043lymp_h
lymphs1635053lymphs
man57465873__m_an
mean65538093__mean
moan65832023__moan
nymph1555213nymp_h
nympha1643573nympha
nymphae1743833nymphae
nymphal1744033nymphal
nymphean1842403nymphean
nympho1643583nympho
nymphs1633503nymphs
oompah1334253oompah
pampa114913423pampa_
pampas124913993pampas
pampean1335543pampean
pan58466453___pan
pompano1345203pompano
pompon1238943pompon
pygmean1542223pygmean
pyran10514473py_ran
rampant11312173rampant
reman75730153rem_an
roman75424823rom_an
ryokan1353753ryokan
sampans112411003sampans
simian8811163simian
skyman1535313skym_an
soman75024903som_an
span65234663__span
stewpan1234193stewpan
stygian1144083stygian
sylvan12257363sylvan
taipans9269553taipans
tamal73522623tam_al
tambac122210243tambac
tambak14249263tambak
tamein8313093tamein
tamp86133003tamp__
tampala1136613tampala
tamped114317043tamped
tamper104618513tamper
tamping122815813tamping
tampion11298663tampion
tampons112711563tampons
tamps95524083tamp_s
tan37167573t___an
tapa65129143t_apa_
tapas74627713t_apas
tarpans92513533tarpans
tarpon82812803tarpon
tartan64217513tartan
tarzan152910753tarzan
taxman15328613taxman
temp85323333temp__
temped113912893temped
tempeh13357463tempeh
temper103914093temper
tempi94912203temp_i
temping122710693temping
templar1145643templar
temple102811333temple
tempo95214973temp_o
tempos103812293tempos
temps95417133temp_s
tempt95124843temp_t
tempts10439453tempts
tenpin8310583tenpin
teopans939203teopans
tepa66021683t_epa_
tepal76319583t_epal
tepas76521683t_epas
than76128773t__han
tiepin839343tiepin
timbal102510753timbal
timpanum1442563timpanum
tinman82411143tinman
titan53318173t_itan
titian62512663titian
titman82711003titman
tolan55124013t_olan
tomans85419133tom_ans
tombac12258883tombac
tombak14237753tombak
tombal102311023tombal
tomcat101013453tomcat
tompion11247103tompion
topaz16315323t_opaz
toucan838193toucan
trapans92812463trapans
trepang10257293trepang
trepans92311593trepans
triptan947543triptan
tropin83316753tropin
tryma1037223trym_a_
tump85927033tump__
tumped114216233tumped
tumping123114243tumping
tumps95420793tump_s
turban8310483turban
tycoon1136023tycoon
tyin76424003ty__in
tyiyn11635333ty_iyn
tymbals14265723tymbals
tympanies1644263tympanies
tympanist1644323tympanist
tympanums1851953tympanums
type96223743ty_p_e
typed115815453ty_ped
types105721063ty_pes
typey135511883ty_pey
typhon1436673typhon
typic124511963ty_pic
typing124110583ty_ping
typo95418123ty_p_o
typos106015813ty_pos
typp115812783ty_p_p
typps12549303ty_pps
typy126013043ty_p_y
tyrant9315333ty_rant
ulpan7310123_ulpan
unman72715423unm_an
woman105818003wom_an
xylan1537463xy_lan
yapon104613583_yapon
yean75834583_y_ean
yuan76120013_y_uan
yulan8411493_yulan
yupon10469483_yupon
zymosan2143803zymosan

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.376475242.0
2DLD Change Limit1127161956.21618133.2
3Display Results1951950.0633095.2
 (SQL Overall)1786911956.65526850.6
 
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.