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 “palatial” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

88 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
palatial1041062(None) 
palatal9310151palat_al
malarial10410612malarial
palatals1037772palat_als
palatially1545402palatially
palatine10316072palatine
pallial92911252pal_lial
partial92616262pa_rtial
patagial1157172patagial
pelagial1146542pelagial
abaxial1646183_abaxial
abbatial1284673abbatial
adagial946373_adagial
adaxial1545323_adaxial
alation72920553_alation
alodial899953_alodial
aplasia92510803aplasia_
aplasias10279233aplasias
balata8614683balat_a_
balatas9311833balat_as
bilabial1265683bilabial
calvarial1445693calvarial
dalmatian1244643dalmatian
fanatical1446493fanatical
filarial1147863filarial
galabia1038333galabia_
galabias1137733galabias
galangal1043893galangal
galatea839973galatea_
galateas937153galateas
glacial1038143_glacial
halation11313853halation
labial84714343__labial
malaria9313703malaria_
malarian10311563malarian
malarias10313773malarias
martial92415413ma_rtial
palabra1137193palabra_
palabras1267353palabras
paladin101011773paladi_n
paladins11911003paladins
palais8420423pala_i_s
palapa10310673pala_pa_
palapas11311493pala_pas
palatable1346383palatable
palatably1644443palatably
palatally1454353palatally
palate84226793palat__e
palates93624943palat_es
palatinate1245603palatinate
palatines11313053palatines
paleal84716673pal__eal
palestral1145323palestral
palladia1146633palladia_
pallia83015593pal_lia_
palmation13310223palmation
palpal104112053pal__pal
palpating1438543palpating
palpation1339073palpation
paludal1035683pal_udal
panatela1044913panatela
paradisal1246883paradisal
parasail1049233parasail
partials101911973pa_rtials
pastil85018323pa_sti_l
patagia1068783patagia_
phalangal1552473phalangal
phratral1344373phratral
piratical1348673piratical
plagal948573p_la_gal
plastral1046913plastral
platan83913693p_lat_an
plateau937403p_lateau
platier93716293p_latier
platies93722543p_laties
platina94413643p_latina
platinas103610313p_latinas
plating103823073p_lating
pluvial1245433p_luvial
political1349713political
preaxial1746973preaxial
primatial1348103primatial
pulpital1243873pulpital
puparial1246313puparial
salariat8416303salariat
solatia7312253solatia_
spatial9310323_spatial
talaria7412523talaria_

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 Filter1786911461620.406440125.6
2DLD Change Limit146162886.98320931.1
3Display Results88880.0332666.7
 (SQL Overall)178691887.42224075.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.