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

460 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
paesan8511409(None) 
paean77222721pae_an
paesani9348681paesani
paesano9338791paesano
paesans93312691paesans
paisan84417071paisan
caesar8410932caesar
paeans85118262pae_ans
paeon74819492pae_on
paesanos10296702paesanos
pagan86121162pa_gan
paisa76021072paisa_
paisana94010222paisana
paisano9429512paisano
paisans93614752paisans
paisas84317492paisas
parian83223962parian
parmesan1244752parmesan
parson83817902parson
partan83820562partan
passant9813942passant
pausal81511962pausal
pavan106518472pa_van
pean66147172p_e_an
peasant9314922peasant
peasen84815962peasen
pecan91919032p_ecan
pekan111613972p_ekan
preman104117452preman
presa74319042presa_
ptisan8417972ptisan
adman84517903_adman
aeon45634613_ae_on
alan46844083_a_lan
ameban1039093ameban
ansa45927773_ansa_
ansae55720973_ansae
apeak115513453ape_ak
apes66047433apes__
apian75018333_apian
arson55118833_arson
asana5315483_a_sana
asea46327183_asea_
assai5711543_assai
assay8710283_assay
atman75520143_atman
avian84616053_avian
axeman1538103axeman
axman144813183_axman
azan136521783_a_zan
badman113813843badman
bagman114613813bagman
balsa77920413balsa_
balsam105612233balsam
balsas86417523balsas
banian8315383banian
banyan1139483banyan
barman103519703barman
basal75722283ba_sal
baseman1138553baseman
basin75026923ba_sin
batman105214063batman
batsman1157993batsman
bayman133712703bayman
bean66443863_be_an
began86319573_began
cabman123812503cabman
caeca93915133caeca_
caecal103713733caecal
caesars9410733caesars
caftan111710123caftan
caiman103615663caiman
calesa8412473calesa_
calesas9411833calesas
callan83619603callan
cancan10314103cancan
capelan1139003capelan
capstan1137903capstan
captan101613343captan
carman103920743carman
casa65630863ca_sa_
casas75327843ca_sas
casein83216453casein
casern84713313casern
cateran9313773cateran
causal81413203causal
caveman1437073caveman
cayman133613213cayman
clean75420413cle_an
daedal849083daedal
daemon9279593daemon
dalesman1145803dalesman
daman84821163da_man
damson938063damson
daresay1135433daresay
darshan1167063darshan
daysman1335053daysman
dean56039483_de_an
deewan10267553deewan
desand84812633_desand
desman9311693_desman
dewan95718043_dewan
elan46734243__elan
etesian757853etesian
faecal11359813faecal
faena85014203faena_
faenas94412763faenas
foeman11311233foeman
gaen57329603gae__n
gaes56348033gaes__
gagman103811243gagman
gamelan10106643gamelan
gamesman1344513gamesman
gasman92911743gasman
gateman1057473gateman
glean65818203gle_an
gossan747233gossan
haemal113811643haemal
haemin113412663haemin
haen76229453hae__n
haes77651023haes__
hansa85416783hansa_
hansas94616043hansas
hausen9610383hausen
hazan173813613ha_zan
hazzan17236803hazzan
iceman1037853iceman
japan14411233ja_pan
jawan15710383ja_wan
jean116629283_je_an
kaes85734063kaes__
kaftan13185823kaftan
kalian10312163kalian
kamsin1238323kamsin
kanban1238623kanban
lagan66520343la_gan
lallan63414173lallan
lauan55216793la_uan
lawman11289053lawman
layman113511303layman
lean46345243_le_an
leman75622603_leman
madman113712383madman
maenad939413maenad
maes66948403maes__
magian9312833magian
mannan85413623mannan
masa65034723ma_sa_
masas75630413ma_sas
mason74820183ma_son
massa75518923massa_
massas85116463massas
matsah1138233matsah
mayan105616903ma_yan
mean65538093_me_an
mesa67025483_mesa_
mesas76823203_mesas
mesian84315503_mesian
meson74118313_meson
messan83912063messan
naan47621933na__an
nasal56217593na_sal
naysay1234973naysay
oarsman937733oarsman
ocean71212963oce_an
paca85132243pa_ca_
pacas96029403pa_cas
paces96741113paces__
pacha126518063pacha_
pachas135017143pachas
packman1736693packman
pacs85842183pacs__
padnag1036073padnag
pads76742953pads__
padshah16113353padshah
paella8410913paella
paellas9411413paellas
paeons83915523paeons
pagans95717923pa_gans
pageant10312783pageant
pages85235073pages__
pain65647243pa__in
paisanas10288873paisanas
paisanos10337553paisanos
paise75028333pais_e
pakeha1533933pakeha_
pakehas1635313pakehas
palea75028663palea_
paleae84820293paleae
paleal84716673paleal
pales75753803pales__
palest83926223pales_t
palmar104113463palmar
palpal104112053palpal
pals66951353pals__
palsy105417463pals_y
pampa114913423pampa_
pampas124913993pampas
pampean1335543pampean
pams85641763pams__
pan58466453p___an
panda85022613panda_
pandani1039903pandani
pandas95521963pandas
panes76148693panes__
panga85323533panga_
pangas99921103pangas
pangen94115913pangen
pans65855733pans__
pansy105717973pans_y
papa85827143pa_pa_
papain10313793papain
papal95820673pa_pal
papas94927493pa_pas
papaw125112493pa_paw
papayan1445303papayan
paphian1437453paphian
paps86443453paps__
para65242173pa_ra_
parae76335703pa_rae
parang93715513pa_rang
paras76143043pa_ras
parasang1147333parasang
pardah123412823pardah
pardon94618733pardon
pares77164483pares__
pareses94718883pareses
paresis93315093paresis
pariah114320583pariah
parians93519733parians
parka115120883parka_
parkas125018023parkas
parlay113713993parlay
parmesans1344103parmesans
parral85517533parral
pars67560793pars__
parse75236993pars_e
parsec105914483parsec
parsed96323893parsed
parser84822373parser
parses85534703parses
parsing103819553parsing
parsons93516873parsons
partans94418283partans
partisan1058423partisan
parton84720993parton
pas58775743pa_s__
pascal10812373pascal
pase65346863pa_s_e
paseo77022513pa_seo
paseos88015813paseos
pases75346503pa_ses
pash95638133pa_s_h
pasha105417183pa_sha
pashas115117063pashas
pass65239953pa_s_s
passade1039233passade
passado1037053passado
passage1039803passage
passband1344773passband
passe75525693pa_sse
passed94320943passed
passee84522023passee
passel85117003passel
passer84721033passer
passes86030473passes
passim10410283passim
passing104318423passing
passion9310883passion
passus83610293passus
past65959013pa_s_t
pasta76624533pa_sta
pastas85422873pastas
paste74932953pa_ste
pasts75936503pa_sts
pasty105725053pa_sty
paten74827343pa_ten
pates76047893pates__
patin76832853pa_tin
patina86022193patina
patron84018043patron
pats66460853pats__
patsy105717203pats_y
patten84418193patten
paulin8312983paulin
pause75021833paus_e
paused95114963paused
pauser84415963pauser
pauses84621473pauses
pausing103912813pausing
pavane114113443pa_vane
pavans115715593pa_vans
paves104833923paves__
pavin105623203pa_vin
pawn94625303pa__wn
pawpaw1653503pawpaw
paws96038183paws__
paxes144928423paxes__
paxwax1742953paxwax
payday1536613payday
pays95940223pays__
pea56657243p_e_a_
peag75431343p_e_ag
peahen113410133peahen
peak106535203p_e_ak
peal68648103p_e_al
peans75437643p_e_ans
pear69745233p_e_ar
peas65755063p_e_as
peasants1038263peasants
pease75231113peas_e
peases85229473peases
peat65967933p_e_at
pecans101515833p_ecans
pechan13511543pechan
pedal86022503p_edal
pedant9319493p_edant
peen65938083p_e_en
pees65257373pees__
pein65834943p_e_in
pekans121710553p_ekans
pekin111514423p_ekin
pelon74423213p_elon
pen56558843p_e__n
penal75228373p_enal
penang92511113p_enang
penman10312323penman
penna74520203p_enna
peon65635243p_e_on
pepsin10310853pepsin
person83517873person
pes57259783p_es__
pesade9311103p_esade
pesky145911563p_esky
peso66925823p_es_o
pesos77221623p_esos
pest65555293p_es_t
pesto75723723p_esto
pests75933273p_ests
pesty106421713p_esty
petal76526893p_etal
petsai838083petsai
phaeton1235973phaeton
phaseal1245673phaseal
pheasant1347083pheasant
pian66136093p__ian
pies66949603pies__
pieta75421753pieta_
pietas84516503pietas
pikeman1535523pikeman
pinesap1164723pinesap
pissant91012503pissant
pitman102412123pitman
pitsaw1135613pitsaw
placeman1445683placeman
plan65833943p__lan
platan83913693platan
plea66830603ple_a_
plead85818463ple_ad
pleas75627033ple_as
pleasant1048323pleasant
please84315733please
pleat74734473ple_at
pleiad947833pleiad
plena75816393plena_
pleon74216383ple_on
plexal1536833plexal
poesy105014063poes_y
poison8312223poison
potman102813573potman
predawn1335353predawn
preen75925053pre_en
prefab1336243prefab
prelaw1139103prelaw
premen105017803premen
prepay13310313prepay
preplan1149953preplan
presage10312293presage
presale9416353presale
prese75228383pres_e
present94022733present
preset84430983preset
presoak1348453presoak
presong1039843presong
press75425953pres_s
pressman1247153pressman
prest75736353pres_t
presto84216203presto
prests84021263prests
pretax152310193pretax
prewar114712573prewar
prewarn124410143prewarn
prison8514023prison
prolan8414693prolan
pterin81014153pterin
ptisans9317363ptisans
pulsant9310563pulsant
pulsar8329363pulsar
pyes95528993pyes__
pyran10514473p_yran
quean143612843que_an
radian74117273radian
raglan73711503raglan
ragman94013713ragman
raisin62716923raisin
ramson8310463ramson
randan7315253randan
ratan53722663ra_tan
rattan63613603rattan
reason62616333reason
redan66125013_redan
reman75730153_reman
reran57329103_reran
resat55139683_resat
resaw84117253_resaw
resawn9399953_resawn
resay85320543_resay
resin54131053_resin
rewan85623663_rewan
salesman1047353salesman
salsa56718923salsa_
salsas65316133salsas
sampan102511893sampan
sansar63613393sansar
saran53730303sa_ran
sarsar63011843sarsar
sarsen6314233sarsen
sasin54626573sa_sin
seaman84015903seaman
season62714903season
seawan94111223seawan
sedan65620423_sedan
seesaw935973seesaw
sewan85921293_sewan
skean94415623ske_an
spaceman1445323spaceman
spaes76029973spaes__
spartan948333spartan
spean74620513spe_an
taipan82410663taipan
talesman1046693talesman
tampan102512323tampan
tarpan82814293tarpan
tarsal63315273tarsal
tartan64217513tartan
tarzan152910753tarzan
taxman15328613taxman
trepan82511673trepan
vanman1139793vanman
vasa76522973va_sa_
vasal85516293va_sal
vassal979243vassal
vegan95114153_vegan
waes76048603waes__
wangan10311223wangan
warsaw1236193warsaw
wean75734353_we_an
weasand1135503weasand
weason93210823weason
yean75834583_ye_an

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 Limit1127164606.45017475.3
3Display Results4604600.1403285.7
 (SQL Overall)1786914606.73326539.6
 
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.