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

233 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
tertian751119(None) 
tertial7313861tertial
tertians839101tertians
certain92612212certain
gentian8310102gentian
martian93514682martian
permian112612282permian
pertain92714962pertain
tartan64217512tart_an
terbia8311162terbia_
terbias9310742terbias
ternion739492ternion
terrain7410852terrain
tertials8510072tertials
tertiary1145432tertiary
therian10311292ther_ian
titian62512662t_itian
vermian12329712vermian
aeolian738633aeolian
aeonian738353aeonian
aeration8319933aeration
aerial64625713aer_ial
artisan759463_artisan
bartisan1056163bartisan
bartizan1954413bartizan
berlin83116373berli_n
bertha11429173bertha_
berthas12398763berthas
bestial9311643bestial
ceratin93020163cerati_n
ceria75125363cer_ia_
cerias83321983cer_ias
certify1546243certify
cortin82423153corti_n
cortina91915973cortina
cretin82917913creti_n
curtain9319793curtain
dentin73919573denti_n
deraign936573deraign
destain8412083destain
detain74617383de_tain
detrain8412253detrain
dextran1586163dextran
durian7312003dur_ian
entertain947863entertain
entia5318203_entia_
eolian6312593_eolian
eonian6311833_eonian
etesian757853etesian
exertion15310083exertion
feria85922713fer_ia_
feriae95618603fer_iae
ferial94621253fer_ial
ferias95020393fer_ias
fermion1236763fermion
fertile10311733fertile
fetial95716193fe_tial
fustian1036903fustian
gentians937563gentians
german9611983ger_man
germina1038503germina
herdman13238423herdman
herein93717793herei_n
hernia9312293hernia_
herniae1039043herniae
hernial10310433hernial
hernias10310773hernias
heroin94420593heroi_n
hessian1035853hessian
hetman112510603he_tman
inertia7410203inertia_
inertiae8411473inertiae
inertial8411733inertial
inertias8410383inertias
iteration9515033iteration
jerkin17258113jerki_n
jerrican1794123jerrican
keratin113314153kerati_n
kerria10339923kerria_
kerrias11289513kerrias
lectin82515013lecti_n
lection92614863lection
leptin82512333lepti_n
lesbian944463lesbian
martial92415413martial
martians103111613martians
martin84122523marti_n
meatman1137903meatman
median94117543me_dian
mention9314373mention
meridian1147683meridian
merlin83916683merli_n
merman10513863mer_man
mesian84315503me_sian
parian83223963par_ian
partan83820563part_an
partial92616263partial
partisan1058423partisan
partizan1955643partizan
pectin102615533pecti_n
pereia85217983pereia_
pereion9312053pereion
pertains102113423pertains
portion9615493portion
pterin81014153pter_i_n
puritan939283puritan
reran57329103rer__an
retain64523283re_tain
retia55326113re_tia_
retial64724993re_tial
retina65023383re_tina
retrain7615423retrain
retrial7615553retrial
section92515663section
seitan62613233seit_an
serein63318463serei_n
serial64625863ser_ial
serin55434443ser_i_n
sestina72711973sestina
sextain14257103sextain
sextan13389643sext_an
steradian1045063steradian
taction93213023taction
tarpan82814293tar_pan
tarsia65514273tarsia_
tarsias74013373tarsias
tartana73010193tart_ana
tartans72615823tart_ans
tartar63214753tart_ar
tartier74123263tartier
tartily103511573tartily
tarting84222653tarting
tartish101512633tartish
tarzan152910753tar_zan
tearstain943433tearstain
teatime9310083teatime
tecta74215523tect_a_
tectal83713253tect_al
tectite9310583tectite
tegmina1035243tegmina
tektite1136883tektite
teleman959573teleman
teleran7510183teleran
telia55821143te_lia_
telial65815363te_lial
tenia55324483te_nia_
teniae64517353te_niae
tenias64720073te_nias
tenpin8310583tenpi_n
tension7311803tension
tentie62521183tenti_e
tentier73815923tentier
tenting84621153tenting
teopan839353te_opan
terai53525483ter__ai
terais64023513terai_s
teratism10312173teratism
terbic10410963terbi_c
terbium1147293terbium
terefah1344113terefah
terga63315643ter_ga_
tergal72912833ter_gal
tergite8311003tergite
terminal1039733terminal
terming104016003terming
termini93410813termini
termite9313893termite
termtime1244773termtime
tern46134803ter___n
ternions838813ternions
terra54419673ter_ra_
terrae62915213ter_rae
terrains8410323terrains
terrane72814233ter_rane
terras63516973ter_ras
terreen7257573terreen
terrier73414963terrier
terries73425633terries
terrify1336353terrify
terrine72517573terrine
territ63421383terri_t
territs72714503territs
testa54822043test_a_
testae64216253test_ae
testier74015643testier
testify13246943testify
testily102910803testily
testing86021053testing
testis64916713testi_s
teston6313303test_on
testoon748373testoon
tetany959843te_t_any
tetra53417953te_tra_
tetrad73612053te_trad
tetras63017623te_tras
tetri52716453tetri__
tetris62816293tetri_s
textile1437223textile
textual1444603textual
therein102310353therei_n
theriac1239143ther_iac
therians1138313ther_ians
thermion1345933thermion
thespian1343203thespian
titan53318173t_it_an
titians72710453t_itians
titman82711003t_itman
torsion7310803torsion
torta55925353tort_a_
tortas64918253tort_as
torten65314353tort_en
tortile7313193tortile
train56529113t_rai_n
trapan82412973t_rapan
trepan82511673t_repan
triac74116373t_r_iac
triad65217723t_r_iad
trial54926353t_r_ial
triton63914893t_riton
tuition738823tuition
turban8310483tur_ban
turfman1243983turfman
turion6313163tur_ion
urethan1045473urethan
venetian1146073venetian
verdin103113023verdi_n
veritas103012753veritas
vermin113414523vermi_n
version10310923version
vertical13410433vertical
vertigo1146133vertigo
vervain1335563vervain
zeatin15412823zeati_n

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.436409841.7
2DLD Change Limit1340272336.20321606.8
3Display Results2332330.0962427.1
 (SQL Overall)1786912336.73526531.7
 
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.