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

162 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
scruffs155417(None) 
scruff1437961scruff_
scruffy1842641scruffy
scuffs14419051sc_uffs
chuffs17427782_chuffs
cuffs135017492_c_uffs
gruffs13337452_gruffs
ruffs114516742__ruffs
sclaffs1543572sclaffs
scoffs14347502sc_offs
scrubs104210312scru_bs
scrums104614252scru_ms
scuff133914892sc_uff_
scurfs113210812sc_urfs
shroffs1634362shroffs
sluffs12349582s_luffs
snuffs12358532s_nuffs
stuffs123810222s_tuffs
bluffs14388373_bluffs
buffs135519513__buffs
caffs135417373_c_affs
chaffs17459613_chaffs
chufas14397673_chufas
chuff164812493_chuff_
chuffy20445863_chuffy
cliffs14477593_cliffs
coffs134916303_c_offs
crafts115312743_crafts
crofts114910593_crofts
cruces105117543_cruces
crucks144412583_crucks
crudes96218623_crudes
cruds85815853_cru_ds
cruets85314953_cruets
crumbs12409233_crumbs
crumps124514343_crumps
cruors838643_cruors
crus65828483_cru__s
cruses88127713_cruses
crusts84916543_crusts
cruxes154911563_cruxes
cuff125327993_c_uff_
cuifs104814693_c_uifs
curfs105122143_c_urfs
draffs13617903_draffs
duffs125216623__duffs
earmuffs1641373earmuffs
ecrus75113863ecru__s
fluffs11347783_fluffs
griffs13398993_griffs
gruff124712143_gruff_
gruffy16396013_gruffy
guffs124414823__guffs
huffs144514743__huffs
luffs114516283__luffs
muffs134114213__muffs
pouffs14418123_pouffs
puffs134114933__puffs
raffs115017523__raffs
rebuffs1533403rebuffs
riffs115114613__riffs
ruff105127653__ruff_
ruffe114713813__ruffe
ruffes124112423__ruffes
sacrums11388043sacru_ms
scarfs114714683sc_arfs
scaups105411933scau_ps
scaurs85512053scau_rs
schuits1235823schuits
schuls11299853schu_ls
schuss11186733schu_ss
sclaff1438313sclaff_
scoff134413343sc_off_
scours84913593scou_rs
scouses93313243scouses
scouths12527893scouths
scouts84817943scou_ts
scrags95713803scr_ags
scrams105216623scr_ams
scrapes116217663scrapes
scraps106017243scr_aps
scrawls12177283scrawls
screaks13469363screaks
screams114810623screams
screeds106210293screeds
screens95212183screens
screes85023973scr_ees
screws115513893scr_ews
scribes113713203scribes
scries85226823scr_ies
scrimps13517903scrimps
scrims104615933scr_ims
scrips105316033scr_ips
scripts11509373scripts
scrives124414273scrives
scrods94111613scr_ods
scrolls938063scrolls
scroops11288253scroops
scrouges1136683scrouges
scrub94914203scru__b
scrubby1642803scrubby
scruffier1743303scruffier
scruffiest1842933scruffiest
scruffily2041883scruffily
scrum95418203scru__m
scrunch1444033scrunch
scruple1137193scruple
scruples1237433scruples
scubas103710223sc_ubas
scuds85116243sc_u_ds
scuffed16298243sc_uffed
scuffer15328883sc_uffer
scuffers16307493sc_uffers
scuffle15266893sc_uffle
scuffles16287863sc_uffles
sculks123610263sc_ulks
sculls84613883sc_ulls
sculps104611753sc_ulps
scums95017423sc_u_ms
scups95316653sc_u_ps
scurf104719323sc_urf_
scurfy14338763sc_urfy
scutes85219193sc_utes
scuts74522523sc_u_ts
serfs84922013ser__fs
serifs94017053ser_ifs
serums83916303seru_ms
setoffs1334133setoffs
sheriffs17253923sheriffs
shrifts1335963shrifts
shroff1538503shroff_
shrubs11409213shru_bs
shrugs10469163shru_gs
sirups83710533siru_ps
skiffs16327013s_kiffs
sluff114016813s_luff_
sniffs12378843s_niffs
snuff113514043s_nuff_
snuffy15356243s_nuffy
sorus54527583soru__s
spiffs14328473s_piffs
spliffs1533563spliffs
spruces113810503spruces
sprues84515763spru_es
sprugs94010173spru_gs
staffs12349753s_taffs
stiffs12389963s_tiffs
strafes104516003strafes
strifes104716583strifes
strumas9419833strumas
strums84716453stru_ms
strunts7429543strunts
struts65616803stru_ts
stuff113817053s_tuff_
stuffy15317083s_tuffy
surfs85022543s__urfs
syrups11277953syru_ps
tariffs1334593tariffs
truffe1276233_truffe
truffes1356773_truffes
tuffs115118263__tuffs
uncuffs1543143uncuffs

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.403443402.0
2DLD Change Limit1340271626.06322105.7
3Display Results1621620.0632571.4
 (SQL Overall)1786911626.52927368.8
 
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.