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

274 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
smaltos940819(None) 
smalto84410281smalto_
smalts85214891smalt_s
altos55822952__altos
maltol8310842_maltol
maltols939402_maltols
maltose939782_maltose
malts76331752_malt_s
rialtos736612rialtos
salts55431882s_alt_s
salvos94613382s_alvos
santos64421832s_antos
smalls84514122smal_ls
smalt74729332smalt__
smalti84111192smalt_i
smarts86218002smart_s
smelts85412772smelt_s
smolts84411882smolt_s
alto47831263__alto_
alts46639903__alt_s
amatol838693ama_tol
amatols938183ama_tols
anattos7138453anattos
autos56523323__autos
calos74431903_cal_os
cantos84826973_cantos
dalton7311273_dalton
daltons8310403_daltons
datos65222783_da_tos
dattos74311903_dattos
espartos1044333espartos
exalts13328313exalt_s
gelatos83111513gelatos
hallos95425103_hallos
halos85230253_hal_os
halts85230103_halt_s
healths13478753healths
imagos9117553ima_gos
impastos12244833impastos
jatos125116823_ja_tos
machos135217493_machos
macros104017013_macros
madtom1138023_madtom
madtoms1236923_madtoms
magots9312363_magots
makos116518363_ma_kos
malars85020683_malars
malates93522603_malates
males75049793_mal_es
mallow114014743_mallow
mallows123714323_mallows
malls76233433_mal_ls
malms95021553_mal_ms
maloti8313213_maloti
malt66254813_malt__
maltase938903_maltase
malted94819863_malted
malteds10377603_malteds
maltha1137503_maltha
malthas1237913_malthas
maltoses1039853_maltoses
malty106721703_malt_y
mambos125414493_mambos
mangos94319333_mangos
manitos9314053_manitos
manos74933623_ma_nos
mantas85725363_mantas
mantes84430783_mantes
mantis83926033_mantis
marts77442233_mart_s
masts77035763_mast_s
mates75251363_ma_tes
maths105624023_ma_ths
mats65460293_ma_t_s
mattes85624533_mattes
matts76829183_ma_tts
matzos1749263_matzos
mauts75927193_maut_s
mayos105521933_ma_yos
melton8311553_melton
meltons9410923_meltons
melts74930103_melt_s
milos75428013_mil_os
milts75430713_milt_s
molto75619603_molto_
molts76032093_molt_s
mottos84615243_mottos
pantos85222743_pantos
quartos16328733quartos
ratos55528763_ra_tos
realtor73611353realtor
realtors82811683realtors
rialto638603rialto_
sabots8314703s_abots
sagos66123873s_a_gos
salads75316963s_alads
salals65120083s_alals
saleps85014903s_aleps
sales56055593s_al_es
sallow94315753s_allow
sallows103915553s_allows
salmis8514273s_almis
salmon84614183s_almon
salmons93713263s_almons
salol55222143s_al_ol
salols64017873s_alols
salon55228553s_al_on
salons63823693s_alons
saloon64418023s_aloon
saloons74415323s_aloons
saloop84212583s_aloop
saloops93510133s_aloops
salpas85116923s_alpas
salps74423243s_al_ps
sals46851673s_al__s
salsas65316133s_alsas
salt45758523s_alt__
saltbox1643743s_altbox
salted74121203s_alted
salter64325083s_alter
salters73622253s_alters
saltest71916513s_altest
saltie63422433s_altie
salties73725773s_alties
saltish10312163s_altish
salty85524383s_alt_y
salutes73716253s_alutes
salves94221763s_alves
salvo84415643s_alvo_
salvoes102811313s_alvoes
salvor94711093s_alvor
salvors103910913s_alvors
sambos104315193s_ambos
samites93118713samites
samlets93813553samlets
santo56227283s_anto_
santol64515243s_antol
santols73513323s_antols
sargos74318273s_argos
saros55238063s_a_ros
sartor6313883s_artor
sartors7314973s_artors
sates54949323s_a_tes
satis55633683s_a_tis
saults65816173sault_s
sautes63924913s_autes
scalados11276083scalados
scalars93711903scalars
scalds94813693scal_ds
scalers93817263scalers
scales84529313scal_es
scallop11237643scallop
scallops12297393scallops
scalls84218203scal_ls
scalps104315233scal_ps
scants85219723scant_s
scarts85321493scart_s
scats75930603sca_t_s
scatts85914663sca_tts
sealers74323553sealers
seals54839693seal__s
seats54844343sea_t_s
sextos134012163s_extos
sfumatos1353343sfuma_tos
shackos16429023shackos
shafts125411443shaft_s
shakos134912193sha_kos
shales94731253shal_es
shallop12348453shallop
shallops13288323shallops
shallot103614133shallot
shallots11319503shallots
shallow13388873shallow
shallows14388863shallows
shalom11810923shal_om
shaloms1288983shaloms
shalt85534493shalt__
shammos14307203shammos
shamos114216983sha_mos
shantis103313103shantis
sheltas10279673sheltas
shmaltz2144653shmalt_z
shmaltzes2352783shmaltzes
shmaltzy2552113shmaltzy
sialids839723sialids
sials54227243sial__s
siglos7311473sigl_os
silos56029433s_il_os
silts55330823s_ilt_s
skalds11437833skal_ds
skates104219403ska_tes
skatol1035723ska_tol
skatols1135533ska_tols
skats94621543ska_t_s
slalom888173slal_om
slaloms9106543slaloms
slants64819083slant_s
slates64934063sla_tes
slats55436903sla_t_s
slots54830533s__lots
smacks144112323sma_cks
small74016263smal__l
smaller93410333smaller
smallest1039403smallest
smallish1346573smallish
smallpox1941843smallpox
smaltine1037833smaltine
smaltines1136993smaltines
smaltite1046903smaltite
smaltites1145743smaltites
smarms105712533sma_rms
smart75834093smart__
smartass1044273smartass
smarted105012613smarted
smarten9348863smarten
smartens10286663smartens
smarter94113133smarter
smartest10310183smartest
smartie9310173smartie
smarties10312873smarties
smartly12497433smartly
smarty115013793smart_y
smashes123914613smashes
smatter93613333smatter
smatters104011713smatters
smazes174311663sma_zes
smells83914743smel_ls
smelt74726783smelt__
smelted10399093smelted
smelter93311913smelter
smelters103310513smelters
smilers94113853smilers
smiles84522293smil_es
smileys12336323smileys
smites83921923sm_ites
smiths114711023sm_iths
smolt74824163smolt__
smooths12216323smooths
smuts75415713sm_ut_s
snaths95112913sna_ths
solanos74412853solanos
solates73523853solates
solos54830793s_ol_os
spaits85017473spait_s
spales84728103spal_es
spalls84217343spal_ls
spates85028173spa_tes
spats75031383spa_t_s
spelts84614643spelt_s
spilths12356023spilths
spintos939133spintos
splats84817303splat_s
stactes91914633stactes
stalags838643stalags
stales65538293stal_es
stalks104614553stal_ks
stalls64019933stal_ls
starts65423123start_s
states64337083sta_tes
stator64015483sta_tor
stators73915583sta_tors
stats55933363sta_t_s
status65515213sta_tus
stealths11104123stealths
stilts67915313stilt_s
sublots92410913sublots
swales93920763swal_es
swallow13355753swallow
swallows14295893swallows
swarths13537323swarths
swaths125312643swa_ths
swats85726863swa_t_s
wealths13365813wealths
zealots1636763zealots

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.423422437.4
2DLD Change Limit1340272746.62320236.6
3Display Results2742740.0932946.2
 (SQL Overall)1786912747.13925030.3
 
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.