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

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

82 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
graphite144715(None) 
graphites1546821graphites
gnathite1244482gnathite
granite82017082gra_nite
grapheme1644012grapheme
graphic1537352graphi_c
graphics1645652graphics
graphing1538532graphing
graphitic1744792graphitic
graphitize2552662graphitize
grapline1138722grapline
raphide13138072_raphide
agraphia1445243agraphi_a
agraphias1545073agraphias
agraphic1646183agraphi_c
aplite8316393__aplite
brachiate1646873brachiate
braunite1047253braunite
crappie13298983crappi_e
elaphine1346113elaphine
gahnite1135973g_ahnite
garpike1435093garp_ike
geophyte1745053geophyte
gnathites1344233gnathites
gobshite1443273gobshite
goethite1244053goethite
gothite1146403g_othite
gracile102512603gra_cile
gradate9511233gra_date
gradine93317033gra_dine
graduate1058083graduate
graecize2044763graecize
graffiti1542983graffiti
graffito1542873graffito
granita82111303gra_nita
granites92116363gra_nites
grannie8310353granni_e
granulite1046923granulite
grape84824663grap___e
grapelike1644663grapelike
grapevine1543243grapevine
graph115315613graph___
graphed1498473graph_ed
graphemes1743633graphemes
graphical1745883graphical
graphitized2752183graphitized
graphitizes2652723graphitizes
graphs124510153graph__s
grapier103712603grap_ier
graplin1058443grapli_n
graplines1237353graplines
graplins1148263graplins
grapple12378003grap_ple
graptolite1353373graptolite
grate64932883gra___te
gratine84719193gra_tine
gratuity1244283gratuity
gravesite1344443gravesite
gravity1437183gra_vity
grumphie1642763grumphi_e
grushie1135813grushi_e
haplite12310703_haplite
ophite11410563__ophite
psephite1543843psephite
raphae114311733_raph_ae
raphe104916423_raph__e
raphia113511263_raphi_a
raphias123511083_raphias
raphides14188393_raphides
raphis114014323_raphi_s
rapine85023083_rap_ine
ratite65022423_ra_tite
rawhide14134973_rawhide
sulphite1346003sulphite
trachyte1645943trachyte
traplike1437653traplike
trapline10411863trapline
trephine1338933trephine
trichite1349333trichite
triplite1039103triplite
uralite71714103ura_lite
uranite72515693ura_nite

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 Filter1786911461620.500357382.0
2DLD Change Limit146162826.61022112.3
3Display Results82820.0302733.3
 (SQL Overall)178691827.14025026.8
 
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.