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

123 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
stupe7521775(None) 
stipe76523371stipe
stope74727241stope
stupa74112311stupa
stupes84116951stupes
supe65932761s_upe
astute6310762astute
coupe96023482coupe
drupe85012992drupe
dupe76630602_dupe
etape74413702etape
etude63612302etude
jupe134921002_jupe
loupe75319512loupe
sauce75121652sauce
saute55028082saute
scape96921842scape
scope94821482scope
scup84822382scup_
scups95316652scups
scute75520942scute
setup73915822setup_
setups83910462setups
shape105125112shape
shute84520342shute
sipe67341042s_ipe
situp74414062situp_
situps8538782situps
slipe75626132slipe
slope75823562slope
slue45332192slu_e
slype105112362slype
snipe75320572snipe
soup66232912soup_
souped95017672souped
soups75322942soups
soupy106115402soupy
souse56530772souse
spue66025522spu_e
spume95817312spume
stade64825302stade
stage65330192stage
stake95927532stake
stale55637102stale
stane55933002stane
stapes85028732stapes
staph104314652staph
staple84415822staple
stare54440262stare
state56237332state
stave85324992stave
steep76020702steep
stele55026842stele
step67126292step_
steppe10319872steppe
steps76619882steps
stere55328542stere
stile54931572stile
stime76521792stime
stiped94517072stiped
stipel84412122stipel
stipes84524052stipes
stoae55024262stoae
stoke94922512stoke
stole54928812stole
stone55431182stone
stop66532032stop_
stoped94721012stoped
stoper84320092stoper
stopes84525892stopes
stops74827282stops
stopt76528352stopt
store56333812store
stoup75517072stoup_
stoups85313272stoups
stoure64814942stoure
stove85220252stove
strep77120852strep
stripe85822442stripe
stub66221842stu_b
stubs75016072stubs
stuck114515772stuck
stud56220092stu_d
studs64415872studs
study94411792study
stuff113817052stuff
stull54916272stull
stum65526012stu_m
stump94616462stump
stumped124210152stumped
stumper113610092stumper
stumps104912282stumps
stumpy13458132stumpy
stums75320082stums
stun45623452stu_n
stung65417152stung
stunk94616292stunk
stuns54719492stuns
stunt55328172stunt
stupas83910882stupas
stupefy1542902stupefy
stupid937592stupid
stupor836012stupor
sturt56028962sturt
stye76218972st_ye
style85519362style
sue35651462s_u_e
sup57041942s_up_
super74924482s_uper
supes75628302s_upes
sups64834432s_ups
sure45447412s_ure
suture6313202suture
swipe105217082swipe
tape64538142_tape
taupe7314162taupe
tope65946382_tope
tube65828662_tube
tule45735872_tule
tune45635862_tune
tup56037542_tup_
tups65628762_tups
type96223742_type

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.0961861364.6
2DLD Change Limit538001231.65332546.9
3Display Results1231230.0333727.3
 (SQL Overall)1786911231.782100275.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.