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

137 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
pliancy143559(None) 
plainly1236472plainly
planch133711442pl_anch
pliably14147382pliably
pliant83918822plian_t
pliantly1345782pliantly
valiancy1674812valiancy
alienly1037503alienly
alliance1097263alliance
appliance1544493appliance
blanch133410853bl_anch
blatancy1543573blatancy
chancy164010863_chancy
clanky15469073cl_anky
cleanly1236323cleanly
clinch133910353cli_nch
clingy12659063cli_ngy
compliancy2153753compliancy
deviancy1754183deviancy
elegancy1444383elegancy
errancy1256363errancy
fancy134615483__fancy
fiance11310743_fiance
flinch144010103fli_nch
flinty126112493fli_nty
flippancy2151693flippancy
flouncy1543673flouncy
fluency1545353fluency
glance94312313gl_ance
glinty106910693gli_nty
iliac75013493ilia_c_
infancy1546173infancy
lacy95829633_l_a_cy
lance75126723_l_ance
lanky125517483_l_anky
leanly93811503_leanly
liana53915893_lian_a
lianas63713383_lianas
liane54720663_lian_e
lianes63819323_lianes
liang64914413_lian_g
liangs74410593_liangs
linac7315413_linac_
linacs8310813_linacs
lindy96918313_li_ndy
liney87029633_li_ney
lingy96925143_li_ngy
linky127622383_li_nky
linty87126563_li_nty
liny78141323_li_n_y
litany939053_litan_y
lunacy1136843_lunacy
militancy1644123militancy
mincy125817413_mi_ncy
nancy105214923__nancy
pacy115328683p__a_cy
painch133511323pai_nch
painty114714753pai_nty
pandy115021173p__andy
pansy105717973p__ansy
panty105929303p__anty
papacy1547493papa_cy
patency1466313patency
peccancy1643953peccancy
penance11313443penance
pian66136093p_ian__
pianic103714123p_ianic
piano76118713p_ian_o
pianos84315933p_ianos
pians75126963p_ian_s
pinch125619303p_i_nch
piney105727503p_i_ney
pinky145823403p_i_nky
pinny105222063p_i_nny
piny911838353p_i_n_y
piquancy2442973piquancy
piracy1339473p_iracy
place94824613pl_a_ce
plack135017843pl_a_ck
plaguy12386413pl_aguy
plaice10311553pl_aice
plain74823303plain__
plained103812233plained
plainer93811983plainer
plains85019593plain_s
plaint85323203plain_t
plaints94012053plaints
plan65833943pl_an__
planar84212713pl_anar
planche14299753pl_anche
plane74929143pl_an_e
planed94420913pl_aned
planer84122653pl_aner
planes85028083pl_anes
planet84228353pl_anet
plank115221143pl_an_k
planks124116753pl_anks
plans75731273pl_an_s
plant75437113pl_an_t
plants84921803pl_ants
plashy14448873pl_ashy
platy105021663pl_a_ty
play95928983pl_a__y
pleach134211243plea_ch
plenary1237543plenary
plench134010813pl_ench
plenty11311413pl_enty
pliable111610323pliable
pliancies1346673pliancies
plica9613373pli__ca
plink115219123pli_n_k
plinks124913263pli_nks
plinth11310453pli_nth
plisky1533713pli_sky
plunky15377953pl_unky
poignancy1752483poignancy
pointy114913283poi_nty
policy133211513poli__cy
potency1457433potency
prance104318573p_rance
pricy124814563pri__cy
primacy1635603primacy
prince104114763pri_nce
privacy1744233privacy
pudency1544763pudency
radiancy1445333radiancy
reliance10310473reliance
saliency13125393saliency
slangy105411393sl_angy
slanty95114843sl_anty
slinky13399103sli_nky
tenancy1237503tenancy
truancy1244993truancy
unfancy1545203unfancy
vacancy1744443vacancy
valiance1397383valiance
zincy195413513_zi_ncy

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.403443402.0
2DLD Change Limit1340271375.98622390.1
3Display Results1371370.0462978.3
 (SQL Overall)1786911376.43527768.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.