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

185 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
palatal931015(None) 
palatals1037771palatals
palatial10410621palatial
balata8614672balata_
balatas9311832balatas
palapa10310672palapa_
palapas11311492palapas
palatable1346372palatable
palatably1644442palatably
palatally1454352palatally
palate84226782palat_e
palates93624932palates
paleal84716672pal_eal
pallial92911252pallial
palpal104112052pal_pal
paludal1035682paludal
plagal948572p_lagal
platan83913692p_latan
acetal84314903_acetal
alanyl955483_alanyl
alate55340323_alat_e
alated75625143_alated
alates64833963_alates
albata839333_albata_
albatas938373_albatas
algal66518223_al_gal
altar55520643_al_tar
amatol838693_amatol
aortal65217513_aortal
artal55525473_a_rtal
atabal839743_atabal
atlatl637873atlat_l
avatar937523_avatar
balneal936573balneal
calamar1149293calamar
calathi1247583calathi
cantal84122033ca_ntal
capital112311523capital
caracal11312513caracal
chalazal2243873chalazal
falafel1383903falafel
fallal93612693fal_lal
fatal84819373__fatal
galangal1043893galangal
galatea839953galatea
galateas937133galateas
gametal1037603gametal
haematal1345143haematal
halakah17517963halakah
halal85623593hal__al
halala94715093halala_
halalah13429393halalah
halalas104214083halalas
halavah16447023halavah
hallal94415563hal_lal
hartal9415473ha_rtal
hematal1238953hematal
hiatal9310203_hiatal
lanital7310913lanital
malarial10410613malarial
malate84624553malat_e
malates93522603malates
maltol8310843mal_tol
marital92314183marital
meatal84114733_meatal
natal53921493__natal
paginal10269493paginal
pajama17317653pajama_
pajamas18278153pajamas
palabra1137183palabra
palabras1267353palabras
palace104516913pala_ce
palaced124110773palaced
palaces114216453palaces
paladin101011773paladin
palais8420423pala_is
palatalize2144873palatalize
palatially1545393palatially
palatine10316063palatine
palaver1238753palaver
palazzi1742993palazzi
palazzo1743083palazzo
palea75028663pal_ea_
paleae84820293pal_eae
paleate94120003paleat_e
palestral1145323palestral
palet74650803palet__
paletot9413713paletot
palets85122313palet_s
palette93613983palette
palikar1335453palikar
pall65039343pal___l
pallia83015593pallia_
palmar104113463pal_mar
palmate113215233palmat_e
palmated132511003palmated
palmately1644443palmately
palmful1445053palmful
palmtop1343873palmtop
palpate113213923palpat_e
palpated13249763palpated
palpates122613063palpates
palpator1247123palpator
palter84423263pal_ter
paltry114910403pal_try
panada94113053panada_
panadas103312213panadas
panama104213353panama_
panamas113112763panamas
panatela1044913panatela
papadam1486913papadam
papal95820673p__apal
papaya1337503papaya_
papayan1445303papayan
papayas1437273papayas
papyral1445773papyral
parasail1049233parasail
parasol939553parasol
parental10310943parental
parietal1048773parietal
parral85517533pa_rral
partan83820563pa_rtan
partial92616263partial
pascal10812373pa_scal
paschal14157243paschal
pasta76624533pa_sta_
pastas85422873pa_stas
pastel85918713pa_stel
pastil85018323pa_stil
pataca10311193pataca_
patacas11311003patacas
patagial1157173patagial
patamar1147093patamar
pausal81511963pa_usal
pelagial1146543pelagial
pelletal1045733pelletal
pelota8612833pelota_
pelotas9410723pelotas
petal76526893p__etal
phalangal1552473phalangal
phrasal1246163phrasal
phratral1344373phratral
pinata83817223pinata_
pinatas93711503pinatas
pivotal1245433pivotal
planar84212713p_lanar
plantar9369993plantar
plastral1046913plastral
plat66048873p_lat__
platane93112303p_latane
platans93413123p_latans
plate74635113p_lat_e
plateau937403p_lateau
plated95225773p_lated
platen84518203p_laten
plater84427693p_later
plates85432243p_lates
plats75531373p_lat_s
platy105021663p_lat_y
platys11459853p_latys
playa105812943p_laya_
playas114612283p_layas
plaza164311063p_laza_
plazas17409913p_lazas
plexal1536843p_lexal
plical10411683p_lical
plural839823p_lural
portal84218463p_ortal
postal84317533p_ostal
preanal9310713preanal
prenatal1048373prenatal
primatal1247133primatal
pulpal10408453pul_pal
pulpital1243873pulpital
ratal55025113__ratal
ratatat7412263ratatat
salaam8711013sala_am
salal55425703sal__al
statal61613223_statal
stratal72710603stratal
tapetal938273tapetal
tarlatan845063tarlatan
valuta938743valuta_
valutas1036533valutas
valval12398863val_val

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 Limit1340271856.25021444.3
3Display Results1851850.0632936.5
 (SQL Overall)1786911856.71926594.9
 
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.