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

126 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
stucco104425(None) 
stuccos1153931stuccos
secco9312422s_ecco
stuccoed1352852stuccoed
stuccoer1252802stuccoer
stuccoes1254272stuccoes
stuck114515772stu_ck
studio7247132studio
succor1036622s_uccor
bucko134614023_bucko
bunco94616083_bunco
gaucho1256223gaucho
guaco85012163_guaco
juco134716203_ju_co
junco144612203_junco
mucho125013443_mucho
mucro94513723_mucro
sauce75121653sau_ce
sauced93913303sauced
saucer84314103saucer
sauces84919503sauces
sauch104918773sau_ch
sauchs115112233sauchs
saucy104615163sau_cy
scudo85412213scu_do
sculch13226213sculch
scutch13247083scutch
seccos1039923s_eccos
shacko153810113shacko
shuck144314533shu_ck
shucks154010413shucks
sicko115315393s_icko
sirocco1143033sirocco
sluice849513sluice
sluicy1166483sluicy
smutch13205843smutch
snuck114411913snu_ck
socko115215113s_ocko
soucar839323soucar
soupcon1144163soupcon
source8410673source
staccato1244063staccato
stack114421693st_ack
stacks124317263stacks
stacte82113913stacte
stance84316913stance
stanch113812373stanch
starch113013203starch
staunch1244273staunch
stench114111163stench
steno54716863st_eno
stereo65317913stereo
stich104117923st_ich
stichs114511653stichs
stick115121563st_ick
sticks125118613sticks
sticky154711343sticky
stingo74212163stingo
stinko10499393stinko
stitch11419103stitch
stoccado1342953stoccado
stock114417563st_ock
stocks124715633stocks
stocky15369153stocky
stoic7317243stoic_
stoics8311113stoics
strick124813203strick
strict84821043strict
struck12489263struck
stub66221843stu__b
stubby1345043stubby
stubs75016073stu_bs
stuccoers1342563stuccoers
stuccoing1442493stuccoing
stud56220093stu__d
studios8256643studios
studly10397693studly
studs64415873stu_ds
study94411793stu_dy
stuff113817053stu_ff
stuffs123810223stuffs
stuffy15317083stuffy
stull54916273stu_ll
stulls63912973stulls
stum65526013stu__m
stump94616463stu_mp
stumps104912283stumps
stumpy13458133stumpy
stums75320083stu_ms
stun45623453stu__n
stung65417153stu_ng
stunk94616293stu_nk
stuns54719493stu_ns
stunt55328173stu_nt
stunts65615253stunts
stupa74112313stu_pa
stupas83910883stupas
stupe75217753stu_pe
stupes84116953stupes
stupid937593stupid
stupor836013stupor
sturdy1037043sturdy
sturt56028963stu_rt
sturts63915143sturts
succah1336643s_uccah
succors1137413s_uccors
succory1444643s_uccory
succoth1445093s_uccoth
succour1144693s_uccour
such96424813s_u_ch
suck106131733s_u_ck
sucks114523073s_ucks
sucky144415503s_ucky
sucre75019103s_ucre
sulci7615053s_ulci
sulfo8313363s_ulfo
sumo67326313s_u_mo
taco67031353_t_aco
telco7511873_telco
tuck104626573_tu_ck
tucks114721123_tucks
turaco839453_turaco
turbo71015043_turbo
unco66021403__unco
yucca12467443_yucca
yucch15417433_yucch

Search took 7 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 Filter1786911127160.266671770.7
2DLD Change Limit1127161266.12318408.6
3Display Results1261260.0333818.2
 (SQL Overall)1786911266.42227824.8
 
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.