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

137 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
blest7643172(None) 
ablest84721831ablest
best66355321b_est
blast76532571blast
bleat75737001bleat
blent76230951blent
bless75917811bless
blet66247671ble_t
blets75324941blets
bluest84016481bluest
lest46956321_lest
ableist9311772ableist
ables75935542ables_
alert54740652alert
ales47067102ales_
alist56136782alist
baldest102313532baldest
bales76250082bales_
barest85327692barest
basest84720492basest
bast66362412b_ast
beast76338642beast
beat66168302b_eat
bees65453382bees_
beet66457542b_eet
beets76131442beets
behest11314612behest
bels66142492bels_
belt65754032b_elt
belts75931162belts
bent67759912b_ent
bes56557432b_es_
beset76739132b_eset
besot76429712b_esot
bests75932612b_ests
bet58376672b_e_t
bets67051442b_ets
biles75542142biles_
blase75524232blase
blasts85116772blasts
blasty115611052blasty
blat66550952bl_at
blats75132502blats
bleak115915382bleak
blear75918682blear
bleats85518612bleats
bleb85425222ble_b
blebs96416152blebs
bled75729312ble_d
bleed85019802bleed
bleep95013452bleep
blend85317452blend
blew94722432ble_w
bliss75616912bliss
bloat75229922bloat
blot65842322bl_ot
blots75626172blots
blues75127042blues_
bluesy11448982bluesy
bluet75631192bluet
bluets87215492bluets
blunt75525022blunt
blurt77625622blurt
blush105115312blush
boast75935702boast
boldest102613062boldest
boles75448602boles_
boost75132472boost
breast8319632breast
brent75734132brent
burst75332242burst
bust65947782b_ust
byes95230532byes_
chest104926142chest
clast76030582clast
cleat76335062cleat
cleft106222852cleft
clept95725772clept
crest74632692crest
doest65829522doest
drest65530342drest
egest65222342egest
eldest72912682eldest
elect74327032elect
fest74949442_fest
fleet85932332fleet
flesh115013742flesh
fliest94718432fliest
geest64829612geest
gest56149132_gest
gleet65532342gleet
glost65422932glost
guest65225922guest
halest94823272halest
hest75950772_hest
idlest74014862idlest
illest63615722illest
jest116738502_jest
last46260322_last
least56134882_least
leet45957902_leet
left76340482_left
lent46360532_lent
lept66440882_lept
les35663072_les_
less45635102_less
let36481472_le_t
lets47147942_lets
list47055342_list
lost47951492_lost
lust47442602_lust
molest85022742molest
nest45548732_nest
noblest93613562noblest
oblast8613662oblast
obtest81213012obtest
oldest72114092oldest
oles46453472oles_
palest83926222palest
pest65555292_pest
pleat74734472pleat
prest75736352prest
quest144121322quest
reest54938092reest
rest46459842_rest
sleet55639132sleet
slept75728102slept
sliest66621952sliest
slyest93811362slyest
test48651622_test
unblest9411812unblest
vest75743602_vest
vilest9416842vilest
weest85026772weest
west75748082_west
wrest84925432wrest
zest136035702_zest

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.0931921408.6
2DLD Change Limit538001371.56334421.0
3Display Results1371370.0462978.3
 (SQL Overall)1786911371.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.