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

67 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
bourride114440(None) 
bourrides1244821bourrides
boride9415902bo__ride
bourree91311342bourr_ee
outride82615682_outride
berried103714043b_erried
bestride1138613bestride
blurred10427803blurred_
blurrier1035163blurrier
blurrily1343913blurrily
blurring11277233blurring
bolide9515563bo__lide
borides10515153bo__rides
bornite9311183bo_rnite
bougie93613273bou_gi_e
bountied1136333bountied
bourne83714093bou_r_ne
bourrees10127643bourrees
bourse84414333bou_r_se
boursin938283boursi_n
boursins1037513boursins
bourtree10135573bourtree
bride86425533b___ride
burdie93615023b_urdi_e
buried94822373b_u_ried
burkite1337003b_urkite
burnie83715413b_urni_e
burred95820723b_urred_
burrier93613553b_urrier
burring104016993b_urring
burrito936223b_urrito
corrade101111043co_rrade
corrida1078503co_rrida
corrie83621223co_rri_e
corrode101310573co_rrode
courtside1243353courtside
currie84317263_curri_e
curried103313653_curried
dhurrie1153953dhurri_e
dourine8311453dou_rine
durrie73713263_durri_e
fluoride1245873fluoride
flurried12235283flurried
gourde8107933gou_r_de
horrid10311563ho_rrid_
horrider1236533ho_rrider
hurried113511043_hurried
joyride1853753jo_yride
murrine9411483_murrine
oreide7311673_o_reide
oroide7311703_o_roide
orrice81410163_o_rrice
ourie54027303_ou_ri_e
outrider92410563_outrider
outrides92414993_outrides
outrode82313423_outrode
outside82414193_outside
override121512523override
porridge1243763po_rridge
scurried11267053scurried
scurrile1055073scurrile
slurried9285943slurried
sourdine936893sourdine
torrid7311853to_rrid_
torrider936173to_rrider
ureide7310363__ureide
worried11308693wo_rried

Search took 7 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.453394461.4
2DLD Change Limit146162676.32623105.0
3Display Results67670.0332030.3
 (SQL Overall)178691676.81226231.8
 
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.