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

264 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
blet6624767(None) 
beet66457541beet
belt65754031belt
bet58376671b_et
blat66550951blat
bleat75737001bleat
bleb85425221bleb
bled75729311bled
blent76230951blent
blest76431721blest
blets75324941blets
blew94722431blew
blot65842321blot
bluet75631191bluet
let36481471_let
abet610547942abet
able66340532able_
abled86926832abled
abler75624312abler
ables75935542ables
ablest84721832ablest
aglet65534142aglet
ale36572342ale_
alec66430062alec
alee46652322alee
alef76340692alef
alert54740652alert
ales47067102ales
alit46155692alit
alt36467962al_t
baht96740012baht
bait66556002bait
bale66353842bale_
baled85436442baled
baler75635272baler
bales76250082bales
ballet84733972ballet
bast66362412bast
bat510988952b_at
bate66552422bate
batt65053872batt
be47948942b_e_
beat66168302beat
bed67950622b_ed
bee56262402b_ee
beef96233672beef
been65335782been
beep85931212beep
beer65635992beer
bees65453382bees
beets76131442beets
beg65944132b_eg
beget85632552beget
bel57148462b_el
bell66237182bell
bels66142492bels
belts75931162belts
ben56554922b_en
bent67759912bent
beret74946362beret
bes56557432b_es
beset76739132beset
best66355322best
beta66234132b_eta
beth96629232b_eth
bets67051442b_ets
bey86645422b_ey
bhut95425712bhut
bidet84935622bidet
bier65531822bier
bile66147172bile_
biles75542142biles
billet86029722billet
bint67355032bint
bit57070892b_it
bite66546992bite
bitt65545802bitt
blab86629132blab
blae66134642blae
blah98625062blah
blam86131702blam
blast76532572blast
blate75933782blate
blats75132502blats
blaw97026722blaw
bleak115915382bleak
blear75918682blear
bleats85518612bleats
blebs96416152blebs
bleed85019802bleed
bleep95013452bleep
blend85317452blend
bless75917812bless
blin67228172blin
blip88322772blip
blite76225352blite
blitz165318132blitz
bloat75229922bloat
blob86027092blob
bloc85023272bloc
blog75723822blog
blots75626172blots
blow95827192blow
blub85324872blub
blue65328462blue
blued84520322blued
bluer74918492bluer
blues75127042blues
bluest84016482bluest
bluets87215492bluets
bluey104817052bluey
blunt75525022blunt
blur66020532blur
blurt77625622blurt
boat66360312boat
bole66448692bole_
boles75448602boles
bolete8519612bolete
boleti8413402boleti
bolt66254172bolt
boot67759372boot
bort65960962bort
bot59680402b_ot
bott66548572bott
bout66353292bout
brat66055542brat
bred75130972bred
bree67241262bree
bren65629562bren
brent75734132brent
brew95023562brew
brit66350152brit
brut66537962brut
bullet84528612bullet
bunt65850852bunt
buret77444012buret
bust65947782bust
but55963022b_ut
bute66739672bute
butt65143742butt
bye86134592bye_
byes95230532byes
byte96521812byte
cablet104429462cablet
celt65646712celt
cleat76335062cleat
clef97028182clef
cleft106222852cleft
clept95725772clept
clew95520572clew
clot66542422clot
culet76040342culet
deet57356582deet
delt57855272delt
diet57357532diet
duet56446262duet
ebbet93517292ebbet
elect74327032elect
et26964192__et
feet75352212feet
felt75146932felt
fet66471632_fet
filet85540162filet
flat77147822flat
flea75628492flea
fled85429772fled
flee76238792flee
fleet85932332fleet
flew105824252flew
flex146123472flex
fley106626852fley
flit76539272flit
fret75845042fret
gelt56448012gelt
get47467462_get
giblet93418892giblet
gled65631142gled
glee55239062glee
gleet65532342gleet
gleg66219802gleg
glen56027202glen
gley85724652gley
glut56331292glut
goblet93219482goblet
haet75659502haet
het67674312_het
ilea45931462ilea
ilex115822032ilex
inlet53732402inlet
islet54527552islet
jet106754822_jet
keet85347332keet
kelt85343192kelt
khet116328622khet
lat37593402_lat
lea37660182_lea
led46254552_led
lee36068142_lee
leet45957902leet
left76340482_left
leg46446112_leg
lei36846382_lei
lek75640302_lek
lent46360532_lent
lept66440882_lept
les35663072_les
lest46956322_lest
lets47147942_lets
leu36047402_leu
lev66139422_lev
lex107943822_lex
ley66246812_ley
lez125541312_lez
lit39377312_lit
lot38179262_lot
meet65350552meet
melt65752892melt
met56072432_met
net36670292_net
objet141213142objet
ole37155212ole_
olea46532722olea
oleo46630482oleo
oles46453472oles
owlet83324462owlet
palet74650802palet
pelt67651082pelt
pet56477302_pet
plat66048872plat
plea66830602plea
pleat74734472pleat
pleb86123812pleb
pled75231432pled
plew97222812plew
plex137321372plex
plot66141232plot
poet65552902poet
relet54749822relet
ret35982832_ret
riblet84222442riblet
set36681252_set
slat46959022slat
sled55334372sled
sleet55639132sleet
slept75728102slept
slew76228232slew
slit46250102slit
slot46049822slot
slut45040592slut
stet45947322stet
sublet82827242sublet
suet46754822suet
tablet84227642tablet
tet39274982_tet
tret46653532tret
unlet54133332unlet
valet84337872valet
vet65958522_vet
weet75254152weet
welt75547862welt
wet65966622_wet
whet105133782whet
yet66960692_yet
ylem9217892ylem

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 Filter178691298720.0762351197.4
2DLD Change Limit298722640.98630296.1
3Display Results2642640.0634190.5
 (SQL Overall)1786912641.125158836.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.