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

145 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
setoffs133413(None) 
setoff1238911setoff_
cutoffs1533602cutoffs
feoffs1163702fe_offs
putoffs1543332putoffs
scoffs14347502s_coffs
selloffs1443632selloffs
sendoffs1543492sendoffs
setons64620172seto_ns
setous64917372seto_us
setouts74110332setouts
shroffs1634362shroffs
shutoffs1752072shutoffs
staffs12349752s_taffs
stiffs12389962s_tiffs
stuffs123810222s_tuffs
toffs116016722__toffs
betons84919553beto_ns
boffs134915503__boffs
buyoffs1842433buyoffs
castoffs1644043castoffs
coffs134916303__coffs
cutoff1436563cutoff_
detours858043detours
detoxes1538803detoxes
dieoffs1443033dieoffs
doffs125614333__doffs
dustoffs1543163dustoffs
effs105114033_e__ffs
estops84011223esto_ps
feoff10711053fe_off_
fetors91014473feto_rs
flyoffs1542253flyoffs
jetons134512613jeto_ns
ketols104210763keto_ls
ketones115014503ketones
ketoses114912873ketoses
ketosis11429733ketosis
layoffs1642573layoffs
leadoffs1542303leadoffs
liftoffs1342063liftoffs
metols84115773meto_ls
metopes11311363metopes
netops839213neto_ps
offs107117013___offs
payoffs1843243payoffs
putoff1436423putoff_
rebuffs1533403rebuffs
reroofs1037943reroofs
restaffs1444783restaffs
restuffs1444193restuffs
retools73411023retools
retorts76016513retorts
ripoffs1543383ripoffs
ruboffs1543123ruboffs
runoffs1343013runoffs
satoris7317253satoris
sclaffs1543573sclaffs
scoff134413343s_coff_
scruffs1554173scruffs
scuffs14419053s_cuffs
seconds1038283seconds
sectors93116453secto_rs
segos64919483sego__s
seifs85019333se__ifs
selfs85220243se__lfs
selloff1345923selloff_
sendoff1446233sendoff_
senoras72714953senoras
senores73218113senores
senors63620793seno_rs
sepoys1138473sepo_ys
serfs84922013se__rfs
serifs94017053se_rifs
serosas7312663serosas
serous65023563sero_us
serows96016393sero_ws
seton55223543seto__n
setose65114773seto_se
setout64719473seto_ut
sets45549503set___s
settees73513633settees
setters73822063setters
settles73916003settles
setts55124323set__ts
setups83910463set_ups
sextons143710413sexto_ns
sextos134012163sexto__s
sheriffs17253923sheriffs
showoffs2042453showoffs
shroff1538503shroff_
shutoff1693203shutoff_
skiffs16327013s_kiffs
sluffs12349583s_luffs
sniffs12378843s_niffs
snuffs12358533s_nuffs
sofas85320713s__ofas
softs85019233s__ofts
sotols63714473soto_ls
spiffs14328473s_piffs
spinoffs1642773spinoffs
spliffs1533563spliffs
spoofs114011813s_poofs
staff113817713s_taff_
stiff114219243s_tiff_
stoas55126023s_to_as
stoats65117483s_toats
stobs75718233s_to_bs
stocks124715633s_tocks
stoics8311113s_toics
stokes104821793s_tokes
stoles63927673s_toles
stomas84816323s_tomas
stomps105612833s_tomps
stones65130033s_tones
stooks105115373s_tooks
stools65117023s_tools
stoops85917893s_toops
stopes84525893s_topes
stopoffs1662993stopoffs
stops74827283s_to_ps
stores65533663s_tores
storks106115953s_torks
storms85814633s_torms
stoss54316343s_to_ss
stots54828553s_to_ts
stotts64612863s_totts
stoups85313273s_toups
stours65015633s_tours
stouts65019003s_touts
stoves93818923s_toves
stowps115710583s_towps
stows86622703s_to_ws
stuff113817053s_tuff_
stuffy15317083s_tuffy
teffs115111733__teffs
tiffs114414883__tiffs
tipoffs1543033tipoffs
toff105929903__toff_
toffy145310283__toffy
tofts84919243__tofts
tofus86415423__tofus
tuffs115118263__tuffs
vetoers10359473vetoers
vetoes92914083veto_es

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271456.18621666.2
3Display Results1451450.0463152.2
 (SQL Overall)1786911456.63826919.4
 
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.