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

(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
graft9532720(None) 
craft105327661craft
draft95526681draft
grafts105013251grafts
grant64840021grant
grat55651281gra_t
grift95924461grift
kraft125721011kraft
raft76245911_raft
abaft10318062abaft
aft66849012__aft
agrafe1038092agrafe
bract96332722bract
brant74742172brant
brat66055542bra_t
crafts115312742crafts
crafty14478912crafty
croft105622682croft
daft85537252_daft
draff125615662draff
drafts105012532drafts
drafty13638932drafty
drat56247832dra_t
drift95722842drift
engraft11118612engraft
frat75648542fra_t
gaff114828152g_aff
gait56150192g_ait
gast56052562g_ast
gat46880512g_a_t
ghast95621222ghast
ghat86435282gha_t
ghaut95919432ghaut
giant65430592giant
gift86735792g_ift
gnat56034432gna_t
goat56250832goa_t
graal64316502graal
grab75427612gra_b
grabs85719692grabs
grace85124542grace
grad66829862gra_d
grade75126092grade
grads75625752grads
grafted124110222grafted
grafter114211152grafter
grail64622872grail
grain65126252grain
gram77034582gra_m
grama85620282grama
gramp106218322gramp
grams85327312grams
gran56335012gra_n
grana65722092grana
grand75122692grand
grans64832542grans
grants73722472grants
grape84824662grape
graph115315612graph
grapy115416432grapy
grasp84814482grasp
grass66125202grass
grate64932882grate
grave94624872grave
gravy125512112gravy
gray85329892gra_y
grays95621332grays
graze155820052graze
great66034242great
greet65835322greet
griff124416452griff
grifts104511682grifts
griot65328412griot
gript85126172gript
grist65529872grist
grit55247242gr_it
groat65531972groat
grot55942052gr_ot
grout65330422grout
gruff124712142gruff
grunt65523542grunt
haft105941842_haft
ingraft1199482ingraft
krafts13438852krafts
krait94726772krait
kraut95221402kraut
prat65952042pra_t
raff104933042_raff
rafts87820632_rafts
rant45864672_rant
rapt67245312_rapt
rat37892742_ra_t
reft75141272_reft
regraft11310152regraft
rift75642332_rift
shaft115725252shaft
tract75635712tract
trait56940842trait
trapt76433392trapt
waft106139002_waft
wrapt105123182wrapt

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.0961861364.6
2DLD Change Limit538001011.40638264.6
3Display Results1011010.0303366.7
 (SQL Overall)1786911011.532116639.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.