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

156 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
studs6441587(None) 
scuds85116241scuds
spuds85113671spuds
stubs75016071stubs
stud56220091stud_
study94411791study
stums75320081stums
stuns54719491stuns
suds56135301s_uds
bauds85821042bauds
bestuds10326752bestuds
buds75235182_buds
cruds85815852cruds
cuds76730482_cuds
duds65530152_duds
etude63612302etude
etudes73811602etudes
etuis54013132etuis
feuds95914882feuds
fuds86528572_fuds
gauds75717722gauds
lauds65618482lauds
leuds66214812leuds
mauds85519272mauds
muds75530662_muds
ouds56430112_ouds
pseuds944792pseuds
puds75630522_puds
saids65328862saids
sands65228582sands
sards64736182sards
sauls55128122sauls
scads85419962scads
scud76221282scud_
scudi85112162scudi
scudo85412212scudo
scums95017422scums
scups95316652scups
scuts74522522scuts
seeds64330062seeds
sends65528242sends
setups83910462setups
shads95124482shads
sheds96122702sheds
shuls85319712shuls
shuns85018142shuns
shuts85622482shuts
silds65520532silds
situps8538782situps
situs55019232situ_s
skids104615342skids
skuas95611732skuas
sleds64418852sleds
slubs74719532slubs
slues54527172slues
slugs64618562slugs
slums74623432slums
slurs54123372slurs
sluts54523982sluts
smuts75415712smuts
sneds65715352sneds
snubs75412552snubs
snugs64913022snugs
sods54940222s_ods
sords64527802sords
souks94820522souks
souls55127362souls
sounds74616182sounds
soups75322942soups
sours55230502sours
sous46947212sou_s
spud75818492spud_
spues75025382spues
spurs74621522spurs
squads164410292squads
squids16409802squids
stabs76221382stabs
stade64825302stade
stades74626242stades
stags66226742stags
stands75118052stands
stars55836572stars
stats55933362stats
stays86022022stays
steads74116222steads
steeds73814882steeds
stems75219952stems
steps76619882steps
stets55423912stets
stews85519142stews
sties55132982sties
stirs55921622stirs
stoas55126022stoas
stobs75718232stobs
stops74827282stops
stoss54316342stoss
stots54828552stots
stounds8377822stounds
stoups85313272stoups
stours65015632stours
stouts65019002stouts
stows86622702stows
strouds837802strouds
strums84716452strums
struts65616802struts
stub66221842stu_b
stuck114515772stuck
studies82413862studies
studio7247132studio
studios8256642studios
studly10397692studly
stuff113817052stuff
stuffs123810222stuffs
stull54916272stull
stulls63912982stulls
stum65526022stu_m
stump94616462stump
stumps104912282stumps
stun45623452stu_n
stung65417152stung
stunk94616292stunk
stunt55328172stunt
stunts65615252stunts
stupa74112312stupa
stupas83910882stupas
stupe75217752stupe
stupes84116952stupes
stupids1035272stupids
sturdy1037042sturdy
sturt56028962sturt
sturts63915142sturts
styes86316522styes
subs66037122s_ubs
sudd64719782s_udd
sudds75513592sudds
sudsy95010682s_udsy
sues46247652s_ues
suks85927122s_uks
sums65837582s_ums
suns45841902s_uns
sups64834432s_ups
suqs134319652s_uqs
surds65624662surds
suss45229302s_uss
tads57143952_tads
teds54932582_teds
thuds95110132thuds
tods56141852_tods
tubs65430062_tubs
tugs56231672_tugs
tuis44829642_tuis
tuns45138662_tuns
tups65628762_tups
turds65021692_turds
tuts45838452_tuts
yauds95013222yauds

Search took 3 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.326548131.9
2DLD Change Limit538001562.36022796.6
3Display Results1561560.0463391.3
 (SQL Overall)1786911562.73265406.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.