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

504 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
bale6635384(None) 
able66340531able
ale36572341_ale
babe86835811babe
bade75140881bade
bake105637511bake
bal56662721bal_
bald76432901bald
baled85436441baled
baler75635271baler
bales76250081bales
balk105132221balk
ball66043321ball
balm85534201balm
bals66354041bals
bane65250421bane
bare65460521bare
base64847021base
bate66552421bate
bile66147171bile
blae66134641blae
bole66448691bole
dale55643981dale
gale56347321gale
hale76052831hale
kale86533751kale
male66052291male
pale66055011pale
rale45050561rale
sale44959701sale
tale46154161tale
vale74937341vale
wale74546431wale
aal39058672aal_
aals49941142aals
abase76023482abase
abate76627842abate
abbe87627182abbe
abele76323252abele
abled86926832abled
abler75624312abler
ables75935542ables
ably99725132ably
abye97921002abye
ace59656832_ace
ae212590292_a_e
age47154332_age
al210674042_al_
ala312463602_ala
alae45643752_alae
alb57342652_alb
alec66430062_alec
alee46652322_alee
alef76340692_alef
ales47067102_ales
all36148232_all
alme65832162_alme
aloe45540192_aloe
alp56641132_alp
als36663022_als
alt36467962_alt
ane37866942_ane
ape57251182_ape
are37874572_are
ate37059242_ate
ave67748702_ave
awe67746622_awe
axe108239492_axe
axle116424602axle
aye67151762_aye
ba49962342ba__
baa510650422ba_a
baaed85218162baaed
baal67033112baal
baals76122702baals
baas66844672baas
baba88828342baba
babble94017112babble
babel95821692babel
babes95834112babes
babu85829222babu
baby116723672baby
bach116131392bach
back125535762back
bad67763152ba_d
badge94819682badge
badly114918762badly
bads77048862bads
baff124632262baff
baffle14399872baffle
bag67059222ba_g
bagel85116792bagel
bags76645502bags
bah87755352ba_h
baht96740012baht
bail65042802bail
bailed94726652bailed
bailee84526012bailee
bailer85425252bailer
bailey115015672bailey
bailie83818362bailie
bails75933522bails
bait66556002bait
baize164717392baize
baked126130772baked
baker115629542baker
bakes117035372bakes
balas76937212balas
balded105417512balded
balder95318862balder
balds85524642balds
baldy115518932baldy
baleen8613052baleen
balers85626932balers
balked135219412balked
balker124519162balker
balks114926292balks
balky145418242balky
balled94926892balled
baller83825202baller
ballet84733972ballet
balls76236412balls
bally105530102bally
balms95723922balms
balmy125217472balmy
balsa77920412balsa
bam78560142ba_m
bams87044452bams
ban58366832ba_n
band76740902band
baned85436352baned
banes74945582banes
bang74836992bang
bangle94018952bangle
bani65334952bani
bank105835742bank
bans66555132bans
bap76455842ba_p
baps86040842baps
bar58070552ba_r
barb85240062barb
barbe95328282barbe
bard75648862bard
barde85330772barde
bared85144482bared
barer74535802barer
bares75457132bares
barf95844402barf
barge85631022barge
bark106242152bark
barley115116762barley
barm86739602barm
barn66444642barn
barre75929542barre
bars66564092bars
barye105021492barye
bas58681752ba_s
based85331582based
baser74828922baser
bases75644352bases
bash915240162bash
bask105131422bask
bass66146782bass
bast66362412bast
baste74829982baste
bat510988952ba_t
bated85935532bated
bates75846342bates
bath95940082bath
bathe105822882bathe
bats66962332bats
batt65053872batt
battle85217862battle
bauble103813212bauble
baud74928422baud
baulk114914332baulk
bawd105520842bawd
bawl95326062bawl
bawled124415692bawled
bawler114315052bawler
bawls105719322bawls
bay89661642ba_y
bayed115423022bayed
bays97143912bays
be47948942b__e
beadle93314682beadle
beagle93612592beagle
bee56262402b_ee
bel57148462bel_
belie75630382belie
bell66237182bell
belle75827832belle
bels66142492bels
belt65754032belt
bene66439492bene
biali73419072biali
bialy105119322bialy
bible95119412bible
bice86235552bice
bide76041472bide
bike106532592bike
biles75542142biles
bilge87618912bilge
bilk105824412bilk
bill67239932bill
bine66650852bine
birle75023632birle
bise66437092bise
bite66546992bite
bize155926282bize
blab86629132blab
blade85923332blade
blah98625062blah
blam86131702blam
blame95625492blame
blare75826232blare
blase75524232blase
blat66550952blat
blate75933782blate
blaw97026722blaw
blaze165520832blaze
bleb85425222b_leb
bled75729312b_led
blet66247672b_let
blew94722432b_lew
blue65328462blue
bode75838752bode
bogle85821682bogle
bola66035562bola
bold75432812bold
boles75448602boles
boll65634752boll
bolo65535952bolo
bolt66254172bolt
bone65949322bone
bore66051332bore
boule74828042boule
brace95629272brace
brae65639112brae
brake116025342brake
brave104925502brave
braze165423452braze
bree67241262bree
brie65837902brie
bubale104014622bubale
bugle84721942bugle
bulb85626692bulb
bulge86419872bulge
bulk105426152bulk
bull65634872bull
bute66739672bute
butle75023102butle
bye86134592b_ye
byre95023852byre
byte96521812byte
cable95329912cable
cade76443912cade
cafe95230322cafe
cage75339062cage
cake105439962cake
calf96339562calf
calk105527662calk
call66838672call
calm85032362calm
calo64936442calo
calve105919922calve
calx135722792calx
came87648752came
cane66653112cane
cape87242782cape
care66968372care
carle74535702carle
case65848082case
cate66254592cate
cave95941262cave
cole66956112cole
dace76934922dace
dal47554952dal_
dales66439742dales
dals57145122dals
dame77140312dame
dare55848862dare
date56443322date
daze147327232daze
dele56843082dele
dole56550002dole
eagle64219482eagle
ease45042332ease
eave75733582eave
fable105824752fable
face96140122face
fade85736342fade
fake115534942fake
fall75535312fall
false84818122false
falx147120782falx
fame95639392fame
fane75343562fane
fare76354462fare
farle86929242farle
fate75444282fate
fave105532962fave
faze165630042faze
file75446642file
gable85325522gable
gae46457702ga_e
gage65936102gage
gal46055512gal_
gala55635162gala
galea64722932galea
gales65442482gales
gall56335992gall
gals57946502gals
game76644322game
gane55145292gane
gape75134512gape
gate55746572gate
gave84634052gave
gaze145032412gaze
hade85440192hade
hae67364002ha_e
hake115637842hake
haled95335822haled
haler85033522haler
hales85449842hales
half106238452half
hall75741162hall
halm95834972halm
halo76437322halo
halt76056302halt
halve114818922halve
hame97043132hame
haole84820082haole
hare76255732hare
hate78450172hate
have106137072have
haze164833392haze
hole77553392hole
idle55423762idle
isle45121702isle
jade125325442jade
jake155925772jake
jane115031472jane
jape134923422jape
jole117233822jole
kae76744542ka_e
kales95730982kales
kame105728232kame
kane85133962kane
lace66848472lace
lade56345982lade
ladle66320442ladle
lake85741602lake
lall45531312lall
lame66849292lame
lane45153322lane
lase46148512lase
late47560482late
lave75642142lave
laze136235052laze
mabe85733342mabe
mace87345782mace
macle96127002macle
made75440232made
mae57659102ma_e
mage75739122mage
maile75232212maile
make105537882make
males75049792males
mall64639362mall
malm85129972malm
malt66254802malt
mane65052012mane
maple95521142maple
mare64759322mare
mate65154212mate
maze155434972maze
mile66352562mile
mole66251832mole
mule65236972mule
nabe66029492nabe
nae35952742na_e
nala46930392nala
naled65525052naled
name65637412name
nape65230802nape
nave75732312nave
obole75917142obole
ogle56325052ogle
ole37155212_ole
orle45630462orle
pace86345772pace
padle84522342padle
page76036102page
pal56761672pal_
palea75028662palea
paled85538722paled
paler75436932paler
pales75753802pales
palet74650802palet
pall65039342pall
palm85331362palm
palp85828572palp
pals66951352pals
paly95835532paly
pane64950282pane
pare66760842pare
parle75836162parle
pase65346862pase
pate65350462pate
pave96133892pave
pele65539552pele
pile65649692pile
pole65951302pole
pule65040952pule
quale143617852quale
race66746262race
rage55742352rage
rake84841572rake
rales54947492rales
rape65041632rape
rare45348432rare
rase46149982rase
rate45458762rate
rave75542092rave
raze135235432raze
rile45650532rile
role45851822role
rule49938422rule
sabe66140572sabe
sable74732162sable
sade55544472sade
sae38365182sa_e
safe75930952safe
sage55044592sage
sake85244962sake
sal36462882sal_
salep77022952salep
sales56055592sales
sall44544682sall
salp64534092salp
sals46851672sals
salt45758522salt
salve85022132salve
same65245642same
sane45954332sane
sate45556102sate
save75741362save
scale74629142scale
shale85332832shale
sole46053672sole
spale74929212spale
stale55637102stale
swale85221592swale
table75429602table
tace65342512tace
tae38267052ta_e
tael46030712tael
take84739262take
tala45938052tala
talc66226812talc
taler56034862taler
tales55451372tales
tali46837162tali
talk86230092talk
tall47240212tall
tame66343662tame
tape64538142tape
tare45957622tare
tate44748602tate
tele45040872tele
tile45451442tile
tole46052902tole
tule45735872tule
unbale83616402unbale
vales85434262vales
valet84337872valet
valse85117522valse
value85719092value
valve114515932valve
vane75534682vane
vase75629652vase
vile76139802vile
vole75236982vole
wade85237062wade
wae67556952wa_e
wage84834082wage
wake114935702wake
waled94330992waled
waler84229262waler
wales86142832wales
walk115625612walk
wall76236102wall
waly105830902waly
wame95035482wame
wane76344712wane
ware76254722ware
wave105234732wave
whale115517432whale
wile75944372wile
wyle105519382wyle
yald86920602yald
yare75636942yare
yule75725142yule

Search took 1 second 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.0632836365.1
2DLD Change Limit298725040.76638997.4
3Display Results5045040.1234097.6
 (SQL Overall)1786915040.952187700.6
 
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.