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

153 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
scup8482238(None) 
cup76738241_cup
scaup95515991scaup
scop85925521scop
scud76221281scud
sculp95314841sculp
scum85924521scum
scups95316651scups
scut65835541scut
soup66232911soup
sup57041941s_up
ascus75013582ascus
cap76758982_cap
cep75736332_cep
cop711162372_cop
coup86729792coup
cub76940942_cub
cud67937452_cud
cue57544182_cue
cum76440162_cum
cups85430822_cups
cur56841982_cur
cusp86021062_cusp
cut57957662_cut
dup67637882_dup
ecu56828232ecu_
ecus65421462ecus
hup86437812_hup
jaup135316422jaup
loup66028432loup
pup76339882_pup
roup66627692roup
salp64534092salp
samp85733592samp
sap56463232s_ap
sau36356572sau_
saul45836522saul
scab85926712scab
scad75725762scad
scag76626892scag
scalp95217982scalp
scam85932352scam
scamp115717312scamp
scan65530452scan
scape96921842scape
scar66434202scar
scarp95724102scarp
scat65848372scat
scaups105411932scaups
scaur75814902scaur
schul102510412schul
scoop95617162scoop
scope94821482scope
scops95820192scops
scot66242602scot
scour75315532scour
scout75031452scout
scow96021422scow
scrap97120402scrap
scrip96619192scrip
scrub94914202scrub
scrum95418192scrum
scry96017762scry
scuba94211592scuba
scudi85112162scudi
scudo85412212scudo
scuds85116242scuds
scuff133914892scuff
sculk115112462sculk
scull75315762scull
sculps104611752sculps
sculpt104412692sculpt
scums95017422scums
scurf104719322scurf
scuta75815752scuta
scute75520942scute
scuts74522522scuts
scuzz1537572scuzz
seep66540342seep
setup73915822setup
ship95228232ship
shop95629832shop
shul75823152shul
shun75122772shun
shut76137582shut
simp85228772simp
sip57656012s_ip
sirup74014912sirup
situp74414062situp
skep105219352skep
skip105421742skip
skua86113152skua
slap66434042slap
slip67031732slip
slop66533872slop
slub65428032slub
slue45332192slue
slug55124642slug
slum65430512slum
slump94816632slump
slur45525152slur
slurp74014982slurp
slut45040592slut
smug75815262smug
smut66629782smut
snap65727032snap
snip66424652snip
snub65320762snub
snug55218692snug
soap65831132soap
sop57557862s_op
sou37853692sou_
souk86127172souk
soul46435712soul
soups75322942soups
soupy106115402soupy
sour45935892sour
sous46947212sous
spud75818492spud
spue66025522spue
spun66221462spun
spur65321192spur
step67126292step
stop66532032stop
stoup75517072stoup
stub66221842stub
stud56220092stud
stum65526012stum
stump94616462stump
stun45623452stun
stupa74112312stupa
stupe75217752stupe
sub55445552s_ub
such96424812such
suck106131732suck
sue35651462s_ue
suk75632972s_uk
sum56346012s_um
sump86331532sump
sun37149032s_un
sunup7313052sunup
supe65932762s_upe
sups64834432s_ups
suq126228992s_uq
swap95925432swap
swop95120502swop
swum96416822swum
syrup103010962syrup
tup56037542_tup
up47832822__up
whup125714162whup
yaup96618482yaup
yup86031702_yup

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 Filter178691298720.0802233637.5
2DLD Change Limit298721530.95331345.2
3Display Results1531530.0305100.0
 (SQL Overall)1786911531.063168100.7
 
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.