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

232 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
shroff153850(None) 
shroffs1634361shroffs
scoff134413342s_coff
scruff1437962scruff
setoff1238912setoff
sheriff16287692sheriff
showoff1943892showoff
shrift12413542shrift
shroffed1842562shroffed
shroud1038772shroud
shrove125412232shrove
shutoff1693202shutoff
boff124727333__boff
buyoff1754233buyoff
chaff165016283ch_aff
chroma132912473chroma
chrome133214813chrome
chromo132811013chromo
chromy16309903chromy
chuff164812493ch_uff
coff126930783__coff
croft105622683_croft
cutoff1436563cutoff
dieoff1335503dieoff
doff116225783__doff
draff125615663_draff
feoff10711053_feoff
flyoff1444023flyoff
griff124416463_griff
gruff124712143_gruff
hoof106036583_h_oof
hoofs115721043_hoofs
howf136127203_h_owf
howff175110493_howff
huff135623843_h_uff
layoff1545093layoff
off96331633___off
payoff1736023payoff
prof96134663_pro_f
profs105120893_profs
proof105221533_proof
putoff1436423putoff
raff104933043__raff
reroof9315003reroof
riff104430103__riff
ripoff1436433ripoff
rolf75134873__rolf
roof75738833__roof
ruboff1435203ruboff
ruff105127653__ruff
runoff1235413runoff
sarod65325873saro_d
sarode75317513sarode
sarods74918573sarods
sarong73914873sarong
saros55238063saro_s
schrod1247883schro_d
schrods1337433schrods
sclaff1438313sclaff
scoffs14347503s_coffs
scrod85115073scro_d
scrods94111613scrods
scroll8310173scroll
scroop10299783scroop
scrota8310203scrota
scruffs1554173scruffs
scruffy1842643scruffy
scuff133914893s_cuff
selloff1345923selloff
sendoff1446233sendoff
serf76340113ser__f
serfs84922013ser_fs
serif84132133ser_if
serifs94017053serifs
serosa6313023serosa
serous65023563serous
serow86720443sero_w
serows96016393serows
setoffs1334133setoffs
shadoof1446133shadoof
shaduf1337063shaduf
shaft115725263sh_aft
sharif122917123sharif
sharifs13279903sharifs
sheaf115424123sh_eaf
sheafs124912883sheafs
shelf115221113sh_elf
sheol84318373sheo_l
sheols94614163sheols
shereef1337743shereef
sherif122915243sherif
sheriffs17253923sheriffs
sherifs13299683sherifs
sheroot10414373sheroot
shift114225143sh_ift
shlock15378193shlock
shmo95318103shmo__
shmoes114612103shmoes
shnook1366343shnook
shoal83920273sh_oal
shoat85633953sh_oat
shock144917033sh_ock
shod86225063sh_o_d
shoe75933443sh_o_e
shoed95723013sh_oed
shoer84722163sh_oer
shoes85429663sh_oes
shofar1236313sh_ofar
shog86025143sh_o_g
shogi95014013sh_ogi
shogs95319713sh_ogs
shoji15419963sh_oji
shone83725983sh_one
shoo75929893sh_o_o
shooed103916083shooed
shoofly1634353shoofly
shook124920163sh_ook
shooks134515633shooks
shool84523153sh_ool
shools94919013shools
shoon84022013sh_oon
shoos84226363sh_oos
shoot84235913sh_oot
shoots94619363shoots
shop95629843sh_o_p
shops104222903sh_ops
shoran94016043shoran
shore85432653sh_ore
shored105723653shored
shores94830413shores
shorl84720253sh_orl
shorls94516203shorls
shorn85722183sh_orn
short85040533sh_ort
shorts95321743shorts
shorty124313203shorty
shot76150263sh_o_t
shote85526103sh_ote
shots84730853sh_ots
shott85332193sh_ott
shout85433173sh_out
shove114421043sh_ove
show106229193sh_o_w
shown115216483sh_own
showoffs2042453showoffs
shows115324583sh_ows
showy145714013sh_owy
shoyu1138913sh_oyu
shrank13359123shrank
shred98125613shr_ed
shreds105613053shreds
shrew119720173shr_ew
shrewd136810783shrewd
shrews129313923shrews
shri76021703shr__i
shriek134211103shriek
shrifts1335963shrifts
shrike134513243shrike
shrill94712303shrill
shrimp13478773shrimp
shrine94920053shrine
shrink134511733shrink
shris84221453shr_is
shrive125216953shrive
shroffing1943313shroffing
shrouds1136023shrouds
shrub104814893shr_ub
shrubs11409213shrubs
shrug94512513shr_ug
shrugs10469163shrugs
shrunk13357063shrunk
shutoffs1752073shutoffs
skiff153612803s_kiff
sluff114016813s_luff
sniff113915863s_niff
snuff113514043s_nuff
sofa75625603s__ofa
soft76942823s__oft
spiff133616403s_piff
spinoff1544933spinoff
spliff1438603spliff
spoof105019013s_poof
spoofs114011813spoofs
spoofy14498553spoofy
sprout8419403sprout
staff113817713s_taff
stiff114219243s_tiff
stopoff1565023stopoff
strafe95215983strafe
strife95318363strife
strobe84513813strobe
strode75215973strode
stroke105116173stroke
stroll6311603stroll
stroma84313073stroma
strong74914883strong
strook10410303strook
strop77422243stro_p
strops86220383strops
stroud7310383stroud
strove95014793strove
strow88920573stro_w
strown96812093strown
strows96718273strows
stroy87720393stro_y
stroys95914603stroys
stuff113817053s_tuff
sunroof1047053sunroof
surf76039313sur__f
surfs85022543sur_fs
surfy115319473sur_fy
tariff12711363tariff
thrift12412043thrift
thro77726423thro__
throat94819753throat
throb109816853thro_b
throbs118311373throbs
throe89321423thro_e
throes97518673throes
throne98517603throne
throng10539973throng
throve128012393throve
throw118719733thro_w
thrown1214911443thrown
throws129715233throws
tipoff1436383tipoff
toff105929903__toff
turnoff1344013turnoff
unroof9410193unroof
whiff17310063wh_iff
whoof144612693wh_oof
whoofs15457243whoofs

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.376475242.0
2DLD Change Limit1127162325.45320670.5
3Display Results2322320.0633682.5
 (SQL Overall)1786912325.89230327.7
 
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.