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

174 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
beladied123666(None) 
beladies11310421beladies
beaded104922422be_ad_ed
beadier103513912be_adier
begladded1542862begladded
belaced124112152bela_ced
belated103520012bela_ted
belauded1244792belauded
belayed133610082bela_yed
belfried1444202belfried
belied95022162bel__ied
bellied104314072bel_lied
bladed104717762b_lad_ed
readied93316622re_adied
babied114913513b__abied
badged114814783b__adged
balanced1356513balanced
balded105417513bal_d_ed
baldies105317703bal_dies
bandied114414303b_andied
beached154516553be_ached
beader94623793be_ad_er
beadiest113815533be_adiest
beadily1378843be_adily
beading113221863be_ading
beadle93314683be_adle_
beadles103414733be_adles
beadmen12299453be_admen
beaked135919493be_a_ked
beakier134012163be_akier
beamed115720733be_a_med
beamier113411943be_amier
beaned95621473be_a_ned
beanie83618593be_anie_
beanies93821093be_anies
bearded114212133be_arded
becalmed1534813becalmed
becapped1733933becapped
beclasped1643743beclasped
bedamned1434583bedamned
bedaubed1443183bedaubed
bedded115114063be__dded
beedies10314203be_edies
beflagged1742423beflagged
begalled1236023begalled
begazed2036203bega_zed
behaved16176683beha_ved
beheaded1536373behead_ed
belabored1443813belabored
belady12489933belad__y
beladying1634763beladying
belaud939133bela__ud
belauding1335463belauding
belayer12339503bela_yer
belaying143110603belaying
belched154011843bel_ched
beldame1237233beldame_
beldames1336803beldames
beleaped1336103beleaped
belfries1336983belfries
belie75630383bel__ie_
belief115018603bel__ief
belier84423563bel__ier
belies84631053bel__ies
believed14427923believed
bellbird1343823bellbird
belled94626183bel__led
bellies94023723bel_lies
bellowed14158603bellowed
belonged1235313belonged
beloved13188393bel_oved
belted94020633bel__ted
bemadamed1742193bemadamed
bemadden1443113bemadden
benamed122911093bena_med
bendayed1534873bendayed
bended105521233be_nd_ed
bendier103111413be_ndier
beraked144312433bera_ked
berated104422133bera_ted
berried103714043be_rried
beslaved1435023besla_ved
betaxed17307023beta_xed
betided114810203betid_ed
bewailed1435343bewailed
bewared13310113bewa_red
bewearied1544203bewearied
bielded11226713biel_d_ed
birdied11329433b_irdied
blabbed11357813b_labbed
blacked163613373b_lacked
bladder11429153b_ladder
blade85923333b_lad_e_
blader93618583b_lad_er
blades95221253b_lad_es
blading113615363b_lading
blamed116017953b_la_med
blanked144011223b_lanked
blared95018243b_la_red
blasted104213473b_lasted
blatted104812713b_latted
blawed124713893b_la_wed
blazed184314713b_la_zed
bleached16378563bleached
bleared104211253blea_red
blearier1037333blearier
bleated104015973blea_ted
blended114710713blend_ed
bloodied1245973bloodied
bludged12439313b_ludged
bodied103814583b__odied
bradded12388713b_radded
braided114013213b_raided
brandied1259113brandied
breaded115014063bread_ed
buddied12388003b_uddied
bullied104514813bul_lied
cladded12356923_cladded
delated93722873dela_ted
delayed123310763dela_yed
deleaded1148333delead_ed
deluded10158763delud_ed
eddied9248323_e_ddied
elapid939543_elapi_d
elapsed1056103_elapsed
elated74725823_ela_ted
elided84814673_elid_ed
eluded84612773_elud_ed
evaded1137063_evad_ed
gelated93615633gela_ted
gelded94512113gel_d_ed
gladded11357453_gladded
gladier93810993_gladier
headed114020473he_ad_ed
headier113212953he_adier
jellied15419223jel_lied
laded74232613__lad_ed
ladies75124883__ladies
ladled85013483__ladled
lazied164610653__lazied
leaded84221543le_ad_ed
leadier83212723le_adier
maladies11311933maladies
melamed1249633mela_med
melanized2158573melanized
melded104714713mel_d_ed
melodies11310123melodies
melodised1345043melodised
melodized2245453melodized
miladies1139923miladies
plaided11409643_plaided
pleaded113511263plead_ed
readded103310733re_added
readier83117423re_adier
readies83324713re_adies
rebodied1237243rebodied
recladded1443673recladded
relaced103517213rela_ced
relaid75518443rela_i_d
relanded102410463relanded
relapsed1136523relapsed
related83327573rela_ted
relaxed153312523rela_xed
relayed113212753rela_yed
relied74926233rel__ied
reloaded1059103reload_ed
remedied1237953remedied
salaried9311023salaried
steadied1036563steadied
toadied9248013_toadied
unladed92614373unlad_ed
velarized2256803velarized
wearied112911803we_aried
welded114013383wel_d_ed

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 Filter1786911461620.326548131.9
2DLD Change Limit1461621748.89016441.2
3Display Results1741740.0632761.9
 (SQL Overall)1786911749.27919257.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.