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

156 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
perplex183615(None) 
people10310192people_
peopled1238502peopled
peopler1138082peopler
peoples11312222peoples
periled10316322periled
perplexed2143262perplexed
perplexer2042752perplexer
perplexes2044682perplexes
perspex1834182perspex
purple102712682purple_
purpled12299782purpled
purpler11289272purpler
purples112712832purples
complex2037243complex
diplex16408053_diplex
duplex16386973_duplex
ferule93413203ferule_
feruled11318423feruled
ferules103112723ferules
fourplex2042093fourplex
funplex1932833funplex
herpes115517323herp_es
hirple11158973hirple_
hirpled13157143hirpled
hirples12149643hirples
megaplex2042513megaplex
merle75824373mer_le_
merles85322763mer_les
metroplex2043443metroplex
parle75836163par_le_
parled94626293par_led
parles86334403par_les
parley116718363par_ley
parole84425253parole_
paroled104217633paroled
parolee94119643parolee
paroles95025883paroles
parsley1247803parsley
partlet92720363partlet
pealed95322813pe_aled
pearled10411553pearled
pearler9310373pearler
pebble1238003pebble_
pebbled1445403pebbled
pebbles1337573pebbles
pedaled113711893pedaled
pedaler103410693pedaler
peddle103512823peddle_
peddled123410543peddled
peddler113210493peddler
peddles112913703peddles
pedler93614623pe_dler
peeled94119713pe_eled
peeler83517383pe_eler
peeped113915393peep_ed
peeper103614803peep_er
pele65539553pe__le_
peles75738083pe__les
pellet83326553pe_llet
pemphix2342493pemphix
penile82219603penile_
peoplers1237163peoplers
pepla9312863pe_pl_a
peplos101211543pe_plos
peplum12156823pe_plum
peplus10138343pe_plus
pepped103113403pe_pped
pepper93512943pe_pper
peppier10268323peppier
percale11314093percale_
percales12313803percales
perched154713243perched
percher143313423percher
perches143717953perches
perdie94718513perdie_
perdue93912633perdue_
perdues103511333perdues
pere66450263per__e_
perea75026443per__ea
peres76246643per__es
periblem1445513periblem
perigee101113393perigee
peril75425953peril__
perilla9311233perilla
perilled11410113perilled
perils84121853peril_s
perinea9313033perinea
peripter1278753peripter
perked134617693per_ked
perkier133813123perkier
permed115217353per_med
perp89029893perp___
perpend12259353perpend
perpent112318813perpent
perplexers2142333perplexers
perplexing2243143perplexing
perplexity2452213perplexity
perps95521483perp__s
perries93226603perries
perse75429523per_se_
perses85428063per_ses
perter84422283per_ter
pertly115312553pertl_y
peruke123210393peruke_
peruked14367893peruked
perukes133210113perukes
peruse84016843peruse_
perused103112193perused
peruser93511373peruser
peruses94018163peruses
pestle83215843pestle_
pestled102711443pestled
pestles93217693pestles
petaled103614153petaled
petrale9312623petrale_
petrales10312983petrales
pettle84116053pettle_
pettled103611513pettled
pettles93916483pettles
pimple123512963pimple_
pimpled14289193pimpled
pimples133012423pimples
plex137321373___plex
pollex153711163p_ollex
popple92710983popple_
poppled11339243poppled
popples103011873popples
preplan1149953preplan
prepped11329903prepped
prepreg12165963prepreg
prex135722973p_r__ex
prole74527793p_role_
proleg94612113p_roleg
proles84627203p_roles
prolix1538683p_rolix
puerile9310093puerile_
purfle112511183purfle_
purfled13248733purfled
purfler12248733purfler
purfles122511843purfles
purled94520753pur_led
purplest12249133purplest
purply13369053purpl_y
pyrex175211213pyr__ex
reflex16359513re_flex
repled93319783re_pled
semple103212753semple_
simplex18256393simplex
telex125214823te__lex
temple102811333temple_
templed12278563templed
temples112610893temples
templet112712003templet
triplex16447803triplex
vertex1637373ver_tex

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.420425454.8
2DLD Change Limit1340271567.06318975.9
3Display Results1561560.0632476.2
 (SQL Overall)1786911567.54623680.2
 
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.