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

221 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
basinal931003(None) 
banal75925992ba__nal
basal75722282bas__al
basidial1145622basidial
basil75122272basi__l
basilar937302basilar
basin75026922basin__
basined10310002basined
basinet9318932basinet
basinful1343232basinful
basing95427662basin_g
basins85722762basin_s
binal75323822b__inal
carinal94318232carinal
laminal94113632laminal
matinal9312602matinal
nasial6413282nasi_al
paginal10269492paginal
vaginal11288402vaginal
abapical1444943abapical
abasia8712953abasi_a_
abasias9711013abasi_as
abasing10610673abasin_g
abaxial1646183abaxi_al
absinth1244973absinth
acinar8310483_acinar
actinal9312293actinal
affinal1336443affinal
agonal7410053_agonal
albinal937813albinal
anal48037523_a__nal
anginal8310163anginal
animal85016253_animal
annal56520763_a_nnal
apical10913903_apical
apsidal1046703apsidal
arsenal739383arsenal
asana5315483_asana_
asanas6514113_asanas
astral66919283_astral
atonal6514023_atonal
axial124515193_axi_al
axonal1347653_axonal
azonal1568273_azonal
baaing94916163baain_g
baal67033113ba___al
badinage1294923badinage
bail65042803ba_i__l
baiza164813223ba_iza_
baizas173810823ba_izas
baking135626623bakin_g
bakings144312023bakings
baling94829693balin_g
balneal936573balneal
banana83213413banana_
bananas93312223bananas
banian8315383bani_an
banians9312033banians
baning95127833banin_g
barbal104016663ba_rbal
barbital1247053barbital
barilla9310323barilla
baring95135853barin_g
baritonal1144673baritonal
baronial1049483baronial
basalt83519583bas__alt
baseball1245623baseball
baseman1138553baseman
basenji1641943basenji
bashaw14349303bas_haw
bashful1556553bashful
bashing135422583bashin_g
bashings144311243bashings
basic96220523basi__c
basically1648033basically
basics104915123basi_cs
basidia1047613basidia
basify1437513basi_fy
basilary1345063basilary
basilic1137493basilic
basilical1344203basilical
basils85717473basi_ls
basinets1039063basinets
basinfuls1442303basinfuls
basion84315853basi_on
basions94213953basions
basipetal1352383basipetal
basis75429863basi__s
basking144718613baskin_g
bassinet10312843bassinet
bastinade1244903bastinade
bastinado1243073bastinado
basting104227203bastin_g
bastings114214693bastings
bathyal1544823bathyal
bating95132253batin_g
baying125222583bayin_g
bestial9311643bestial
biasing103512453biasin_g
biaxial1645363biaxi_al
bivinyl1542733bivinyl
bizonal1845563bizonal
brasil8713863brasi__l
bridal9511453b_ridal
burial84117623buri_al
busing96420593busin_g
busings103711223busings
byssal1134993bys_sal
canal75428043ca__nal
capital112311523capital
capsidal1345623capsidal
cardinal1139563cardinal
carina84325323carina_
carinae94318583carinae
carinas93622403carinas
carnal83919203ca_rnal
casing94829103casin_g
casings104013513casings
casini84615863casin_i
casino84317553casin_o
casinos93512833casinos
casita82913703casita_
casitas93312043casitas
cassina94113163cassina_
cassinas103610633cassinas
casual81112863cas_ual
clinal8311553_clinal
datival1135583datival
easing74926463easin_g
encinal949243encinal
evasional1244293evasional
facial113615633faci_al
farina94618233farina_
farinas103215233farinas
fascial1258303fascial
faunal94711593fa_unal
final83922033__final
fusional1145073fusional
gastral8329553gastral
gavial10310083gavi_al
geminal10109903geminal
imaginal1144903imaginal
jarina134014063jarina_
jarinas143712183jarinas
labial84714343labi_al
lacunal9136553lacunal
laical8312323la_ical
lamina84920443lamina_
laminae93512973laminae
laminals10339303laminals
laminar93810283laminar
laminas93615873laminas
lanital7310913lanital
lasing74727983lasin_g
latina65621143latina_
latinas74416463latinas
liminal93810673liminal
luminal93711003luminal
magical1239783magical
marginal1137603marginal
marina84623413marina_
marinas93519383marinas
marital92314183marital
maximal18347093maximal
mesial84818083mesi_al
musical1139553musical
nadiral836343nadiral
narial6317953nari_al
nasal56217593nas__al
national8311533national
nominal92712373nominal
ordinal838633ordinal
pascal10812373pas_cal
paschal14157243paschal
passional1146043passional
pastina93914593pastina_
pastinas103712153pastinas
patina86022193patina_
patinae95414403patinae
patinas96318523patinas
piscinal1285843piscinal
racial83419243raci_al
radial74020393radi_al
radical103312793radical
rascal8511123ras_cal
rasing74330833rasin_g
rational8412543rational
reginal84814293reginal
retinal75318353retinal
rhinal9510193_rhinal
rosinol756323rosinol
ruminal9289993ruminal
sahiwal1344443sahiwal
salina64221123salina_
salinas73116093salinas
sasin54626573sasin__
sasins64923103sasin_s
seasonal847263seasonal
seminal91213403seminal
sial45938833__si_al
signal73711483__signal
sisal54217733__sisal
spinal84915313_spinal
staminal1046983staminal
tarnal63716503ta_rnal
trinal6516963_trinal
uncinal959963uncinal
urinal6614123_urinal
vaccinal1544903vaccinal
vagina102710933vagina_
vaginae11377683vaginae
vaginas11298813vaginas
vasal85516293vas__al
vassal979243vas_sal
vatical1239983vatical
veinal93812963_veinal
vesical12159813vesical
vicinal12268543vicinal
viminal12288823viminal
vinal85725813__vinal
visional1146663visional

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.393454684.5
2DLD Change Limit1340272215.93622578.7
3Display Results2212210.0762907.9
 (SQL Overall)1786912216.40527898.7
 
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.