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

130 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
cutoff143656(None) 
cutoffs1533601cutoffs
putoff1436421putoff
buyoff1754232buyoff
castoff1547792castoff
coff126930782c__off
cuff125327992cu__ff
cutout8315922cutout
dustoff1445052dustoff
putoffs1543332putoffs
ruboff1435202ruboff
runoff1235412runoff
setoff1238912setoff
shutoff1693202shutoff
toff105929902__toff
auto47432083auto__
autoed7712823autoed
autos56523323auto_s
boff124727333__boff
buff125229863bu__ff
buyoffs1842433buyoffs
caff125631673c__aff
caitiff1547133caitiff
castoffs1644043castoffs
chaff165016283c_haff
chuff164812493c_huff
citify1437443citify
citola838393citola
citole8311503citole
cliff135917133c_liff
coffs134916303c__offs
coft97939683c__oft
coif96337913c__oif
coof96643273c__oof
coofs105924713c_oofs
cookoff1954073cookoff
corf95941483c__orf
croft105622683c_roft
cuboid1139503cuboid
cuffs135017493cu_ffs
cuif96529143cu__if
cuifs104814693cu_ifs
cupola10317693cupola
curf97538783cu__rf
curfs105122143cu_rfs
custody1334093custody
custom104010273custo_m
customs11348263customs
custos84014313custo_s
cut57957663cut___
cutch125116193cut_ch
cutdown1344083cutdown
cute66440453cut__e
cutely115312803cutely
cuter74728233cut_er
cutes79438323cut_es
cutest85820143cutest
cutesy114810733cutesy
cutey105819793cut_ey
cuteys11569983cuteys
cutie76925933cut_ie
cuties84927363cuties
cutin75022783cut_in
cutins83919983cutins
cutis77723763cut_is
cutlas8313103cutlas
cutler84718033cutler
cutlet84924363cutlet
cutouts938033cutouts
cutover1235283cutover
cuts65841153cut__s
cutter84521003cutter
cuttle84113893cuttle
cutty105417223cut_ty
cutup9410093cut_up
cutups1036813cutups
cutwork16176823cutwork
cutworm14186353cutworm
cyton101511463cyto_n
cytons111710183cytons
dieoff1335503dieoff
doff116225783__doff
duff114326643du__ff
dustoffs1543163dustoffs
feoff10711053_feoff
flyoff1444023flyoff
fuckoff1842393fuckoff
futon83113773futo_n
futons93911513futons
guff114624933gu__ff
huff135623843hu__ff
jumpoff2442243jumpoff
layoff1545093layoff
liftoff1243163liftoff
luff104426703lu__ff
muff124723863mu__ff
muton73817003muto_n
mutons84314363mutons
off96331633___off
outfox1636143outfox
payoff1736023payoff
puff125525433pu__ff
puton73617913puto_n
putons83515153putons
putout8315113putout
quaff201311353qu_aff
quiff201111563qu_iff
ripoff1436433ripoff
ruboffs1543123ruboffs
ruff105127653ru__ff
runoffs1343013runoffs
scoff134413343_scoff
scuff133914893scu__ff
setoffs1334133setoffs
shroff1538503shroff
shutoffs1752073shutoffs
staff113817713_staff
stiff114219243_stiff
stuff113817053_stuff
teff106023763__teff
tiff104727723__tiff
tipoff1436383tipoff
toffs116016723__toffs
toffy145310283__toffy
toft77441653__toft
tofu76921333__tofu
tuff104528523__tuff
turnoff1344013turnoff
tutor5712493tuto_r
tutors6912333tutors

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.373479064.3
2DLD Change Limit1127161305.19021717.9
3Display Results1301300.0462826.1
 (SQL Overall)1786911305.60931857.9
 
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.