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

351 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
smalti8411119(None) 
smalt74729331smalt_
smalto84410281smalto
smalts85214891smalts
maloti8313212_maloti
malt66254812_malt_
malts76331752_malts
malty106721702_malty
salmi7815862s_almi
salt45758522s_alt_
saltie63422432s_altie
salts55431882s_alts
salty85524382s_alty
sati45539332s_a_ti
shalt85534492shalt_
shanti94014092shanti
shmaltz2144652shmaltz
small74016262smal_l
smalls84514122smalls
smaltine1037832smaltine
smaltite1046902smaltite
smaltos9408192smaltos
smart75834092smart_
smartie9310172smartie
smarts86218002smarts
smarty115013792smarty
smelt74726782smelt_
smelts85412772smelts
smolt74824162smolt_
smolts84411882smolts
aalii5316133_aalii
alit46155693__alit
alt36467963__alt_
alto47831263__alto
alts46639903__alts
anti45536363__anti
basmati1148233basma_ti
bhakti1544333bhakti
biali73419073bial_i
cacti9318643_cacti
coati75624643coa_ti
culti76317253_culti
dealt65234283dealt_
exalt123018533exalt_
exalts13328313exalts
fealty122910223fealty
fracti1139963fracti
gelati73814533gelati
halt76056303_halt_
halts85230103_halts
health124712143health
lati46438273_la_ti
lealty92910603lealty
maftir1136493_maftir
magi76329533_ma_gi
malar76424443_malar
malate84624563_malate
male66052303_mal_e
males75049793_males
malic94525663_malic
malkin122913153_malkin
mall64639373_mal_l
mallei84414633_mallei
malls76233433_malls
malm85129983_mal_m
malms95021553_malms
malmy124816343_malmy
malted94819863_malted
maltha1137513_maltha
maltier93015483_maltier
malting103219083_malting
maltol8310843_maltol
manta75629913_manta
mantic104120903_mantic
mantid93820383_mantid
mantis83926033_mantis
maqui16249953_maqui
mart66865983_mart_
martin84122523_martin
marts77442233_marts
mast65959963_mast_
mastic103119173_mastic
mastix152310513_mastix
masts77035763_masts
mat58083943_ma_t_
mate65154223_ma_te
math95437453_ma_th
matin75132853_ma_tin
mats65460293_ma_ts
matt65752663_ma_tt
matte75626843_matte
mattin84416633_mattin
matts76829183_matts
maut65448453_maut_
mauts75927193_mauts
maxi137023563_ma_xi
melt65752893_melt_
melts74930103_melts
melty104918363_melty
milt65455813_milt_
milts75430713_milts
milty104720073_milty
molt66356163_molt_
molto75619603_molto
molts76032093_molts
mufti10610543_mufti
osmatic11179993osma_tic
palpi95414553_palpi
phalli1148263phalli
realty92713693realty
rialto638603rialto
sadi55834643s_a_di
saith85826553s_aith
saki85628483s_a_ki
sal36462883s_al__
salad65321833s_alad
salal55425703s_alal
salami8313103s_alami
sale44959703s_al_e
salep77022953s_alep
sales56055593s_ales
salic73424713s_alic
sall44544683s_al_l
sally85129713s_ally
salmis8514273s_almis
salol55222143s_alol
salon55228553s_alon
salp64534093s_al_p
salpa75018353s_alpa
salpid9510883s_alpid
salps74423243s_alps
sals46851673s_al_s
salsa56718923s_alsa
salted74121203s_alted
salter64325083s_alter
saltier74318633s_altier
salties73725773s_alties
saltily10310543s_altily
saltine75018563s_altine
salting84120793s_alting
saltire73113043s_altire
saltish10312163s_altish
saluki1036203s_aluki
salute64418023s_alute
salve85022133s_alve
salvia93310753s_alvia
salvo84415643s_alvo
samadhi1344063samadhi
samite83020603samite
samlet84126563samlet
samlets93813553samlets
santir6315253s_antir
santo56227283s_anto
sari45444043s_a_ri
sat36288483s_a_t_
sate45556103s_a_te
satin55935223s_a_tin
satis55633683s_a_tis
sault55834963sault_
saults65816173saults
saute55028083s_aute
scalar83612433scalar
scald84818123scal_d
scaldic1235943scaldic
scalds94813693scalds
scale74629143scal_e
scaled94822443scaled
scaleni936883scaleni
scaler84321603scaler
scales84529313scales
scall74420373scal_l
scalls84218203scalls
scalp95217983scal_p
scalps104315233scalps
scaly104718723scal_y
scampi12469103scampi
scant79735073scant_
scants85219723scants
scanty114014663scanty
scart76139773scart_
scarts85321493scarts
scat65848373sca_t_
scats75930603sca_ts
scatt76030093sca_tt
scatts85914663scatts
scatty115310653scatty
schmaltz2443443schmaltz
seal45654373seal__
sealed74328363sealed
sealer63928963sealer
seals54839703seal_s
seat47575563sea_t_
seats54844343sea_ts
semantic1249553semantic
sematic111716883sema_tic
seniti64317223seniti
senti56226703s_enti
shaft115725273shaft_
shafts125411443shafts
shale85332833shal_e
shaled105023953shaled
shales94731253shales
shaley123714993shaley
shall85024053shal_l
shalom11810923shalom
shaly114322863shal_y
shantih13309643shantih
shantis103313103shantis
shanty124715123shanty
shat76456603sha_t_
shelta93111793shelta
sheltie10109913sheltie
shelty124011553shelty
shmaltzy2552113shmaltzy
sial45938833sial__
sialic8313633sialic
sialid7314943sialid
sialoid8310963sialoid
sials54227243sial_s
sigloi737743sigloi
silt46558193s_ilt_
silts55330823s_ilts
silty84721633s_ilty
skald104210173skal_d
skaldic1443553skaldic
skalds11437833skalds
skat87037903ska_t_
skate94721553ska_te
skats94621543ska_ts
skylit1338283skylit
slalom888173slalom
slant55238703slant_
slants64819083slants
slanty95114843slanty
slat46959023sla_t_
slate55438283sla_te
slats55436903sla_ts
slaty86523153sla_ty
slit46250103s__lit
smack134615453sma_ck
smacks144112323smacks
smaller93410333smaller
smallish1346573smallish
smalltime1342193smalltime
smaltines1136993smaltines
smaltites1145743smaltites
smarm95517603sma_rm
smarms105712533smarms
smarmy13629353smarmy
smarted105012613smarted
smarten9348863smarten
smarter94113133smarter
smarties10312873smarties
smarting113212453smarting
smartly12497433smartly
smash104814433sma_sh
smatter93613333smatter
smaze165012933sma_ze
smazes174311663smazes
smectic1336613smectic
smell74916233smel_l
smells83914743smells
smelly114110363smelly
smelted10399093smelted
smelter93311913smelter
smelting11339713smelting
smilax1535393smilax
smile74823923smil_e
smiled93716433smiled
smiler83916683smiler
smiles84522293smiles
smiley114012303smiley
smit65138413sm_it_
smite75224873sm_ite
smith107818053sm_ith
smooth11259203smooth
smote75820283sm_ote
smut66629783sm_ut_
smuts75415713sm_uts
smutty11266323smutty
snath86419803sna_th
solate64526073solate
solatia7312253solatia
soldi65717203s_oldi
solei55624343s_olei
soli46637013s_ol_i
somata8312383soma_ta
somatic111916473soma_tic
spahi10311143spa_hi
spait75631603spait_
spaits85017473spaits
spale74929213spal_e
spales84728103spales
spall74919303spal_l
spalls84217343spalls
spastic11310383spastic
spat66548523spa_t_
spate74731583spa_te
spats75031383spa_ts
spelt75430193spelt_
spelts84614643spelts
speltz174010123speltz
spilt75532223spilt_
spilth11469733spilth
splat76129343splat_
splats84817303splats
split75729013s_plit
stacte82113913stacte
stalag7310023stalag
stale55637103stal_e
staled74728103staled
staler64025823staler
stales65538293stales
stalk94518003stal_k
stalks104614553stalks
stalky13499303stalky
stall54722353stal_l
stalls64019933stalls
starlit71512913starlit
start55642313start_
starts65423123starts
stat47352693sta_t_
state56237333sta_te
static83118683sta_tic
statin63921473sta_tin
stats55933363sta_ts
stealth1096453stealth
stelai63912563stelai
stilt54831983stilt_
stilts67915313stilts
strati63518903strati
styli83911173styl_i
sulci7615053s_ulci
sunlit61516103sunlit
svelte9319753svelte
swale85221593swal_e
swales93920763swales
swami105614523swa_mi
swart86234643swart_
swarth126012083swarth
swarty125812383swarty
swat77244443swa_t_
swath115920383swa_th
swats85726863swa_ts
syli74318983s_yl_i
tali46837163_tal_i
thalli958923thalli
umami939883uma_mi
volti84915963_volti
waltz17615473_waltz
wealth12379223wealth

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.516346300.4
2DLD Change Limit1127163515.65619928.6
3Display Results3513510.1063311.3
 (SQL Overall)1786913516.27828463.0
 
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.