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 “balneal” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

142 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
balneal93657(None) 
anneal64812292_anneal
apneal83411122_apneal
banal75925992ba_n_al
paleal84716672pal_eal
adnexal1543823_adnexal
algal66518223_al_gal
allheal1044553allheal
anal48037523_a_n_al
anear55420323_a_near
annal56520763_a_nnal
anneals7449943_anneals
annual64710703_annual
apnea73413413_apnea_
apneas83211383_apneas
apnoeal956193_apnoeal
appeal103911613_appeal
areal55928733_a_real
baal67033113ba___al
babel95821693ba_be_l
badness1039573badness
bagel85116793ba_ge_l
balas76937213bal__as
balata8614673balata_
balatas9311833balatas
balboa10389963balboa_
balboas113710073balboas
balded105417513balde_d
balder95318863balde_r
baldest102313533baldest
baldhead1544273baldhead
baldness1137043baldness
bale66353843bal_e__
baled85436443bal_e_d
baleen8613053bal_een
baleens938473baleens
baleful1238003baleful
baler75635273bal_e_r
balers85626933bal_ers
bales76250083bal_e_s
balked135219413balke_d
balker124519163balke_r
balkers134915723balkers
ball66043323bal___l
ballad94315323bal_lad
balled94926893balle_d
baller83825203balle_r
ballers94421013ballers
ballet84733973balle_t
ballets93719513ballets
balmoral1244633balmoral
baloney1237483balone_y
baloneys1334663baloneys
balsa77920413bal_sa_
balsam105612233bal_sam
balsas86417523bal_sas
banda85223103ba_nda_
bandas95120543ba_ndas
bandeau1038523bandeau
bane65250433ba_ne__
baned85436353ba_ne_d
baneful1237893ba_neful
banes74945583ba_ne_s
banian8315383ba_nian
banjax2234763ba_njax
banned94721343banne_d
banner84421503banne_r
bannerol1044313bannerol
banners94018713banners
bannet84925333banne_t
bannets94013843bannets
bantam10314063ba_ntam
banyan1139483ba_nyan
banzai1737653ba_nzai
barbal104016663ba_rbal
barbel104317073barbe_l
barbell11429963barbell
barned95623583barne_d
barney115314453barne_y
barneys12569563barneys
baronial1049483baronial
barrel84517873barre_l
basal75722283ba__sal
basinal9310033basinal
bateau8810563ba_teau
bathyal1544823bathyal
batteau936343batteau
beleap10410283bel_eap
benzal1739643b_enzal
biannual1043323biannual
bilinear1044043bilinear
binal75323823b_in_al
bleak115915383b_l_eak
blear75918683b_l_ear
bleat75737003b_l_eat
boreal84817213b_oreal
borneol936823borneol
bracteal1245563bracteal
bulbel104510683bulbe_l
calcaneal1363063calcaneal
calendal1145383calendal
calyceal1543043calyceal
canal75428043ca_n_al
cannel84216403canne_l
cantal84122033ca_ntal
carnal83919203carn_al
corneal94414503corneal
cuneal8611513_cuneal
darnel74312183darne_l
falderal12104803falderal
fallal93612693fal_lal
faunal94711593faun_al
galangal1043893galangal
galea64722933gal_ea_
galeae74717453gal_eae
galeas74618513gal_eas
galena74911093galena_
galenas83310343galenas
halal85623593hal__al
hallal94415563hal_lal
hallel93514093halle_l
ileal56118083_il_eal
lacteal966813lacteal
leal46043273__l_eal
lineal65616023_lineal
manual8313463ma_nual
oatmeal944973oatmeal
palatal9310153palatal
palea75028663pal_ea_
paleae84820293pal_eae
pallial92911253pallial
palpal104112053pal_pal
paludal1035683paludal
panel76023623pa_ne_l
pineal84817683_pineal
salal55425703sal__al
sandal73317283sa_ndal
tarnal63716503tarn_al
tineal66216163_tineal
valval12398863val_val
vandal103713833va_ndal
vineal94814743_vineal

Search took 7 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271425.97022450.1
3Display Results1421420.0463087.0
 (SQL Overall)1786911426.17228951.9
 
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.