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

216 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
pallial9291125(None) 
pallia83015591pallia_
fallal93612692fall_al
hallal94415562hall_al
palatal9310152palatal
palatial10410622palatial
paleal84716672pa_leal
palliate10311892palliate
pallid93915282palli_d
pallidly1444062pallidly
pallier94417162pallier
palling104024482palling
pallium1149012pallium
palpal104112052pa_lpal
paludal1035682paludal
partial92616262partial
pollical1247952pollical
aecial84817313_aecial
aerial64625713_aerial
albinal937813_albinal
algal66518223_a_lgal
alias55834603_a_lias
allay85620393_all_ay
allheal1044553_allheal
alliable1038433_alliable
allied74217153_allied
allies63827673_allies
allium8311243_allium
allodial9117393_allodial
alluvial1144313_alluvial
allyl85310543_all_yl
alodial899953_alodial
atrial65418943_atrial
audial7312993_audial
axial124515193_a_xial
ballad94315323ball_ad
ballies93725743ballies
balling104424763balling
balneal936573balneal
calla74827073call_a_
callan83619603call_an
callas84526753call_as
calling103826773calling
cambial134010763cambial
dahlia1035773dahlia_
dahlias1135723dahlias
dallied93713613dallied
dallier84215373dallier
dallies84023193dallies
fabliau1244903fabliau
facial113615633fa_cial
fallals103310193fall_als
fallible1355363fallible
fallibly1644393fallibly
falling113621583falling
familial1366083familial
fascial1258303fascial
faucial1257323faucial
filial93013253_filial
galliard10125753galliard
galliass935423galliass
gallic9411643galli_c
gallica1047463gallica
gallican1155333gallican
gallicas1136933gallicas
gallied94115003gallied
gallies84122713gallies
galling93921963galling
galliot82214133galliot
gallium1037943gallium
ganglial1054663ganglial
gavial10310083ga_vial
glacial1038143glacial
glial66715433__glial
halal85623593ha_l_al
hallah124115403hall_ah
hallel93514093hall_el
halliard12125963halliard
halloa94918123halloa_
halloas104318463halloas
hallucal1343483hallucal
hallway1636173hallway
ilial55317843__ilial
kalian10312163ka_lian
kalmia1238893kalmia_
kalmias1347973kalmias
labial84714343la_bial
lallan63414173lall_an
lalling83519623lalling
malarial10410613malarial
malling103623663malling
martial92415413martial
milligal1145703milligal
narial6317953na_rial
nasial6413283na_sial
nauplial1042903nauplial
paella8410913paella_
paellas9411413paellas
paginal10269493paginal
pail66141833pa__i_l
pailful1236103pailful
palais8420423palai_s
palapa10310673palapa_
palapas11311493palapas
palatals1037773palatals
palea75028663pa_lea_
paleae84820293pa_leae
palier85023563pa_lier
palikar1335453palikar
paling93530133pa_ling
palish114718273pa_lish
pall65039343pa_l__l
palladia1146633palladia_
palled94625163pall_ed
pallet84232653pall_et
pallets93919303pallets
palliasse1173023palliasse
palliated1238493palliated
palliates11311033palliates
palliator1146003palliator
palliest102814633palliest
palliums1236703palliums
pallor8313673pall_or
pallors9314363pallors
palls74332563pall__s
pally105727123pall__y
palmar104113463pa_lmar
palmful1445053palmful
palmier113312173palmier
palming123914013palming
palmist112814343palmist
palmlike1656043palmlike
palpi95414553palpi__
palping124112873palping
palsied102911303palsied
palsies94420273palsies
papal95820673pa__pal
paphian1437453paphian
papilla11127913papilla
papyral1445773papyral
pariah114320583pa_riah
parian83223963pa_rian
parlay113713993parl_ay
parling103823763parling
parral85517533pa_rral
partials101911953partials
pascal10812373pa_scal
paschal14157243paschal
pastil85018323pasti_l
patagial1157173patagial
paulin8312983pauli_n
paulins9312613paulins
pausal81511963pa_usal
payload1336403payload
pelagial1146543pelagial
pelletal1045733pelletal
pellicle1245043pellicle
penial84120893p_enial
phalli1148263phalli__
phallic1447293phalli_c
phallism1545713phallism
phallist1338983phallist
phial10313203p__hial
pial65636703p___ial
pillar8314023pill_ar
pilling103722563pilling
pillion92011703pillion
plagal948573p_lagal
pleiad947833p_leiad
plexal1536843p_lexal
plical10411683p_lical
plural839823p_lural
pluvial1245433pluvial
polling102920383polling
pollist9816603pollist
praedial1178763praedial
prandial1149643prandial
predial103815413predial
pulling103821073pulling
pullman1135403pullman
pulpal10408453p_ulpal
pulpital1243873pulpital
rachial122012173rachial
racial83419243ra_cial
radial74020393ra_dial
rallied83514083rallied
rallier73816273rallier
rallies73823343rallies
ralline73518413ralline
salal55425703sa_l_al
sallied83316953sallied
sallier73320423sallier
sallies73227813sallies
salpian938493salpian
salvia93310753salvia_
salvias10279933salvias
spacial1138763spa_cial
spalling113213463spalling
spatial9310323spa_tial
tallied83314753tallied
tallier72817213tallier
tallies73624603tallies
tallis63319963talli_s
tallish103313583tallish
tallit63422733talli_t
tallith102913063tallith
tallits73215993tallits
tallol63612223tall_ol
telial65815363_telial
valval12398863va_lval
walla85321033wall_a_
wallah124011993wall_ah
wallas95719393wall_as
wallie93216803walli_e
wallies103320743wallies
walling113520973walling

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272166.37321030.4
3Display Results2162160.0962250.0
 (SQL Overall)1786912166.87525991.4
 
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.