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

44 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
sowbread144319(None) 
showbread1842301showbread
sowbreads1542851sowbreads
lowbred13225362lowbre_d
shewbread1842042shewbread
showbreads1952082showbreads
beebread1343243beebread
bowered133113043bowere_d
bowhead1636433bow_head
bread85523113___bread
copyread1643783copyread
cornbread1443063cornbread
cowered133214653cowere_d
dowered122811553dowere_d
frybread1741653frybread
lowered112711913lowere_d
oread64619603_o__read
outread82811093_outread
powered132911643powere_d
sabred95916533s_abre_d
sewered112911243sewere_d
shewbreads1951863shewbreads
shortbread16132083shortbread
showered1537013showere_d
showerhead2051953showerhead
soared74324293so_are_d
sobbed113516263so_bbe_d
sobered102912433so_bered
softhead1545003softhead
sombre10729473sombre__
sombrely1543703sombrely
sombrero1242583sombrero
sorbed94916523sorb_e_d
sored66141783so__re_d
sorehead1246973sorehead
soured74921863so_ure_d
sowed94933863sow__e_d
soybean1243953soyb_ean
spread9312533s__pread
subbreed1345873subbreed
subhead1387693s_ubhead
swobbed15335443swobbe_d
towered112911403towere_d
towhead1435223tow_head

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.420425454.8
2DLD Change Limit146162447.15620425.1
3Display Results44440.0162750.0
 (SQL Overall)178691447.59223536.7
 
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.