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 “keddah” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

110 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
keddah153426(None) 
keddahs1642921keddahs
keblah1545312keblah
khedah1743642khedah
addax1435993_addax
bedded115114063bedded
bedder104215783bedder
bedlam1149273bedlam
bedpan1137583bedpan
beldam11410113beldam
benday123810813benday
buddha1333173buddha
cedar84014323ce_dar
cheddar14254733cheddar
chuddah17263253chuddah
dah78148983___dah
dedal75719023de_dal
deodar837713deodar
eddo63411803_edd_o
eddy93912093_edd_y
edh76921563_e_d_h
emdash12244113_emdash
endash10297123_endash
ephah1337063_ephah
fellah124910773fellah
feudal1037683feudal
gerah9315303ge_rah
giddap1143413giddap
goddam1145163goddam
heddle114211163heddle
heyday1635143heyday
houdah1335173houdah
howdah1634723howdah
kaddish16317973kaddish
kasbah1535183kasbah
kea76540913ke__a_
keas86337093ke__as
kebab134312003ke_bab
kebar115113533ke_bar
keblahs1634563keblahs
kedge115513693ke_dge
kedged13439713kedged
kedges124812943kedges
kenaf12316033ke_naf
kench145513923ke_nch
kendo105113223kend_o
kendos114510663kendos
ketch144912023ke_tch
keypad1633823keypad
keypal1534893keypal
keyway1943823keyway
khaddar1642113khaddar
kheda1346533kheda_
khedahs1852953khedahs
khedas1446313khedas
kiblah1535583kiblah
kidded13299383kidded
kidder123811093kidder
kiddie12359393kiddie
kiddish16276583kiddish
kiddo11398943kidd_o
kiddos12416863kiddos
kiddush16242483kiddush
kiddy144910273kidd_y
kidnap1334193kidnap
medal86221323me_dal
meddle103312763meddle
media84721713media_
mediad104313713mediad
mediae94217413mediae
medial93819863medial
median94117543median
medias93620783medias
medlar93010463medlar
midday13327503midday
neddy10479873nedd_y
odah87018933__odah
pardah123412823pardah
pedal86022503pe_dal
peddle103512823peddle
pedlar93311273pedlar
purdah12288753purdah
redan66125013re_dan
redbay1238333redbay
redcap1158493redcap
redd66323173redd__
redded94019543redded
redden83613613redden
redder83918133redder
reddish1238033reddish
reddle83815913reddle
redds74617833redd_s
redear73515173redear
redia65524483redia_
rediae74221993rediae
redial74923113redial
redias74523603redias
redraw10269853redraw
sedan65620423se_dan
selah8319613se_lah
sendal73314993sendal
serdab937833serdab
tedded93810893tedded
tedder83312153tedder
teddy10489493tedd_y
wedded123811833wedded
wedder113612293wedder
whidah1634793whidah
whydah1942953whydah
yeah106725413ye__ah

Search took 10 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161109.29612125.2
3Display Results1101100.0333333.3
 (SQL Overall)1786911109.46918871.2
 
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.