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
barbering14229682barbering
bartering122313642bartering
borderline1343732borderline
bothering152210202bothering
bouldering1464762bouldering
bowering142911712bo_wering
broidering1444672broidering
brokering1636282brokering
burdening1335542burdening
cornering12311892cornering
doddering1335182doddering
embordering1752622embordering
foddering1535162foddering
moldering1367862moldering
murdering1357132murdering
pondering132411332pondering
portering122012302portering
powdering16246502powdering
reordering1266212reordering
soldering1169032soldering
wondering142110462wondering
badgering1436963badgering
bannering12208803bannering
bantering122414233bantering
barding113822893bard__ing
barreling1238043barreling
barring104021593bar__ring
battering122715143battering
beavering1538703beavering
bedewing1537143b_edewing
berberin1246563berberin_
berberine1346523berberine
berberins1346713berberins
bettering122212753bettering
bickering1837663bickering
birdieing1343033birdieing
birding114014923bird__ing
birring103713063bir__ring
bittering122511993bittering
blundering1444823blundering
boarding123110233board__ing
boding104320063bo_d__ing
bodying1438973bo_d_ying
bogeying1575703bo_geying
bolstering1346873bolstering
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
boweling143410683bo_weling
bowstring15165123bowstring
breeding123411843b_reeding
breezing20368133b_reezing
brewing133411153b_r_ewing
briefing1436943b_riefing
broadening1444033broadening
brokerings1743283brokerings
brothering1646033brothering
buffering1835223buffering
buggering1435193buggering
bumpering1636593bumpering
bunkering16207103bunkering
burring104016993bur__ring
buttering122312523buttering
careering12311203careering
chowdering2044163chowdering
cindering13311223cindering
cockering1839693cockering
coffering1838043coffering
cohering142413833co_hering
compering163414163compering
coopering142611323coopering
coppering162810893coppering
corbeling1439033corbeling
cordelling1446383cordelling
cording113620823cord__ing
cordoning1338063cordoning
corseting12312173corseting
coshering15510023coshering
covering142215723co_vering
cowering142514033co_wering
dandering122511063dandering
disordering1444383disordering
dowering132510613do_wering
forbearing1644803forbearing
fording123717043ford__ing
fordoing1357303ford_oing
foredoing1456483foredoing
forewing1539003for_ewing
fostering132411253fostering
foundering1545353foundering
gandering122111293gandering
gardening1236513gardening
garnering11298083garnering
gartering112111573gartering
gendering12249753gendering
goffering1744483goffering
gorgerin1044963gorgerin_
gorgerins1145193gorgerins
hardening1438023hardening
hindering14310273hindering
hoidening1435633hoidening
hollering1337743hollering
homering141512073ho_mering
hoovering1635753hoovering
hordein1138753horde_in_
hordeins1238323horde_ins
hording123517053hord__ing
hovering151911143ho_vering
hoydening1744353hoydening
juddering1933763juddering
koshering1735363koshering
laddering1237593laddering
loitering1039683loitering
loppering14237283loppering
lording93115233lord__ing
lordling1077743lord_ling
loudening1144743loudening
lowering122210913lo_wering
misordering1544033misordering
modeling12311073mo_deling
modeming1437103mo_deming
mongering13310353mongering
morseling1238073morseling
mortaring1237943mortaring
mothering152110183mothering
mouldering1474283mouldering
niddering1255323niddering
nidering10510483_nidering
ochering14219393_ochering
offering1536393_offering
overing111918053_o_vering
pandering133211963pandering
perduring1336013perduring
pothering151911283pothering
pottering122612003pottering
powering142210803po_wering
preordering15124303preordering
rendering112213183rendering
rodeoing1037253ro_deoing
rogering10310273ro_gering
scowdering1743983scowdering
smoldering1474103smoldering
sobering111912783so_bering
soddening1244543soddening
soldiering1244243soldiering
sundering11312323sundering
teddering12256303teddering
tendering112210813tendering
tochering1537153tochering
torturing1036253torturing
tottering10229613tottering
towering122610873to_wering
wandering143310983wandering
wildering1456743wildering
wording123014563word__ing
worsening1345553worsening
yodeling1357673yo_deling

Search took 9 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.1601116818.8
2DLD Change Limit1486411738.12318298.8
3Display Results1731730.0931860.2
 (SQL Overall)1786911738.37621333.7
 
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.