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

102 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
blond8561837(None) 
bland85320451bland
blend85317451blend
blind86319321blind
blonde94813291blonde
blonds95213341blonds
blood85319521blood
bond75334361b_ond
aland65526412aland
almond91410432almond
alone55732962alone
along65419492along
aloud65018072aloud
band76740912b_and
belon73924112belon_
belong93411042belong
belons84119412belons
bend76435262b_end
beyond1237072beyond
bind76234512b_ind
biont7727162biont
blank115418552blank
bled75729312bl_ed
bleed85019802bleed
blende95413442blende
blends96012882blends
blent76230952blent
blin67228172blin_
blinds95111612blinds
blini75519272blini
blink115720142blink
bloat75229922bloat
blob86027092blo_b
blobs95620032blobs
bloc85023272blo_c
block134917842block
blocs95219652blocs
blog75723822blo_g
blogs85319232blogs
bloke114316632bloke
blonder104011942blonder
blondes104213162blondes
bloods94614842bloods
bloody124710172bloody
bloom95918972bloom
bloop96116152bloop
blot65842322blo_t
blots75626172blots
blow95827192blo_w
blowed125016692blowed
blown105716672blown
blows105423832blows
blowy134315322blowy
blued84520322blued
blunt75525022blunt
bod67055542b_o_d
bold75432812b_old
bonds86126842b_onds
bone65949322b_one
boned85133242b_oned
bong75633412b_ong
bonk105531712b_onk
bony96732082b_ony
booed85127272booed
boon67142172boon_
boons75031912boons
bound84819582bound
brand85124492brand
broad84817692broad
bronc91714342bronc
brood84620242brood
bund75530662b_und
clod76124612clo_d
clon66232482clon_
clone75728162clone
cloned94518802cloned
clonk114417442clonk
clons75228132clons
cloud86716422cloud
eland65820392eland
flong95815682flong
flood95215602flood
fond86330952_fond
frond95316342frond
gland75217712gland
klong105310402klong
land56337312_land
lend56233672_lend
load56730602_load
loid55531492_loid
lone45849132_lone
long56933342_long
lord55032082_lord
loud55228042_loud
oblong935382oblong
plod76723272plo_d
plonk114613982plonk
pond75530492_pond
sloid64619712sloid
slojd13378842slojd
sloyd9409682sloyd
yond86122312_yond

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit538001021.39038705.0
3Display Results1021020.0166375.0
 (SQL Overall)1786911021.702104988.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.