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 “perceptions” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

230 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
perceptions179819(None) 
perception1688611perception_
apperceptions1893032apperceptions
deceptions1547862de_ceptions
exceptions2146862_exceptions
perceptional1854902perceptional
perfections1848142perfections
permeations1549882permeations
receptions1449742re_ceptions
apperception1793463apperception_
conceptions17410593conceptions
deception1448323de_ception_
decryptions1943613decryptions
erections112515213_er_ections
eruptions1146763_er_uptions
exception2046853_exception_
excerptions2244983_excerptions
inceptions1448543_inceptions
interceptions1758183interceptions
misperceptions2262483misperceptions
percentiles1546203percentiles
perceptible1953633perceptible
perceptibly2253153perceptibly
perceptive1946803percepti_ve
percepts14247643percept___s
percolations1648053percolations
percussions1544873percussions
perditions1348873per_ditions
pereions10310853per_e__ions
perfection1748363perfection_
permeation14410563permeation_
perorations13314063perorations
persecutions1654793persecutions
perversions1645413perversions
precautions1546553precautions
preceptors1657053precept_ors
precessions1548553precessions
preemptions17134853preemptions
prelections151210473prelections
preoptions1447643p_reoptions
preventions1648533preventions
reception13410333re_ception_
recreations13412253recreations
secretions12117853secre_tions
abruptions1443844abr_uptions
accretions1444934accre_tions
aerations9317904aer__ations
arcuations1249344_arcuations
ascriptions1544984ascriptions
captions123813224___captions
conception16410454conception_
corrections1548874corrections
corruptions1555174corruptions
creations112614544_cr_eations
deceptional1654774de_ceptional
decoctions1547144de_coctions
decryption1843744decryption_
defecations1779004defecations
defections161510204de_fections
deflections17187324deflections
dejections20168354de_jections
deletions102610934de_le_tions
depletions1355744deple_tions
deprecations1748564deprecations
derivations15611494derivations
derogations1349394derogations
descensions1444374descensions
descriptions1755404descriptions
desertions1139884de_sertions
desorptions1445994desorptions
detections131410044de_tections
detentions11148804de_tentions
directions1379644dir_ections
egestions1046704_e_gestions
ejections18249964_e_jections
elections112414974_e_lections
encryptions1852964_encryptions
erection102115514_er_ection_
erepsins1037454_er_epsi_ns
eructations1347234_eructations
eruditions1146104_eruditions
eruption1047044_er_uption_
evections142510694_e_vections
excepting2145874_excepti_ng
exceptional2254444_exceptional
excerption2145064_excerption_
excretions1946624_excretions
executions1946394_executions
exemptions2164834_exemptions
exertions1639764_e_xertions
exsections1947634_exsections
exsertions1746744_exsertions
furcations1547534furc_ations
herniations1447404herniations
imperfections2254004imperfections
inception1348704_inception_
incretions1248654incre_tions
interception1649404interception_
irruptions1243894_irruptions
lections102413844le_c__tions
mercaptans1652074mercapt_ans
mercurations1646564mercurations
miscaptions1744184miscaptions
misperception2162874misperception_
nervations1359484ner_vations
operations12312954oper__ations
overcautions1755264overcautions
pactions122613504p_ac__tions
partitions1248334par_titions
peacetimes1643874peace_times
pectins112315234pe_c__ti_ns
peculations15310284peculations
peltations12311554pe_ltations
perceives1646314perce__ives
perceiving1844664perceivi_ng
percentages1653424percentages
percentile1447414percenti_le
percents122713374percent___s
percept133112524percept____
perceptively2454514perceptively
perceptiveness2354784perceptiveness
perceptivity2453424perceptivity
perceptual1653614percept_ual
percipient1655754percip_ient
percipients1753674percip_ients
percolation1549224percolation_
percussion1444994percussion_
perdition1249014per_dition_
peregrins1246964per_egri_ns
pereion9312054per_e__ion_
perennations1447254perennations
pereons92815004per_e___ons
perfecting1847514perfecti_ng
perfectionism2253984perfectionism
perfectionist2055334perfectionist
perfectives2145474perfectives
perfectos16106074perfect_o_s
perforations1747874perforations
perfusions1595334per_fusions
peripetias1446324peripeti_as
peripeties1448404peripeti_es
permeating1539924permeati_ng
permeators1447404permeat_ors
permissions1545334permissions
permutations1646504permutations
peroration12316004peroration_
perpetrations1746374perpetrations
perpetuations1754984perpetuations
persecution1564784persecution_
personations1448394personations
persuasions1383914persuasions
pervasions1545664per_vasions
perversion1545854perversion_
perverting1646624perverti_ng
petitions11511084pe__titions
placations1438584plac_ations
plications14310494plic_ations
porcelains1444384porcelai_ns
portions10514414por___tions
precaution1447244precaution_
precenting151012154precenti_ng
precentors1488344precent_ors
preceptive1947764precepti_ve
preceptor1547324precept_o_r
preceptory1945484precept_ory
precepts14268894precept___s
precession1448824precession_
precipitins1746174precipitins
precipitous1753924precipitous
precisions1449374prec_isions
preclusions1544664preclusions
preconceptions2253884preconceptions
predations13812154p_redations
predictions1649654predictions
preemption16105254preemption_
prehensions1645944prehensions
prelection141511294prelection_
prenotions1248294p_renotions
preoption1348084p_reoption_
preportions1548264preportions
prescriptions19135334prescriptions
presumptions18153884presumptions
pretensions1347084pretensions
pretentious13125594pretentious
preunions1146484p_r_eunions
prevention1549174prevention_
privations15310104p_rivations
proactions1449344p_roactions
probations14311084p_robations
processions1548154processions
procreations1647274procreations
projections2258474projections
promotions1448784p_romotions
pronations12314034p_ronations
prorations12314464p_rorations
protections15510704protections
punctations1585354punctations
purgations1346744pur_gations
quercetins2152594querce_ti_ns
reactions11711714reac__tions
recautions1247814re_cautions
recensions1248484re_censions
receptionist1656404re_ceptionist
receptors1356934re_cept_ors
recessions1248934re_cessions
reconceptions1965124reconceptions
recreation12413614recreation_
redemptions1643734redemptions
reelections13167944reelections
refections151811644re_fections
reflections16178554reflections
rejections191510104re_jections
repletions1247474reple_tions
resections121513034re_sections
resorptions1347234resorptions
resumptions15154594resumptions
retentions101611114re_tentions
secessions1246464se_cessions
secretins11108464secre_ti_ns
secretion11118304secre_tion_
sections102714704se_c__tions
selections12310874se_lections
seriations10316684ser_iations
serrations10313104ser_rations
sorptions1137124sor__ptions
speciations1548484spe_ciations
subreptions1545894subreptions
superventions18125784superventions
surjections2075284surjections
vernations13310334ver_nations

Search took 10 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 Filter1786911488190.436409841.7
2DLD Change Limit1488192308.90616710.0
3Display Results2302300.1401642.9
 (SQL Overall)1786912309.48218845.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.