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

65 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
flaxseed194257(None) 
flaxseeds2041541flaxseeds
axseed1456992__axseed
flambeed16324382flambeed
flashed144112182fla_shed
allseed835953al_lseed
axseeds1533393__axseeds
blasted104213473bla_sted
clashed133614013cla_shed
clasped123610443cla_sped
classed104113653cla_ssed
elapsed1056103elaps_ed
fashed136720253f_a_shed
fasted105320953f_a_sted
faxed166220533f_ax__ed
feased105718713fea_s_ed
feasted11310843fea_sted
filagreed1472873filagreed
flacked173711583fla_cked
flagged13459633fla_gged
flailed1137303fla_iled
flaked144715653fla__ked
flambee144210013flambee_
flamed124618973fla__med
flammed15377413fla_mmed
flanged123810843fla_nged
flanked153710643fla_nked
flanneled1343313flanneled
flapped15328253fla_pped
flared105317603fla__red
flasher133914063fla_sher
flashes133916103fla_shes
flasket1439733fla_sket
flatbed13397983fla_tbed
flatfeet1446213flatfeet
flathead1535803flathead
flatted114012943fla_tted
flattened13185303flattened
flattered13188623flattered
flaunted1234603flaunted
flavored1554573flavored
flawed134712723fla__wed
flaxen16518573flax__en
flaxes165015353flax__es
flaxier17337983flax_ier
flaxiest18298183flaxiest
flayed134414053fla__yed
flensed1136613flens_ed
fleshed143210263fl_eshed
flexed17419083flex__ed
flossed11388533fl_ossed
flushed143310973fl_ushed
fluxed17509673flux__ed
glaceed1136193gla_ceed
glassed93710433gla_ssed
hayseed1435633_hayseed
lapsed94712583_laps_ed
lased65132343_la_s_ed
lashed105625213_la_shed
lassoed8408743_lassoed
lasted74323603_la_sted
linseed838203_linseed
plashed133712643pla_shed
slashed114114853sla_shed
waxweed2132923_waxweed

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.1731032896.0
2DLD Change Limit146162657.06320694.0
3Display Results65650.0302166.7
 (SQL Overall)178691657.26624592.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.