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

122 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
percepts1424764(None) 
percents122713371percents
percept133112521percept_
precepts14268891precepts
excepts1885202_excepts
percent113520602percent_
perfects15107352perfects
periapts1237272periapts
perpents122312042perpents
perverts1337532perverts
precents123015042precents
precept133112512precept_
recepts113010262re_cepts
tercets93512442terce_ts
accepts13356353_accepts
aperients1178253aperients
berets85822523ber_e_ts
cermets1139713cerme_ts
concepts143110303concepts
deceits102810883de_ceits
decrypts1642943decrypts
descents112511203descents
discepts1336743discepts
erects84116183_er_ects
erupts8348903_er_upts
except1797653_except_
excerpts1943743_excerpts
ferments13311473ferments
ferrets103111393ferre_ts
forceps14466983forcep_s
gerents82612923ger_ents
incepts11238283_incepts
intercepts1448633intercepts
mercapto1443313mercapto
mercers114412773merce_rs
merces105720743merce__s
operceles1344613operceles
parapets1239763parapets
parcels113712663parce_ls
parents93418123par_ents
pargets105215193parge_ts
peaces106324083peace__s
peacoats1247833peacoats
peeps95822363pe__ep_s
pellets94014783pelle_ts
pelmets11309693pelme_ts
pencels113610053pence_ls
pendents1139413pendents
percales12313803percales
perceive1546973perceive
perceives1646313perceives
percental1348663percental
perception1688613perception
perceptions1798193perceptions
perceptive1946803perceptive
perceptual1653603perceptual
perchers153611523perchers
perches143717953perc_hes
percoids1339663percoids
percuss1137163perc_uss
pereons92815003per_eons
peres76246643per_e__s
perfect141010833perfect_
perfecta15115203perfecta
perfectas16135073perfectas
perfecto15105743perfecto
perfectos16106073perfectos
perhaps1446123perhap_s
periapt11313413periapt_
pericopes1547873pericopes
peridots1138323peridots
peripety1546193peripety
permeate12311613permeate
permeates13311773permeates
permits11314003per_mits
perpends13227753perpends
perpent112318813perpent_
perps95521483per__p_s
persalts1038193persalts
perses85428063perse__s
persists1049183persists
pertest9317043pertest_
pervert12315583pervert_
piercers12316723pierce_rs
pierces113411193pierce__s
placets113911223place_ts
portents103512823portents
precasts1239453precasts
precedes13310713precedes
precent113520263precent_
preceptor1547323preceptor
preceptors1657053preceptors
precess11310863prece_ss
precipes143212213precipes
precuts111710473prec_uts
preempts1444543preempts
prefects1598133prefects
preheats1339413preheats
prelects1299723prelects
preps96220693p_r_ep_s
presents103315643presents
presets94216423prese_ts
prests84021263p_r_ests
pretests10310013pretests
pretexts1735603pretexts
prevents133012293prevents
priests93810863p_riests
prompts1337473p_rompts
reaccepts1583213reaccepts
receipts1274693re_ceipts
recept103319073re_cept_
rerents73319423rer_ents
secrets9311773secre_ts
serpents102410373serpents
tercelets1144813tercelets
tercels94110363terce_ls
terces83921413terce__s
tercet83624913terce_t_
terrets72913583terre_ts
versets103913103verse_ts
vervets13419753verve_ts
wergelts1253413wergelts

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.420425454.8
2DLD Change Limit1461621227.93618417.6
3Display Results1221220.0631936.5
 (SQL Overall)1786911228.41921224.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.