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

234 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
stupors93588(None) 
stupor836011stupor_
sapors84118812s_apors
sopors85215202s_opors
stators73915582stators
stopers94217372stopers
stumpers12318312stumpers
stupas83910882stup_as
stupes84116952stup_es
stupids1035272stupids
stuporous1144012stuporous
sudors7311102s_udors
supers84622402s_upers
tumors8810612_tumors
tutors6912332_tutors
assurors894043assurors
authors10311853authors
coupons112710563coupons
cruors838643cru_ors
dupers94615603_dupers
fluors94311373flu_ors
furors9310953_furors
humors11129633_humors
jupons15377803_jupons
jurors1338283_jurors
lupous849433_lupous
mistutors1144763mistutors
mucors104410853_mucors
outport9714123outport
outports1048273outports
outpours1036683outpours
paupers114311073paupers
rumors81110403_rumors
sailors73213723sailors
salvors103910913salvors
sapor75119253s_apor_
sapours93610623s_apours
sappers113518903sappers
sartors7314973sartors
saucers93712133saucers
saugers83914053saugers
sautoirs834923sautoirs
saviors1058993saviors
savors95616103s_avors
scaupers12378173scaupers
sculptors1344003sculptors
scuppers1446543scuppers
scups95316653scup__s
seaport9315603seaport
seaports1038463seaports
secpars1138413secpars
sectors93116453sectors
seisors73212843seisors
seizors16329013seizors
senhors103512133senhors
seniors73413623seniors
senors63620793s_enors
sensors73514643sensors
sepoys1138473s_epoys
settlors8255013settlors
setulous846913setulous
setups83910463setup__s
sexpots1636293sexpots
shapers124016893shapers
signors83410913signors
simpers113014123simpers
sippers113117753sippers
situps8538783situp__s
slopers94213093slopers
slurs54123373slu__rs
snipers93311773snipers
soapers93715923soapers
sopor74016493s_opor_
sordors8310013sordors
soucars938423soucars
soukous1136413soukous
soupcons1244373soupcons
soups75322943soup__s
sours55230503sou__rs
souters74422603souters
spars75431543s__pars
spinors939423spinors
spoors84014033s_poors
spore75428593s__pore
spores84726613s__pores
sport75935983s__port
sports84619183s__ports
spots74424113s__pots
spumous1135853spumous
spurs74621523s__purs
squalors1744583squalors
stagers84116673stagers
stairs65416333st_airs
stampers124211603stampers
stanols739733stanols
stapes85028733stap_es
staphs114411033stap_hs
staplers103111203staplers
staples93617213staples
starers74522313starers
stars55836573st__ars
staters73922343staters
stator64015483stator_
stayers103813633stayers
steepers103011373steepers
steers63820983st_eers
stenos63915773steno_s
stentors839743stentors
steppers12289283steppers
steppes113110693steppes
steps76619883step__s
stepsons1045663stepsons
sterols7313443sterols
stertors8310933stertors
stipels9418953stipels
stipes84524053stip_es
stirs55921623st__irs
stivers103613543stivers
stoas55126023st__oas
stobs75718233st__obs
stokers114515183stokers
stolons73410243stolons
stolport1046013stolport
stolports1143483stolports
stompers123610043stompers
stoners74817953stoners
stooks105115373st_ooks
stools65117023st_ools
stoopers103711303stoopers
stoops85917893st_oops
stoper84320103stoper_
stopes84525893stop_es
stopoff1565023stopoff
stopoffs1662993stopoffs
stopovers1443833stopovers
stoppers123910593stoppers
stops74827283st__ops
stopword1444503stopword
stopwords1544003stopwords
store56333813st__ore
storers75018683storers
stores65533663st__ores
stork96819693st__ork
storks106115953st__orks
storm76520403st__orm
storms85814633st__orms
story86723033st__ory
stoss54316343st__oss
stots54828553st__ots
stoups85313273stoup__s
stours65015633st_ours
stovers103713733stovers
stows86622703st__ows
stridors9367323stridors
stripers103911593stripers
strops86220383st_rops
strows96718273st_rows
stroys95914603st_roys
strumous1045733strumous
stubborn1242883stubborn
stubs75016073stu__bs
stuccoers1342563stuccoers
stuccoes1254273stuccoes
stuccos1153933stuccos
studhorse1342033studhorse
studiers9236623studiers
studies82413863studies
studios8256643studios
studious9245553studious
studs64415873stu__ds
studwork1643693studwork
studworks1743673studworks
stuffers14277383stuffers
stuffs123810223stu_ffs
stuivers11406673stuivers
stulls63912983stu_lls
stumper113610093stumper_
stumps104912283stu_mps
stums75320083stu__ms
stunners8277923stunners
stuns54719493stu__ns
stunts65615253stu_nts
stupa74112313stup__a
stupe75217753stup__e
stupefy1542903stupefy
stupid937593stup_id
sturt56028963stu__rt
sturts63915143stu_rts
stutters83210473stutters
stylers10359353stylers
stypsis1245243stypsis
subers85722643s_ubers
suborn8310013s_uborn
suborns939493s_uborns
succors1137413succors
sudor6312623s_udor_
suers55128483s_u_ers
sugars7312423s_ugars
suitors73012493suitors
sumos75720093s_umo_s
super74924483s_uper_
superb104410993s_uperb
supes75628303s_up_es
suppers113314703suppers
support11310523support
supports1246513supports
supra73614253s_up_ra
sups64834433s_up__s
sutlers73116973sutlers
tabors84517113_tabors
tapers84025813_tapers
tapirs84113173_tapirs
tenors63217753_tenors
tepoys1137543_tepoys
topers85025323_topers
topos75726393_topo_s
torpors939383torpors
tors46157383_t__ors
tubers85017033_tubers
tumor71110693_tumor_
tumours976753_tumours
tuners64417343_tuners
tupiks1235493_tupiks
tups65628763_tup__s
turgors836833_turgors
tussors7388773_tussors
tutor5712493_tutor_
tuyers94612563_tuyers
typos106015813_typo_s
vapors113812693_vapors
yaupers12337663yaupers
yaupons12345683yaupons
youpons12265983youpons
yupons11398353_yupons

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272346.37621020.5
3Display Results2342340.0763078.9
 (SQL Overall)1786912346.85826055.8
 
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.