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

336 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
smalto8441028(None) 
smalt74729331smalt_
smalti84111171smalti
smaltos9408191smaltos
smalts85214891smalts
alto47831262__alto
malt66254802_malt_
maltol8310842_maltol
malts76331752_malts
malty106721702_malty
molto75619602_molto
rialto638602rialto
salt45758522s_alt_
salts55431882s_alts
salty85524382s_alty
salvo84415642s_alvo
santo56227282s_anto
shalt85534482shalt_
shmaltz2144642shmaltz
small74016262smal_l
smalls84514122smalls
smart75834092smart_
smarts86218002smarts
smarty115013792smarty
smelt74726782smelt_
smelts85412772smelts
smolt74824162smolt_
smolts84411882smolts
also46423443__also
alt36467963__alt_
altho86312603__altho
altos55822953__altos
alts46639903__alts
amatol838683ama_tol
anatto6139913anatto
auto47432083__auto
calo64936443_cal_o
canto74931013_canto
chalot113020133chalot
dalton7311273_dalton
dato56129943_da_to
datto65416423_datto
dealt65234283dealt_
esparto944233esparto
exalt123018533exalt_
exalts13328313exalts
fealty122910223fealty
gelato73812953gelato
hallo85127553_hallo
halo76437323_hal_o
halt76056303_halt_
halts85230103_halts
health124712143health
imago8118683ima_go
impasto11275193impasto
jato115822683_ja_to
lealty92910603lealty
macho126120153_macho
macro94718173_macro
madtom1138023_madtom
magot8326393_magot
mako105622353_ma_ko
malar76424443_malar
malate84624553_malate
male66052293_mal_e
males75049793_males
malic94525653_malic
mall64639363_mal_l
mallow114014743_mallow
malls76233433_malls
malm85129973_mal_m
malms95021553_malms
malmy124816343_malmy
maloti8313193_maloti
malted94819853_malted
maltha1137503_maltha
maltols939403_maltols
maltose939783_maltose
mambo115215733_mambo
mango85724313_mango
manito8518693_manito
mano66536793_ma_no
manta75629903_manta
mart66865973_mart_
marts77442233_marts
mast65959953_mast_
masts77035763_masts
mat58083933_ma_t_
mate65154213_ma_te
math95437443_ma_th
mats65460283_ma_ts
matt65752653_ma_tt
matte75626843_matte
matts76829183_matts
matzo16312893_matzo
maut65448443_maut_
mauts75927193_mauts
mayo96524293_ma_yo
melt65752893_melt_
melton8311553_melton
melts74930103_melts
melty104918363_melty
milo65536093_mil_o
milt65455803_milt_
milts75430713_milts
milty104720073_milty
molt66356163_molt_
molts76032093_molts
motto76119513_motto
panto76129413_panto
quarto153511123quarto
rato45436973_ra_to
realtor73611353realtor
realty92713693realty
rialtos736613rialtos
sabot7931773s_abot
sago56332673s_a_go
saith85826553s_aith
sal36462883s_al__
salad65321833s_alad
salal55425703s_alal
sale44959703s_al_e
salep77022953s_alep
sales56055593s_ales
salic73424713s_alic
sall44544683s_al_l
sallow94315753s_allow
sally85129713s_ally
salmi7815863s_almi
salmon84614183s_almon
salol55222143s_alol
salon55228553s_alon
saloon64418023s_aloon
saloop84212583s_aloop
salp64534093s_al_p
salpa75018353s_alpa
salps74423243s_alps
sals46851673s_al_s
salsa56718923s_alsa
saltbox1643743s_altbox
salted74121203s_alted
salter64325083s_alter
saltie63422423s_altie
salute64418023s_alute
salve85022133s_alve
salvor94711093s_alvor
salvos94613383s_alvos
sambo95118013s_ambo
samite83020603samite
samlet84126563samlet
samlets93813553samlets
santol64515243s_antol
santos64421833s_antos
sargo65424413s_argo
sartor6313873s_artor
sat36288483s_a_t_
sate45556103s_a_te
sati45539323s_a_ti
sault55834963sault_
saults65816173saults
saute55028083s_aute
scalado10276473scalado
scalar83612433scalar
scald84818123scal_d
scalds94813693scalds
scale74629143scal_e
scaled94822443scaled
scaler84321603scaler
scales84529313scales
scall74420373scal_l
scallop11237643scallop
scalls84218203scalls
scalp95217983scal_p
scalps104315233scalps
scaly104718723scal_y
scant79735073scant_
scants85219723scants
scanty114014663scanty
scart76139773scart_
scarts85321493scarts
scat65848373sca_t_
scats75930603sca_ts
scatt76030093sca_tt
scatts85914663scatts
scatty115310653scatty
schmaltz2443443schmaltz
seal45654373seal__
sealed74328363sealed
sealer63928963sealer
seals54839693seal_s
seat47575563sea_t_
seats54844343sea_ts
sexto124415453s_exto
sfumato1253683sfuma_to
shacko153810113shacko
shaft115725253shaft_
shafts125411433shafts
shako125516083sha_ko
shale85332833shal_e
shaled105023953shaled
shales94731253shales
shaley123714993shaley
shall85024053shal_l
shallop12348453shallop
shallot103614133shallot
shallow13388873shallow
shalom11810913shalom
shaly114322863shal_y
shanti94014073shanti
shanty124715113shanty
shat76456593sha_t_
shelta93111783shelta
shelty124011543shelty
shmaltzy2552103shmaltzy
sial45938833sial__
sialic8313633sialic
sialid7314933sialid
sials54227243sial_s
silo46037913s_il_o
silt46558193s_ilt_
silts55330823s_ilts
silty84721633s_ilty
skald104210173skal_d
skalds11437833skalds
skat87037893ska_t_
skate94721543ska_te
skatol1035713ska_tol
skats94621533ska_ts
slalom888173slalom
slant55238703slant_
slants64819083slants
slanty95114843slanty
slat46959023sla_t_
slate55438283sla_te
slats55436903sla_ts
slaty86523153sla_ty
slot46049823s__lot
smack134615453sma_ck
smacks144112323smacks
smaller93410333smaller
smallpox1941843smallpox
smaltine1037833smaltine
smaltite1046903smaltite
smarm95517603sma_rm
smarms105712533smarms
smarmy13629353smarmy
smarted105012613smarted
smarten9348863smarten
smarter94113133smarter
smartie9310163smartie
smartly12497433smartly
smash104814433sma_sh
smatter93613333smatter
smaze165012933sma_ze
smazes174311663smazes
smell74916233smel_l
smells83914743smells
smelly114110353smelly
smelted10399093smelted
smelter93311913smelter
smilax1535393smilax
smile74823913smil_e
smiled93716433smiled
smiler83916683smiler
smiles84522293smiles
smiley114012303smiley
smit65138403sm_it_
smite75224863sm_ite
smith107818043sm_ith
smooth11259193smooth
smote75820273sm_ote
smut66629783sm_ut_
smuts75415713sm_uts
smutty11266323smutty
snath86419803sna_th
solano65314183solano
solate64526073solate
soldo67116563s_oldo
solo45538943s_ol_o
somata8312383soma_ta
spado83713703spa_do
spait75631603spait_
spaits85017473spaits
spale74929213spal_e
spales84728103spales
spall74919303spal_l
spalls84217343spalls
spat66548523spa_t_
spate74731583spa_te
spats75031383spa_ts
spelt75430193spelt_
spelts84614643spelts
speltz174010113speltz
spilt75532223spilt_
spilth11469733spilth
spinto8410663spinto
splat76129343splat_
splats84817303splats
stacte82113913stacte
stalag7310023stalag
stale55637103stal_e
staled74728103staled
staler64025823staler
stales65538293stales
stalk94518003stal_k
stalks104614553stalks
stalky13499303stalky
stall54722353stal_l
stalls64019923stalls
start55642313start_
starts65423123starts
stat47352693sta_t_
state56237333sta_te
stator64015473sta_tor
stats55933363sta_ts
stealth1096453stealth
stilt54831983stilt_
stilts67915303stilts
subito8410443subito
sublot82315523sublot
sulfo8313363s_ulfo
svelte9319753svelte
swale85221593swal_e
swales93920763swales
swallow13355753swallow
swart86234643swart_
swarth126012083swarth
swarty125812383swarty
swat77244443swa_t_
swath115920383swa_th
swats85726863swa_ts
tanto55724943_tanto
tomato8313453toma_to
waltz17615473_waltz
wealth12379223wealth
zealot15313473zealot

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 Filter1786911127160.1431249587.4
2DLD Change Limit1127163366.45317467.2
3Display Results3363360.1103054.5
 (SQL Overall)1786913366.70626646.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.