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

51 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
bejewel195304(None) 
bejewels2042491bejewels
bedewed1437152bedewed
bejeweled2272002bejeweled
jewel156711702__jewel
bedel84219393b__edel
bedell93610043bede_ll
bedemen12910183bedemen
bedevil1344513bedevil
bedew114513033bedew__
bedews12398943bedew_s
beebee10313063be_ebee
beefed123510873be_efed
beeped115313453be_eped
beeper103714093be_eper
beetle8311673be_etle
beeves114615043be_eves
beezer174010523be_ezer
befell11428713befe_ll
behowl1445533behow_l
bejesus1643693bejesus
bejeweling2341713bejeweling
bejewelled2351463bejewelled
beseem1069083bese_em
betel74419903b__etel
bethel1169643be_thel
between1234683between
bevel104517043b__evel
beveled133811123beveled
beveler124010683beveler
beweep13147253bewe_ep
bezel165215173b__ezel
bilevel1244393bilevel
bowel105621203b__owel
brewed125411873b_rewed
brewer114812543b_rewer
crewel114310473_crewel
djebel1643453_djebel
jebel145612143__jebel
jewed165114833__jewed
jewels16508613__jewels
jezebel2541923jezebel
newel86114133__newel
peewee11311963pe_ewee
refeel93913243refe_el
reheel93610823rehe_el
renewal1038703renewal
renewed11309993renewed
renewer10248693renewer
resewed113011823resewed
weewee12310083we_ewee

Search took 7 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.1561145455.1
2DLD Change Limit134027516.28021341.9
3Display Results51510.0163187.5
 (SQL Overall)178691516.45227695.4
 
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.