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

214 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
scruff143796(None) 
scruffs1554171scruffs
scruffy1842641scruffy
scuff133914891sc_uff
chuff164812492_chuff
cuff125327992_c_uff
gruff124712142_gruff
ruff105127652__ruff
sclaff1438312sclaff
scoff134413342sc_off
scrub94914202scru_b
scrubs104210312scrubs
scrum95418202scru_m
scrums104614252scrums
scuffs14419052sc_uffs
scurf104719322sc_urf
scurfs113210812scurfs
scurfy14338762scurfy
shroff1538502shroff
sluff114016812s_luff
snuff113514042s_nuff
stuff113817052s_tuff
bluff134413833_bluff
buff125229863__buff
caff125631673_c_aff
chaff165016283_chaff
chufa13489113_chufa
chuffs17427783_chuffs
chuffy20445863_chuffy
cliff135917133_cliff
coff126930783_c_off
craft105327663_craft
croft105622683_croft
cru57129563_cru__
cruck135615323_cruck
crud75219613_cru_d
crude86018573_crude
cruds85815853_cruds
cruel74815903_cruel
cruet74831843_cruet
crumb114313593_crumb
crump115616423_crump
cruor7310453_cruor
crura7312583_crura
crus65828483_cru_s
cruse75726103_cruse
crush106815993_crush
crust75827663_crust
crux135415003_cru_x
cuffs135017493_c_uffs
cuif96529143_c_uif
curf97538783_c_urf
curfs105122143_curfs
draff125615663_draff
duff114326643__duff
earmuff1543063earmuff
ecru65819533ecru__
ecrus75113863ecru_s
fluff103913613_fluff
griff124416463_griff
gruffs13337453_gruffs
gruffy16396013_gruffy
guff114624933__guff
huff135623843__huff
luff104426703__luff
muff124723863__muff
pouff135215423_pouff
puff125525433__puff
raff104933043__raff
rebuff1437023rebuff
riff104430103__riff
ruffe114713813__ruffe
ruffs114516743__ruffs
sacrum103910143sacru_m
sacrums11388043sacrums
scarf105427143sc_arf
scarfs114714683scarfs
scarify1537443scarify
scaup95515993scau_p
scaups105411933scaups
scaur75814903scau_r
scaurs85512053scaurs
schuit1139563schuit
schul102510413schu_l
schuln11256233schuln
schuls11299853schuls
schuss11186733schuss
sclaffs1543573sclaffs
scoffs14347503scoffs
scorify1535203scorify
scour75315533scou_r
scours84913593scours
scouse84113633scouse
scout75031453scou_t
scouth115011153scouth
scouts84817943scouts
scrag85916173scr_ag
scrags95713803scrags
scram910621623scr_am
scrams105216623scrams
scrap97120403scr_ap
scrape105917573scrape
scraps106017243scraps
scrawl11208093scrawl
screak125311063screak
scream104814253scream
scree720031713scr_ee
screed95718933screed
screen85216023screen
screes85023973screes
screw109318543scr_ew
screws115513893screws
screwy14659463screwy
scribe104613533scribe
scried95817303scried
scries85226823scries
scrim95419743scr_im
scrimp125110583scrimp
scrims104615933scrims
scrip96619193scr_ip
scrips105316033scrips
script105717903script
scrive115414943scrive
scrod85115073scr_od
scrods94111613scrods
scroll8310173scroll
scroop10299783scroop
scrota8310203scrota
scrouge1036353scrouge
scrubby1642803scrubby
scruffier1743303scruffier
scruffily2041883scruffily
scrunch1444033scrunch
scruple1137193scruple
scry96017763scr__y
scuba94211593sc_uba
scud76221283sc_u_d
scudi85112163sc_udi
scudo85412213sc_udo
scuds85116243sc_uds
scuffed16298243sc_uffed
scuffer15328883sc_uffer
scuffle15266893sc_uffle
sculk115112463sc_ulk
scull75315763sc_ull
sculp95314843sc_ulp
scum85924523sc_u_m
scums95017423sc_ums
scup84822383sc_u_p
scups95316653sc_ups
scurry11419593scurry
scurvy14386103scurvy
scut65835543sc_u_t
scuta75815753sc_uta
scute75520943sc_ute
scuts74522523sc_uts
scuzz1537573sc_uzz
serf76340113ser__f
serfs84922013ser_fs
serif84132133ser_if
serifs94017053serifs
serum75223473seru_m
serums83916303serums
setoff1238913setoff
sheriff16287693sheriff
shrift12413543shrift
shroffs1634363shroffs
shrub104814893shru_b
shrubs11409213shrubs
shrug94512513shru_g
shrugs10469163shrugs
shrunk13357063shrunk
sirup74014913siru_p
sirups83710533sirups
sirupy11377053sirupy
skiff153612803s_kiff
sluffs12349583s_luffs
sniff113915863s_niff
snuffs12358533s_nuffs
snuffy15356243s_nuffy
sorus54527583soru_s
spiff133616403s_piff
spliff1438603spliff
spruce103910873spruce
sprucy13356323sprucy
sprue74717633spru_e
sprues84515763sprues
sprug85313893spru_g
sprugs94010173sprugs
sprung94610033sprung
staff113817713s_taff
stiff114219243s_tiff
strafe95215983strafe
strife95318363strife
struck12489263struck
strum75619453stru_m
struma84313273struma
strums84716453strums
strung75213023strung
strunt64918913strunt
strut56030733stru_t
struts65616803struts
stuffs123810223s_tuffs
stuffy15317083s_tuffy
surf76039313s__urf
surfs85022543sur_fs
surfy115319473sur_fy
syrup103010963syru_p
syrups11277953syrups
syrupy14285823syrupy
tariff12711363tariff
truffe1276233_truffe
tuff104528523__tuff
uncuff1436113uncuff

Search took 6 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 Filter1786911127160.360496363.9
2DLD Change Limit1127162144.81023433.7
3Display Results2142140.0633396.8
 (SQL Overall)1786912145.23334147.0
 
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.