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

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
to automatically increase the Change Limit after seconds.

87 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
epic8692130(None) 
emic86422751emic
epics95014281epics
etic66123951etic
pic76046821_pic
sepic94617051sepic
spic85227431spic
aspic95114732aspic
ceric94023092ceric
chic115925202chic
demic105119192demic
depict113514792depict
edict84722282edict
edit54934862edit
egis56520652egis
emir65918702emir
emit65438422emit
epact94921532epact
epee64628502epee
epha9310052epha
epical10413392epical
epoch1248202epoch
epos66723732epos
erica7316542erica
ethic101511222ethic
evict104417142evict
evil75318072evil
exec135313942exec
exit114428672exit
flic96223732flic
genic85119392genic
hemic125718622hemic
hic86540562_hic
huic94818052huic
kepi105315632kepi_
kepis115313362kepis
laic65931562laic
medic104619652medic
melic94722332melic
mesic93617862mesic
mic77647642_mic
odic74920572odic
optic93715182optic
otic66624822otic
pac79054082_pac
pec76744412_pec
pein65834942pein
peptic122113152peptic
pi48145362_pi_
pia56848032_pia
pica85831492_pica
pice84641092_pice
pick125933812_pick
pics85633912_pics
pie55457402_pie
pig65744972_pig
pin57066722_pin
pip78051042_pip
pis56362032_pis
pit56471922_pit
piu56639542_piu
pix126437932_pix
pyic116915822pyic
relic74623362relic
repin75324702repin
sepia75318672sepia
septic102713192septic
sic55847872_sic
spec85821972spec
spica94717942spica
spice95528812spice
spick134519072spick
spics94123242spics
spicy125417712spicy
spik105419712spik
spin66231302spin
spit65545082spit
spiv95917792spiv
telic76019822telic
tepid8314312tepid
tic56343462_tic
topic95721502topic
typic124511962typic
uric63624942uric
xenic144114642xenic
xeric144315662xeric
zoic152316072zoic

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 Filter178691298720.263679433.5
2DLD Change Limit29872870.86034734.9
3Display Results87870.0165437.5
 (SQL Overall)178691871.139156884.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.