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

224 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
payolas1214897(None) 
payola11208111payola_
canolas9313992canolas
paellas9411412paellas
pagodas11367552pagodas
pakoras1337472pakoras
paroles95025882paroles
parols84722612parol_s
payload1336402payload
payloads1445292payloads
payoffs1843242payoffs
payors114312642payo_rs
payouts1247302payouts
payrolls1344752payrolls
psyllas1244882psyllas
pyrolas1239862pyrolas
abomas101113583_abomas
agoras7613343_agoras
aholds10469483_aholds
aiolis6316843_aiolis
akelas10311193_akelas
alas46358123_a__las
alohas9411703_alohas
amoles84122193_amoles
anlas55626933_a_nlas
anoas57226493_ano_as
anoles64827433_anoles
apnoeas946353apnoeas
areolas71013863areolas
aromas81018613_aromas
atlas55821583_a_tlas
atolls65511353_atolls
awols84713523_awol_s
azoles154614613_azoles
balas76937213ba__las
bayous11411153bayo_us
bolas74733763__bolas
boylas113011723boy_las
cabalas113516003cabalas
caeomas1138403caeomas
cajoles163712103cajoles
callas84526753ca_llas
canola8313623canola_
canulas9312853canulas
carols85124983carol_s
carolus94612603carolus
cholas114818003_cholas
citolas939363citolas
colas75436773__colas
crapolas1247403crapolas
cupolas11277753cupolas
dagobas1145143dagobas
favelas1337023favelas
galas65731643ga__las
gaols66717573ga_ol_s
gayals1039513gayal_s
granolas938053granolas
gyozas1933613_gyozas
halalas104214083halalas
halloas104318463halloas
haoles94919803ha_oles
hawalas13348353hawalas
hylas114815903_hy_las
kabalas133911063kabalas
kamalas13339123kamalas
kayles134712003kay_les
kayoes134710823kayo_es
kayos127714703kayo__s
kolas94822233__kolas
layoffs1642573layoffs
layouts1046483layouts
maculas113114023maculas
mandolas1139133mandolas
manilas93915873manilas
masalas9312053masalas
mayas105924383may__as
mayoral1237693mayoral
mayors115714193mayo_rs
mayos105521933mayo__s
maypoles1545993maypoles
molas75132093__molas
moolas83615593_moolas
myomas1338303_myomas
nalas55528363na__las
nyalas936903_nyalas
pabular11259473pabular
pacas96029403pa__cas
pachas135017143pa_chas
paddles113515643paddles
padles95221123pa_dles
padouks1434873padouks
paella8410913paella_
paeons83915523paeo_ns
pagoda10487873pagoda_
pagods105310193pago_ds
pails75833063pa_il_s
paisas84317493pa_isas
pajamas18278153pajamas
pakehas1635313pakehas
pakora1247283pakora_
palais8420423pa__lais
palapas11311493palapas
pales75753803pa__les
pallors9314363pallors
palls74332563pa__lls
palms94921753pa__lms
palookas1443843palookas
palps94719563pa__lps
pals66951353pa__l_s
pampas124913993pa_mpas
panadas103312213panadas
panamas113112763panamas
pandas95521963pa_ndas
pandoras11310053pandoras
panels84716523panel_s
pangas99921103pa_ngas
panochas1545653panochas
papas94927493pa__pas
papayas1437273papayas
papula103011113papula_
papulae11249353papulae
papular11299763papular
papules112411573papules
parabolas1347003parabolas
paras76143043pa__ras
parkas125018023pa_rkas
parlay113713993pa_rlay
parlays123910453pa_rlays
parles86334403pa_rles
parlors9312913parlors
parlous9414293parlous
parodos103011753parodos
parol74826273parol__
parole84425253parol_e
paroled104217633paroled
parolee94119643parolee
parolees104313983parolees
parous84024163paro_us
parrals94414573parrals
paruras9310533paruras
pascals11610013pascals
pashas115117063pa_shas
pastas85422873pa_stas
patacas11311003patacas
patellas1039103patellas
patinas96318523patinas
patois84319363pato_is
patrols93513513patrol_s
pavlovas1642423pavlovas
pawls105617663pa_wl_s
payables15166483payables
payday1536613pay_day
paydays1634433paydays
payees114812903pay_ees
payers114621823pay_ers
paynims1434973paynims
payoff1736023payo_ff
payor105413843payo__r
payout11714653payo_ut
payroll1245613payrol_l
pays95940223pay___s
pelotas9410723pelotas
pergolas1158233pergolas
peyotes1238483peyotes
peyotls1233633peyotls
phyla13469183phy_la_
phylae14458733phy_lae
phylar14437373phy_lar
phyllos1535583phyllos
phytols15276553phytol_s
pinoles93418703pinoles
playas114612283play__as
playoffs1942793playoffs
plugolas1143133plugolas
polar75623453p__olar
polars84419353p__olars
poles75351003p__oles
polis74731163p__olis
polkas1239103p__olkas
polls74627723p__olls
polos76129913p__olos
pols66044563p__ol_s
polyols1238493polyol_s
polyomas1546993polyomas
polys105718763p__olys
pools74427703p_ool_s
posoles9314883posoles
poyous112911623poyo_us
pozoles1839063pozoles
proas75028803p_ro_as
prolan8414693p_rolan
prolans9314273p_rolans
proles84627203p_roles
psoas75012983p_so_as
psylla1133953psylla_
psyops1334343psyo_ps
pyas96225703p_y__as
pylons113011243p_ylons
pyoses114314303p_yoses
pyosis114012123p_yosis
pyrola1139003pyrola_
qabalas18289503qabalas
radulas839583radulas
ramblas112710263ramblas
ramonas9311093ramonas
ranulas7311773ranulas
rayas85922053ray__as
rayons94113343rayo_ns
rugolas836373rugolas
salols64017873salol_s
samosas939303samosas
sapotas939613sapotas
spatulas1045473spatulas
tablas83716163ta_blas
talas55935893ta__las
taxols13328633taxol_s
tolas54532773__tolas
variolas1168533variolas
violas93713523_violas
wallas95719393wa_llas
waylay1535453way_lay
waylays1634673way_lays
yogas96615603__yogas
yolks125412773__yolks

Search took 10 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.423422437.4
2DLD Change Limit1340272248.61015566.4
3Display Results2242240.0762947.4
 (SQL Overall)1786912249.10919617.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.