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 “barrel” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

85 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
barrel8451787(None) 
barbel104317071barbel
barre75929541barre_
barred95725791barred
barrels94514361barrels
barren85317611barren
barres84427541barres
barret84930481barret
carrel84718631carrel
parrel84515981parrel
ariel55228972_ariel
artel56122742_artel
babel95821692ba_bel
bagel85116792ba_gel
barbal104016662barbal
barbe95328282barbe_
barbed115121312barbed
barbell11429962barbell
barbels114514432barbels
barber104419322barber
barbes104526232barbes
barbet104427882barbet
barde85330772barde_
barded105426422barded
bardes95026932bardes
bare65460522ba_re_
bared85144482ba_red
barely114716792ba_rely
barer74535802ba_rer
bares75457132ba_res
barfed125416382barfed
barge85631022barge_
barged105822642barged
bargee94624442bargee
barges94528252barges
barked135027312barked
barker124822862barker
barley115116762barley
barmen105418532barmen
barned95623582barned
barney115314452barney
barreled1137842barreled
barrenly1345412barrenly
barrens94414322barrens
barrets94917102barrets
barrier94017732barrier
barrio8312572barrio
barrow114512762barrow
barter85525372barter
barye105021492barye_
baryes116218502baryes
birred94713202birred
bordel94514572bordel
burred95820722burred
burrer83718472burrer
carcel105018672carcel
carpel105418472carpel
carrell94610462carrell
carrels95117302carrels
cartel85022532cartel
carvel114817572carvel
darnel74312182darnel
fardel104712592fardel
farfel124310432farfel
ferrel92810202ferrel
garred85217402garred
garret74426552garret
jarred144613252jarred
laurel649032laurel
marcel103714852marcel
marred95421042marred
marrer83716672marrer
marvel113712002marvel
parcel103915472parcel
parral85517532parral
parred95024072parred
parrels94713492parrels
quarrel1636092quarrel
saurel6511982saurel
sorrel6413542sorrel
tarre55825632tarre_
tarred74720282tarred
tarres64723042tarres
warred104019842warred
warren95012852warren

Search took 4 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 Filter178691825510.1101624463.6
2DLD Change Limit82551853.07626837.1
3Display Results85850.0165312.5
 (SQL Overall)178691853.20255806.1
 
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.