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

51 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
graftage134368(None) 
graftages1443681graftages
driftage1342932driftage
waftage14115322_waftage
brakeage1544013brakeage
brassage1145283brassage
cartage10312593_cartage
chantage1446633chantage
draftable1575563draftable
draftee11379523draft_ee
drainage1045783drainage
drayage1234423dra_yage
driftages1453153driftages
frontage1296243frontage
frottage1245083frottage
fruitage1244343fruitage
garage8314513g_a_rage
garbage1138053g_arbage
gavage1137193g_a_vage
gradate9511233gra_date
graduate1058083graduate
graft95327203graft___
grafted124110223graft_ed
grafter114211153graft_er
grafters12409193grafters
grafting13319623grafting
grafts105013253graft__s
grandame1247113grandame
grange83716203gra__nge
grantable1257293grantable
grantee83217133grant_ee
grate64932883gra_t__e
gratine84719193gra_tine
gravitate1345543gravitate
graylag1283113graylag_
graylags1372983graylags
grillage1055613grillage
leafage1194573leaf_age
ragtag836643_ragtag_
ragtags935373_ragtags
rampage1237453_rampage
ravage1039303_ra_vage
restage83316193_restage
rootage839053_rootage
trackage1545653trackage
tractate10411003tractate
vantage11109893_vantage
waftages15105393_waftages
wantage11119623_wantage
wastage11109253_wastage
wattage1186983_wattage

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.456391866.2
2DLD Change Limit146162516.59322169.3
3Display Results51510.0301700.0
 (SQL Overall)178691517.07925242.4
 
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.