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

147 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
palliates1131103(None) 
palliate10311891palliate_
palliated1238491palliated
gallates92815522gall_ates
palates93624932pa_l_ates
pallettes1148802pallettes
palliasse1173022palliasse
palliasses1283582palliasses
palliatives1643512palliatives
palliator1146002palliator
palliators1245822palliators
palmitates1445452palmitates
palpates122613062pa_lpates
palpitates1445302palpitates
patriates11311362patriates
pollinates1247302pollinates
ablates92416903_abl_ates
alates64833963_a_l_ates
albites9313203_albi_tes
alginates10310123_alginates
aliases7914493_a_liases
alleviates1344943_alleviates
alliances11107093_alliances
allies63827673_alli__es
allocates11410473_allocates
aplites9314933_apli_tes
aviates10313063_a_viates
baldpates1445233baldpates
ballades114211643ball_ades
ballgames1443573ballgames
ballies93725743balli__es
ballutes1037523ball_utes
calcites12313003calci_tes
califates14310113califates
calliopes1346143calliopes
callipees1345303callipees
cellmates1347513cellmates
ciliates10413453_ciliates
collates103019143coll_ates
colligates1347713colligates
collimates1447973collimates
dalliances1344263dalliances
dallies84023193dalli__es
fellates11312753fell_ates
filiates11412663_filiates
foliates11412753_foliates
gallate83417123gall_ate_
galliards1194543galliards
galliass935423gallia_ss
galliasses1173063galliasses
gallies84122713galli__es
galliots9228683galliot_s
glaciates1267343glaciates
halites103221193ha_li_tes
halliards13104933halliards
haplites1339993hapli_tes
illites72415013_illi_tes
kalifates1646133kalifates
labiates101011513la_biates
malates93522603ma_l_ates
maleates103316343ma_leates
marlites103415263marli_tes
milliares1149403milliares
mullites10411643mulli_tes
paginates123111363paginates
paillettes1244653paillettes
palaces114216453pa_l_aces
palate84226783pa_l_ate_
palatinates1344993palatinates
paleate94120003pa_leate_
palefaces1645303palefaces
palettes103112833pa_lettes
palisades1245613palisades
palleted1139873pall_eted
pallets93919303pall_et_s
pallette1039513pallette_
pallia83015593pallia___
pallial92911253pallia__l
palliating1347893palliating
palliation1248503palliation
palliations1347723palliations
palliative1544773palliative
pallidness1343283pallidness
pallier94417163palli__er
palliest102814643palli__est
palliums1236703palli_ums
palmate113215233pa_lmate_
palmated132511003pa_lmated
palmettes1346883palmettes
palmister1345053palmister
palmisters1444673palmisters
palmists12268813palmist_s
palmitate1346413palmitate_
palpate113213923pa_lpate_
palpated13249763pa_lpated
palpitate1365973palpitate_
palpitated1544233palpitated
palsies94420273palsi__es
parietes10714543pa_rietes
passivates1544963passivates
patinates113814693patinates
patriate10311933patriate_
patriated1238533patriated
pearlites1138233pearli_tes
pelites93821993p_eli_tes
pellicles1344923pellicles
penlites10312273penli_tes
perlites10316363perli_tes
phallists1445723phallist_s
phyllites1745323phylli_tes
pillages113012613pill_ages
placates12311753p_lacates
plates85432243p__l_ates
playdates1554903playdates
playmates1646603playmates
pleiades1145753p_leiades
pollenates1246743pollenates
pollices12410753polli_ces
pollinate1147713pollinate_
pollinated1345823pollinated
pollists10910823pollist_s
pollutes1037613poll_utes
prelates10418573prel_ates
pullulates1243923pullulates
pulsates1048813p_ulsates
radiates92415293ra_diates
rallies73823343ralli__es
salivates1239293salivates
sallies73227813salli__es
satiates8314633sa_tiates
spoliates1138543spoliates
tailgates1046533tailgates
tallages92312003tall_ages
tallies73624603talli__es
tallises82713263talli_ses
tallithes12286573tallithes
talliths11377433talli_ths
tallits73215993talli_t_s
tillites8312833tilli_tes
tollgates1046053tollgates
valerates12310543valerates
validates1338243validates
vallate103016563vall_ate_
valuates112811203va_luates
variates111214983va_riates
vellicates1545903vellicates
wallies103320743walli__es

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 Filter1786911486410.483369960.7
2DLD Change Limit1486411476.33023482.0
3Display Results1471470.0761934.2
 (SQL Overall)1786911476.88925938.6
 
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.