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

66 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
agraffe144333(None) 
agrafe1038091agra_fe
agraffes1553041agraffes
agrafes1137522agrafes
gaffe124111652_g_affe
giraffe1442992giraffe
griffe13438092_griffe
abrade9313053abra_de
aerate64830553aera_te
agapae9388043ag_apae
agape85614843ag_a_pe
agarose838673agarose
agate66525153ag_a_te
agave95314033ag_a_ve
agaze156113663ag_a_ze
aggrade1035643aggra_de
aglare7312433agla_re
agnate73314883agna_te
agorae7511203agora__e
agrapha1345133agrapha
agravic1345893agravic
agree65226033agr__ee
airfare1047243airfare
arable81821003a_rable
arame75026623a_ra_me
arrange838683arrange
aurae54128113aura__e
aurate64426473aura_te
carafe115416163cara_fe
draff125615663_draff_
draffs13617903_draffs
draffy16486633_draffy
gaff114828153_g_aff_
gaffed144210203_g_affed
gaffer134310133_g_affer
gaffes134811103_g_affes
gaffs124914653_g_affs
garage8314513gara_ge
giraffes1542603giraffes
grace85124543_gra_ce
grade75126093_gra_de
graft95327203_gra_ft
grafted124110223_grafted
grafter114211153_grafter
grafts105013253_grafts
gramme114210333_gramme
grange83716203_grange
grape84824663_gra_pe
grate64932883_gra_te
grave94624873_gra_ve
graze155820053_gra_ze
griff124416463_griff_
griffes14367923_griffes
griffs13398993_griffs
gruff124712143_gruff_
gruffed1544943_gruffed
gruffer1475793_gruffer
gruffs13337453_gruffs
gruffy16396013_gruffy
piaffe1494913_piaffe
raff104933043__raff_
raffle123910703__raffle
raffs115017523__raffs
ruffe114713813__ruffe
strafe95215983stra_fe
truffe1276233_truffe

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.406440125.6
2DLD Change Limit134027667.04619021.7
3Display Results66660.0302200.0
 (SQL Overall)178691667.48223882.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.