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

365 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
berthing1420959(None) 
birthing14338431birthing
airthing12297952airthing
bathing134816242b_athing
beaching164114142beaching
beating104326872beat_ing
beetling1139282beetling
belching16349152belching
belting104119132belt_ing
benching163411342benching
beraking153612962beraking
berating113220752berating
beriming13310452beriming
berming123614822ber_ming
berrying14137362berrying
besting104923922best_ing
bethink1677202be_think
betrothing1644662betrothing
betting103921402be_tting
birching16328462birching
birthings15254622birthings
breathing15218372breathing
earthing12310322earthing
farthing1538072farthing
girthing13256082girthing
northing12199062northing
perching163711632perching
seething1239022seething
teething1237162teething
worthing15178052worthing
abetting1158293abe_tting
aborting11710253abort_ing
aerating92820993aerating
airting83616303airt_ing
alerting91312383alert_ing
anything1534993anything
arching136216693_arching
averting122512733avert_ing
baching156017753b_aching
baiting103918883bait_ing
bantling112611993bantling
barbing123716993bar_bing
barding113822893bar_ding
barfing134615093bar_fing
barging114018483bar_ging
baring95135853bar__ing
barking144724183bar_king
barning104320353bar_ning
barring104021593bar_ring
bartering122313643bartering
bashing135422583b_ashing
basting104227203bast_ing
batching163712093batching
bating95132253b_at_ing
batting104422273b_atting
battling113110493battling
batwing13509813b_atwing
beading113221863be_ading
beaming123618803be_aming
beaning103820683be_aning
bearding124011943bearding
bearing103624773be_aring
beatings114113223beat_ings
becking164416073be_cking
beclothing1843873beclothing
becoming1538163becoming
becriming1646353becriming
bedding124114483be_dding
bedewing1537143bedewing
bedirtying1742723bedirtying
bedraping1535373bedraping
beefing133911473be_efing
beeping124013913be_eping
beeswing14255763beeswing
befitting15236623befitting
befretting1644793befretting
begazing2136633begazing
begetting13186583begetting
begging123012653be_gging
begriming1545523begriming
behaving1735453behaving
behind1238063be__hind
behoving1734913behoving
being84920503be___ing
belaying143110603belaying
belling103825073be_lling
bellying14359073bellying
beltings11369253belt_ings
beltline1036943beltline
belying133612443be_lying
bemiring13239603bemiring
bemixing20226523bemixing
bemusing1336613bemusing
benaming1339693benaming
bending114420893be_nding
benthic1437473benthi_c
benthon1237693benthon_
benthons1337973benthons
bereaving1537563bereaving
berhyming2042703berhyming
berlin83116373ber_lin_
berline93716853ber_line
berlins93216013ber_lins
berth104917883berth___
bertha11429173berth__a
berthas12398763berth_as
berthed13259123berth_ed
berths114712423berth__s
beryline1337083beryline
besetting12268423besetting
besoothing1693163besoothing
besotting12256873besotting
bestowing1535803bestowing
betaine9413783be_taine
betaking153010143betaking
bethank1666273be_thank
bethinks1765043be_thinks
betiding1239913betiding
betraying1537703betraying
bettering122212753bettering
beveling143011033beveling
bewaring14279493bewaring
bewitching2162773bewitching
bewraying1834863bewraying
bighting15269453bighting
birding114014923bir_ding
birling104317053bir_ling
birring103713063bir_ring
bitching163610623bitching
biting95321823b_it_ing
bitting103717293b_itting
blatting114111653blatting
bleaching17287093bleaching
bleating113514503bleat_ing
blenching17276503blenching
blitzing2035903blitzing
blotching1734963blotching
blotting113910433blotting
blurting11258773blurt_ing
blushing14339333blushing
boating103721303boat_ing
bolting104416763bolt_ing
booting103821363boot_ing
borating113414503borating
boring94724873bor__ing
borking144716173bor_king
botching16359703botching
bottling11279143bottling
bracing123817613b_racing
braking143917703b_raking
braving133714613b_raving
braying134416313b_raying
brazing193715113b_razing
breaching17269403breaching
breading123515463breading
breaking153914243breaking
breaming133612513breaming
breathings16234313breathings
breeching17236473breeching
breeding123411843breeding
breezing20368133breezing
brewing133411153b_rewing
bribing123111043b_ribing
bring85528503b_r__ing
brining103216473b_rining
broking143514823b_roking
brushing14359963brushing
bruting102612993b_ruting
bruxing17236823b_ruxing
bunching163410703bunching
bunting103718833bunt_ing
burbling13249423burbling
burgling12239303burgling
burking143716323bur_king
burling104421133bur_ling
burning104215503bur_ning
burping124012943bur_ping
burring104016993bur_ring
bursting1138703bursting
burthen1236363burthen_
burthening1643463burthening
burthens1335383burthens
burying133413913bur_ying
bushing134018583b_ushing
busting104221793bust_ing
bustling112110063bustling
butling103516813b_utling
butting103519283b_utting
byrling13337373byr_ling
carting104228283cart_ing
centring112112953centring
cering94522533cer__ing
certain92612213certain_
clothing14278783clothing
darting94020663dart_ing
dartling1039563dartling
deashing134210953deashing
denting94422183dent_ing
derating103222273derating
deratting1139513deratting
deriding112512933deriding
deriving132510743deriving
dirtying1336093dirtying
earthling1346193earthling
eating75134403_eat_ing
eching126315563_e_ching
erasing8317953_erasing
erlking1236693_erlking
eroding9314273_eroding
errhine1036593_errhine
erring73816473_er_ring
etching134511843_etching
everting122213133evert_ing
everything2042353everything
exerting162211153exert_ing
faithing1537153faithing
farthings1635233farthings
farting114120753fart_ing
felting113515213felt_ing
ferrying15146233ferrying
feruling1258873feruling
fetching17298413fetching
feting104417793fe_t_ing
fetting113517873fe_tting
fettling1266773fettling
freshing152611023freshing
fretting122711523fretting
frothing15208533frothing
gentling1048453gentling
getting93316563ge_tting
girting93113333girt_ing
hearting12513123heart_ing
heating114024323heat_ing
hefting144510913heft_ing
henting113719653hent_ing
herding122915123her_ding
herring113615873her_ring
herrying15147013herrying
hurting113914033hurt_ing
hurtling12318313hurtling
inearthing1443543inearthing
jerking19308913jer_king
jesting154317713jest_ing
jetting153815343je_tting
jettying1933953jettying
karting123716063kart_ing
kerbing14308483ker_bing
kerfing15307533ker_fing
kerning124010893ker_ning
kithing153411553_kithing
kything18285523_kything
lathing114315693_lathing
leaching143012833leaching
leashing123310313leashing
leching134613653le_ching
leeching14318373leeching
leftwing1532973leftwing
letching143810263letching
letting83218533le_tting
loathing1247673loathing
lurching14277333lurching
marching164312193marching
marting103325013mart_ing
meeting103314963meet_ing
melting103317753melt_ing
merging112711753mer_ging
meriting11314673meriting
meshing134513813me_shing
meting94320593me_t_ing
metring103215283me_tring
morphing1637553morphing
mouthing142810243mouthing
naething1236073naething
neighing1355523neighing
nerving112910823ner_ving
nesting84320443nest_ing
nestling958893nestling
netting84018763ne_tting
nettling957213nettling
northings13185573northings
nothing113511903_nothing
obverting1536303obvert_ing
overthin1438533overthin_
overthink1945843overthink
parching164313053parching
parting103527383part_ing
partying14168893partying
peaching163613643peaching
peching154513903pe_ching
pelting102917273pelt_ing
periling11316863periling
perishing1539533perishing
perking143716453per_king
perming123416083per_ming
pertain92714963pertain_
pertains102113413pertains
perusing11811063perusing
pestling111010253pestling
petting103720953pe_tting
pettling1168213pettling
pithing134014053_pithing
porting103021783port_ing
reaching143317203reaching
renting84026853rent_ing
rerising93017783rerising
resting85031183rest_ing
restring91518783restring
retching143412173retching
rethink1488883re_think
retrying122410443retrying
retting83425883re_tting
retying113213833re_tying
scathing14269703scathing
scything17264883scything
searching1538343searching
seating84130683seat_ing
serging93416673ser_ging
sering74731813ser__ing
serrying12167683serrying
serving113014983ser_ving
setting83621393se_tting
settling978943settling
sheathing1636863sheathing
sleuthing1334203sleuthing
soothing12269963soothing
sorting83221813sort_ing
southing122811823southing
swathing15248713swathing
tarting84222653tart_ing
teaching143612603teaching
teethings1344233teethings
tenting84621153tent_ing
terming104015993ter_ming
testing86021053test_ing
thing96622963___thing
tithing113513893_tithing
toothing12278863toothing
torching142510083torching
trithing122811773trithing
trothing122410843trothing
turtling9238833turtling
tything14316573_tything
unearthing1454373unearthing
venting114218093vent_ing
verging123812303ver_ging
versing112314193ver_sing
vesting114618683vest_ing
vetoing11309053ve_toing
vetting114216563ve_tting
weeting113816053weet_ing
weighing1635283weighing
welching17287363welching
welshing15296523welshing
welting113615313welt_ing
wenching17328863wenching
westing115020273west_ing
wetting114117383we_tting
withing143814493_withing
wrathing15248923wrathing
wreathing16266313wreathing
writhing15278673writhing
xeroxing1534513xeroxing
yerking15368803yer_king
zeroing1738343zer_oing
zesting174515333zest_ing

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461623658.25017716.6
3Display Results3653650.1562339.7
 (SQL Overall)1786913658.56220870.2
 
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.