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

212 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
plainest1031361(None) 
fainest10417702_fainest
paliest93021602pali_est
plaices11411142plaices_
plained103812232plaine_d
plainer93811982plaine_r
plainness1155182plainness
plains85019592plain_s_
plaint85323202plain__t
plaintext1863422plaintext
plaints94012052plaints_
planes85028082pla_nes_
planet84228352pla_ne_t
planets93914082pla_nets
platiest103216082platiest
vainest10315762_vainest
against838383again_st
airest63825263__airest
alanines8314803alanines_
alines65735223al_ines_
alkines114415733alkines_
alpines94016193alpines_
alpinist1059153alpinist
blackest16269303blackest
blains84516373blain_s_
blandest113811043blandest
blankest14439063blankest
blindest11609093bl_indest
brainiest11209723brainiest
chaines124518733chaines_
clarinet10317293clarine_t
clarinets1137683clarinets
clayiest1337913clayiest
cleanest10310293cleanest
clines84926043cl_ines_
delaines9312963delaines_
divinest123012173divinest
earnest7318733_earnest
elains64919853elain_s_
elmiest9310743elmi_est
faintest1139073_faintest
fairest10412293_fairest
finest94321733__finest
flakiest153210543flakiest
flakiness1636473flakiness
flamiest133111973flamiest
flamines13311643flamines_
flanes94522423fla_nes_
flatness1138153flatness
flattest1138713flattest
flavines1437893flavines_
flawiest14298573flawiest
flaxiest18298183flaxiest
fliest94718433fl_i_est
frailest1139493frailest
gainst74914693_gain_st
gladdest11145843gladdest
gladiest101710333gladiest
gladness1036153gladness
glaiket1238363glaike_t
glaires84010133glaires_
glairiest1035483glairiest
glaives11347833glaives_
glariest92012523glariest
glariness1038553glariness
glasnost944953glasnost
glaziest18227913glaziest
glaziness1935753glaziness
gluiest839773glui_est
gluiness937363gluiness
grainiest10188993grainiest
inanest72115363ina_nest
laciest93819033_laciest
laciness102112553_laciness
lakiest113517263_lakiest
lamest84722763_la_mest
lanes54946793_la_nes_
lankest112714113_lankest
largest83715103_largest
latest63822703_la_test
lawines103313563_lawines_
laxest134913363_la_xest
laxness1436043_laxness
laziest163814473_laziest
laziness17239983_laziness
leanest7415863_leanest
lianes63819323_lianes_
likest104914383_l_ikest
lines57054573_l_ines_
liniest73321153_l_iniest
livest95315733_l_ivest
luniest73516993_luniest
malines93625603malines_
meanest9315703mea_nest
naivest10309473_naivest
oleines7313393oleines_
opalines10311423opalines_
paciest112917803p_aciest
pained95622853p_aine_d
painless10108343p_ainless
pains75138283p_ain_s_
paint75443693p_ain__t
paintiest11310563p_aintiest
paints85921833p_aints_
palatines11313033palatines_
paleness10312983paleness
palest83926223p_a_lest
palings103915823palings_
palliest102814633palliest
palmiest123212023palmiest
panes76148693p_a_nes_
pannes85522853p_annes_
patines95225763patines_
patness92912283p_atness
peakiest143512993peakiest
peartest10311303peartest
peatiest103118803peatiest
phattest1336913phattest
phoniest132811533phoniest
pianist9615103pia_nist
pines76048863p__ines_
piniest93121133p__iniest
pinkest132812623p__inkest
pipiest113114493pipi_est
pipiness1238003pipiness
pixiness1736093pixiness
places104323703pla_ces_
placet103923673pla_ce_t
placets113911223pla_cets
placidness1553303placidness
placket15412873placke_t
plackets1646583plackets
plages94520153pla_ges_
plagues103311063plagues_
plaice10311553plaice__
plaided11409643plaide_d
plaids94312443plai_ds_
plain74823303plain___
plaining113911553plaining
plainly1236473plain_ly
plaintexts1971343plaintexts
plait75631573plai___t
plaited103713893plaite_d
plaiter93615393plaite_r
plaiters103512633plaiters
plaits83816473plai_ts_
plane74929143pla_ne__
planed94420913pla_ne_d
planeness1138153planeness
planer84122653pla_ne_r
planers94517943pla_ners
plangent1138803plangent
planish12412053pla_nish
planks124116753pla_nks_
planless1036813planless
planned103810153planne_d
planner93511623planne_r
planners10399933planners
plans75731273pla_n_s_
plant75437113pla_n__t
plants84921803pla_nts_
plaques18317893plaques_
plashes124417393plashes_
plashiest1478373plashiest
platanes102711883platanes_
platens94213983platens_
plates85432243pla_tes_
platies93722543platies_
platinas103610313platinas_
platings113611363platings_
playless1334863playless
playlet1239523playle_t
playlets1334903playlets
playlist1347573playlist
plenist9314333pl_enist
pliant83918823plian__t
plies74526513pl_i_es_
plinks124913263pl_inks_
plumiest122110293plumiest
plummest14276413plummest
plumpest14236353plumpest
plushest13328283plushest
pokiest133314913poki_est
pokiness14219863pokiness
politest10312943politest
porniest103214313porniest
poxiest163412253poxi_est
praises94121103praises_
pralines102217723pralines_
priest84125423p_ri_est
pulpiest1258433pulpi_est
pulpiness1335603pulpiness
puniest92918093puni_est
puniness101610273puniness
punniest102511583punniest
purines94420763purines_
quaintest1845343quaintest
rainiest81214923_rainiest
salines74029413salines_
sanest64426693_sa_nest
slackest14289393slackest
slatiest82616263slatiest
slatiness92511363slatiness
sliest66621953sl_i_est
splines94718893spl_ines_
staidest939803staidest
tannest72617853_tannest
trapnest10310923trapnest
valines104520213valines_
waniest103819113_waniest
wannest103915003_wannest
zaniest163214773_zaniest

Search took 9 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 Limit1461622127.79618748.3
3Display Results2122120.0932279.6
 (SQL Overall)1786912128.04522211.4
 
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.