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

88 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
dewan9571804(None) 
dean56039481de_an
deewan10267551deewan
dewans105215141dewans
dewar95817731dewar
dewax165510851dewax
diwan95712551diwan
rewan85623661rewan
sewan85921291sewan
bean66443862be_an
began86319572began
daman84821162daman
dan46859662d__an
dawen95413722dawen
dawn85624202daw_n
dead65434242de_ad
deaf85838402de_af
deal56347412de_al
deans66131392de_ans
dear55343602de_ar
debag94212302debag
debar85517862debar
decaf114919442decaf
decal85523232decal
decane93818872decane
decant93524222decant
decay114718482decay
dedal75719022dedal
dedans85915072dedans
deewans11306902deewans
defang1137752defang
defat95426692defat
degas75119162degas
deign74312802deign
delay94820632delay
demand104314252demand
demean9510562demean
demon86520312demon
den47554342de__n
denar65223292denar
derat65044082derat
deray95024182deray
desand84812632desand
desman9311692desman
detain74617382detain
deva85720982deva_
devas96218882devas
devon95113682devon
dew77139922dew__
dewars105117072dewars
dewed105020302dewed
dewing114115702dewing
dewlap1264842dewlap
dews86230602dew_s
dewy115419022dew_y
divan96114842divan
diwans105110372diwans
down86427492dow_n
drawn95614242drawn
elan46734242_elan
gowan95415742gowan
hewn106719852hew_n
hwan105716892_hwan
jawan15710382jawan
jean116629282je_an
lean46345242le_an
leman75622602leman
mean65538082me_an
pean66147172pe_an
pecan91919032pecan
pekan111613972pekan
redan66125012redan
reman75730152reman
reran57329102reran
rewax155713922rewax
rewin85623962rewin
rewon86920572rewon
rowan85418732rowan
seawan94111222seawan
sedan65620422sedan
sewans95215902sewans
sewar85421092sewar
sewn76124332sew_n
swan76631312_swan
vegan95114152vegan
wan66761932__wan
wean75734352we_an
yean75834582ye_an

Search took 3 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.0901985455.6
2DLD Change Limit53800881.86028924.7
3Display Results88880.0165500.0
 (SQL Overall)178691881.96690890.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.