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

52 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
bedevils144437(None) 
bedevil1344511bedevil_
bedells10379362bede_lls
bedels94015272bede__ls
bedeviled1673442bedeviled
bedrails1136292bedrails
devils104412812__devils
weevils1384682we_evils
bedecks1635793bede_cks
bedel84219393bede__l_
bedell93610043bede__ll
bedeviling1743483bedeviling
bedevilled1742343bedevilled
bedewing1537143bedewing
bedews12398943bede__ws
bedims1149593bed__ims
bedouins1145513bedouins
bedquilt2043453bedquilt
bedquilts2141633bedquilts
bedrail1037253bedrail_
bedrivels1542713bedrivels
bedrolls1144673bedrolls
bedsits1037563bed_sits
beduins1039123bed_uins
beedies10314203be_edies
beefily1535613be_efily
beeves114615043be_ev_es
bejewels2042483bejewels
benefits1345713benefits
betels84515063bete__ls
bevels113913983b__evels
bevies114017303b__evies
bewails1277553be_wails
bezels173712283beze__ls
bezils1711310603b__ezils
bilevels1343693bilevels
daredevils155903daredevils
deils65722863__de_ils
devels104313903__devels
devil94714733__devil_
ervils948773_e_rvils
evils84114263___evils
federals1247303federals
kevils13358333__kevils
medevacs1643373medevacs
medievals1553353medievals
redefies12710163redefies
redenies9615713redenies
redtails968003redtails
wedels103811033wede__ls
weevil1295433we_evil_
weevily1694643we_evily

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.1701051123.5
2DLD Change Limit146162527.31319986.6
3Display Results52520.0163250.0
 (SQL Overall)178691527.49923828.6
 
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.