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

217 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
tessera73633(None) 
tesserae844791tesserae
dessert82916452dessert
lesser63514852lesser_
teaser65421522teaser_
teasers75317242teasers
tempera11329042tempera
tenser64919432tenser_
terser67317822terser_
tesseract1153342tesseract
tester64227152tester_
testers74124542testers
tosser64215662tosser_
tossers74713502tossers
tusser64615832tusser_
tussers74313562tussers
assert64922583_assert
berserk1334913berserk
besmear1134833besmear
blesser9329293blesser_
blessers10277633blessers
bursera936763bursera
cassena9287843cassena
censer84516583censer_
censers94313903censers
cessed94615613cesse_d
cesses84221363cesse_s
cesura838763ce_sura
cusser86016093cusser_
cussers94213403cussers
denser74115193denser_
desert72725493de_sert
desserts9247923desserts
dissert83720693dissert
dosser74417973dosser_
dossers84516233dossers
dresser83611953dresser_
dressers9359863dressers
drosera836203drosera
enserf9310763_enserf
entera64216833_entera
esker94412983_esker_
eskers105312223_eskers
esses56422973_esse_s
ester54727713_ester_
esters64627733_esters
exsert13414363_exsert
fesse86116333fesse__
fessed104515063fesse_d
fesses94820253fesse_s
fester94723513fester_
festers104121393festers
fusser94813773fusser_
fussers104210813fussers
gasser75017773gasser_
gassers84714633gassers
genera71211713ge_nera
gerbera1034773gerbera
gesneria944053gesneria
geyser1036513geyser_
geysers1135703geysers
guesser8166543guesser_
guessers9174903guessers
hetaera1036493hetaera
hisser94713793hisser_
hissers104112313hissers
jesse126012833jesse__
jessed144112303jesse_d
jesses135215953jesse_s
jester134319153jester_
jesters144118193jesters
kisser104212453kisser_
kissers114211293kissers
leaser65322673leaser_
leasers74717843leasers
lessee64116363lesse_e
lessees73510243lessees
lessen64212433lesse_n
lessens7409383lessens
lessor64010603lessor_
lessors73610523lessors
messed95018183messe_d
messes84924343messe_s
messier93412923messier_
mosser84618273mosser_
mossers94116193mossers
nesses64718323nesse_s
nester64124183nester_
nesters74422793nesters
ossetra744073_ossetra
passer84721033passer_
passers94717753passers
peseta8310573pe_seta
pesewa1135543pe_sewa
pessary1246873pessary
pester84827593pester_
pesters93827093pesters
pisser84416383pisser_
pissers95014753pissers
presser93717623presser_
pressers103215023pressers
reassert8313673reassert
reseda739703re_seda
rester63832433rester_
resters74130403resters
seiser65318343seiser_
seisers73816393seisers
sera46141393___sera
tasse54821843tasse__
tassel66014773tasse_l
tassels74510853tassels
tasses64826763tasse_s
tasset65925313tasse_t
tassets75012773tassets
taster64930573taster_
tasters74225643tasters
tearer64822903tearer_
tearers75218233tearers
tease55428713tease__
teased74721153tease_d
teasel63914983tease_l
teasels74311313teasels
teases65426273tease_s
tedder83312163tedder_
tedders94010233tedders
teemer85515743teemer_
teemers95012903teemers
teener64717503teener_
teeners74415453teeners
teeter65420313teeter_
teeters74018303teeters
telega736773te_lega
teleran7510173te_leran
telfer9379893telfer_
telfers10299073telfers
teller63519813teller_
tellers73717593tellers
temper103914093temper_
temperas12278233temperas
tempers113513013tempers
tempura11295253tempura
tender74121843tender_
tenders83719723tenders
tenner64117103tenner_
tenners74014923tenners
tense55225843tense__
tensed74817833tense_d
tensely1037363tensely
tenses64722553tense_s
tensest72713313tensest
tensor63812673tensor_
tensors72712373tensors
tenter64623933tenter_
tenters73921103tenters
tephra1136483te_phra
termer85717253termer_
termers95414503termers
terra54419663te__rra
terse55026823terse__
tersely1038113tersely
tersest71713993tersest
tesla55612603te_s_la
tesselate944183tesselate
tesseracts1251583tesseracts
tessitura951803tessitura
testa54822043te_s_ta
tested74421523teste_d
testee64323303teste_e
testees74215913testees
testes65125823teste_s
testier74015643testier_
tether93716103tether_
tethers103815313tethers
tetra53417953te__tra
tetter64322453tetter_
tetters74320473tetters
tossed74215223tosse_d
tosses65225393tosse_s
tressed83714263tresse_d
tressel73010893tresse_l
tressels8367653tressels
tresses73719543tresse_s
tressier847963tressier_
tressure846483tressure
trusser74010263trusser_
trussers8348283trussers
tuatera756373tuatera
tushery1335633tushery
tusker104212193tusker_
tuskers113710043tuskers
tussar6369543tussar_
tussars7359253tussars
tusseh9448423tusse_h
tussehs10395563tussehs
tusses64921243tusse_s
tussor6378233tussor_
tussore7317283tussore
tussors7388773tussors
tussur6357293tussur_
tussurs7356393tussurs
verser94516963verser_
versers103813523versers
vesper1138083vesper_
vesperal1344883vesperal
vespers1239033vespers
vessel937953vesse_l
vessels1035933vessels
viscera1235083viscera
wester94222893wester_
western102911093western
westers105221963westers
yessed104511163yesse_d
yesses93615813yesse_s
yester93417983yester_
yestern10338633yestern
zester153617793zester_
zesters163517293zesters

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.406440125.6
2DLD Change Limit1340272176.78319759.3
3Display Results2172170.0762855.3
 (SQL Overall)1786912177.26524596.1
 
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.