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

126 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
unbarring123606(None) 
barring104021592__barring
debarring1335722debarring
embarring1444522embarring
gnarring10225972gn_arring
unarming1138622un_arming
unbaling11310682unba_ling
unbanning1235892unbanning
unbearing1239352unbearing
unbracing1437022unbracing
unbraking1636932unbraking
uncaring11312842unca_ring
undaring10412752unda_ring
unerring9311272un_erring
unhairing1335952unhairing
unvarying1644502unvarying
anearing9413973anea_ring
barbing123716993__barbing
barding113822893__barding
barfing134615093__barfing
barging114018483__barging
baring95135853__ba_ring
barking144724183__barking
barning104320353__barning
birring103713063__birring
burring104016993__burring
charring142913163_charring
debarking1735383debarking
disbarring1445283disbarring
earring83519013__earring
embarking1844193embarking
enlarging1135803enlarging
garring93116713__garring
gnarling10217603gn_arling
imbarking1843613imbarking
inarming1138343in_arming
incurring1236873incurring
inferring1338613inferring
instarring1144063instarring
interring10315423interring
jarring153613193__jarring
marring103319553__marring
narking124015383_n_arking
nearing83020333_nea_ring
outbarking1746213outbarking
outwarring1445363outwarring
parring103222063__parring
scarring112511513_scarring
snarfing12358663sn_arfing
snaring83920953sn_a_ring
snarling92513183sn_arling
sparring113112223_sparring
starring92312953_starring
sunbathing1642933sunbathing
sunburning1343353sunburning
tarring83318303__tarring
umbering1399433umb_ering
unabating1246753unabating
unabiding1345203unabiding
unageing1036273un_ageing
unaging9510933un_a_ging
unbarred11238713unbarr_ed
unbeing1039373unb__eing
unbelting1237663unbelting
unbending1337463unbending
unbinding1336513unbinding
unbolting1236453unbolting
unbowing1436993unb_owing
unboxing1836113unb_oxing
unbraiding1445123unbraiding
unbudging1443793unbudging
uncaging1268713unca_ging
uncaking1539463unca_king
uncapping1635133uncapping
uncasing11511003unca_sing
unchairing1644603unchairing
uncharging1744393uncharging
uncharming1844523uncharming
uncorking1637403uncorking
uncrating12813183uncrating
uncurbing1455513uncurbing
uncurling1237113uncurling
underling111514613underling
underwing141410883underwing
undraping1337333undraping
undrawing1436903undrawing
unearthing1454373unearthing
unfading1347693unfa_ding
unfailing1337453unfailing
unfearing1338883unfearing
unfurling1335763unfurling
ungazing1936033unga_zing
ungirding1245153ungirding
unguarding1343533unguarding
unhanding1437203unhanding
unhanging1436363unhanging
unharried1344763unharried
unhatting1335873unhatting
unhorsing1336853unhorsing
unjamming2143043unjamming
unlacing1148653unla_cing
unlading1058863unla_ding
unlashing1336493unlashing
unlaying1258363unla_ying
unlearning1144713unlearning
unmaking1538133unma_king
unmanning1245873unmanning
unmarried1244583unmarried
unmasking1635263unmasking
unmitring1245263unmitring
unmooring1255813unmooring
unnailing1037023unnailing
unnerving1336633unnerving
unpacking1835133unpacking
unpaying1456943unpa_ying
unsaying1288153unsa_ying
unsnarling1143913unsnarling
unsparing1237713unsparing
unstring9312093un_string
untacking1636643untacking
untiring9312003un_tiring
unwaning1238133unwa_ning
unwavering1743223unwavering
upbearing1435033upbearing
updarting1334333updarting
warring113717973__warring

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.436409841.7
2DLD Change Limit1486411267.09320956.0
3Display Results1261260.0462739.1
 (SQL Overall)1786911267.57523589.6
 
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.