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

86 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
barouches164497(None) 
barouche1544171barouche_
avouches1634822_avouches
broaches153211622b_roaches
brooches15288192b_rooches
capouches1843632capouches
caroaches1637792caroaches
caroches15710692caro_ches
cartouches17112962cartouches
crouches153711292_crouches
farouche1643052farouche_
grouches14328212_grouches
rouches124217892__rouches
arches114822043_ar__ches
arouses74921293_arou_ses
avouched1743583_avouched
avoucher1653853_avoucher
avouchers1743083_avouchers
babiches1735253ba_biches
baches135426943ba___ches
backaches22146813backaches
barbecues15144473barbecues
barbules1238043barbu_les
barnacles1355333barnacles
baronages1247153baronages
baronies10315023baro_nies
baronnes1038553baro_nnes
baroques1934863baro_ques
baroscopes1646753baroscopes
barques18259643barqu__es
batches144019613ba__tches
berdaches1745053berdaches
birches143412323bir__ches
blotches1537433b_lotches
boches134618523b__o_ches
boroughs1443803borough_s
borsches1536003bor_sches
botches143716023b__otches
bouchee143313543b__ouchee
bouchees15339533b__ouchees
boucles113113003b__oucles
braches144621223b_r_aches
branches153613803b_ranches
breaches153714123b_reaches
breeches15258673b_reeches
brioches15227253b_rioches
britches15278683b_ritches
broached16309123b_roached
broacher15329263b_roacher
broachers16328153b_roachers
broche133612103b_ro_che_
bronchos15206173b_ronchos
bronchus15204743b_ronchus
brunches153710453b_runches
brushes124014663b_r_ushes
capuches1735513ca_puches
caroche1469243caro_che_
carouses10614503carou_ses
carroches1665893carroches
cartouche16122583cartouche_
couches144020473__couches
crotches153411303_crotches
crouched16359153_crouched
debouches17124103debouches
douches134315233__douches
earaches13411313ear_aches
grouched15356663_grouched
larches124416453lar__ches
marches143921173mar__ches
mouches143815963__mouches
ouches114322183___ouches
panoches1548133pano_ches
parches143720003par__ches
pouches144116743__pouches
retouches1445903retouches
roaches123616213__roaches
rotches123515703__rotches
rouche114714313__rouche_
ruches114819583__r_uches
scrooches1645703scrooches
slouches13208073_slouches
soroches1338803soro_ches
tarbushes1444883tarbushes
touches125118343__touches
troches123715343_tro_ches
vouches153914113__vouches

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 Filter1786911486410.423422437.4
2DLD Change Limit148641868.67317138.4
3Display Results86860.0461869.6
 (SQL Overall)178691869.14219546.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.