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

208 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
plainly123647(None) 
gainly1049322_gainly
mainly11411492_mainly
painty114714752p_ainty
placidly1644162placidly
plain74823302plain__
plained103812232plained
plainer93811982plainer
plains85019592plain_s
plaint85323202plain_t
plaints94012052plaints
pliably14147382pliably
pliancy1435592pliancy
pliantly1345782pliantly
plyingly1734502plyingly
vainly1258502_vainly
alanyl955483ala_nyl
alienly1037503alienly
alpinely1344343alpinely
bairnly1234503_bairnly
blackly1835253blackly
blain75421793blain__
blains84516373blain_s
blandly1336043blandly
blankly1634263blankly
blarney12174763blarney
blazingly2444473blazingly
blindly1335743bl_indly
brainily1337313brainily
brainy114815643brain_y
clanky15469073cla_nky
cleanly1236323cleanly
clingy12659063cl_ingy
daily95922333_dai_ly
dainty105311473_dainty
elain55324703elain__
elains64919853elain_s
faintly1337083_faintly
fairly125610013_fairly
flail85316183flai_l_
flails94313003flai_ls
flakily1736293flakily
flamingly1845023flamingly
flaringly1646253flaringly
flatly123110213fla_tly
flaunty1354413flaunty
flinty126112493fl_inty
fluidly1434813fluidly
frailly1337313frailly
gaily95020973_gai_ly
gladly11497933gla_dly
glairy10448273glai_ry
glaringly1445823glaringly
glazily2035383glazily
glibly1236293gl_ibly
glinty106910693gl_inty
gluily10308293glui_ly
grainy103914213grain_y
inly75622213___inly
lacily11612763_lacily
lain46146283_lain__
lairdly1134913_lairdly
laithly1335653_laithly
laity85318903_lai_ty
lamely114013223_lamely
lanely93914483_lanely
lankly13439623_lankly
lanky125517483_la_nky
lastly93310873_lastly
lately93413843_lately
lawny115912013_lawn_y
laxly15610103_la_xly
lazily1859713_lazily
leanly93811503_leanly
lily76730183_l_i_ly
lindy96918313_l_indy
liney87029633_l_iney
lingy96925143_l_ingy
linky127622383_l_inky
linty87126563_l_inty
liny78141323_l_in_y
lyingly14115263_lyingly
malignly1444683malignly
manly105022953_ma_nly
meanly115412043mea_nly
packly17228333p_ackly
pail66141833p_ai_l_
pails75833063p_ai_ls
pain65647243p_ain__
painch133511323p_ainch
pained95622853p_ained
pains75138283p_ain_s
paint75443693p_ain_t
paints85921833p_aints
paisley1235553p_aisley
palely11311933p_alely
paling93530133palin_g
palings103915823palings
pallidly1444063pallidly
pally105727123p_a_lly
paly95835533p_a__ly
pandy115021173p_a_ndy
pansy105717973p_a_nsy
panty105929303p_a_nty
partly116315473p_artly
patly105020583p_a_tly
pearly116414843pea_rly
peartly1267453peartly
phonily1537103phonily
pily96132733p__i_ly
piney105727503p__iney
pinkly155012243p__inkly
pinky145823403p__inky
pinny105222063p__inny
piny911838353p__in_y
pipingly1635703pipingly
placably17156673placably
placing123815283placin_g
plagal948573plagal_
plagiary1443643plagiary
plaguey13335943plaguey
plaguily1443513plaguily
plaguy12386413pla_guy
plaice10311553plai_ce
plaices11411143plaices
plaid85118303plai__d
plaided11409643plaided
plaids94312443plai_ds
plainest10313613plainest
plaining113911553plaining
plait75631573plai__t
plaited103713893plaited
plaiter93615393plaiter
plaits83816473plai_ts
plan65833943pla_n__
planar84212713pla_nar
planch133711443pla_nch
plane74929143pla_n_e
planed94420913pla_ned
planer84122653pla_ner
planes85028083pla_nes
planet84228353pla_net
planing103418253planing
planish12412053planish
plank115221143pla_n_k
planks124116753pla_nks
planned103810153planned
planner93511623planner
plans75731273pla_n_s
plant75437113pla_n_t
plants84921803pla_nts
planula935773planula
plashy14448873pla_shy
plasticly1644763plasticly
platina94413643platin_a
platinas103610313platinas
plating103823073platin_g
platings113611363platings
platinic1237073platinic
platinum1245443platinum
platy105021663pla__ty
plausibly1643113plausibly
play95928983pla___y
playboy1743813playboy
playday1643823playday
playing133816093playin_g
pleadingly1793383pleadingly
pleasingly1644163pleasingly
plenty11311413pl_enty
pliable111610323pliable
pliant83918823plian_t
plink115219123pl_in_k
plinks124913263pl_inks
plinth11310453pl_inth
plisky1533713pl_isky
ploidy1237483ploi_dy
plumply1634223plumply
plunky15377953pl_unky
plushly15385383plushly
plying124312083plyin_g
pointy114913283p_ointy
pokily15309063poki_ly
posingly1436933posingly
pratingly1538363pratingly
primly13439623p_rimly
pryingly1735543pryingly
pulingly1436803pulingly
pulpily1436103pulpi_ly
punily11311773puni_ly
quaintly2065023quaintly
rainily10310433_rainily
rainy85921083_rain_y
saintly1039343_saintly
slackly1635263slackly
slain54923573slain__
slainte738543slainte
slangy105411393sla_ngy
slantly10399323slantly
slanty95114843sla_nty
slily85820033sl_i_ly
slimly11408903sl_imly
slinky13399103sl_inky
staidly1136683staidly
thinly1238673_thinly
ungainly1244423ungainly
validly1435573validly
wanly115118023_wa_nly
zanily18310183_zanily

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272086.75019855.9
3Display Results2082080.0802600.0
 (SQL Overall)1786912087.23624694.7
 
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.