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

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
razeed16371001(None) 
razed155027981raz_ed
razee145827801razee_
razees154314761razees
razzed15478281razzed
brazed184717082braz_ed
brazened20134902brazened
crazed184714452craz_ed
dazed165919362daz_ed
fazed186222962faz_ed
gazed165520332gaz_ed
grazed174115912graz_ed
hazed185222202haz_ed
jazzed22416292jazzed
lazed154925842laz_ed
lazied164610652lazied
mazed175523872maz_ed
paveed12438892paveed
raced87635312ra_ced
racemed1237012racemed
racked134526082racked
radded94716492radded
rafted104714702rafted
raged74829452ra_ged
ragee65432662ragee_
ragees74618662ragees
ragged94620262ragged
ragweed1235072ragweed
raided85017702raided
railed74727542railed
rained75024602rained
raised76120332raised
raked105831422ra_ked
rakee96031172rakee_
rakees104516972rakees
ramee74633852ramee_
ramees84620892ramees
rammed113117302rammed
ramped114617902ramped
ranee55438102ranee_
ranees64623962ranees
ranged84824312ranged
ranked114620742ranked
ranted74324702ranted
raped85334622ra_ped
rapped114122682rapped
rared65738322ra_red
rased65033932ra_sed
rasped94715202rasped
rated65441382ra_ted
ratted74923342ratted
raved94931432ra_ved
raveled114113632raveled
ravened115012282ravened
raxed135622662ra_xed
rayed95127502ra_yed
raze135235432raz_e_
razer144824272raz_er
razers154919612razers
razes145032702raz_es
razored1736332razored
razzes144910072razzes
reed55549622r__eed
refeed104717622refeed
reseed74823292reseed

Search took 5 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 Filter178691825510.766233278.1
2DLD Change Limit82551654.15619863.1
3Display Results65650.0302166.7
 (SQL Overall)178691654.95236084.6
 
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.