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

128 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
reliction1131069(None) 
relictions12310021relictions
depiction1437272depiction
dereliction1444572dereliction
election102015352_election
eviction13228682_eviction
prediction15410302prediction
prelection141511282prelection
reaction10612602re_action
redaction1259662redaction
reduction1259902reduction
reelection12198632reelection
refection141512282refection
reflection15168992reflection
rejection181710252rejection
relation82619772rel_ation
religion996742reli_gion
relocation12312112relocation
replication15712012replication
resection111613272resection
selection11311272selection
addiction13146013addiction
affliction1843543affliction
bilection13156803bilection
bolection13117673bolection
ciliation111112493ciliation
decoction1447523decoction
dedication14311963dedication
deduction1377073deduction
defection151610643defection
deflection16147733deflection
dejection19178663dejection
delation92318083del_ation
deletion92011973del_etion
depictions1546893depictions
derelictions1544333derelictions
detection121310413detection
deviation13312393deviation
diction102313053__diction
edition8310853_edi_tion
eduction1169053_eduction
ejection172510043_ejection
elation73620453_el_ation
elections112414963_elections
electron102611403_electron
elicitor1045773_elicitor
elision72311103_eli_sion
elocution1145673_elocution
elution72913823_el_ution
erection102115513_erection
evection131910833_evection
evictions14228623_evictions
exaction1738953_exaction
fellation1238843fellation
fiction122010733__fiction
filiation121110243filiation
flection13239563_flection
foliation121110793foliation
friction1347913_friction
gelation93014433gel_ation
helicon1237643helic__on
helictite1445973helictite
indiction1239803indiction
infliction1545943infliction
lection92614863__lection
lenition8310083leni_tion
mediation12312293mediation
medication15411173medication
peltation11312963peltation
petition10711753peti_tion
plication13311683_plication
predication16412433predication
predictions1649643predictions
preelection15136483preelection
prelections151210443prelections
prelibation15128663prelibation
radiation10313393radiation
reactions11711713re_actions
realization20417213realization
recaution1148093recaution
reception13410303reception
recision10310273reci_sion
recitation12315943recitation
redactions1359133redactions
redirection1446033redirection
reductions1359583reductions
reedition1047833reedition
reelections13167943reelections
refections151811633refections
reflation12412333reflation
reflections16178553reflections
refraction15137903refraction
reification16412903reification
rejections191510093rejections
relations92418333rel_ations
relaxation1746453relaxation
relegation11610023relegation
relict83623903relict___
relicts94414593relict__s
religions1086603reli_gions
relisting102414353relisting
relocations13311133relocations
reluctation1347963reluctation
relucting1239773relucting
remission1147333remission
remotion10410233re_motion
rendition1058933rendition
repletion1147693repletion
replications16811053replications
replicon1244323replic__on
resections121513023resections
restation9316913restation
restriction1349363restriction
retaliation11612323retaliation
retention91611483retention
retortion949673retortion
retraction121310533retraction
revision1138713revi_sion
revocation15410813revocation
ruction93611613r__uction
section92515663se__ction
sedition939333sedi_tion
seduction1266983seduction
selections12310873selections
seriation9318063seriation
stiction1038813_stiction
striction1148983striction
volition1179173voli_tion

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 Limit1486411287.61019532.3
3Display Results1281280.0632031.7
 (SQL Overall)1786911287.84322783.5
 
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.