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

77 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
relics8451790(None) 
relic74623361relic_
relict83623901relict
relicts94414591relicts
relies65036421relies
belies84631052belies
beylics1436182beylics
celiacs11157892celiacs
colics104219902colics
cretics112911652cretics
delict94320332delict
delicts104012252delicts
delis64928542deli_s
epics95014282_epics
felids103111622felids
flics105418362_flics
frolics1236832frolics
helices12313722helices
helios94816632helios
irenics937832irenics
kelims1278912kelims
medics114115352medics
melic94722332melic_
pelvics14245642pelvics
prelims1139822prelims
rebecs103913672rebecs
rebids94015532rebids
recits83621352recits
recs65734182re__cs
redias74523602redias
redips93713842redips
refits94017652refits
reflies104418532reflies
regius7311922regius
reifs84819092re_ifs
reins56234562re_ins
reis45343232re_i_s
rejigs14368092rejigs
relace83122152relace
relaces93420882relaces
relays94316752relays
relets64025672relets
relied74926232relied
relief94419682relief
reliefs10439432reliefs
relier65826182relier
reliers75519212reliers
reline65434352reline
relines75331322relines
relink104415922relink
relinks114510222relinks
relish93916952relish
relist64628412relist
relists73817052relists
relit55340682reli_t
relive95120782relive
relives104619442relives
relock124713522relock
relocks134411292relocks
reluct83916112reluct
relucts9369672relucts
remiss84216352remiss
remits85622942remits
renigs74314592renigs
renins64526452renins
reoils64516872reoils
repins84924312repins
replica1137942replica
replicas1237092replicas
replies94521042replies
rerigs74014792rerigs
resids74219152resids
resins64528772resins
resits64725562resits
reties65436192reties
rewins95020822rewins
telic76019822telic_

Search took 3 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 Filter178691825510.376475242.0
2DLD Change Limit82551772.53032628.9
3Display Results77770.0332333.3
 (SQL Overall)178691772.93960799.9
 
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.