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

95 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
receptions144974(None) 
deceptions1547861deceptions
reception13410321reception_
deception1448322deception_
exceptions2146862exceptions
inceptions1448532inceptions
perceptions1798192perceptions
recautions1247812recautions
recensions1248482recensions
receptionist1656402receptionist
receptors1356922recept_ors
recessions1248932recessions
recreations13412252recreations
redemptions1643732redemptions
refections151811642refections
rejections191510102rejections
resections121513032resections
retentions101611112retentions
captions123813223__captions
conceptions17410593conceptions
deceptional1654773deceptional
decoctions1547143decoctions
decryptions1943613decryptions
defections161510203defections
dejections20168353dejections
deletions102610933dele_tions
desertions1139883desertions
detections131410043detections
detentions11148803detentions
egestions1046703_egestions
ejections18249963_ejections
elections112414973_elections
erections112515213_erections
eruptions1146763_eruptions
evections142510693_evections
exception2046853exception_
excerptions2244983excerptions
exemptions2164833_exemptions
exertions1639763_exertions
inception1348693inception_
lections102413843lec__tions
perception1688613perception_
precautions1546553precautions
preceptors1657053precept_ors
precessions1548553precessions
preemptions17134853preemptions
prelections151210473prelections
preoptions1447643pre_options
preventions1648533preventions
reactions11711713re_actions
rebellions1244203rebellions
recaution1148093recaution_
receipting1546753receipti_ng
receiptors1443653receipt_ors
recension1148863recension_
receptionists1754773receptionists
receptive1648323recepti_ve
receptor1256693recept_o_r
recepts113010263recept___s
recession1149103recession_
recisions1139913rec_isions
recitations13314203recitations
reclusions1246243reclusions
reconceptions1965123reconceptions
recreation12413613recreation_
recursions1245403recursions
redactions1359133redactions
redemption1543883redemption_
reductions1359583reductions
reeditions1147653reeditions
reelections13167943reelections
refection141512283refection_
reflations13311233reflations
reflections16178553reflections
rejection181710253rejection_
relations92418333re_lations
relegations1248973relegations
relictions12310023relictions
remotions1149703re_motions
renditions1149183renditions
repetitions1378023repetitions
repletions1247473repletions
resection111613273resection_
resorptions1347233resorptions
restations10315843restations
resumptions15154593resumptions
retention91611483retention_
retortions1049143retortions
revelations14410303revelations
reversions1347573reversions
ructions102811683ruc__tions
secessions1246463secessions
secretions12117853secretions
sections102714703sec__tions
selections12310873selections

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 Filter1786911406030.436409841.7
2DLD Change Limit140603956.86020496.1
3Display Results95950.0462065.2
 (SQL Overall)178691957.34224338.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.