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 “doff” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

146 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
doff11622578(None) 
boff124727331boff
coff126930781coff
daff115229681daff
diff116228841diff
doffs125614331doffs
duff114326641duff
off96331631_off
toff105929901toff
aff95537612_aff
baff124632272baff
biff125026892biff
boffo136010372boffo
boffs134915502boffs
buff125229862buff
caff125631672caff
coffs134916302coffs
coft97939682coft
coif96337912coif
coof96643272coof
corf95941482corf
cuff125327992cuff
daffs125116422daffs
daffy155510282daffy
daft85537252daft
deaf85838402deaf
def76546722d_ef
defi86321492defi
deft85540222deft
defy114921262defy
delf85436572delf
dieoff1335502dieoff
dif76846902d_if
diffs126315492diffs
difs86027322difs
do310155252do__
doat56947672doat
doby106022162doby
doc66841512do_c
dock116228742dock
docs75631152docs
dodo66024912dodo
doe47361952do_e
doer57734702doer
does56554472does
doffed14428502doffed
doffer133911352doffer
dog57449752do_g
doge66233802doge
dogs66440152dogs
dogy96126492dogy
doit56347852doit
dojo126016142dojo
dol47150652do_l
dole56550002dole
doll56632492doll
dols56943052dols
dolt56649422dolt
dom69752442do_m
dome77240732dome
doms76239572doms
don46757652do_n
dona55529632dona
done55747912done
dong66031652dong
dons56048702dons
doom76430072doom
door56928512door
dopa77220902dopa
dope76038892dope
dopy106224152dopy
dor47253922do_r
dore56353302dore
dork96531462dork
dorm76834632dorm
dorp76028052dorp
dorr56627722dorr
dors56747602dors
dory85836232dory
dos48062312do_s
dose56442432dose
doss56235042doss
dost57248352dost
dot47573182do_t
dote55442882dote
doth86225712doth
dots55647662dots
doty86128222doty
doum76226672doum
dour56330432dour
doux125817982doux
dove85131562dove
dow76749972do_w
down86427492down
dows85941052dows
doxy156419952doxy
doze145829082doze
dozy175920322dozy
draff125615662draff
duffs125216622duffs
eff96128622_eff
feoff10711052feoff
gaff114828152gaff
golf85731182golf
goof85436872goof
guff114624932guff
hoof106036582hoof
howf136127202howf
howff175110492howff
huff135623842huff
iff96730392_iff
jiff175321412jiff
loaf76734902loaf
loft76539142loft
loof78141052loof
luff104426702luff
miff125625062miff
muff124723862muff
naff105128932naff
oaf65952882_oaf
of58247772_o_f
offs107117012_offs
oft67744062_oft
poof95541662poof
pouf95732642pouf
pouff135215422pouff
puff125525432puff
raff104933042raff
riff104430102riff
rolf75134872rolf
roof75738832roof
ruff105127652ruff
scoff134413342scoff
sofa75625602sofa
soft76942822soft
teff106023762teff
tiff104727722tiff
toffs116016722toffs
toffy145310282toffy
toft77441652toft
tofu76921332tofu
tuff104528522tuff
waff134228042waff
wolf105729562wolf
woof106532422woof
yaff135324262yaff

Search took 3 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 Filter178691298720.906197230.7
2DLD Change Limit298721461.69017675.7
3Display Results1461460.0304866.7
 (SQL Overall)1786911462.62668046.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.