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

176 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
spurs7462152(None) 
purs65641041_purs
slurs54123371slurs
sours55230501sours
spars75431541spars
spuds85113671spuds
spues75025381spues
spur65321191spur_
spurn74815451spurn
spurns84811381spurns
spurt77227981spurt
spurts84814971spurts
apers76629132apers
aspers86220312aspers
blurs74619082blurs
burs65847422_burs
curs65645542_curs
fours85521492fours
furs76735042_furs
gaurs66317992gaurs
hours85422392hours
knurs94511152knurs
lours55125292lours
opus66420592opu_s
ours47237562_ours
pars67560792_pars
pours74623182pours
pubs85029212_pubs
puds75630512_puds
pugs76332772_pugs
puls65437562_puls
puns66641482_puns
pups86032232_pups
pur56840552_pur_
pure65543332_pure
puri65931442_puri
puris75332022_puris
purl65631422_purl
purls74723352_purls
purr64925812_purr
purrs75320432_purrs
purse76028892_purse
pursy105016412_pursy
pus55547842_pu_s
puss64830132_puss
puts65641752_puts
sapors84118812sapors
sapours93610622sapours
sauls55128122sauls
saury84317222saury
scars75433532scars
scaurs85512052scaurs
scours84913592scours
scuds85116242scuds
scums95017422scums
scups95316652scups
scurf104719322scurf
scurfs113210812scurfs
scuts74522522scuts
sears54744912sears
seers55136382seers
sers45746652s_ers
shuls85319712shuls
shuns85018142shuns
shuts85622482shuts
sieurs659042sieurs
sirs44338332s_irs
skuas95611732skuas
slubs74719532slubs
slues54527172slues
slugs64618562slugs
slums74623432slums
slur45525152slur_
slurb74116322slurb
slurbs8439742slurbs
slurp74014982slurp
slurps84410002slurps
sluts54523982sluts
smuts75415712smuts
snubs75412552snubs
snugs64913022snugs
soars54732512soars
sopors85215202sopors
sorus54527582sorus
souks94820522souks
souls55127362souls
soups75322942soups
sour45935892sour_
sous46947212sou_s
spaes76029972spaes
spams94922192spams
spans74528732spans
spar65433302spar_
spare75135562spare
spares84834552spares
spark114920892spark
sparks124616362sparks
sparse84516342sparse
spas67036722sp_as
spats75031382spats
spays105520512spays
spears84019472spears
specs96916672specs
speers85019952speers
speirs85013232speirs
sperm93216012sperm
sperms102512602sperms
spews105015922spews
spics94123242spics
spiers84421742spiers
spies76037622spies
spiks114117472spiks
spins75327982spins
spire75828692spire
spires84628112spires
spirt75032952spirt
spirts85317132spirts
spiry105017352spiry
spits74429552spits
spivs105114242spivs
spoors84014032spoors
spore75428592spore
spores84726612spores
sport75935982sport
sports84619182sports
spots74424112spots
spouts85115112spouts
sprue74717632sprue
sprues84515762sprues
sprug85313892sprug
sprugs94010172sprugs
spry96819122sp_ry
spud75818492spu_d
spue66025522spu_e
spued84918472spued
spume95817312spume
spumes1021314882spumes
spumy124610362spumy
spun66221462spu_n
spunk114513402spunk
spunks12349332spunks
spurge93711322spurge
spurges104111652spurges
spurry11429122spurry
sputa74612962sputa
stars55836572stars
stirs55921622stirs
stours65015632stours
stubs75016072stubs
studs64415872studs
stums75320082stums
stuns54719492stuns
sturt56028962sturt
sturts63915142sturts
subs66037122s_ubs
suds56135292s_uds
suers55128482suers
sues46247652s_ues
suks85927122s_uks
sums65837582s_ums
suns45841902s_uns
supers84622402supers
supes75628302supes
supra73614252supra
sups64834432s_ups
suqs134319652s_uqs
sura45740292s_ura
suras55336322s_uras
surd56433812s_urd
surds65624662s_urds
sure45447412s_ure
surf76039312s_urf
surfs85022542s_urfs
suss45229302s_uss
tours55325892tours
yours85217882yours

Search took 2 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.0802233637.5
2DLD Change Limit538001761.64032804.9
3Display Results1761760.0463826.1
 (SQL Overall)1786911761.766101184.0
 
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.