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

234 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
strette731076(None) 
stretta737291stretta
stretti747911stretti
stretto737731stretto
syrette1037181syrette
burette939852burette
curette939782curette
stetted82610402st_etted
street64125772street_
streets73312612streets
stretch1236412stretch
strettas846422strettas
strettos847112strettos
striate74218952striate
strutted946342strutted
strutter846502strutter
syrettes1136962syrettes
aigrette946833aigrette
arete56031353_are_te
ariette7312373ariette
atretic9313923atretic
aureate72515283aureate
barbette1249113barbette
barrette1039783barrette
beretta938463beretta
biretta947243biretta
burettes1048953burettes
casette9310393casette
corvette1338093corvette
create85126383_create
curetted1137173curetted
curettes1039313curettes
cuvette1235833cuvette
dinette8310013dinette
esthete1047433esthe_te
estreat7314813estreat_
estreated1039553estreated
estreats839423estreats
fouette1038213fouette
fretted113411853_fretted
fretter103412753_fretter
fretty1249223_fretty
fumette1245523fumette
galette84212693galette
garotte868703garotte
gazette17357363gazette
genette838863genette
iterate71119113iterate
layette1037133layette
lunette737483lunette
mofette1296773mofette
mozette1886773mozette
musette938433musette
navette1036983navette
ocreate93711743ocreate
octette946423octette
palette93613983palette
parkette14138023parkette
pipette1137943pipette
pretty11510873_pretty
proette9312363proette
rente54733783__rente
rete44944133__re_te
retie55735303__retie
retted74826313__retted
rosette7310373rosette
rotte54625933__rotte
saree55044663sare__e
satinette944553satinette
scree720031713scre__e
secrete9311073secre_te
seethe93712483s_eethe
sente56432883s__ente
septette1044763septette
serenate81914883serenate
serene63522353sere_ne
serest64831613serest_
seriate73722473seriate
serrate73017543serrate
serviette1242963serviette
setae56026223s__etae
sett45949053s__ett_
settee63721023s__ettee
setter64023723s__etter
settle63915663s__ettle
setts55124323s__etts
sextette1544073sextette
siree55238813sire__e
sirvente1145023sirvente
sorbate9311733sorbate
sorest65028003sorest_
sortie63621993sor_tie
soubrette1143993soubrette
sprattle1054763sprattle
spree74830863spre__e
sprent84522383sprent_
sprite84421773spr_ite
stacte82113913st_acte
staithe1037723staithe
starets73515923stare_ts
startle72511123startle
state56237333st__ate
statue66015323st_atue
statuette943263statuette
statute7419323statute
steatite8310583steatite
steelie7310213steelie
steeple937323steeple
steeve93710903st_eeve
stelae63716483st_elae
stele55026843st_e_le
stent55634513st_ent_
stents65019453st_ents
steppe10319873st_eppe
stere55328543st_e_re
sterile7316603sterile
sterlet71318473sterlet
sternite8310543sternite
stertor7310093stertor
stet45947323st_e_t_
stets55423913st_e_ts
stiletto843793stiletto
stomate9313123stomate
stott56929793st_ott_
stotted83511423st_otted
stotts64612863st_otts
strafe95215983str_afe
strait64025893strait_
straiten838613straiten
straiter8311783straiter
straits74916323straits
strake104017393str_ake
strange85416343strange
strata63616283str_ata
stratal72710603stratal
stratas73013583stratas
strath93216373str_ath
straths102711723straths
strati63518903str_ati
stratum9318253stratum
stratus73011733stratus
streak104613623stre_ak
streaked13228453streaked
streaker12229483streaker
streaks114411273streaks
streaky14447813streaky
stream84717293stre_am
streamed11258903streamed
streamer10239513streamer
streams94713373streams
streamy12509483streamy
streek104111413stre_ek
streeked13246153streeked
streeker12206643streeker
streeks11378713streeks
streel64214023stre_el
streeled9267863streeled
streels73811343streels
strength1244433strength
strep77120853stre__p
streps86218063stre_ps
stress66616673stre_ss
stressed9128543stressed
stresses81112493stresses
stretched1546213stretched
stretcher1446293stretcher
stretches1438293stretches
stretchy1644083stretchy
streusel843933streusel
strew89220663stre__w
strewed115811343strewed
strewer104310413strewer
strewn96710013stre_wn
strews96817103stre_ws
striae65422273str_iae
striata7379953striata
striated93414153striated
striates83417083striates
strict84821043strict_
stricter1039423stricter
stride75420963str_ide
strife95318363str_ife
strike105619733str_ike
stripe85822443str_ipe
stript85222193stript_
strive95020963str_ive
strobe84513813str_obe
strode75215973str_ode
stroke105116173str_oke
strophe1239143strophe
strove95014793str_ove
strumae9368093strumae
strunt64918913strunt_
strunted957243strunted
strunts7429543strunts
strut56030733str_ut_
struts65616803str_uts
strutters955693strutters
stutter72911463st_utter
stylate10179773stylate
stylite10219613stylite
styrene10116693styre_ne
superette1149973superette
surest65026763surest_
sureties8316583sureties
surety93515013sure_ty
svelte9319753s_velte
sweetie10157873sweetie
teethe94511313_teethe
terete6319333_terete
tetter64322453_t_etter
tonette7310373tonette
treat56240353_treat_
treated83618703_treated
treater74219833_treater
treats64821693_treats
treaty94414353_treaty
treble8311663_treble
tree47745813_tre__e
trestle72611363_trestle
tret46653533_tre_t_
trets55928023_tre_ts
trevet94818913_trevet
triste63818643_triste
trite54730033_tr_ite
trotted83711283_trotted
trotter73312253_trotter
tryste9399583_tryste
tsetse664693_tsetse
tzetze1432733_tzetze
umbrette1244943umbrette
usherette1242723usherette
vedette1166003vedette
vidette1167543vidette

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 Limit1340272346.79619721.5
3Display Results2342340.0932516.1
 (SQL Overall)1786912347.27924548.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.