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

223 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
offend1336566(None) 
offed12359161offe_d
offends14234291offends
boffed15369482boffe_d
defend113910492defend
doffed14428502doffe_d
effendi1442422effendi
fend84832972__fend
fiend95312982_fiend
forfend1435412forfend
offence1545352offence
offended1643652offended
offender1543722offender
offense1343682offense
offer114311382offe_r
offered1436142offered
offers12349962offers
offhand1742882offhand
offing13368642offing
often84611412often_
addend9458453addend
affect1448903affect
affine12310503affine
affined1436413affined
afford1346493afford
afield1035953afield
amend85717753_amend
append1138273append
ascend9429733ascend
attend7258973attend
augend837633augend
baffed154812173baffe_d
bend76435263__bend
biffed15449883biffe_d
blend85317453_blend
boffin14359053boffin_
boffing16339983boffing
boffins15329073boffins
bookend14396643bookend
buffed154313143buffe_d
coffee144113743coffe_e
coffees15329573coffees
coffer144112863coffe_r
coffered1737673coffered
coffers154112693coffers
coffin14339813coffin_
coffined1735993coffined
coffing163811253coffing
coffins153110193coffins
coffled16297363coffled
cofound1335513cofound
coifed124113063coife_d
coiffed1635413coiffe_d
commend144010183commend
compend144010303compend
contend103511893contend
cuffed154311213cuffe_d
daffed14429493daffe_d
defends12358773defends
defund11447983defund
depend103510923depend
doffer133911353doffe_r
doffers14359853doffers
doffing15357793doffing
effect1437443effect
effendis1542513effendis
effete1235183effete
emend86214893_emend
end46834353___end
expend16247503expend
extend14267523extend
faena85014203_faena
fed76548353__fe_d
feed84538903__feed
fen66851353__fen_
fends96324973__fends
fens76139763__fens
feod815523003__feod
feoffed1332813feoffe_d
feud86523023__feud
field95015323_field
fiends104110293_fiends
fifed125115973fife_d
find87532603__find
fined94930503_fined
fjeld16465583_fjeld
fled85429773_fle_d
foined105915013foined
foment113718303foment
fond86330953__fond
forefend1545603forefend
forfends1544833forfends
found94917843_found
foxed165115213foxe_d
freed95223543_freed
fremd115010323_fremd
frena85915273_frena
friend10388933friend
frond95316343_frond
fund85624983__fund
gaffed144210203gaffe_d
godsend1084043godsend
goffer13409513goffe_r
goffered1634523goffered
goffers14409213goffers
golfed11569763golfe_d
goofed114911383goofe_d
hoofed134614893hoofe_d
huffed163710153huffe_d
impend11478793impend
intend72310373intend
lagend838743lagend
legend837693legend
lend56233673__lend
loafed104011153loafe_d
lofted103811893lofte_d
luffed133810823luffe_d
mend75334033__mend
miffed15398713miffe_d
muffed154210593muffe_d
naffed13408333naffe_d
oaken95814383oaken_
oared65030653oare_d
oaten55222403oaten_
obtund945583obtund
off96331633off___
offal1136243off_al
offals1235893offals
offbeat1564143offbeat
offcut1444703offcut
offences1645023offences
offenders1643403offenders
offending1744093offending
offenses1443833offenses
offerer1335543offerer
offering1536393offering
offeror1342943offeror
office1435693office
offings14285833offings
offish15137273offish
offkey1932343offkey
offline1345783offline
offload1443203offload
offs107117013off__s
offset1238373offset
offsets1333503offsets
offside1453693offside
oftener1035923oftener
ofter84116873ofte_r
oftest91212003oftest
ogled75915963ogle_d
ohed87825183o_he_d
oiled64429473oile_d
olden65114853olden_
omen66828183o_men_
omened93711003o_mened
omens75618963o_mens
oogeny10117923oogeny
oohed94214213oohe_d
oozed154214263ooze_d
oped76230153o_pe_d
open66427003o_pen_
opened94311863o_pened
opens76118553o_pens
opined95113853opined
opted84914273opte_d
orbed85516193orbe_d
oread64619603o_read
orient6322533orient
osmund933803osmund
outed65429063oute_d
outfind1139563outfind
oven76624143o_ven_
ovens86217453o_vens
owed86833873o_we_d
owned95113233owne_d
owsen84210193owsen_
oxen116218593o_xen_
oxford1763663oxford
pend75934533__pend
portend103411193portend
poufed12449713poufe_d
pouffed16365953pouffe_d
puffed153510603puffe_d
refed93921923refe_d
refeed104717623refeed
reffed134712513reffe_d
refind104717073refind
refund104810303refund
relend76116453relend
remend95216553remend
rend56136573__rend
resend75016773resend
riffed133811563riffe_d
rolfed104510523rolfe_d
roofed105214743roofe_d
ruffed134312743ruffe_d
scend85516293_scend
scoffed16266183scoffe_d
send55237293__send
shend94719973_shend
soften9429493soften_
softened1235663softened
softens10347623softens
spend85619333_spend
tend56433773__tend
tiffed13368393tiffe_d
toffee123311013toffe_e
toffees13327083toffees
trend64817453_trend
unbend9269773unbend
unfed94614223unfe_d
unfond10149113unfond
unkend11309223unkend
upend85011043_upend
upsend9356883upsend
vend86626423__vend
waffed16459793waffe_d
wend85330453__wend
wifed125117743wife_d
wolfed13428013wolfe_d
woofed134511203woofe_d
yaffed16457323yaffe_d

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.390458182.1
2DLD Change Limit1127162234.76623650.0
3Display Results2232230.0633539.7
 (SQL Overall)1786912235.21934238.6
 
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.