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

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

100 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
relic7462336(None) 
melic94722331melic
relics84517901relics
relict83623901relict
relit55340681relit
telic76019821telic
areic73219392are_ic
atelic8313702atelic
aulic74420242aulic
belie75630382belie
beylic1337822beylic
celiac101910432celiac
ceric94023092ceric
colic95726172colic
cretic102816282cretic
deli55631292deli_
delict94320332delict
delis64928542delis
deltic9312502deltic
demic105119192demic
emic86422752_emic
epic86921302_epic
etic66123952_etic
felid94717172felid
felsic1147052felsic
flic96223732_flic
folic105319322folic
frolic1149202frolic
gelid74916982gelid
genic85119392genic
heliac111010892heliac
helio85321192helio
helix154413012helix
hemic125718622hemic
irenic8311102irenic
kelim11912552kelim
malic94525662malic
medic104619652medic
mesic93617862mesic
oleic7313332oleic
pelvic13307552pelvic
prelim10311422prelim
rabic93817402rabic
realia6314592realia
rebec94416542rebec
rebid85121362rebid
rec55645462re__c
recit75235102recit
redia65524482redia
redid74922392redid
redip87816962redip
refit84230062refit
refix155212482refix
rei35647252re_i_
reif76937652re_if
rein46040892re_in
reis45343232re_is
rejig133810122rejig
relace83122152relace
relaid75518442relaid
relax124817802relax
relay84424672relay
relet54749822relet
relicts94414592relicts
relied74926232relied
relief94419682relief
relier65826182relier
relies65036422relies
reline65434352reline
relink104415922relink
relish93916952relish
relist64628412relist
relive95120782relive
relock124713522relock
reluct83916112reluct
rely75428952rel_y
remit75737222remit
remix145916552remix
renig64518912renig
renin54830032renin
reoil55321182reoil
repin75324702repin
replica1137942replica
rerig64018482rerig
resid64124092resid
resin54131052resin
resit54241042resit
retia55326112retia
retie55735302retie
rewin85623962rewin
runic73615772runic
salic73424712salic
sepic94617052sepic
stelic8313082stelic
telia55821142telia
ureic74514462ure_ic
uremic103410512uremic
uretic82914352uretic
xenic144114642xenic
xeric144315662xeric

Search took 2 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 Filter178691538000.330541487.9
2DLD Change Limit538001001.51635488.1
3Display Results1001000.0303333.3
 (SQL Overall)1786911001.87695251.1
 
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.