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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
reception1341033(None) 
deception1448321deception
receptions1449741receptions
deceptions1547862deceptions
exception2046852exception
inception1348702inception
perception1688612perception
recaution1148092recaution
recension1148862recension
receptive1648332receptive
receptor1256702recept_or
recession1149102recession
recreation12413612recreation
redemption1543882redemption
refection141512282refection
rejection181710252rejection
resection111613272resection
retention91611482retention
caption113513693__caption
conception16410453conception
deceptional1654773deceptional
deceptive1746853deceptive
decoction1447523decoction
decryption1843743decryption
defection151610643defection
dejection19178663dejection
deletion92011973dele_tion
desertion10410203desertion
detection121310413detection
detention10169543detention
egestion946863_egestion
ejection172510043_ejection
election102015353_election
erection102115513_erection
eruption1047043_eruption
evection131910833_evection
exceptions2146863exceptions
excerption2145063excerption
exemption2064943_exemption
exertion15310083_exertion
inceptions1448533inceptions
lection92614863lec__tion
perceptions1798193perceptions
precaution1447243precaution
preceptive1947763preceptive
preceptor1547323precept_or
precession1448823precession
preemption16105253preemption
prelection141511293prelection
preoption1348083pre_option
prevention1549173prevention
reaction10612603re_action
rebellion1144733rebellion
recautions1247813recautions
receipting1546753receipting
receiptor1343493receipt_or
recensions1248483recensions
recept103319083recept___
receptionist1656403receptionist
receptors1356933receptors
recepts113010273recept__s
recertify1743643recertify
recessions1248933recessions
recision10310273rec_ision
recitation12315943recitation
reclusion1146503reclusion
reconception1855653reconception
recreations13412253recreations
recursion1146153recursion
redaction1259663redaction
redemptions1643733redemptions
reduction1259903reduction
reedition1047833reedition
reelection12198633reelection
refections151811643refections
reflation12412333reflation
reflection15168993reflection
rejections191510103rejections
relation82619773re_lation
relegation11610023relegation
reliction11310693reliction
remotion10410233re_motion
rendition1058933rendition
repetition1278233repetition
repletion1147693repletion
resections121513033resections
resorption1247253resorption
restation9316913restation
resumption14124733resumption
retentions101611113retentions
retortion949673retortion
revelation13410923revelation
reversion1248093reversion
ruction93611613ruc__tion
secession1146703secession
secretion11118303secretion
section92515663sec__tion
selection11311273selection

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 Filter1786911486410.783228213.3
2DLD Change Limit148641987.95318689.9
3Display Results98980.0462130.4
 (SQL Overall)178691988.78220347.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.