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

192 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
setoff123891(None) 
setoffs1334131setoffs
cutoff1436562cutoff
feoff10711052fe_off
putoff1436422putoff
scoff134413342s_coff
selloff1345922selloff
sendoff1446232sendoff
seton55223542seto_n
setons64620172setons
setose65114772setose
setous64917372setous
setout64719462setout
shroff1538502shroff
shutoff1693202shutoff
staff113817712s_taff
stiff114219242s_tiff
stuff113817052s_tuff
toff105929902__toff
behoof1458683behoof
beton76022063beto_n
betons84919553betons
betony114211583betony
betook12439603betook
boff124727333__boff
buyoff1754233buyoff
castoff1547793castoff
coff126930783__coff
cutoffs1533603cutoffs
detour778193detour
detox13310953deto_x
dieoff1335503dieoff
doff116225783__doff
dustoff1445053dustoff
eff96128623_e__ff
estop74312103esto_p
estops84011223estops
feoffs1163703fe_offs
fetor81214533feto_r
fetors91014473fetors
flyoff1444023flyoff
jeton124815403jeto_n
jetons134512613jetons
keto86223453keto__
ketol95414003keto_l
ketols104210763ketols
ketone105014533ketone
ketose105711813ketose
layoff1545093layoff
leadoff1443903leadoff
liftoff1243163liftoff
metol75917813meto_l
metols84115773metols
metope10611123metope
netop7312343neto_p
netops839213netops
off96331633___off
payoff1736023payoff
putoffs1543333putoffs
rebuff1437023rebuff
reroof9315003reroof
restaff1339013restaff
restuff1346953restuff
retold73013753retold
retook104313443retook
retool63914483retool
retore67630773retore
retorn610923433retorn
retort66831153retort
ripoff1436433ripoff
ruboff1435203ruboff
runoff1235413runoff
satori6415843satori
sclaff1438313sclaff
scoffs14347503s_coffs
scruff1437963scruff
scuff133914893s_cuff
second9411153second
sector83415933secto_r
sectors93116453sectors
sego56525183sego__
segos64919483sego_s
seif75638733se__if
seifs85019333se_ifs
self75138293se__lf
selfs85220243se_lfs
selloffs1443633selloffs
sendoffs1543493sendoffs
senor53822803seno_r
senora63216163senora
senors63620793senors
sepoy10314303sepo_y
sepoys1138473sepoys
serf76340113se__rf
serfs84922013se_rfs
serif84132133se_rif
serifs94017053serifs
serosa6313023serosa
serous65023563serous
serow86720443sero_w
serows96016393serows
set36681253set___
seta45637313set__a
setae56026223set_ae
setal56430903set_al
setouts74110333setouts
sets45549503set__s
sett45949053set__t
settee63721023settee
setter64023723setter
settle63915663settle
setts55124323set_ts
setup73915823set_up
setups83910463setups
sexto124415453sexto__
sexton133610793sexto_n
sextons143710413sextons
sextos134012163sexto_s
sheriff16287693sheriff
showoff1943893showoff
shroffs1634363shroffs
shutoffs1752073shutoffs
skiff153612803s_kiff
sluff114016813s_luff
sniff113915863s_niff
snuff113514043s_nuff
sofa75625603s__ofa
soft76942823s__oft
sotol54917653soto_l
sotols63714473sotols
spiff133616403s_piff
spinoff1544933spinoff
spliff1438603spliff
spoof105019013s_poof
spoofs114011813spoofs
spoofy14498553spoofy
staffs12349753s_taffs
stiffs12389963s_tiffs
stoa45425913s_to_a
stoae55024263s_toae
stoai55417873s_toai
stoas55126023s_toas
stoat57135953s_toat
stob66724613s_to_b
stobs75718233s_tobs
stock114417563s_tock
stogy95414083s_togy
stoic7317253s_toic
stoke94922513s_toke
stole54928813s_tole
stoma75918273s_toma
stomp95616663s_tomp
stone55431183s_tone
stony85818643s_tony
stood65517713s_tood
stook95218213s_took
stool55619893s_tool
stoop75821543s_toop
stop66532033s_to_p
stope74727243s_tope
stopoff1565023stopoff
stops74827283s_tops
stopt76528353s_topt
store56333813s_tore
stork96819693s_tork
storm76520403s_torm
story86723033s_tory
stoss54316343s_toss
stot46347333s_to_t
stots54828553s_tots
stott56929793s_tott
stoup75517073s_toup
stour54916743s_tour
stout57434053s_tout
stove85220253s_tove
stow77325743s_to_w
stowp105614233s_towp
stows86622703s_tows
stuffs123810223s_tuffs
stuffy15317083s_tuffy
teff106023763__teff
tiff104727723__tiff
tipoff1436383tipoff
toffs116016723__toffs
toffy145310283__toffy
toft77441653__toft
tofu76921333__tofu
tuff104528523__tuff
veto76622993veto__
vetoed10359823vetoed
vetoer93410063vetoer
vetoes92914083vetoes

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.393454684.5
2DLD Change Limit1127161925.45320670.5
3Display Results1921920.0603200.0
 (SQL Overall)1786911925.90630255.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.