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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

152 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
debarring133571(None) 
debarking1735381debarking
barring104021592__barring
deairing10311892de_airing
debagging1533592debagging
debasing12238062deba_sing
debating123213732deba_ting
debearding1543732debearding
deferring1436142deferring
demarking1736772demarking
demurring1335252demurring
departing1349512departing
deterring1138622deterring
disbarring1445282disbarring
earring83519012_e_arring
embarring1444512embarring
unbarring1236062unbarring
barbing123716993__barbing
barding113822893__barding
barfing134615093__barfing
barging114018483__barging
baring95135853__ba_ring
barking144724183__barking
barning104320353__barning
bearding124011943be_arding
bearing103624773be_a_ring
bewaring14279493bewa_ring
birring103713063__birring
burring104016993__burring
charring142913163_charring
daring84928683d__a_ring
darking134217343d__arking
darling93418363d__arling
darning93817333d__arning
darting94020663d__arting
dealing94323233de_a_ling
deaning94020473de_a_ning
deashing134210953de_ashing
deaving123814753de_a_ving
debarment1447793debarment
debarred12165633debarr_ed
debauching1942473debauching
debeaking1735923debeaking
debiting122511203deb_iting
deboning12109153deb_oning
debriding1446483debriding
debugging1542993debugging
debunking1733353debunking
debuting12268633deb_uting
decamping1734943decamping
decanting132510633decanting
decaying15239453deca_ying
decerning1337293decerning
declaring1339573declaring
decrying15237413de_crying
decurving1634723decurving
defacing15238683defa_cing
defaming15238463defa_ming
defanging1535333defanging
defatting1436103defatting
deforcing1636063deforcing
deforming1636703deforming
defraying1735853defraying
degassing1234823degassing
degerming1435753degerming
degrading13137373degrading
dehorning1455243dehorning
dehorting1447213dehorting
delating103119603dela_ting
delaying133210973dela_ying
demanding14237923demanding
demasting1338453demasting
demerging1436643demerging
denaturing12115853denaturing
deperming1537113deperming
deploring1337853deploring
deporting1369593deporting
depraving1635973depraving
derailing112011313derailing
deranging1238063deranging
derating103222283dera_ting
deratting1139513deratting
desalting1138843desalting
desanding12207653desanding
descrying1635103descrying
deserting11713143deserting
deserving1497903deserving
desiring10312143de_siring
desorbing1346363desorbing
despairing1445063despairing
detaching1637263detaching
detailing112510413detailing
detaining112510473detaining
deterging1237853deterging
detouring1136973detouring
devaluing1434833devaluing
devouring1435953devouring
dewatering1545773dewatering
dewaxing20215293dewa_xing
deworming1635043deworming
disarming1338803disarming
dwarfing1633613d_warfing
earing75235483_e_a_ring
earning83418213_e_arning
earrings9299633_e_arrings
embarking1844193embarking
erring73816483_e__rring
fearing113520033fe_a_ring
garring93116713__garring
gearing92818843ge_a_ring
gnarring10225973_gnarring
hearing113324163he_a_ring
hearsing1239383he_arsing
hearting12513123he_arting
herring113615883he__rring
imbarking1843613imbarking
jarring153613193__jarring
learning978553le_arning
marring103319553__marring
nearing83020333ne_a_ring
parring103222063__parring
pearling11912013pe_arling
rearing83128783re_a_ring
rearming111413613re_arming
rebaiting12311643rebaiting
rebating112418343reba_ting
reboarding1445673reboarding
reboring11312783reb_oring
reburying1535193reburying
recarrying1643653recarrying
recurring1237953recurring
reearning1039053reearning
referring1338033referring
regarding12149153regarding
remarking1638893remarking
remarrying1643373remarrying
repairing12310013repairing
reparking1638923reparking
retarding111110653retarding
rewarding14148833rewarding
rewarming15147383rewarming
scarring112511513_scarring
searing83330923se_a_ring
sparring113112223_sparring
starring92312953_starring
tarring83318303__tarring
tearing84021493te_a_ring
warring113717973__warring
wearing113318863we_a_ring
wearying1546703we_arying
yearling1297883ye_arling
yearning1296983ye_arning

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411527.19020673.3
3Display Results1521520.0632412.7
 (SQL Overall)1786911527.67323288.3
 
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.