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

101 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
graphic153735(None) 
agraphic1646181agraphic
graphics1645651graphics
agraphia1445242agraphia
digraphic1845512digraphic
edaphic1544242edaphic
glyphic1844062glyphic
gnathic1344842gnathic
graph115315612graph__
graphed1498472graphed
graphemic1943612graphemic
graphical1745882graphical
graphing1538532graphing
graphite1447152graphite
graphitic1744792graphitic
graphs124510152graph_s
graplin1058442graplin
orphic1368322or_phic
raphia113511262_raphia
raphis114014322_raphis
seraphic1546632seraphic
trophic14311032trophic
agapeic1244713agapeic
agrapha1345133agraph_a
agraphias1545073agraphias
agravic1345893agra_vic
aphid115515393__aphid
aphis105917133__aphis
arabic10312733ara_bic
atrophic1549373atrophic
biographic2047443biographic
brachia141910423brachia
capric12411803_capric
crappie13298983crappie
cryptic1646153cryptic
delphic1545103delphic
drastic10310873drastic
epigraphic2055333epigraphic
erethic1257723erethic
frantic12310363frantic
gallic9411643g_allic
gamic103916203g_a_mic
garlic9310043g_arlic
geographic1947753geographic
glyptic1544503glyptic
gothic1237793g_othic
gradin83517483gra_din
graham1237853gra_ham
grail64622873gra__il
grain65126253gra__in
granitic1168623granitic
grannie8310353grannie
grape84824663grap__e
grapery13457953grapery
grapes95123123grap_es
grapey126012303grap_ey
grapheme1644013grapheme
graphemics2052583graphemics
graphites1546823graphites
grapier103712603grapier
grapline1138723grapline
graplins1148263graplins
grapnel1035603grapnel
grappa11396443grap_pa
grappas12357103grappas
grapple12378003grapple
grapy115416433grap__y
gratin74520583gra_tin
gratis74819243gra_tis
gravid113710983gra_vid
grumphie1642763grumphie
grushie1135813grushie
gryphon1643873gryphon
haptic13511893_haptic
morphic1648693morphic
orographic1849073orographic
practic13312243practic
priapic1346023priap_ic
rabic93817403_ra_bic
rachis114017653_rachis
raphae114311733_raphae
raphe104916423_raph_e
raphes115117453_raphes
raphias123511083_raphias
raphide13138073_raphide
rapid86422033_rap_id
sapphic1644553sapphic
seraphim1544803seraphim
seraphin1345953seraphin
spathic1437543spathic
strophic1569003strophic
sylphic1745883sylphic
teraphim1545003teraphim
traffic1544733traffic
tragic93811543tra_gic
trigraphic1854763trigraphic
tropic103014193trop_ic
tryptic1446003tryptic
uraemic1156543uraemic
uranic82315183ura_nic
uratic83016353ura_tic

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271017.33018284.7
3Display Results1011010.0303366.7
 (SQL Overall)1786911017.78322959.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.