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

332 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
paesans9331269(None) 
paeans85118261pae_ans
paesan85114091paesan_
paesani9348681paesani
paesano9338791paesano
paesanos10296701paesanos
paisans93614751paisans
caesars9410732caesars
paean77222722pae_an_
paeons83915522pae_ons
pagans95717922pa_gans
paisan84417072paisan_
paisana94010222paisana
paisanas10288872paisanas
paisano9429512paisano
paisanos10337552paisanos
paisas84317492paisa_s
parians93519732parians
parmesans1344102parmesans
parsons93516872parsons
partans94418282partans
passant9813942passant
pavans115715592pa_vans
peans75437642p_e_ans
peasant9314922peasant
peasants1038262peasants
pecans101515832p_ecans
pekans121710552p_ekans
ptisans9317362ptisans
aeons57624653_ae_ons
alans55636173_a_lans
arsons63917213_arsons
asana5315483_a_sana
asanas6514113_a_sanas
assais6711963_assais
assays977903_assays
atmans84413963_atmans
avians93711563_avians
azans146516883_a_zans
balsams11579013balsams
balsas86417523balsa_s
banians9312033banians
banyans1237913banyans
basins85722763ba_sins
beans75734693_be_ans
caesar8410933caesa_r
caestus947773caestus
caftans12179443caftans
caimans113811783caimans
calesas9411833calesa_s
callans94518473callans
cancans11311873cancans
capelans1238013capelans
capstans1257243capstans
captans111612053captans
casas75327843ca_sa_s
caseins93115053caseins
caserns94711223caserns
caterans10313223caterans
causals91411183causals
caymans14349513caymans
cleans85817053cle_ans
daemons10269233daemons
damans94715983da_mans
damsons1038013damsons
darshans1286543darshans
deans66131393_de_ans
dedans85915073_dedans
deewans11306903deewans
desand84812633_desand
desands94810163_desands
desmans1039003_desmans
dewans105215143_dewans
elans55527753__elans
etesians845473etesians
faenas94412763faena_s
gamelans11115853gamelans
gleans75014743gle_ans
gossans836783gossans
haemins122811403haemins
hansas94616043hansa_s
hausens1077633hausens
hazans183411653ha_zans
hazzans18215783hazzans
japans1539823ja_pans
jawans1657843ja_wans
jeans126022113_je_ans
kaftans14185353kaftans
kalians11310183kalians
kamsins1346963kamsins
kanbans1337723kanbans
lagans75717783la_gans
lallans74113543lallans
lauans65113533la_uans
leans55536253_le_ans
lemans85316393_lemans
maenads1037373maenads
magians10310753magians
mannans93611523mannans
masas75630413ma_sa_s
masons83916513ma_sons
massas85116463massa_s
matsahs1236563matsahs
means75831233_me_ans
mesas76823203_mesa_s
mesons83215843_mesons
messans92710463messans
naans55815253na__ans
nasals63312463na_sals
naysays1344123naysays
oceans81211003oce_ans
pacas96029403pa_ca_s
pachas135017143pacha_s
padnags1135083padnags
padshahs17113153padshahs
paeanism1248703pae_anism
paellas9411413paellas
paeon74819493pae_on_
pagan86121163pa_gan_
pageant10312783pageant
pageants1136693pageants
pains75138283pa__ins
paisa76021073paisa__
pakehas1635313pakeha_s
palais8420423pa_lais
paleways1645833paleways
palsies94420273palsies
pampas124913993pampa_s
pampeans1444703pampeans
pandani1039903pandani
pandanus1136433pandanus
pandas95521963panda_s
pangas99921113panga_s
pangens103112063pangens
pans65855733p___ans
pansies94521983pansies
papains11312363papains
papas94927493pa_pa_s
papaws13419113pa_paws
paphians1545593paphians
parang93715513pa_rang
parangs104314373pa_rangs
paras76143043pa_ra_s
parasang1147333parasang
parasangs1246033parasangs
pardahs13289673pardahs
pardons103817623pardons
pareses94718883pares_es
paresis93315093pares_is
pariahs123812343pariahs
parian83223963parian_
parkas125018023parka_s
parlays123910453parlays
parmesan1244753parmesan_
parrals94414573parrals
parsecs11429923parsecs
parsers94118153parsers
parses85534703pars_es
parsing103819553parsing
parson83817903parson_
partan83820563partan_
partisans1167483partisans
partons94620513partons
pascals11610013pascals
paseos88015813pa_seos
pases75346503pa_s_es
pashas115117063pa_shas
pashes115828393pa_shes
pass65239953pa_s__s
passade1039233passade
passades1139203passades
passado1037053passado
passados1146303passados
passage1039803passage
passages1139513passages
passband1344773passband
passbands1453983passbands
passels93913023passels
passers94717753passers
passes86030473pa_sses
passing104318423passing
passings11409873passings
passions10310583passions
passus83610293pa_ssus
pastas85422873pa_stas
pastes85233913pa_stes
pastis84924323pa_stis
pasts75936503pa_s_ts
patens84820863pa_tens
patinas96318523patinas
patins87528783pa_tins
patrons93818103patrons
patsies93919483patsies
pattens95414923pattens
paulins9312613paulins
pausal81511963pausa_l
pausers94113223pausers
pauses84621473paus_es
pausing103912813pausing
pavan106518473pa_van_
pavane114113443pa_vane
pavanes123612653pa_vanes
pavins114919663pa_vins
pawns108818133pa__wns
pawpaws1732823pawpaws
paydays1634433paydays
peags86122843p_e_ags
peahens12307573peahens
peaks114825623p_e_aks
peals75235493p_e_als
pean66147173p_e_an_
pears75138613p_e_ars
peas65755063p_e_a_s
peasen84815963peasen_
peases85229473peas_es
peats76140193p_e_ats
pecan91919033p_ecan_
pechans14810503pechans
pedals94316033p_edals
pedant9319493p_edant
pedants10310113p_edants
peens76428193p_e_ens
peins76128063p_e_ins
pekan111613973p_ekan_
pekins121812233p_ekins
penang92511113p_enang
penangs10268373p_enangs
pens65649643p_e__ns
peons75327183p_e_ons
pepsins11310433pepsins
persons93717013persons
pesade9311103p_esade
pesades10310903p_esades
pesos77221623p_es_os
pestos84719083p_estos
pests75933273p_es_ts
petals84719813p_etals
petsais938433petsais
phaetons1345853phaetons
pheasant1347083pheasant
pheasants1443723pheasants
pians75126963p__ians
pietas84516503pieta_s
pinesaps1253983pinesaps
pissant91012503pissant
pissants1097363pissants
pitmans11188743pitmans
pitsaws1234993pitsaws
plans75731273p__lans
platans93413123platans
pleads94613953ple_ads
pleas75627033ple_a_s
pleasant1048323pleasant
pleases94515483pleases
pleats85218593ple_ats
pleiads1045223pleiads
pleons84213343ple_ons
poesies93217403poesies
poisons9310353poisons
predawns1444363predawns
preens85020113pre_ens
prefabs1435163prefabs
preman104117453preman_
prepays1437483prepays
preplans1249613preplans
presa74319043presa__
presage10312293presage
presages11312203presages
presale9416353presale
presales10315263presales
present94022733present
presents103315643presents
presets94216423presets
presoaks1436603presoaks
presong1039843presong
press75425953pres__s
presses93523153presses
prestos93716083prestos
prests84021263pres_ts
prewarns13456943prewarns
prisons9313223prisons
prolans9314273prolans
pterins9812993pterins
ptisan8417973ptisan_
pulsant9310563pulsant
pulsars9358913pulsars
pyrans11411063p_yrans
queans153110753que_ans
radians83013823radians
raglans82410133raglans
raisins72715343raisins
ramsons939563ramsons
randans8313213randans
ratans63819373ra_tans
rattans73411953rattans
reasons72514943reasons
redans75421023_redans
remans84823003_remans
resaws93713513_resaws
resays93714153_resays
resins64528773_resins
salsas65316133salsa_s
sampans112411003sampans
sans45153363___sans
sansars73313913sansars
sarans64224433sa_rans
sarsars73512143sarsars
sarsens7311393sarsens
sasins64923103sa_sins
seasons72614233seasons
seawans10379943seawans
sedans74816093_sedans
seesaws1034703seesaws
sewans95215903_sewans
skeans104512913ske_ans
speans85417143spe_ans
taipans9269553taipans
tampans113310983tampans
tarpans92513533tarpans
tarsals72512603tarsals
tartans72615823tartans
tarzans16329923tarzans
trepans92311593trepans
vassals1057953vassals
vegans103910853_vegans
wangans1149503wangans
warsaws1335763warsaws
weans85326743_we_ans
weasand1135503weasand
weasands1244563weasands
weasons102310583weasons
yeans86624883_ye_ans

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.406440125.6
2DLD Change Limit1340273327.08018930.4
3Display Results3323320.1232699.2
 (SQL Overall)1786913327.60923484.2
 
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.