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

167 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
palliate1031189(None) 
palliated1238491palliated
palliates11311031palliates
gallate83417122gall_ate
palate84226782pa_l_ate
paleate94120002pa_leate
pallette1039512pallette
pallia83015592pallia__
pallial92911252pallia_l
palliasse1173022palliasse
palliative1544772palliative
palliator1146002palliator
palmate113215232pa_lmate
palmitate1346412palmitate
palpate113213922pa_lpate
palpitate1365972palpitate
patriate10311932patriate
pollinate1147712pollinate
vallate103016562vall_ate
ablate82219213_abl_ate
alate55340323_a_l_ate
albite8313313_albi_te
alginate9310693_alginate
alleviate1246063_alleviate
alliable1038433_alliable
alliance1097253_alliance
allocate10411023_allocate
aplite8316393_apli_te
aviate9315203_a_viate
baldpate1345483baldpate
ballade104012563ball_ade
ballgame1343653ballgame
ballista1045803ballista
ballistae1143793ballistae
ballute938543ball_ute
bullate93415073bull_ate
calceate1239863calceate
calcite11413783calci_te
califate13310483califate
calliope1256223calliope
callipee1237733callipee
calycate1537893calycate
cellmate1237863cellmate
ciliate9514603_ciliate
collate92919683coll_ate
colligate1248293colligate
collimate1348163collimate
dalliance1244193dalliance
falcate12311613fa_lcate
fallible1355363fallible
fasciate1347563fasciate
fellate10313433fell_ate
filiate10414233_filiate
foliate10513533_foliate
galeate83916783ga_leate
gallates92815523gall_ates
galliard10125753galliard
galliass935423galliass
galliot82214133galliot_
galliots9228683galliots
gangliate1144493gangliate
glaciate1168073glaciate
gladiate1057053gladiate
halite93624233ha_li_te
halliard12125963halliard
haplite12310703hapli_te
illite63414923_illi_te
kalifate1556493kalifate
labiate91313573la_biate
malate84624553ma_l_ate
maleate94117543ma_leate
marlite92917073marli_te
milliare1039153milliare
mullite9313013mulli_te
paginate114012443paginate
paillette1145243paillette
palace104516913pa_l_ace
palates93624933pa_l_ates
palatinate1245593palatinate
paleae84820293pa_lea_e
paleface1545343paleface
palette93613983pa_lette
palisade1145833palisade
pallet84232653pall_et_
palleted1139863pall_eted
pallets93919303pall_ets
pallettes1148803pallettes
palliasses1283583palliasses
palliating1347883palliating
palliation1248503palliation
palliatives1643513palliatives
palliators1245823palliators
pallid93915283palli__d
pallidly1444053pallidly
pallier94417163palli_er
palliest102814633palliest
palling104024483palli_ng
pallium1149013palli_um
palliums1236703palliums
palmated132511003pa_lmated
palmette1247733palmette
palmist112814343palmist_
palmister1345053palmister
palmists12268813palmists
palmitates1445453palmitates
palmlike1656043palmli_ke
palpated13249763pa_lpated
palpates122613063pa_lpates
palpitated1544233palpitated
palpitates1445303palpitates
papillate13127573papillate
parlante1039693parlante
partite9317133parti_te
passivate1445683passivate
patellate1147483patellate
patinate103016313patinate
patriated1238533patriated
patriates11311363patriates
pearlite1039443pearli_te
pelite84323003p_eli_te
pellicle1245043pellicle
peltate92013773p_eltate
penlite9313243penli_te
perlite9317313perli_te
phallist1338983phallist_
phallists1445723phallists
phyllite1645743phylli_te
pileate93815923p_ileate
pillage103412593pill_age
placate11312433p_lacate
planate9314573p_lanate
plate74635113p__l_ate
playdate1465263playdate
playmate1566463playmate
plicate11314513p_licate
plumate1149803p_lumate
polite83625073p_oli_te
pollenate1157143pollenate
pollinated1345823pollinated
pollinates1247303pollinates
pollist9816603pollist_
pollists10910823pollists
pollute937383poll_ute
prelate9519693prel_ate
prolate9419793prol_ate
pullulate1144703pullulate
pulsate9510233p_ulsate
pulvinate1445193pulvinate
radiate83416313ra_diate
ralline73518413ralli_ne
salivate11310013salivate
satiate7315403sa_tiate
spoliate1039243spoliate
tailgate946823tailgate
tallage82712073tall_age
tallit63422733talli_t_
tallith102913063talli_th
tallits73215993talli_ts
tillite7313563tilli_te
tollgate946253tollgate
valerate11311473valerate
validate1239003validate
valuate102512733va_luate
valvate133710813va_lvate
variate101316433va_riate
vellicate1446433vellicate
wallie93216803walli__e

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621678.82616560.4
3Display Results1671670.0632650.8
 (SQL Overall)1786911679.04519755.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.