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

296 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
sonatas751029(None) 
sonata6313221sonata_
bonitas939452bonitas
conatus9310462conatus
donates83217222donates
pinatas93711502pinatas
senates73322582senates
snaths95112912s_naths
softas94410402so_ftas
solates73523852solates
somata8312382somata_
sonantal886262sonantal
sonants7511232sonants
sonars64818972sona_rs
sonatinas945682sonatinas
stratas73013582stratas
agnates82813193agnates
albatas938373albatas
anabas8314083_anabas
anatase738943_anatase
annates72415423annates
antas55432033_an_tas
aortas65417783ao_rtas
balatas9311833balatas
bananas93312223bananas
boats75635153bo_at_s
bonacis11310323bonacis
bonanzas1943113bonanzas
boniatos1046673boniatos
bonita8312943bonita_
bonitos939733bonitos
borates94823013borates
botas75328783bo__tas
canastas1037693canastas
cantatas103410093cantatas
caponatas1343903caponatas
centas85020703cen_tas
coalas87418963co_alas
coatis85122603co_atis
coats75635003co_at_s
cognates11311583cognates
comates114123643comates
conchas144013313conchas
congas94417033con_gas
contes84432913con_tes
contos84923233con_tos
contras93015623contras
cottas84615573co_ttas
doats65224883do_at_s
donas65926473don__as
donate73619503donat_e
donated93513863donated
donator8310263donator
donators9310403donators
dongas84914613don_gas
donnas75511323don_nas
donuts7410583donut_s
enates64026423_enates
erratas736863erratas
folates103218453folates
fontal9313143fon_tal
fonts86124753fon_t_s
gnats65217713_gnat_s
goannas836223goannas
goats65527303go_at_s
gonadal956523gonadal
gonads84511733gona_ds
honans94814503hona_ns
hondas10313353hon_das
hostas94515823ho_stas
ignatias944913ignatias
iodates8312903iodates
iotas54821113io__tas
isobaths1343833isobaths
isolates8613513isolates
jnanas13207303_jnanas
jotas125717443jo__tas
juntas134210503jun_tas
kanakas10327213kanakas
katas95922093__katas
kinaras1159123kinaras
koalas104011663ko_alas
korats105416063korat_s
locates93218813locates
lotas55926303lo__tas
lovats939073lovat_s
mananas93414733mananas
manats84623463manat_s
mantas85725363man_tas
moats75827643mo_at_s
monadal1047893monadal
monades103713823monades
monads94515303mona_ds
monardas1145713monardas
monas74732153mon__as
montes84226933mon_tes
months113812933mon_ths
nadas66320813__nadas
nalas55528363__nalas
nanas55928633__nanas
napas75924353__napas
natal53921493__natal
nates55238333__nates
neonatal844383neonatal
neonates8310063neonates
nonages8313843nonages
nonarts7311303nonarts
nonas55126653non__as
nonets64118703nonet_s
nonfatal1146053nonfatal
nontax1348413non_tax
notates72817483notates
nunatak1142673nunatak
nunataks1242183nunataks
oaths86117313_o_aths
oats46554213_o_at_s
odonates947743odonates
orates64328613_orates
ozonates1745963ozonates
panadas103312213panadas
panamas113112763panamas
penates93321593penates
phonates13410643phonates
pinata83817223pinata_
pintas85021393pin_tas
pontes83627853pon_tes
posadas1037193posadas
pronates10418373pronates
qanats154112813qanat_s
reatas64021013_reatas
resonates9412403resonates
riatas63915093_riatas
rotas54827723ro__tas
rotates72819773rotates
sagas66025883s__agas
samaras9312913samaras
sancta839833sancta_
sangas75222653san_gas
santos64421833san_tos
sapotas939613sapotas
sataras7315063sataras
satay84718463s__atay
satays94411683s__atays
sates54949323s__ates
satis55633683s__atis
savates10312953savates
sayonaras1242473sayonaras
scants85219723scant_s
scats75930603s_cat_s
scatts85914663s_catts
seats54844343s_eat_s
sedates83418033sedates
senate63725143senat_e
senator7313063senator
senators8312953senators
senecas939013senecas
senegas837253senegas
sennas64214233sen_nas
senoras72714953senoras
sensates8511133sensates
serenatas9145193serenatas
shamas113717943s_hamas
shantis103313103shantis
sheaths1358753sheaths
sheltas10279673sheltas
shnapps1463343shnapps
shnaps1148083shna_ps
shoats94117083shoat_s
siestas738813siestas
sifakas1443333sifakas
sinuates8310963sinuates
skates104219403s_kates
skats94621543s_kat_s
slants64819083slant_s
slates64934063s_lates
slats55436903s_lat_s
snacks124514553s_nacks
snafus936743s_nafus
snags64421313s_na_gs
snails64816653s_nails
snakes103919603s_nakes
snaps74719563s_na_ps
snares65329033s_nares
snarfs95113423s_narfs
snarks104815733s_narks
snarls64016873s_narls
snatch114310603s_natch
snath86419803s_nat_h
snathe94415113s_nathe
snathes104816493s_nathes
snaws86116363s_na_ws
snits54124833s_nit_s
snoots64216683snoot_s
snorts64116503snort_s
snots55225123s_not_s
snouts64915873snout_s
soaks95220293so_a_ks
soaps75120713so_a_ps
soars54732513so_a_rs
soaves94218673so_aves
sobas74424253so__bas
socages101012053socages
socas74026183so__cas
sodas64123543so__das
sofars94712783sofa_rs
sofas85320713so__fas
softa86415183so_fta_
softs85019233so_ft_s
sojas124716393so__jas
solaces93116133solaces
solands84412343solands
solanos74412853solanos
solans64122493sola_ns
solate64526073solat_e
solated83618023solated
solatia7312253solatia
solutes73515263solutes
solvates11249673solvates
somans84619303soma_ns
somas76030373so__mas
somatic111916463somatic
somital939403somital
somites94219123somites
sonance9310313sonance
sonances10310263sonances
sonant6621953sona_nt
sonantic1048273sonantic
sonar56523423son__ar
sonarman1045563sonarman
sonatina849073sonatina
sonatine8313323sonatine
sonders83820713sonders
sondes74922873son_des
sones55444143son__es
songs67725553son__gs
sonicates11410383sonicates
sonics84315633son_ics
sonless72612613sonless
sonnets74211993sonnets
sonnies7315223sonnies
sons46049553son___s
sooths95715593so_oths
soots55536213so_ot_s
sopites93817173sopites
soras55041013so__ras
sorbates10311103sorbates
sorites73825243sorites
sorta57125413so_rta_
sorts54536663so_rt_s
soths86218633so__ths
sots45552453so__t_s
souaris7312333souaris
souths95216603so_uths
sowans94215893sowa_ns
sowars94318013sowa_rs
soyas84520913so__yas
spates85028173s_pates
spats75031383s_pat_s
splats84817303splat_s
sprats85819933sprat_s
squats153712963squat_s
stanzas1636363stanzas
statal61613223s_tatal
states64337083s_tates
stats55933363s_tat_s
status65515213s_tatus
stoats65117483stoat_s
stoccatas1342523stoccatas
stomata938533stomata_
stomatal1045833stomatal
stomates10313343stomates
strata63616283strata_
stratal72710603stratal
straths102711723straths
stratus73011733stratus
sunbaths1344383sunbaths
sunnas63914563sun_nas
suntan62613003sun_tan
suntans72111733suntans
suttas63813793s_uttas
swaths125312643s_waths
swats85726863s_wat_s
sweats94814613sweat_s
syngas10368913syn_gas
syntax1634303syn_tax
synths12377883syn_ths
toccatas1243743toccatas
tongas74315523ton_gas
tortas64918253to_rtas
wonts87621543won_t_s
yentas94614213yen_tas
zananas16319563zananas
zenanas16286233zenanas
zonate154114923zonat_e
zonated173310533zonated
zonulas1637023zonulas

Search took 8 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.1401276364.3
2DLD Change Limit1340272967.36018210.2
3Display Results2962960.1102690.9
 (SQL Overall)1786912967.61023481.1
 
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.