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

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

92 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
agree6522603(None) 
agee56241491ag_ee
aglee65728491aglee
agreed84712501agreed
agrees74915321agrees
gree56641561_gree
ackee115825362ackee
acre67330772acr_e
acred87126352acred
acres76327762acres
aerie54634602aerie
afreet9315152afreet
agape85614842agape
agate66525142agate
agave95314032agave
agaze156113662agaze
age47154332ag__e
aged67334252ag_ed
agene65621582agene
ager55935842ag_er
agers65027852agers
ages55844592ag_es
agger76420892agger
aggie73415012aggie
agile65122262agile
aglet65534142aglet
agley96917332agley
agone65924552agone
agorae7511202agorae
agrafe1038092agrafe
agria65517142agria
ague55725922ag_ue
agues64919052agues
aigret73720022aigret
aired66032922aired
airer54927892airer
ajee115928232a_jee
akee85936812a_kee
alee46652322a_lee
allee54932122allee
apres75426402apres
are37874572a_r_e
area45843392a_rea
areae55229742a_reae
arene55329412a_rene
ares45871022a_res
arete56031352a_rete
argle65421562argle
argue64818442argue
arse46539272a_rse
aurae54128112aurae
aurei54821862aurei
aures55137092aures
awee76336642a_wee
bargee94624442bargee
bree67241262_bree
degree82814852degree
dree56638322_dree
eagre64315322eagr_e
eagres74014572eagres
egret63327312egret
free75940182_free
gee45359202_g_ee
ghee85726112_ghee
glee55239062_glee
grebe85114942_grebe
greed75125692_greed
greek105915942_greek
green65522142_green
grees65132472_grees
greet65835322_greet
grew85620262_grew
grey85624042_grey
grue55825712_grue
hiree85427802hiree
laree56036292laree
ngwee9311072ngwee
ogee57629882og_ee
ogre56320742ogr_e
ogres65818632ogres
pree67044732_pree
pugree92112472pugree
puree74632842puree
ragee65432662rag_ee
raggee84217602raggee
ree37974072__ree
saree55044662saree
scree720031702scree
siree55238812siree
spree74830862spree
three87526912three
tree47745812_tree

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.0931921408.6
2DLD Change Limit53800921.81329674.6
3Display Results92920.0165750.0
 (SQL Overall)178691921.92292971.4
 
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.