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

380 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
paisans9361475(None) 
paesans93312691paesans
paisan84417071paisan_
paisana94010221paisana
paisanas10288871paisanas
paisano9429511paisano
paisanos10337551paisanos
paisas84317491paisa_s
ptisans9317361ptisans
caimans113811782caimans
paeans85118262pa_eans
paesan85114092paesan_
paesani9348682paesani
paesano9338792paesano
paesanos10296702paesanos
pagans95717922pa_gans
pains75138282pai__ns
paisa76021072paisa__
parians93519732parians
parsons93516872parsons
partans94418282partans
partisans1167482partisans
passant9813942passant
pavans115715592pa_vans
pians75126962p_i_ans
poisons9310352poisons
prisons9313222prisons
ptisan8417972ptisan_
raisins72715342raisins
taipans9269552taipans
ains46158883_ai__ns
airns55521033_ai_rns
aisles64721143_aisles
alans55636173_a_lans
apian75018333api_an_
apicals1159923apicals
arsons63917213_arsons
artisans888523artisans
asana5315483_a_sana
asanas6514113_a_sanas
assais6711963_assais
assays977903_assays
atmans84413963_atmans
avians93711563_avians
azans146516883_a_zans
bairns86710873bai_rns
baizas173810823baiza_s
balsams11579013balsams
balsas86417523balsa_s
banians9312033banians
banyans1237913banyans
bartisans1165553bartisans
basins85722763ba_sins
basions94213953basions
bisons83914373_bisons
brisant9312683brisant
caesars9410733caesars
caftans12179443caftans
caiman103615663caiman_
cains75334303cai__ns
cairns85313303cai_rns
caissons1036283caissons
callans94518473callans
camisas113411923camisa_s
cancans11311873cancans
capstans1257243capstans
captans111612053captans
casas75327843ca_sa_s
causals91411183causals
caymans14349513caymans
daikons12186693daikons
daimons10249323daimons
daises74318983dais_es
daisies84217093daisies
damans94715983da_mans
damsons1038013damsons
darshans1286543darshans
divans104612393_divans
diwans105110373_diwans
foisons1047613foisons
gains65729513gai__ns
gainsays1243513gainsays
gossans836783gossans
grisons838993grisons
habitans1346623habitans
hansas94616043hansa_s
harijans1845723harijans
hausens1077633hausens
hazans183411653ha_zans
hazzans18215783hazzans
japans1539823ja_pans
jawans1657843ja_wans
kaftans14185353kaftans
kaiaks937043kai_aks
kains96125643kai__ns
kaisers11369273kaisers
kalians11310183kalians
kamsins1346963kamsins
kanbans1337723kanbans
lagans75717783la_gans
lallans74113533lallans
lauans65113533la_uans
liaisons844293liaisons
ligans76817733_ligans
limans84816303_limans
magians10310753magians
maidens10349663maidens
mains75635113mai__ns
maists85817573mais_ts
malisons1048783malisons
mannans93611523mannans
masas75630413ma_sa_s
masons83916513ma_sons
massas85116463massa_s
matsahs1236563matsahs
messans92710463messans
naans55815253na__ans
naiads739013nai_ads
nairas6312783naira_s
nasals63312463na_sals
nasions73112383nasions
naysays1344123naysays
oppidans1343083oppidans
origans839973origans
orisons7310563orisons
ovisacs1263283ovisacs
pacas96029403pa_ca_s
pachas135017143pacha_s
padishahs1841663padishahs
padnags1135083padnags
padshahs17113153padshahs
paean77222723pa_ean_
paeons83915523pa_eons
pagan86121163pa_gan_
pageant10312783pageant
pageants1136693pageants
paiking143814813paiking
paiks114719853pai__ks
pails75833063pai__ls
pain65647243pai__n_
paining103920243paining
paint75443693pai__nt
paints85921833pai_nts
pairing103716733pairing
pairings11398313pairings
pairs75325833pai__rs
paise75028333pais__e
paisley1235553paisley
paisleys1333343paisleys
palais8420423pa_lais
palikars1445083palikars
palisade1145833palisade
palisades1245613palisades
palsies94420273palsies
pampas124913993pampa_s
pampeans1444703pampeans
pandani1039903pandani
pandanus1136433pandanus
pandas95521963panda_s
pangas99921103panga_s
pangens103112063pangens
pans65855733p___ans
pansies94521983pansies
papains11312363papains
papas94927493pa_pa_s
papaws13419113pa_paws
paphians1545593paphians
papisms13238543papis_ms
papists112110453papis_ts
parang93715513pa_rang
parangs104314373pa_rangs
paras76143043pa_ra_s
parasang1147333parasang
parasangs1246033parasangs
pardahs13289673pardahs
pardons103817623pardons
pariahs123812343pariahs
parian83223963parian_
parises94827183paris_es
parishes13314753parishes
parkas125018023parka_s
parlays123910453parlays
parmesans1344103parmesans
parrals94414573parrals
parsecs11429923parsecs
parsers94118153parsers
parses85534703pars_es
parsing103819553parsing
parson83817903parson_
partan83820563partan_
partisan1058423partisan_
partizans2055243partizans
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
patinas96318523patina_s
patins87528783pa_tins
patrons93818103patrons
patsies93919483patsies
pattens95414923pattens
paulins9312613paulins
pausal81511963pausa_l
pausers94113223pausers
pauses84621473paus_es
pausing103912813pausing
pavan106518473pa_van_
pavane114113443pa_vane
pavanes123612653pa_vanes
pavins114919663pa_vins
pavisers13387443pavisers
pavises125315493pavis_es
pavisses13397103pavisses
pawns108818133pa__wns
pawpaws1732823pawpaws
paydays1634433paydays
peans75437643p__eans
peasant9314923peasant
peasants1038263peasants
pecans101515833p_ecans
pechans14810503pechans
peins76128063pei__ns
peises84125043peis_es
peising103416763peising
pekans121710553p_ekans
pelicans1238093pelicans
pemicans1447043pemicans
pepsins11310433pepsins
persons93717013persons
petsais938433petsais
phials1158873phi_als
pian66136093p_i_an_
piano76118713p_i_ano
pianos84315933p_i_anos
pias66542553p_i_a_s
piasaba1144193piasaba
piasabas1243883piasabas
piasava1243883piasava
piasavas1343333piasavas
pibals103813083p_ibals
picas94626523p_ica_s
pikas114218093p_ika_s
pilafs113511023p_ilafs
pilaus84114133p_ilaus
pilaws11399433p_ilaws
pimas94725103p_ima_s
pinang92611593p_inang
pinangs10267793p_inangs
pinas75434453p_ina_s
pinnas85315513p_innas
pinons86019943p_inons
pins65558453p_i__ns
pions75826393p_i_ons
pipals104213643p_ipals
pirana8713263p_irana
piranas9912603p_iranas
pirns76020093p_i_rns
piscos105112593p_iscos
pishes114722103p_ishes
pisos76021063p_is_os
piss65033333p_is__s
pissant91012503pissant
pissants1097363pissants
pisses84525083p_isses
pistes85325633p_istes
pistons93016373p_istons
pitas77427673p_ita_s
pitmans11188743pitmans
pitons85319043p_itons
pitsaws1234993pitsaws
plains85019593plai__ns
plans75731273p__lans
platans93413123platans
pliant83918823pli_ant
plisses94411773plisses
poisers94214433poisers
poises84226543pois_es
poising103617103poising
poison8312223poison_
praisers103410833praisers
praises94121103prais_es
praising113214563praising
primas104418103prima_s
prions84317783pri_ons
prises84133173pris_es
prising103321453prising
prisms104915503pris_ms
prison8514023prison_
priss74623893pris__s
prisses94816713prisses
pristane10310343pristane
pristanes11410433pristanes
prolans9314273prolans
puisne856353puis_ne
puisnes937423puisnes
puissant10105393puissant
pulsant9310563pulsant
pulsars9358913pulsars
puritans1037633puritans
pyins105815863pyi__ns
pyrans11411063p_yrans
radians83013823radians
raglans82410133raglans
raias54631123rai_a_s
rains55140233rai__ns
raisers73617393raisers
raises64826543rais_es
raisin62716923raisin_
raising83220533raising
raisings9338443raisings
raisiny10319923raisiny
raitas64417673raita_s
ramsons939563ramsons
randans8313213randans
ratans63819373ra_tans
rattans73411953rattans
saigas74114293saiga_s
saimins9312113saimins
sains55639973sai__ns
salsas65316133salsa_s
samisens1035483samisens
sampans112411003sampans
sans45153363___sans
sansars73313913sansars
sarans64224433sa_rans
sarsars73512143sarsars
sarsens7311393sarsens
sasins64923103sa_sins
seisins73614393seisins
seitans73312303seitans
shaitans1136413shaitans
sisals63013573_sisals
taigas73712563taiga_s
tailfans1144553tailfans
tains54936323tai__ns
taipan82410663taipan_
talismans1143833talismans
tampans113310983tampans
tarpans92513533tarpans
tarsals72512603tarsals
tartans72615823tartans
tarzans16329923tarzans
tisane6311573_tisane
tisanes7311853_tisanes
titans63414913_titans
unisons748423unisons
vassals1057953vassals
visas84317653_visa_s
wains86930873wai__ns
waists97415453wais_ts
wangans1149503wangans
wanigans1244743wanigans
warisons1136903warisons
warsaws1335763warsaws
wigans104511703_wigans
witans93412933_witans
zaikais2042913zaikais

Search took 9 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.436409841.7
2DLD Change Limit1340273807.90616952.6
3Display Results3803800.1402714.3
 (SQL Overall)1786913808.48221067.1
 
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.