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

173 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
bordering133883(None) 
ordering1039351_ordering
barbering14229692barbering
bartering122313652bartering
borderline1343732borderline
bothering152210202bothering
bouldering1464762bouldering
bowering142911722bo_wering
broidering1444672broidering
brokering1636282brokering
burdening1335542burdening
cornering12311902cornering
doddering1335182doddering
embordering1752622embordering
foddering1535162foddering
moldering1367862moldering
murdering1357132murdering
pondering132411332pondering
portering122012302portering
powdering16246502powdering
reordering1266212reordering
soldering1169032soldering
wondering142110462wondering
badgering1436973badgering
bannering12208813bannering
bantering122414243bantering
barding113822893bard__ing
barreling1238043barreling
barring104021593bar__ring
battering122715153battering
beavering1538703beavering
bedewing1537143b_edewing
berberin1246573berberin_
berberine1346523berberine
berberins1346713berberins
bettering122212763bettering
bickering1837673bickering
birdieing1343033birdieing
birding114014923bird__ing
birring103713063bir__ring
bittering122512003bittering
blundering1444823blundering
boarding123110233board__ing
boding104320063bo_d__ing
bodying1438973bo_d_ying
bogeying1575713bo_geying
bolstering1346883bolstering
bonding113318433bond__ing
bonneting1236173bonneting
boodling121910243bood_ling
boogeying1643623boogeying
boomerang1442973boomerang
borating113414503bor_ating
border94419973border___
bordereau1243323bordereau
bordered1248933border_ed
borderer1168103border_er
borderers1276333borderers
borderland1452163borderland
borderlines1443253borderlines
borders104317533border__s
boring94724873bo___ring
borking144716173bor__king
borrowing1544563borrowing
boweling143410693bo_weling
bowstring15165123bowstring
breeding123411843b_reeding
breezing20368133b_reezing
brewing133411153b_r_ewing
briefing1436943b_riefing
broadening1444033broadening
brokerings1743283brokerings
brothering1646033brothering
buffering1835223buffering
buggering1435193buggering
bumpering1636593bumpering
bunkering16207103bunkering
burring104016993bur__ring
buttering122312533buttering
careering12311203careering
chowdering2044163chowdering
cindering13311223cindering
cockering1839703cockering
coffering1838053coffering
cohering142413853co_hering
compering163414173compering
coopering142611333coopering
coppering162810903coppering
corbeling1439043corbeling
cordelling1446383cordelling
cording113620833cord__ing
cordoning1338073cordoning
corseting12312183corseting
coshering15510033coshering
covering142215743co_vering
cowering142514053co_wering
dandering122511063dandering
disordering1444383disordering
dowering132510623do_wering
forbearing1644803forbearing
fording123717043ford__ing
fordoing1357303ford_oing
foredoing1456483foredoing
forewing1539013for_ewing
fostering132411263fostering
foundering1545353foundering
gandering122111293gandering
gardening1236513gardening
garnering11298093garnering
gartering112111593gartering
gendering12249753gendering
goffering1744483goffering
gorgerin1044963gorgerin_
gorgerins1145193gorgerins
hardening1438023hardening
hindering14310273hindering
hoidening1435643hoidening
hollering1337743hollering
homering141512083ho_mering
hoovering1635753hoovering
hordein1138753horde_in_
hordeins1238323horde_ins
hording123517053hord__ing
hovering151911153ho_vering
hoydening1744363hoydening
juddering1933763juddering
koshering1735363koshering
laddering1237593laddering
loitering1039683loitering
loppering14237283loppering
lording93115233lord__ing
lordling1077743lord_ling
loudening1144753loudening
lowering122210923lo_wering
misordering1544033misordering
modeling12311083mo_deling
modeming1437113mo_deming
mongering13310353mongering
morseling1238073morseling
mortaring1237943mortaring
mothering152110183mothering
mouldering1474283mouldering
niddering1255323niddering
nidering10510483_nidering
ochering14219403_ochering
offering1536393_offering
overing111918063_o_vering
pandering133211963pandering
perduring1336013perduring
pothering151911283pothering
pottering122612003pottering
powering142210813po_wering
preordering15124303preordering
rendering112213183rendering
rodeoing1037263ro_deoing
rogering10310283ro_gering
scowdering1743983scowdering
smoldering1474103smoldering
sobering111912793so_bering
soddening1244553soddening
soldiering1244243soldiering
sundering11312323sundering
teddering12256303teddering
tendering112210813tendering
tochering1537153tochering
torturing1036253torturing
tottering10229613tottering
towering122610883to_wering
wandering143310983wandering
wildering1456743wildering
wording123014563word__ing
worsening1345563worsening
yodeling1357683yo_deling

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 Limit1486411737.31320325.6
3Display Results1731730.0802162.5
 (SQL Overall)1786911737.82922824.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.