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

160 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
scups9531665(None) 
cups85430821_cups
scaups105411931scaups
scops95820191scops
scuds85116241scuds
sculps104611751sculps
scums95017421scums
scup84822381scup_
scuts74522521scuts
soups75322941soups
sups64834431s_ups
ascus75013582ascu_s
caps87147892_caps
ceps86125952_ceps
cops86751372_cops
coups95522472coups
cubs85832382_cubs
cuds76730472_cuds
cues65438982_cues
cup76738242_cup_
curs65645542_curs
cusp86021062_cusp
cusps94913672_cusps
cuss65430612_cuss
cuts65841152_cuts
dups75929512_dups
ecus65421462ecu_s
jaups144810532jaups
loups75319622loups
pups86032232_pups
roups75118902roups
salps74423242salps
samps96124672samps
saps65346372s_aps
sauls55128122sauls
scabs94818642scabs
scads85419952scads
scags85520972scags
scalps104315232scalps
scamps125014172scamps
scams94423972scams
scans74625102scans
scape96921842scape
scapes105122262scapes
scarps104718602scarps
scars75433532scars
scats75930602scats
scaup95515992scaup_
scaurs85512042scaurs
schuls11299852schuls
schuss11186732schuss
scoops105414362scoops
scop85925522scop_
scope94821482scope
scopes104719592scopes
scots74025902scots
scours84913582scours
scouts84817942scouts
scows106617802scows
scraps106017242scraps
scrips105316032scrips
scrubs104210312scrubs
scrums104614252scrums
scuba94211592scuba
scubas103710222scubas
scud76221282scu_d
scudi85112162scudi
scudo85412212scudo
scuff133914892scuff
scuffs14419052scuffs
sculk115112462sculk
sculks123610262sculks
scull75315762scull
sculls84613882sculls
sculp95314842sculp
sculpt104412692sculpt
sculpts11377062sculpts
scum85924522scu_m
scurf104719322scurf
scurfs113210812scurfs
scut65835542scu_t
scuta75815752scuta
scute75520942scute
scutes85219192scutes
scuzz1537572scuzz
seeps74828752seeps
setups83910462setups
ships105123772ships
shops104222892shops
shuls85319712shuls
shuns85018142shuns
shuts85622472shuts
simps94719762simps
sips65740102s_ips
sirups83710532sirups
situps8538782situps
skeps115614252skeps
skips115616602skips
skuas95611732skuas
slaps76025712slaps
slips76023722slips
slops75026012slops
slubs74719532slubs
slues54527172slues
slugs64618562slugs
slumps104313582slumps
slums74623432slums
slurps84410002slurps
slurs54123372slurs
sluts54523982sluts
smuts75415712smuts
snaps74719562snaps
snips75818012snips
snubs75412552snubs
snugs64913022snugs
soaps75120712soaps
sops65244562s_ops
souks94820522souks
souls55127362souls
soup66232912soup_
soupy106115402soupy
sours55230502sours
sous46947212sou_s
spuds85113672spuds
spues75025382spues
spurs74621522spurs
steps76619882steps
stops74827282stops
stoups85313272stoups
stubs75016072stubs
studs64415872studs
stumps104912282stumps
stums75320082stums
stuns54719492stuns
stupa74112312stupa
stupas83910882stupas
stupe75217752stupe
stupes84116952stupes
subs66037122s_ubs
sucks114523072sucks
suds56135292s_uds
sues46247652s_ues
suks85927122s_uks
sumps95023432sumps
sums65837582s_ums
suns45841902s_uns
sunups837262sunups
sup57041942s_up_
supe65932762s_upe
supes75628302s_upes
suqs134319652s_uqs
suss45229302s_uss
swaps104819202swaps
swops105913972swops
syrups11277952syrups
tups65628762_tups
ups55629052__ups
whups134210002whups
yaups105910742yaups
yups96121602_yups

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 Limit538001601.68631909.8
3Display Results1601600.0305333.3
 (SQL Overall)1786911601.81298615.3
 
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.