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

262 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
basalts935896(None) 
basalt83519581basalt_
basaltes10367681basaltes
baals76122702ba_al_s
basal75722282basal__
basally1237962basally
basaltic1245152basaltic
basils85717472basil_s
baskets135111832baskets
bassets96414822bassets
basts75936932bas__ts
desalts839572desalts
masalas9312072masalas
nasals63312462nasal_s
salts55431882__salts
aals49941143_a_al_s
ablauts936083ablauts
absents93510723absents
abvolts12104373abvolts
abwatts1233403abwatts
adapts9107813_adapts
adults7299953_adults
alants67722023_alants
alts46639903___alts
asanas6514113_asanas
ascots85312513_ascots
asphalts1344183_asphalts
assaults843863assaults
assets65617663_assets
awaits96411953_awaits
baal67033113ba_al__
baalim1038473ba_alim
baalism11310593ba_alism
baas66844673ba_a__s
baases85218013ba_ases
babas96325733baba__s
babbles104416323babbles
babels105216723babel_s
babuls105413643babul_s
bacalao1146613bacalao
bacalaos1245863bacalaos
badass949293bada_ss
baffles153710683baffles
bagass938933baga_ss
bagels95712313bagel_s
baguets1037483baguets
bahts105617803b__ahts
bails75933523ba_il_s
baits76630583b__aits
balas76937213b__alas
balases93815433balases
balata8614683bala_ta
balatas9311833balatas
balds85524643b__alds
bales76250083b__ales
balks114926293b__alks
ballads104212913ballads
ballast9313993ballast
ballasts1037933ballasts
ballets93719513ballets
ballots94116033ballots
balls76236413b__alls
balms95723923b__alms
bals66354043b__al_s
balsams11579013balsa_ms
balsas86417523balsa__s
banal75925993banal__
banality1338763banality
banally1249223banally
bananas93312223bananas
bandits103814793bandits
bangles103617413bangles
bankits133410153bankits
bannets94013843bannets
barbets114915843barbets
barbuts11439843barbuts
barrets94917103barrets
basaltine1144713basaltine
bascules1236683bascules
baseballs1344783baseballs
baseless1099563baseless
basely114412313basel_y
bases75644353bas__es
basest84720493basest_
bashaws15347713bashaws
bashers124820833bashers
bashes115631393bas_hes
bashlyk1942463bashlyk
bashlyks2041973bashlyks
basics104915123bas_ics
basil75122273basil__
basilar937313basilar
basilects1342973basilects
basilic1137493basilic
basilisk1444053basilisk
basinets1039063basinets
basins85722763bas_ins
basions94213953basions
basis75429863bas__is
basket125722913basket_
basks115621763bas__ks
basmati1148233basmati
basmatis1247343basmatis
basques18248673basques
bass66146783bas___s
basses85428303bas_ses
basset85225383basset_
bassett94213863bassett
bassetts10407373bassetts
bassist9312743bassist
bassists1037183bassists
bassly114610073bassl_y
bassos85313703bas_sos
bast66362413bas__t_
bastards113310313bastards
baste74829983bas__te
basters94930313basters
bastes85330383bas_tes
bastiles10313353bastiles
bats66962333b__a_ts
battles94517683battles
batts76727563b__atts
baubles113611863baubles
baulks12429373ba_ulks
bawls105719323ba_wl_s
bayamos1434663bayamos
bayards13379683bayards
bazaars18275883bazaars
bazars174613113baza_rs
beasts84519723b_easts
beats76042243b_ea_ts
beauts86015283b_eauts
becalms1335743becalms
befalls12349123befalls
begalls10319163begalls
belts75931163b__elts
besets85718803bes_ets
besmuts1134683besmuts
besots86415453bes_ots
bests75932613bes__ts
bezants1877343bezants
bharals1236733bharal_s
bialis83617163b_ialis
bialys11387913b_ialys
bisects1137133bisects
blasts85116773b_lasts
blats75132503b_la_ts
bleats85518613blea_ts
bloats85215763bloa_ts
boarts84716873b_oarts
boasts85017923b_oasts
boats75635153b_oa_ts
bogarts1047743bogarts
bolts76232113b__olts
borals86721913boral_s
boskets13409473boskets
bracts105617773b_racts
brants85723053b_rants
brasils9410973brasil_s
brassarts1143823brassarts
brats75336013b_ra_ts
breasts939703breasts
bubales113513343bubales
bubalis11359903bubalis
bubals103513843bubal_s
bustles93816323bustles
busts75227693bus__ts
bytalks1632713bytalks
byzants2153223byzants
cabalas113516003cabalas
cabals104020153cabal_s
canals84421673canal_s
carats85929023cara_ts
casabas1139983casabas
casas75327843casa__s
casavas1237823casavas
caskets133910173caskets
castles94917733castles
casts77237793cas__ts
casuals91410543casual_s
casualty1344473casualty
catalos9414163catalos
causals91411183causal_s
cobalts1139203cobalts
desalt7518313desalt_
easels65914553easel_s
easts57530323eas__ts
exalts13328313_exalts
fasts86429683fas__ts
faults94513553fa_ults
gaskets12348153gaskets
gasts66628633gas__ts
gaults74112783ga_ults
gayals1039513gayal_s
gestalts955493gestalts
halalas104214083halalas
halals95018313halal_s
halts85230103__halts
hamals114816833hamal_s
haslets102510863haslets
hassles103411693hassles
hawalas13348353hawalas
insults7268963insults
jacales16310323jacales
jacals1539873jacal_s
kabalas133911063kabalas
kamalas13339123kamalas
karats106420503kara_ts
lasts57731263las__ts
malts76331753__malts
manats84623463mana_ts
marsalas1038263marsalas
masala8311823masal_a
masas75630413masa__s
mascots113910343mascots
masts77035763mas__ts
misacts1139353misacts
napalms1144033napalms
nasal56217593nasal__
nasalise848863nasalise
nasalism1048203nasalism
nasality1146653nasality
nasally1057443nasally
oasts56529183oas__ts
oxysalts1841703oxysalts
pascals11610013pascal_s
pasts75936503pas__ts
peasants1038263peasants
persalts1038193persalts
psalms1045673_psalms
qabalas18289503qabalas
qanats154112813qana_ts
rabats83116223raba_ts
rascals959663rascal_s
rassles73513923rassles
ratals64219583ratal_s
resales74724903resales
results739833results
sabals84618863sabal_s
salals65120083salal_s
sales56055593__sales
salps74423243__salps
sals46851673__sal_s
salt45758523__salt_
salty85524383__salty
saults65816173sa_ults
savants1038653savants
silts55330823__silts
sisals63013573sisal_s
slats55436903__slats
smalts85214893_smalts
tamales93216153tamales
tamals84116633tamal_s
tapalos938813tapalos
tarsals72512603tarsal_s
tassets75012773tassets
vasal85516293vasal__
vassals1057953vassal_s
vasts86423773vas__ts
vaults94511673va_ults
wasabis1255363wasabis
wasts87433673was__ts

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.423422437.4
2DLD Change Limit1340272626.26321399.8
3Display Results2622620.0932817.2
 (SQL Overall)1786912626.77926359.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.