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 “spree” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

136 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
spree7483086(None) 
pree67044731_pree
saree55044661saree
scree720031711scree
siree55238811siree
sprees85620641sprees
sprue74717631sprue
agree65226032agree
apres75426402apres
bree67241262_bree
dree56638322_dree
epee64628502ep_ee
free75940182_free
gree56641562_gree
hiree85427802hiree
laree56036302laree
osprey1134882osprey
pee56066512_p_ee
pere66450262_pere
preed85128122_preed
preen75925052_preen
prees75937172_prees
prep86427672_prep
prese75228382_prese
prex135722972_prex
prey96228482_prey
prez156126312_prez
puree74632842puree
ree37974072__ree
sarees65329942sarees
sarge65531132sarge
screed95718932screed
screen85216022screen
screes85023972screes
screw109318542screw
see35772262s__ee
sere46153472ser_e
sered65737292sered
serene63522352serene
serer55935512serer
seres55448892seres
serge64727472serge
serve85425962serve
shred98125612shred
shrew119720172shrew
sire46150422sir_e
sired66134282sired
sirees64624582sirees
siren54525822siren
sires55945372sires
sirree64017342sirree
skee85431472s_kee
soiree62919482soiree
sore47059532sor_e
sored66141782sored
sorel56231442sorel
sorer56236592sorer
sores55454282sores
space95325672space
spade84423322spade
spae65034322sp_ae
spaed85522272spaed
spaes76029972spaes
spahee11313442spahee
spake114322742spake
spale74929212spale
spare75135562spare
spared95427492spared
sparer84524962sparer
spares84834552spares
sparge94216052sparge
sparse84516342sparse
spate74731582spate
spec85821972sp_ec
sped76031492sp_ed
speed85526622speed
speel74420762speel
speer74623902speer
sperm93216022sperm
spew95421872sp_ew
sphene113412402sphene
sphere113313662sphere
spice95528812spice
spied85427712spied
spiel74623912spiel
spier75728032spier
spies76037622spies
spike114922842spike
spile75230082spile
spine76534422spine
spire75828692spire
spirea84015632spirea
spired94921862spired
spirem104214162spirem
spireme11478362spireme
spires84628112spires
spite75430662spite
spleen8310262spleen
spode84617702spode
spoke114818662spoke
spore75428592spore
spored94821792spored
spores84726612spores
sprag86418692sprag
sprat76635972sprat
spray106720062spray
spread9312532spread
sprent84522382sprent
sprier84119062sprier
sprig85617742sprig
sprit76736402sprit
sprite84421772sprite
spruce103910872spruce
sprues84515762sprues
sprug85313892sprug
spry96819122spr_y
spryer11418532spryer
spue66025522sp_ue
spued84918472spued
spues75025382spues
spume95817312spume
spurge93711322spurge
stere55328542stere
streek104111412streek
streel64214022streel
street64125772street
strep77120852strep
strew89220662strew
supreme1137892supreme
sure45447412sur_e
surer54833102surer
surge65027692surge
sycee105018622sycee
syren85216742syren
three87526912three
tree47745812_tree

Search took 3 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 Filter178691538000.313570897.8
2DLD Change Limit538001361.64032804.9
3Display Results1361360.0462956.5
 (SQL Overall)1786911361.99989390.2
 
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.