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

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

119 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
relined8532193(None) 
reclined113613601reclined
redlined103811231redlined
refined114720001refined
reined74425521re_ined
relied74926231reli_ed
reline65434351reline_
relines75331321relines
relinked1337001relinked
relived115114681relived
repined104918771repined
resined84522651resined
alined75221402_alined
beelined11277712beelined
belied95022162beli_ed
bylined1335852bylined
declined123910882declined
defined123813822defined
delimed11310722delimed
elided84814672_elided
eloined8149812_eloined
ermined10410602ermined
feline94820142feline_
felines104718072felines
lined64934642__lined
peined94918842pe_ined
rained75024602r_ained
ravined115411822ravined
realigned1145332realigned
realised92214532realised
realized182514222realized
rebind94416922rebin_d
recaned102817202recaned
recited104319102recited
recline94020492recline_
recliner103211912recliner
reclines103718542reclines
recoined113614422recoined
redline84218832redline_
redliner93510472redliner
redlines93916082redlines
refiled114318652refiled
refind104717072refin_d
refine95225692refine_
refiner105316912refiner
refines105426342refines
refired115116992refired
refixed183611152refixed
regained102111242regained
rehinged1336852rehinged
rehired115013152rehired
reigned949212reigned
reinked1239792re_inked
reived104518132re_ived
rejoined16318592rejoined
relaced103517212relaced
reland75920432relan_d
relanded102410462relanded
related83327572related
relaxed153312522relaxed
relayed113212752relayed
relend76116452relen_d
relented92614942relented
relief94419672reli_ef
relier65826182reli_er
relies65036422reli_es
relieved12438512relieved
relink104415922relin_k
relinks114510222relinks
relished1239432relished
relisted9312622relisted
relive95120782relive_
relives104619442relives
reloaned939722reloaned
relumed1069812relumed
relumined1245362relumined
remained112412892remained
remind94819792remin_d
reminded123411522reminded
reminted113615082reminted
remised103516842remised
remixed173510742remixed
reoiled84316852reoiled
repine85627812repine_
repiner94816902repiner
repines94927382repines
repinned1157472repinned
replied103914442repli_ed
reshined123011122reshined
resided95217702resided
resigned1038862resigned
resiled84621982resiled
resited85122422resited
resized174614902resized
retained93016092retained
retied75924982reti_ed
retiled84420512retiled
retimed104714652retimed
retine66237332retine_
retines75134672retines
retinted94414362retinted
retinued95210822retinued
retired84620142retired
retuned86613972retuned
reviled114417922reviled
revised113815482revised
revived144211652revived
rewind104715882rewin_d
rewinded13277672rewinded
rewired115413282rewired
rexine134719442rexine_
rexines144719152rexines
rezoned173611162rezoned
rosined84911902rosined
ruined74813322r_uined
seined74023062se_ined
splined105013112splined
unlined82515802unlined
veined104413912ve_ined

Search took 5 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 Filter1786911076710.1431249587.4
2DLD Change Limit1076711194.15625907.4
3Display Results1191190.0462587.0
 (SQL Overall)1786911194.34541125.7
 
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.