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

287 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
blae6613464(None) 
alae45643751alae
bale66353841bale
blab86629131blab
blade85923331blade
blah98625061blah
blam86131701blam
blame95625491blame
blare75826231blare
blase75524231blase
blat66550951blat
blate75933781blate
blaw97026721blaw
blaze165520831blaze
blue65328461blue
brae65639111brae
ablate82219212ablate
ablaze17239832ablaze
able66340532abl_e
ae212590292__ae
ala312463602ala_
alan46844082alan
alane56135612alane
alar46340072alar
alas46358122alas
alate55340322alate
ale36572342al_e
alee46652322alee
algae65319622algae
alme65832162alme
aloe45540192aloe
ba49962342b_a_
baa510650422b_aa
baaed85218162baaed
baal67033112baal
baas66844672baas
babe86835822babe
bad67763152b_ad
bade75140882bade
bag67059222b_ag
bah87755352b_ah
bake105637512bake
bal56662722b_al
balas76937212balas
bald76432902bald
baled85436442baled
baler75635272baler
bales76250082bales
balk105132222balk
ball66043322ball
balm85534202balm
bals66354042bals
bam78560142b_am
ban58366842b_an
bane65250432bane
bap76455842b_ap
bar58070552b_ar
bare65460522bare
bas58681752b_as
base64847022base
bat510988952b_at
bate66552422bate
bay89661642b_ay
be47948942b__e
bead75937922bead
beak106534382beak
beam86939232beam
bean66443862bean
bear66844642bear
beat66168302beat
beau66137272beau
bee56262402b_ee
belay105021522belay
belie75630382belie
belle75827832belle
bene66439492bene
bias64738162bias
bice86235562bice
bide76041482bide
bike106532602bike
bile66147182bile
bilge87618912bilge
bine66650862bine
bise66437102bise
bite66547002bite
bize155926292bize
blabs95619632blabs
black134719072black
bladed104717762bladed
blader93618582blader
blades95221252blades
blaff135216482blaff
blahs105616512blahs
blain75421792blain
blamed116017952blamed
blamer104417142blamer
blames105121862blames
blams95023852blams
bland85320452bland
blank115418552blank
blared95018242blared
blares85021632blares
blast76532572blast
blats75132502blats
blawed124713892blawed
blawn106813702blawn
blaws105620462blaws
blazed184314712blazed
blazer174414022blazer
blazes174817352blazes
bleak115915382bleak
blear75918682blear
bleat75737002bleat
bleb85425222bleb
bled75729312bled
bleed85019802bleed
bleep95013452bleep
blet66247672blet
blew94722432blew
blin67228172blin
blip88322772blip
blite76225352blite
bloat75229922bloat
blob86027092blob
bloc85023272bloc
blog75723822blog
bloke114316632bloke
blot65842322blot
blow95827192blow
blub85324872blub
blued84520322blued
bluer74918492bluer
blues75127042blues
bluet75631192bluet
bluey104817052bluey
blume95619892blume
blur66020532blur
blype12429672blype
boa56954032boa_
boar66134292boar
boas66150832boas
boat66360312boat
bode75838752bode
bola66035562bola_
bolar75123472bolar
bolas74733762bolas
bole66448692bole
bone65949322bone
bore66051332bore
bra56339462bra_
brace95629272brace
brad75234342brad
braes75735052braes
brag75229722brag
brake116025342brake
bran65740382bran
bras65746452bras
brat66055542brat
brave104925502brave
braw94829562braw
bray95232902bray
braze165423452braze
bree67241262bree
brie65837902brie
bulge86419872bulge
bullae83416162bullae
bute66739672bute
bye86134592b_ye
bylaw13408602bylaw
byre95023852byre
byte96521812byte
clad76225822clad
clade85821012clade
clag75924572clag
clam86332292clam
clan65633922clan
clap86429042clap
clave105420152clave
claw95624342claw
clay95927412clay
clue65324532clue
dale55643982dale
elan46734242elan
elate55335882elate
else45923082else
flab96628352flab
flag87427082flag
flak116026172flak
flake125119972flake
flam96333292flam
flame105124442flame
flan76134182flan
flap96128702flap
flare84823632flare
flat77147822flat
flaw106326642flaw
flax147325632flax
flay106332802flay
flea75628492flea
flee76238792flee
floe76129772floe
flue75329852flue
frae75330472frae
gae46457702_gae
gale56347322gale
glace87420152glace
glad65624012glad
glade75121962glade
glam76529342glam
glare65222952glare
glaze155418162glaze
glee55239062glee
glue55628492glue
hae67364002_hae
hale76052832hale
ilea45931462ilea
kae76744542_kae
kale86533752kale
la219261632_la_
lab58864782_lab
lac510155822_lac
lace66848472_lace
lad48165702_lad
lade56345982_lade
lag47862122_lag
lake85741602_lake
lam57666712_lam
lame66849292_lame
lane45153332_lane
lap58565272_lap
lar37967532_lar
las37281472_las
lase46148512_lase
lat37593402_lat
late47560482_late
lav66847342_lav
lave75642142_lave
law68656642_law
lax107651522_lax
lay68865352_lay
laze136235052_laze
lea37660182_lea
lee36068142_lee
lie38264522_lie
lye66533412_lye
mae57659112_mae
male66052302male
nae35952742_nae
oblate82214742oblate
ole37155212ol_e
olea46532722olea
pale66055012pale
place94824612place
plage84520402plage
plan65833942plan
plane74929142plane
plat66048872plat
plate74635112plate
play95928982play
plea66830602plea
plie65127392plie
rale45050562rale
sae38365182_sae
sale44959702sale
slab67133762slab
slag55934352slag
slake93724052slake
slam67737972slam
slap66434042slap
slat46959022slat
slate55438282slate
slave84224032slave
slaw77930712slaw
slay76436382slay
sloe45534952sloe
slue45332192slue
spae65034322spae
tae38267052_tae
tale46154162tale
telae54323292telae
thae76825562thae
twae74719572twae
ulan46527392ulan
ulnae55214572ulnae
vale74937342vale
wae67556952_wae
wale74546432wale

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.313570897.8
2DLD Change Limit298722870.84335435.3
3Display Results2872870.0634555.6
 (SQL Overall)1786912871.219146588.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.