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

110 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
banal7592599(None) 
anal48037521_anal
baal67033111ba_al
basal75722281basal
binal75323821binal
canal75428041canal
aal39058672_a_al
ana39559832_ana_
anas46649862_anas
anil46437432_anil
annal56520762annal
axal116520492_axal
baa510650422ba_a_
baals76122702ba_als
baas66844672ba_as
baba88828352baba_
babas96325732babas
babel95821692babel
babul96317712babul
bagel85116792bagel
bail65042802ba_il
bal56662722b__al
balas76937212balas
ball66043322ba_ll
balneal936572balneal
ban58366842ban__
banally1249222banally
banana83213412banana
banco94019392banco
band76740912ban_d
banda85223102banda
bandas95120542bandas
bands85233422bands
bandy114824182bandy
bane65250432ban_e
baned85436352baned
banes74945582banes
bang74837002ban_g
bangle94018952bangle
bangs85627772bangs
bani65334962ban_i
banian8315382banian
banjax2234762banjax
banjo143812442banjo
bank105835752ban_k
banks115527902banks
banns75321232banns
bans66555142ban_s
bantam10314062bantam
banty106624002banty
banyan1139482banyan
banzai1737652banzai
barbal104016662barbal
basalt83519582basalt
basil75122272basil
basinal9310032basinal
bawl95326062ba_wl
bazar163816002bazar
benzal1739642benzal
bharal1138892bharal
biaxal1536092biaxal
boral75831702boral
bubal94218212bubal
buna64730722buna_
bunas75126572bunas
bwana10310242bwana_
bwanas1157442bwanas
cabal95222152cabal
canals84421662canals
cantal84122032cantal
carnal83919202carnal
fatal84819372fatal
faunal94711592faunal
final83922032final
gayal9312712gayal
hadal95518122hadal
halal85623592halal
hamal104623112hamal
jacal14313702jacal
kana85928532kana_
kanas95326912kanas
lanai5319572lanai
mana65341962mana_
manas76240432manas
manat76039992manat
manual8313462manual
nana46632902nana_
nanas55928632nanas
nasal56217592nasal
natal53921492natal
naval85315832naval
panel76023622panel
papal95820672papal
penal75228372penal
qanat144426842qanat
ramal74622242ramal
ratal55025112ratal
renal55929502renal
sabal75422482sabal
salal55425702salal
sandal73317282sandal
tamal73522622tamal
tarnal63716502tarnal
tonal53724302tonal
vagal94613632vagal
vandal103713832vandal
vasal85516292vasal
venal85523212venal
vinal85725812vinal
zonal145116852zonal

Search took 3 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 Filter178691538000.330541487.9
2DLD Change Limit538001101.68631909.8
3Display Results1101100.0303666.7
 (SQL Overall)1786911102.04687336.8
 
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.