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

69 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
bourrides124481(None) 
bourride1144391bourride_
borides10515152bo__rides
bourrees10127642bourr_ees
outrides92414992_outrides
berries94423553b_erri_es
bestrides1237913bestrides
blurrier1035153blurri_er
blurriest1155153blurri_est
blurriness1243483blurriness
bolides10515073bo__lides
boride9415903bo__ride_
bornites10310973bo_rnites
bougies103715183bou_gi_es
bounties10311393bounti_es
bournes93615023bou_r_nes
bourree91311343bourr__ee
bourses94014303bou_r_ses
boursins1037513boursi_ns
bourtrees11154013bourtrees
boweries13312293boweri_es
brides94423513b___rides
burdies104117563b_urdi_es
buries84633273b_u_ri_es
burkites1436673b_urkites
burnies94017823b_urni_es
burnsides1244233b_urnsides
burrier93613543b_urri_er
burriest102911213b_urri_est
burritos1044473b_urritos
corrades111211263co_rrades
corridas1177303co_rridas
corries94026783co_rri_es
corrodes111310333co_rrodes
courtsides1343583courtsides
curries93723163_curri_es
dhurries1255583dhurri_es
dourines9311363dou_rines
durries83817353_durri_es
fluorides1345803fluorides
flurries11188893flurri_es
gourdes9109383gou_r_des
gurries83515953_gurri_es
horrider1236523ho_rrider
horridest1345643ho_rridest
hourlies1138343hourli_es
hurries103919653_hurri_es
joyrides1943853jo_yrides
lorries74518343lo_rri_es
morrises10711063mo_rrises
murries94118673_murri_es
oreides8312023_o_reides
oroides8311973_o_roides
orrices9129363_o_rrices
orrises71312233_o_rrises
outride82615673_outride_
outrider92410553_outrider
outriders10237223_outriders
outsides92513233_outsides
overrides131411013overrides
porridges1343913po_rridges
scurries102911483scurri_es
slurries82710413slurri_es
sourdines1046723sourdines
spurries102311323spurri_es
torrider936163to_rrider
torridest1045753to_rridest
ureides8311103__ureides
worries104117133wo_rri_es

Search took 9 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 Filter1786911486410.1561145455.1
2DLD Change Limit148641697.90618801.0
3Display Results69690.0332090.9
 (SQL Overall)178691698.09522074.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.