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

157 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
offset123837(None) 
offsets1333501offsets
coffret15310072coffret
offbeat1564142offbeat
offcut1444702offcut
offed12359162off_ed
offer114311382off_er
offkey1932342offkey
offs107117012offs__
oftest91212002oftest
onset54730172o_nset
outset64027452outset
affect1448903affect
afreet9315153afreet
asset55932263_asset
avoset9315673avoset
basset85225383basset
befret11315963befret
beset76739133_beset
boffed15369483boff_ed
boffs134915503boffs__
boneset9316433boneset
buffest15298643buffest
buffet143113783buffet
closet85226603closet
coffee144113743coff_ee
coffees15329573coffees
coffer144112863coff_er
coffle14359043coffle_
coffled16297363coffled
coffles152610003coffles
coffrets1645363coffrets
coffs134916303coffs__
corset85636223corset
coset75748843_coset
cosset84125863cosset
cruset84425093cruset
deffest14308803deffest
doffed14428503doff_ed
doffer133911353doff_er
doffs125614333doffs__
effect1437443effect
effete1235183eff_ete
effort1238623effort
effs105114033effs__
effuse1234963effuse_
effused1434143effused
effuses1335903effuses
facet106038523_facet
fast77052313_fas_t
feet75352213__feet
fest74949443_fes_t
fet66471633__f_et
filet85540163_filet
fist76248423_fis_t
fleet85932333_fleet
foist85730973fois_t
forest94926743forest
forget106326393forget
fosse86119463fosse_
fosses96022083fosses
fret75845043__fret
fumet105630223_fumet
fuse76429993_fuse_
fused94820443_fused
fusee86224583_fusee
fusel85218493_fusel
fuses85628423_fuses
goffer13409513goff_er
gusset7316433gusset
haffet15311703haffet
iffier1236763iffier
iffiest1337963iffiest
infest93315433infest
inset54430863_inset
keyset13411533keyset
lockset13311163lockset
misset85028153misset
moonset92413043moonset
oafs76425263oafs__
oases55330983o_ases
oast47156323o_as_t
obese75212423obese_
objet141213143o_bjet
obtest81213013obtest
octet7324063o_ctet
oddest81710863oddest
odist6421913odis_t
off96331633off___
offal1136243off_al
offals1235893offals
offbeats1682813offbeats
offcast1544473offcast
offcuts1542573offcuts
offend13365663offend
offense1343683offense_
offenses1443833offenses
offered1436143offered
offerer1335543offerer
offers12349963offers
office1435693office
officer1534213officer
offices1536243offices
offing13368643offing
offish15137273offish
offshoot1742833offshoot
offside1453693offside
offsides1543393offsides
oft67744063o_f__t
often84611413o_ften
ofter84116873o_fter
oldest72114093oldest
omelet8317073omelet
oncet74626543o_ncet
onsets64013543o_nsets
onuses65616253onuses
opuses84012243opuses
ose38147343o__se_
oses46641513o__ses
ousel55222403o_usel
oust46747443o_us_t
outlet63728683outlet
outsat62920283outsat
outsee63121803outsee
outsert72819513outsert
outsets73514923outsets
outsit63620893outsit
overset102821473overset
owlet83324463o_wlet
owse76321623o_wse_
owsen84210193o_wsen
pfft12311883pff__t
pomfret1446993pomfret
posset84923253posset
preset84430983preset
reflet94024233reflet
reset55051863_reset
rifest93114583rifest
roset55945243_roset
russet6319433russet
safest95016603safest
set36681253___set
soffit1237883soff_it
softest10310603softest
subset83122583subset
sunset63723633sunset
tasset65925313tasset
toffee123311013toff_ee
toffees13327083toffees
toffies133210213toffies
toffs116016723toffs__
tuffet122612083tuffet
unset54532433_unset
upset73222593_upset
verset94327323verset
wadset10314303wadset
worset96726583worset

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 Filter1786911127160.390458182.1
2DLD Change Limit1127161575.56320261.7
3Display Results1571570.0463413.0
 (SQL Overall)1786911575.99929786.8
 
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.