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

175 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
tertians83910(None) 
tertials8510071tertials
tertian7511191tertian_
gentians937562gentians
martians103111612martians
pertains102113422pertains
tartans72615822tart_ans
terbias9310742terbia_s
ternions838812ternions
terrains8410322terrains
tertial7313862tertia_l
tertiary1145432tertiary
therians1138312ther_ians
titians72710452t_itians
aerations9317903aerations
aerials74017553aer_ials
artisans888523_artisans
bartisans1165553bartisans
bartizans2053703bartizans
berlins93216013berli_ns
berthas12398763bertha_s
ceratins102818733cerati_ns
cerias83321983cer_ia_s
certain92612213certain_
cortinas102212453cortinas
cortins92421333corti_ns
cretins93216423creti_ns
curtains10259703curtains
dentins83419223denti_ns
deraigns1034883deraigns
destains9311813destains
detains83716093de_tains
detrains9411763detrains
dextrans1695983dextrans
durians839573dur_ians
entertains1047623entertains
etesians845473etesians
exertions1639763exertions
ferias95020393fer_ia_s
fermions1336203fermions
fetials103711743fe_tials
fustians1146403fustians
gentian8310103gentian_
germans1079473ger_mans
hernias10310773hernia_s
heroins103518013heroi_ns
hessians1145053hessians
hetmans12187593he_tmans
inertias8410383inertia_s
iterations10413823iterations
jerkins18358253jerki_ns
jerricans1883753jerricans
keratins122313483kerati_ns
kerrias11289513kerria_s
lectins92515003lecti_ns
lections102413843lections
leptins92412693lepti_ns
lesbians1043603lesbians
martian93514683martian_
martins93322063marti_ns
medians103214213me_dians
mentions10312893mentions
meridians1245543meridians
merlins93015813merli_ns
parians93519743par_ians
partans94418283part_ans
partials101911973partials
partisans1167493partisans
partizans2055253partizans
pectins112315233pecti_ns
pereions10310853pereions
permian112612283permian_
pertain92714963pertain_
portions10514413portions
pterins9812993pter_i_ns
puritans1037633puritans
retains74522253re_tains
retinas74819353re_tinas
retrains8314533retrains
retrials8510823retrials
sections102714703sections
seitans73312303seit_ans
sereins73716123serei_ns
serials73919753ser_ials
serins64029673ser_i_ns
sestinas8249133sestinas
sextains15246813sextains
sextans14349273sext_ans
steradians1143883steradians
tactions102912423tactions
tarpans92513533tar_pans
tarsias74013373tarsia_s
tartan64217513tart_an_
tartana73010193tart_ana
tartanas8258893tart_anas
tartars73313403tart_ars
tarting84222653tarti_ng
tarzans16329923tar_zans
tearstains1043323tearstains
teatimes1039443teatimes
tectites1039993tectites
tektites1236613tektites
telerans859473telerans
tenias64720073te_nia_s
tenpins9410073tenpi_ns
tensions8310223tensions
tenting84621153tenti_ng
teopans939203te_opans
terais64023513ter__ais
teratisms11410073teratisms
terbia8311163terbia__
terbiums1245423terbiums
tergites9310543tergites
terminal1039733terminal
terminals1147463terminals
terming104016003termi_ng
termini93410813termi_ni
terminus1037393terminus
termites10313693termites
termtimes1354803termtimes
ternion739493ternion_
terns55226873ter___ns
terrain7410853terrain_
terrane72814233ter_rane
terranes82514433ter_ranes
terras63516973ter_ra_s
terreens8246533terreens
terriers84210823terriers
terries73425633terri_es
terrine72517573terri_ne
terrines82117553terrines
territs72714503terri_ts
tertiaries1047003tertiaries
testing86021053testi_ng
testis64916713testi__s
testons7313563test_ons
testoons837323testoons
tetanus737933te_t_anus
tetany959843te_t_any
tetrads82910193te_trads
tetras63017623te_tra_s
tetris62816293tetri__s
textiles1536833textiles
theriacs1336543ther_iacs
therian10311293ther_ian_
thermions1445333thermions
thespians1442843thespians
titans63414913t_it_ans
titian62512663t_itian_
torsions839183torsions
tortas64918253tort_a_s
tortious839023tortious
trains64725343t_rai_ns
trans54933043t_r__ans
trapans92812463t_rapans
trepans92311593t_repans
triacs83913223t_r_iacs
triads74513533t_r_iads
trials64319883t_r_ials
triens65417543t_r_iens
tritons73814883t_ritons
tuitions838283tuitions
turbans939563tur_bans
turions7311573tur_ions
urethans1145243urethans
venetians1244673venetians
verdins112812333verdi_ns
veritas103012753verita_s
vermian12329713vermian_
versions11310353versions
verticals1457243verticals
vertices13612283vertices
vertigos1254973vertigos
vervains1435293vervains
zeatins16311733zeati_ns

Search took 10 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621759.04616157.6
3Display Results1751750.0802187.5
 (SQL Overall)1786911759.54918713.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.