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

226 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
tectite931058(None) 
tectites1039991tectites
tektite1136881tektite
pectate112214692pectate
pectize20259912pectize
petite84320652pe_tite
recite83625112rec_ite
sectile9311972sectile
smectite1245772smectite
steatite8310582steatite
tactile9310612tactile
teatime9310082teatime
techie11511722techi_e
tektites1236612tektites
tentie62521182tenti_e
tergite8311002tergite
termite9313892termite
testate73916232testate
textile1437222textile
acetate92514753acetate
active11313743_active
apatite9312963apatite
becrime1387053becrime
bedtime1236973bedtime
betide95115973be_tide
betime105914833be_time
betise85616273be_tise
biotite9311033biotite
cecity1398153cec_ity
centile94217183centile
centime114513033centime
cerite84724873ce_rite
cite65640353__c_ite
dacite91115883dac_ite
deceit93018213deceit_
deceits102810883deceits
deceive1337813deceive
decide104116873dec_ide
decile94619213dec_ile
decline103716613decline
dentate8315153dentate
dentine83320243dentine
despite10410123despite
destine83719953destine
detective1548103detective
dictate10311663dictate
ductile1048483ductile
ecarte84313503_ecarte
ectype1334283_ectype
ejective2037153ejective
elective13311003elective
elite56230183_e_lite
endite73817593_endite
entice81316863_entice
entire61617703_entire
entitle7610293_entitle
entity9312053_entity
erectile1039513erectile
erective13311833erective
estate64719763_estate
eucrite939903eucrite
evite85317683_e_vite
excite15310883_excite
felsite1039083felsite
ferrite103312753ferrite
fertile10311733fertile
festive1339773festive
fictile1238023fictile
fictive1537023fictive
gentile83515293gentile
gestate83614073gestate
hectare1238473hectare
hectic132311523hecti_c
helictite1445973helictite
hematite131612153hematite
hessite1038993hessite
incite83618733inc_ite
kernite1159473kernite
lactate9312703lactate
lectin82515013lecti_n
lectins92515003lectins
lection92614863lection
lecture9149523lecture
lenite6719983le_nite
leucite937753leucite
lucite8313343luc_ite
metate82720533me_tate
necktie1344373neckti_e
nictate9310223nictate
orective1339353orective
partite9317133partite
pectase112410363pectase
pectates122213953pectates
pectic122913873pecti_c
pectin102615533pecti_n
pectinate1349553pectinate
pectines121914683pectines
pectins112315233pectins
pectized22257593pectized
pectizes21229793pectizes
pelite84323003pe_lite
peltate92013773peltate
penlite9313243penlite
peptide122910693peptide
peptize20279483peptize
perlite9317323perlite
petit74332653pe_tit_
petites93820203pe_tites
picrite111911313picrite
ratite65022423_ratite
reactive13310473reactive
receive1239733receive
recipe103414893rec_ipe
recit75235103rec_it_
recited104319103rec_ited
reciter94117263rec_iter
recites93524583rec_ites
recits83621353rec_its
recline94020493recline
recrate92621663recrate
recti73619623recti__
rectify1536453rectify
rectitude1244773rectitude
reptile93914083reptile
requite162012483requite
resite64128453re_site
respite9513033respite
restate73824883restate
restive10315933restive
retie55735303re_ti_e
retile65929673re_tile
retime85321803re_time
retine66237333re_tine
retire64927013re_tire
retitle73913093re_title
reunite7312713reunite
rewrite10311143rewrite
secrete9311073secrete
section92515663section
septate9511873septate
septime1138803septime
sestine73017923sestine
sextile1438573sextile
smectites1344623smectites
spectate12248833spectate
steatites939853steatites
stellite839533stellite
sternite8310543sternite
tachiste1356213tachiste
tacit76333673tac_it_
taconite1049313taconite
tacrine9311293tacrine
tactic10612753tacti_c
tactics1149323tactics
taction93213023taction
tattie64817513tatti_e
taxite13511303t_axite
tealike111111083tealike
teatimes1039443teatimes
techier1269243techier
techies12513603techies
techily1537123techily
tecta74215523tec__ta
tectal83713253tect_al
tectrices1346253tectrices
tectrix1644263tectrix
tectum10328603tect_um
tectums11306423tectums
teethe94511313teet_he
tekkie934203tekki_e
tektitic1444133tektitic
teniae64517353te_niae
tenorite8311993tenorite
tensile72612733tensile
tensity1039103tensity
tensive10269913tensive
tentage81010643tentage
tentier73815923tentier
tenting84621153tenting
tentlike1236903tentlike
tenuity1037453tenuity
teosinte845543teosinte
tephrite1346593tephrite
terete6319333te_rete
tergites9310543tergites
termites10313693termites
termtime1244773termtime
ternate7415483ternate
terrine72517573terrine
territ63421383territ_
territs72714503territs
tertial7313863tertial
tertian7511193tertian
testae64216253test_ae
testates83615453testates
testee64323303test_ee
testicle1037443testicle
testier74015643testier
testify13246943testify
testily102910803testily
testing86021053testing
testis64916713testi_s
tetter64322453te_t_ter
textiles1536833textiles
texture1497083texture
thecate123210023thec_ate
thermite1339033thermite
thorite10313443thorite
tillite7313563tillite
tittie63213153titti_e
toccate1138773toccate
tomtit8413853tomtit_
tomtits937243tomtits
tontine72316143tontine
tortile7313193tortile
tractate10411003tractate
tractile10311073tractile
tractive13310043tractive
treatise8311103treatise
trichite1349333trichite
trite54730033t__rite
turgite837973turgite
verite94323443ve_rite
vestige1137433vestige
website1235323website
zeolite1638903zeolite

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.390458182.1
2DLD Change Limit1340272266.83019623.3
3Display Results2262260.0762973.7
 (SQL Overall)1786912267.29624491.6
 
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.