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
perplex183614(None) 
people10310182people_
peopled1238492peopled
peopler1138072peopler
peoples11312212peoples
periled10316312periled
perplexed2143252perplexed
perplexer2042742perplexer
perplexes2044672perplexes
perspex1834172perspex
purple102712672purple_
purpled12299772purpled
purpler11289262purpler
purples112712822purples
complex2037243complex
diplex16408053_diplex
duplex16386973_duplex
ferule93413203ferule_
feruled11318413feruled
ferules103112723ferules
fourplex2042093fourplex
funplex1932833funplex
herpes115517323herp_es
hirple11158973hirple_
hirpled13157133hirpled
hirples12149643hirples
megaplex2042513megaplex
merle75824373mer_le_
merles85322763mer_les
metroplex2043443metroplex
parle75836163par_le_
parled94626283par_led
parles86334403par_les
parley116718353par_ley
parole84425253parole_
paroled104217623paroled
parolee94119633parolee
paroles95025883paroles
parsley1247793parsley
partlet92720363partlet
pealed95322803pe_aled
pearled10411543pearled
pearler9310373pearler
pebble1238003pebble_
pebbled1445393pebbled
pebbles1337573pebbles
pedaled113711883pedaled
pedaler103410693pedaler
peddle103512823peddle_
peddled123410533peddled
peddler113210493peddler
peddles112913703peddles
pedler93614613pe_dler
peeled94119703pe_eled
peeler83517383pe_eler
peeped113915383peep_ed
peeper103614803peep_er
pele65539553pe__le_
peles75738083pe__les
pellet83326553pe_llet
pemphix2342493pemphix
penile82219603penile_
peoplers1237153peoplers
pepla9312863pe_pl_a
peplos101211543pe_plos
peplum12156823pe_plum
peplus10138343pe_plus
pepped103113393pe_pped
pepper93512943pe_pper
peppier10268323peppier
percale11314093percale_
percales12313803percales
perched154713233perched
percher143313423percher
perches143717953perches
perdie94718513perdie_
perdue93912633perdue_
perdues103511333perdues
pere66450263per__e_
perea75026443per__ea
peres76246643per__es
periblem1445513periblem
perigee101113383perigee
peril75425953peril__
perilla9311223perilla
perilled11410103perilled
perils84121853peril_s
perinea9313033perinea
peripter1278753peripter
perked134617683per_ked
perkier133813123perkier
permed115217343per_med
perp89029893perp___
perpend12259343perpend
perpent112318803perpent
perplexers2142323perplexers
perplexing2243133perplexing
perplexity2452203perplexity
perps95521483perp__s
perries93226603perries
perse75429523per_se_
perses85428063per_ses
perter84422283per_ter
pertly115312543pertl_y
peruke123210393peruke_
peruked14367883peruked
perukes133210113perukes
peruse84016843peruse_
perused103112183perused
peruser93511373peruser
peruses94018163peruses
pestle83215843pestle_
pestled102711433pestled
pestles93217693pestles
petaled103614143petaled
petrale9312623petrale_
petrales10312983petrales
pettle84116053pettle_
pettled103611503pettled
pettles93916483pettles
pimple123512963pimple_
pimpled14289183pimpled
pimples133012423pimples
plex137321373___plex
pollex153711163p_ollex
popple92710983popple_
poppled11339233poppled
popples103011873popples
preplan1149953preplan
prepped11329893prepped
prepreg12165963prepreg
prex135722973p_r__ex
prole74527793p_role_
proleg94612113p_roleg
proles84627203p_roles
prolix1538683p_rolix
puerile9310093puerile_
purfle112511183purfle_
purfled13248723purfled
purfler12248733purfler
purfles122511843purfles
purled94520743pur_led
purplest12249123purplest
purply13369043purpl_y
pyrex175211213pyr__ex
reflex16359513re_flex
repled93319773re_pled
semple103212753semple_
simplex18256393simplex
telex125214823te__lex
temple102811333temple_
templed12278553templed
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.1401276364.3
2DLD Change Limit1340271566.98319193.3
3Display Results1561560.0463391.3
 (SQL Overall)1786911567.16924925.5
 
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.