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

515 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
paisan8441707(None) 
paesan85114091paesan
paisa76021071paisa_
paisana94010221paisana
paisano9429511paisano
paisans93614751paisans
paisas84317491paisas
ptisan8417971ptisan
apian75018332api_an
caiman103615662caiman
paean77222722pa_ean
paesani9348682paesani
paesano9338792paesano
paesans93312692paesans
pagan86121162pa_gan
pain65647242pai__n
paisanas10288872paisanas
paisanos10337552paisanos
paise75028332pais_e
parian83223962parian
parson83817902parson
partan83820562partan
partisan1058422partisan
passant9813942passant
pausal81511962pausal
pavan106518472pa_van
pian66136092p_i_an
poison8312222poison
prison8514022prison
ptisans9317362ptisans
raisin62716922raisin
taipan82410662taipan
adman84517903_adman
aidman92410623_aidman
ain37579093_ai__n
airman82414223_airman
airn46433833_ai_rn
ais39083573_ais__
aisle55223193_aisle
alan46844083_a_lan
ansa45927773_ansa_
ansae55720973_ansae
apical10913903apical
apish105116633apis_h
arisen65316793arisen
arson55118833_arson
artisan759463artisan
asana5315483_a_sana
assai5711543_assai
assay8710283_assay
atman75520143_atman
avian84616053_avian
axman144813183_axman
azan136521783_a_zan
badman113813843badman
bagman114613813bagman
bailsman1245003bailsman
bairn77515533bai_rn
baiza164813223baiza_
baizas173810823baizas
balsa77920413balsa_
balsam105612233balsam
balsas86417523balsas
banian8315383banian
banyan1139483banyan
barman103519703barman
bartisan1056163bartisan
basal75722283ba_sal
basin75026923ba_sin
basion84315853basion
batman105214063batman
batsman1157993batsman
bayman133712703bayman
bison75716983_bison
brisant9312683brisant
cabman123812503cabman
caesar8410933caesar
caftan111710123caftan
caimans113811783caimans
cain65643913cai__n
cairn75717513cai_rn
caisson936593caisson
callan83619603callan
camisa103114323camisa_
camisas113411923camisas
cancan10314103cancan
capstan1137903capstan
captan101613343captan
carman103920743carman
casa65630863ca_sa_
casas75327843ca_sas
causal81413203causal
cayman133613213cayman
daikon11217243daikon
daimen92210573daimen
daimon9259713daimon
dais57040703dais__
daises74318983daises
daisy95915313dais_y
daman84821163da_man
damson938063damson
darshan1167063darshan
daysman1335053daysman
divan96114843_divan
diwan95712553_diwan
fain75840563fai__n
foison948933foison
gagman103811243gagman
gaijin1445973gaijin
gain56042163gai__n
gainsay1144033gainsay
gasman92911743gasman
gossan747233gossan
grison7310103grison
habitan1236903habitan
haika125313793haika_
hansa85416783hansa_
hansas94616043hansas
harijan1735783harijan
hausen9610383hausen
hazan173813613ha_zan
hazzan17236803hazzan
hisn79620933_his_n
japan14411233ja_pan
jawan15710383ja_wan
kaftan13185823kaftan
kaiak8310353kai_ak
kain85334293kai__n
kaiser103610373kaiser
kalian10312163kalian
kamsin1238323kamsin
kanban1238623kanban
lagan66520343la_gan
laical8312323laical
lain46146283lai__n
lallan63414173lallan
lauan55216793la_uan
lawman11289053lawman
layman113511303layman
liaison744473liaison
ligan67920283_ligan
liman75921603_liman
madman113712383madman
magian9312833magian
maiden93512283maiden
mailman1137733mailman
main65345513mai__n
maist75535683mais_t
maists85817573maists
malison939693malison
mannan85413623mannan
masa65034713ma_sa_
masas75630413ma_sas
mason74820183ma_son
massa75518923massa_
massas85116463massas
matsah1138233matsah
mayan105616903ma_yan
mesian84315503mesian
messan83912063messan
naan47621933na__an
naiad6313403nai_ad
naira5314743naira_
nairas6312773nairas
nasal56217593na_sal
nasial6413283nasial
nasion63914083nasion
naysay1234973naysay
oarsman937733oarsman
oppidan1243463oppidan
origan7310693origan
orison6411663orison
ovisac1153953ovisac
paca85132243pa_ca_
pacas96029403pa_cas
pacha126518063pacha_
pachas135017143pachas
packman1736693packman
pacs85842183pacs__
padis86227143padis__
padishah1742483padishah
padnag1036073padnag
pads76742953pads__
padshah16113353padshah
paeans85118263pa_eans
paeon74819493pa_eon
paesanos10296703paesanos
pagans95717923pa_gans
pageant10312783pageant
paginal10269493paginal
paid75737483pai__d
paik105726803pai__k
paiked135113433paiked
paiking143814813paiking
paiks114719853pai_ks
pail66141833pai__l
pails75833063pai_ls
painch133511323painch
pained95622853pained
paining103920243paining
pains75138283pai_ns
paint75443693pai_nt
paints85921833paints
painty114714753painty
pair66031513pai__r
paired95017523paired
pairing103716733pairing
pairs75325833pai_rs
paisley1235553paisley
palea75028663palea_
paleae84820293paleae
paleal84716673paleal
palikar1335453palikar
palisade1145833palisade
palish114718273palis_h
palmar104113463palmar
palpal104112053palpal
pals66951353pals__
palsy105417463pals_y
pampa114913423pampa_
pampas124913993pampas
pampean1335543pampean
pams85641763pams__
pan58466443p___an
panda85022613panda_
pandani1039903pandani
pandas95521963pandas
panga85323533panga_
pangas99921103pangas
pangen94115913pangen
pans65855723pans__
pansy105717973pans_y
papa85827143pa_pa_
papain10313793papain
papal95820673pa_pal
papas94927493pa_pas
papaw125112493pa_paw
papayan1445303papayan
paphian1437453paphian
papism122211513papis_m
papisms13238543papisms
papist102618743papis_t
papists112110453papists
paps86443453paps__
para65242173pa_ra_
parae76335703pa_rae
parang93715513pa_rang
paras76143043pa_ras
parasang1147333parasang
pardah123412823pardah
pardon94618733pardon
pariah114320583pariah
parians93519733parians
paris75145943paris__
parises94827183parises
parish115022353paris_h
parka115120883parka_
parkas125018023parkas
parlay113713993parlay
parmesan1244743parmesan
parral85517533parral
pars67560793pars__
parse75236993pars_e
parsec105914473parsec
parsed96323893parsed
parser84822373parser
parses85534703parses
parsing103819553parsing
parsons93516873parsons
partans94418283partans
partisans1167483partisans
partizan1955643partizan
parton84720993parton
pas58775743pa_s__
pascal10812373pascal
pase65346863pa_s_e
paseo77022513pa_seo
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
patin76832853pa_tin
patina86022193patina_
patinae95414403patinae
patinas96318523patinas
patron84018043patron
pats66460853pats__
patsy105717203pats_y
patten84418193patten
paulin8312983paulin
pause75021833paus_e
paused95114963paused
pauser84415963pauser
pauses84621473pauses
pausing103912813pausing
pavane114113443pa_vane
pavans115715593pa_vans
pavin105623203pa_vin
pavis106422733pavis__
pavise114714803pavis_e
paviser12489093paviser
pavises125315493pavises
pavisse12546813pavisse
pawn94625303pa__wn
pawpaw1653503pawpaw
paws96038183paws__
paxwax1742953paxwax
payday1536613payday
pays95940223pays__
pean66147173p__ean
peasant9314923peasant
peasen84815953peasen
pecan91919033p_ecan
pechan13511543pechan
pein65834943pei__n
peise75825773peis_e
peised94817683peised
peises84125043peises
peising103416763peising
pekan111613973p_ekan
pelican1139433pelican
pemican1348153pemican
penman10312323penman
pepsin10310853pepsin
person83517873person
petsai838083petsai
phial10313203phi_al
phis95724903phis__
pia56848033p_i_a_
pial65636703p_i_al
piano76118713p_i_ano
pians75126963p_i_ans
pias66542553p_i_as
piasaba1144193piasaba
piasava1243883piasava
pibal95217323p_ibal
pica85831493p_ica_
pical95524373p_ical
picas94626523p_icas
pika106322953p_ika_
pikas114218093p_ikas
pilaf103923483p_ilaf
pilar75221503p_ilar
pilau73618523p_ilau
pilaw103913743p_ilaw
pima85428653p_ima_
pimas94725103p_imas
pin57066723p_i__n
pina65842633p_ina_
pinang92611593p_inang
pinas75434453p_inas
pinna75320183p_inna
pinon76024533p_inon
pion67235293p_i_on
pipal95118353p_ipal
pirana8713263p_irana
pirn67128373p_i_rn
pis56362033p_is__
pisco96314983p_isco
pish96127913p_is_h
piso66727563p_is_o
pisos76021063p_isos
piss65033333p_is_s
pissant91012503pissant
piste75824603p_iste
piston83515923p_iston
pita65436433p_ita_
pitas77427673p_itas
pitman102412123pitman
piton76121583p_iton
pitsaw1135613pitsaw
plain74823303plai__n
plainsman1343193plainsman
plan65833943p__lan
platan83913693platan
pliant83918823pli_ant
plica9613373plica_
plicae10410953plicae
plical10411683plical
plisky1533713plisky
plisse8368403plisse
pois66539043pois__
poise75127893pois_e
poised94918473poised
poiser84217243poiser
poises84226543poises
poisha1135723poisha
poising103617103poising
poisons9310353poisons
potman102813573potman
praise84419413prais_e
praised104214813praised
praiser93413943praiser
praises94121103praises
praising113214563praising
preman104117453preman
presa74319043presa_
prima95019343prima_
primal104014623primal
primas104418103primas
prion75119993pri_on
prise74632613pris_e
prised94322203prised
prises84133173prises
prising103321453prising
prism94820263pris_m
prisms104915503prisms
prisons9313223prisons
priss74623893pris_s
prissy11347853prissy
pristane10310333pristane
prolan8414693prolan
psis68120343psis__
puisne856353puisne
puissant10105393puissant
pulsant9310563pulsant
pulsar8329363pulsar
puritan939283puritan
pyin96823233pyi__n
pyran10514473p_yran
radian74117273radian
raglan73711503raglan
ragman94013713ragman
raia46638383rai_a_
raias54631123rai_as
rain46251733rai__n
rais45252623rais__
raise54828053rais_e
raised76120333raised
raiser66620103raiser
raises64826543raises
raising83220533raising
raisins72715343raisins
raisiny10319923raisiny
raita54623073raita_
raitas64417673raitas
ramson8310463ramson
randan7315253randan
ratan53722663ra_tan
rattan63613603rattan
risen54621883_risen
saiga64717933saiga_
saigas74114293saigas
saimin8313663saimin
sain45551293sai__n
salsa56718923salsa_
salsas65316133salsas
samisen937673samisen
sampan102511893sampan
sansar63613393sansar
saran53730303sa_ran
sarsar63011843sarsar
sarsen6314233sarsen
sasin54626573sa_sin
seisin63715123seisin
seitan62613233seitan
shaitan1036883shaitan
sisal54217733_sisal
spartan948333spartan
taiga64115653taiga_
taigas73712553taigas
tailfan1044653tailfan
tain45548073tai__n
taipans9269553taipans
talisman1045553talisman
tampan102512323tampan
tarpan82814293tarpan
tarsal63315273tarsal
tartan64217513tartan
tarzan152910753tarzan
taximan1635783taximan
taxman15328613taxman
tisane6311573_tisane
titan53318173_titan
unison649033unison
uprisen9227353uprisen
vain75233003vai__n
vanman1139793vanman
vasa76522973va_sa_
vasal85516293va_sal
vassal979243vassal
visa76323873_visa_
visas84317653_visas
wain75840193wai__n
waist86132383wais_t
waists97415453waists
wangan10311223wangan
wanigan1135213wanigan
warison1037083warison
warsaw1236193warsaw
wigan95114393_wigan
witan83816503_witan
zaikai1943713zaikai

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 Filter1786911127160.1561145455.1
2DLD Change Limit1127165156.83016503.1
3Display Results5155150.1703029.4
 (SQL Overall)1786915157.15624970.8
 
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.