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

154 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
resection11161327(None) 
refection141512281refection
rejection181710251rejection
resections121513021resections
bisection13136982bisection
defection151610642defection
dejection19178662dejection
desertion10410202desertion
detection121310412detection
ejection172510042_ejection
election102015352_election
erection102115512_erection
evection131910832_evection
exsection1847492exsection
prelection141511282prelection
reaction10612602re_action
reception13410302reception
redaction1259662redaction
reduction1259902reduction
reelection12198632reelection
refections151811632refections
reflection15168992reflection
rejections191510092rejections
reliction11310692reliction
resecting122816482resecting
restation9316912restation
retention91611482retention
section92515662__section
selection11311272selection
trisection1245982trisection
abjection2045323abjection
advection1545553advection
affection1745893affection
assertion946723assertion
bijection20134793bijection
bilection13156803bilection
bisections14136733bisections
bolection13117673bolection
caseation1199513caseation
cessation1176853cessation
deception1448313deception
decoction1447523decoction
deduction1377073deduction
defecation1679803defecation
defections161510203defections
deflection16147733deflection
dejections20168353dejections
deletion92011973dele_tion
depiction1437273depiction
desecration14410063desecration
desertions1139883desertions
detections131410033detections
detention10169543detention
direction1289763direction
dissection13158603dissection
eduction1169053_eduction
egestion946863_egestion
ejections18249963_ejections
elections112414963_elections
electron102611403_electron
erections112515193_erections
evections142510693_evections
eviction13228683_eviction
exaction1738953_exaction
execution1846303_execution
exertion15310083_exertion
exsections1947633exsections
exsertion1646853exsertion
flection13239563_flection
gestation10310663gestation
infection14410473infection
injection1838653injection
insertion9410593insertion
inspection1446663inspection
lection92614863__lection
midsection1544413midsection
objection2045093objection
perfection1748363perfection
persecution1564783persecution
prediction15410303prediction
preelection15136483preelection
prelections151210443prelections
preselection16154883preselection
prevention1549163prevention
projection2158753projection
prosecution1546063prosecution
protection14511453protection
reactions11711713re_actions
reassertion1154023reassertion
rebellion1144723rebellion
recaution1148093recaution
recension1148863recension
receptions1449713receptions
recession1149093recession
recreation12413613recreation
redactions1359133redactions
redemption1543883redemption
redirection1446033redirection
reductions1359583reductions
reedition1047833reedition
reelections13167943reelections
refecting152413353refecting
refective1749113refective
reflation12412333reflation
reflections16178553reflections
refraction15137903refraction
reinfection1645443reinfection
reinjection2044583reinjection
reinsertion1145443reinsertion
reinspection1653263reinspection
rejecting192211153rejecting
rejective2148253rejective
rejector17237723reject_or
relation82619773re_lation
relegation11610023relegation
relictions12310023relictions
relocation12312113relocation
remotion10410233re_motion
rendition1058933rendition
repetition1278233repetition
repletion1147693repletion
reseason844933rese_ason
reseating102421533reseating
resect84424703resect___
resected112514743resect_ed
resects94115593resect__s
resenting102619293resenting
resentive12410723resentive
reservation1489143reservation
resetting102816293resetting
resolution1097733resolution
resorption1247253resorption
respecting1549883respecting
respective1747623respective
restations10315843restations
restriction1349363restriction
resumption14124733resumption
resurrection1453353resurrection
retentions101611103retentions
retortion949673retortion
retraction121310533retraction
revelation13410923revelation
reversion1248093reversion
revocation15410813revocation
ruction93611613r__uction
sections102714703__sections
seduction1266983seduction
selections12310873selections
subsection1496783subsection
suction93713043__suction
trajection1944693trajection
transection1357363transection
trisections1345633trisections
venesection1652943venesection

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 Filter1786911486410.1701051123.5
2DLD Change Limit1486411547.16020759.9
3Display Results1541540.0762026.3
 (SQL Overall)1786911547.40624127.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.