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

245 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
baal6703311(None) 
aal39058671_aal
baa510650421baa_
baals76122701baals
baas66844671baas
bail65042801bail
bal56662721b_al
ball66043321ball
banal75925991banal
basal75722281basal
bawl95326061bawl
aa219179952_aa_
aah616252962_aah
aals49941142_aals
aas310975392_aas
aba512850952aba_
abas68642082abas
ail37171042_ail
al210674042__al
ala312463602_ala
all36148232_all
anal48037522anal
awl67635302_awl
axal116520492axal
ba49962342b_a_
baaed85218162baaed
baalim1038472baalim
baba88828342baba
babas96325732babas
babe86835812babe
babel95821692babel
babu85829222babu
babul96317712babul
baby116723672baby
bach116131392bach
back125535762back
bad67763152b_ad
bade75140882bade
badly114918762badly
bads77048862bads
baff124632262baff
bag67059222b_ag
bagel85116792bagel
bags76645502bags
bah87755352b_ah
baht96740012baht
bails75933522bails
bait66556002bait
bake105637512bake
balas76937212balas
bald76432902bald
bale66353842bale
balk105132222balk
balls76236412balls
bally105530102bally
balm85534202balm
bals66354042bals
bam78560142b_am
bams87044452bams
ban58366832b_an
band76740902band
bane65250422bane
bang74836992bang
bani65334952bani
bank105835742bank
bans66555132bans
bap76455842b_ap
baps86040842baps
bar58070552b_ar
barb85240062barb
barbal104016662barbal
bard75648862bard
bare65460522bare
barf95844402barf
bark106242152bark
barm86739602barm
barn66444642barn
bars66564092bars
bas58681752b_as
basalt83519582basalt
base64847022base
bash915240162bash
basil75122272basil
bask105131422bask
bass66146782bass
bast66362412bast
bat510988952b_at
bate66552422bate
bath95940082bath
bats66962332bats
batt65053872batt
baud74928422baud
baulk114914332baulk
bawd105520842bawd
bawls105719322bawls
bay89661642b_ay
bays97143912bays
bazar163816002bazar
bead75937922bead
beak106534382beak
beam86939232beam
bean66443862bean
bear66844642bear
beat66168302beat
beau66137272beau
bel57148462b_el
bell66237182bell
bharal1138892bharal
biali73419072biali
bialy105119322bialy
bias64738152bias
biaxal1536092biaxal
bill67239932bill
binal75323822binal
birl65830462birl
blab86629132blab
blae66134642blae
blah98625062blah
blam86131702blam
blat66550952blat
blaw97026722blaw
boa56954032boa_
boar66134292boar
boas66150832boas
boat66360312boat
boil66335182boil
bola66035562bola
boll65634752boll
boral75831702boral
bowl96827702bowl
bra56339462bra_
brad75234342brad
brae65639112brae
brag75229722brag
brail75525552brail
bran65740382bran
bras65746452bras
brat66055542brat
braw94829562braw
brawl106217962brawl
bray95232902bray
bubal94218212bubal
buhl95518222buhl
bull65634872bull
burl64937182burl
byrl95716012byrl
cabal95222152cabal
call66838672call
canal75428042canal
carl65144782carl
caul65630002caul
coal66939252coal
craal74117752craal
dahl87019222dahl
dal47554952_dal
deal56347412deal
dhal86719282dhal
dial55935062dial
dual55928172dual
earl45838142earl
egal55119432egal
fail74840242fail
fall75535312fall
farl76338552farl
fatal84819372fatal
feal713940422feal
foal76630922foal
gal46055512_gal
gala55635162gala
gall56335992gall
gaol56925412gaol
gayal9312712gayal
goal55829302goal
graal64316502graal
haaf106227732haaf
haar77323492haar
hadal95518122hadal
hail74839062hail
halal85623592halal
hall75741162hall
hamal104623102hamal
harl75740002harl
haul75530452haul
heal75645692heal
jacal14313702jacal
jail115529092jail
jarl115828132jarl
kaas86531842kaas
kail85131492kail
kraal94511822kraal
lall45531312lall
leal46043272leal
maar66025052maar
mail65543432mail
mall64639362mall
marl66341612marl
maul64830712maul
meal65643172meal
naan47621932naan
nail45838652nail
nala46930392nala
nasal56217592nasal
natal53921492natal
naval85315832naval
opal66923522opal
oral47638122oral
oval77119522oval
pail66141832pail
pal56761672_pal
pall65039342pall
papal95820672papal
pawl95123262pawl
peal68648102peal
pial65636702pial
rail46147762rail
ramal74622242ramal
ratal55025112ratal
real45750292real
rial45938092rial
sabal75422482sabal
sail45447162sail
sal36462882_sal
salal55425702salal
sall44544682sall
saul45836522saul
seal45654372seal
sial45938832sial
tael46030712tael
tail45443652tail
tala45938052tala
tall47240212tall
tamal73522612tamal
teal45546502teal
vagal94613632vagal
vail75432552vail
vasal85516292vasal
veal76936812veal
vial76731092vial
wail75238822wail
wall76236102wall
waul76927312waul
wawl105321942wawl
weal75838682weal
yawl104918972yawl
zeal135530332zeal

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.0602978183.3
2DLD Change Limit298722450.98630296.1
3Display Results2452450.0465326.1
 (SQL Overall)1786912451.092163636.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.