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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
blends9601288(None) 
bends85628971b_ends
bleeds95211591bleeds
blend85317451blend_
blende95413441blende
blendes104713681blendes
blinds95111611blinds
blonds95213341blonds
lends65326251_lends
alands75418372alands
amends94713282amends
bands85233422b_ands
beads85429502b_eads
beds75937782b_e_ds
bend76435262b_end_
bendy115017252b_endy
bendys12518382b_endys
benes75536232b_enes
bens65945702b_en_s
bents76033692b_ents
bields94110002bields
binds86627472b_inds
bland85320452bland_
blanks124112892blanks
bleaks125112432bleaks
blears85116452blears
bleats85518612bleats
blebs96416152ble_bs
bled75729312ble_d_
bleed85019802bleed_
bleeps10499102bleeps
blench133710452blench
blended114710712blended
blender104613842blender
blenders115210992blenders
blenny1156202blenny
blent76230952blen_t
bless75917812ble_ss
blets75324942ble_ts
blind86319322blind_
blinis85313682blinis
blinks124613572blinks
blond85618372blond_
blonde94813292blonde
blondes104213162blondes
bloods94614842bloods
blunts84512892blunts
bonds86126842b_onds
bounds94415802bounds
brands95118942brands
breads95419202breads
breeds94914882breeds
brens75823362bren_s
brents84717272brents
bunds85523542b_unds
calends1039522calends
elands74914772elands
emends95711432emends
ends56528522__ends
fends96324972_fends
fiends104110292fiends
glands85314402glands
gleds75417892gle_ds
gleeds84711622gleeds
glens66519852glen_s
kalends1235682kalends
lands65426902_lands
leads66028492_leads
lend56233672_lend_
lenes54738522_lenes
lenis56326862_lenis
lenos56024862_lenos
lens46146492_len_s
leuds66214812_leuds
mends84927692_mends
pends85527192_pends
pleads94613952pleads
reblends1135292reblends
relends84013252relends
rends65129952_rends
scends95213002scends
sends65528242_sends
shends105313772shends
sleds64418852sle_ds
spends94714472spends
tends65425582_tends
trends75513542trends
upends9438762upends
vends95520892_vends
wends95822812_wends

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 Filter178691825510.343520965.0
2DLD Change Limit82551902.39034540.2
3Display Results90900.0165625.0
 (SQL Overall)178691902.74965002.2
 
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.