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

382 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
farthing153807(None) 
earthing12310331earthing
faithing1537151faithing
farthings1635231farthings
farting114120751fart_ing
airthing12297952airthing
arching136216692_arching
bathing134816242ba_thing
berthing14209602berthing
birthing14338432birthing
carting104228282cart_ing
darting94020662dart_ing
dartling1039562dartling
earthling1346192earthling
farcing133514002far_cing
farding123716742far_ding
faring105231282far__ing
farming133515082far_ming
fashing144918792fa_shing
fasting114522832fast_ing
fating105328672fa_t_ing
fatling113815682fa_tling
fatting113818702fa_tting
frothing15208532frothing
girthing13256082girthing
karting123716062kart_ing
lathing114315692la_thing
marching164312192marching
marting103325022mart_ing
naething1236072naething
northing12199062northing
parching164313052parching
parting103527382part_ing
partying14168892partying
tarting84222652tart_ing
worthing15178052worthing
wrathing15248922wrathing
aahing1019015763_a_ahing
aching126521973_a_ching
acting95920983_act_ing
ahing98928353_a__hing
airting83616303airt_ing
anteing8312813_anteing
anting75827023_ant_ing
anything1534993anything
archine125817053_archine
archings14499863_archings
arcing95819643_ar_cing
arcking145811963_arcking
argling92812733_argling
arguing9248733_arguing
arising83619973_arising
arming94719803_ar_ming
arshin9312173_arshin_
arshins10312573_arshins
ashing107824093_a_shing
autoing8314043_autoing
baching156017753ba_ching
baiting103918883bait_ing
bantling112612003bantling
barbing123716993bar_bing
barding113822893bar_ding
barfing134615093bar_fing
barging114018483bar_ging
baring95135853bar__ing
barking144724183bar_king
barning104320353bar_ning
barring104021593bar_ring
bartering122313653bartering
bashing135422583ba_shing
basting104227203bast_ing
batching163712093batching
bating95132253ba_t_ing
batting104422273ba_tting
battling113110493battling
batwing13509813ba_twing
birching16328463birching
birthings15254623birthings
caching156317503ca_ching
canting104725903cant_ing
carding113922443car_ding
caring95137993car__ing
carking144322853car_king
carling103727073car_ling
caroling113317003caroling
caroming133312963caroming
carping123521083car_ping
carrying14148373carrying
cartoning12311113cartoning
carving133916773car_ving
cashing135022553ca_shing
casting104628343cast_ing
castling11311233castling
catching163712773catching
catling104819793ca_tling
catting103922643ca_tting
charting142614193chart_ing
clothing14278783clothing
crashing143512633crashing
crating103725203crat_ing
daring84928683dar__ing
darking134217343dar_king
darkling1437483darkling
darling93418373dar_ling
darning93817333dar_ning
dashing125917893da_shing
dating85326483da_t_ing
dauting93814763daut_ing
dawting123610673dawt_ing
dirtying1336093dirtying
dratting10389663dratting
earing75235483ear__ing
earning83418213ear_ning
earring83519013ear_ring
earthen1039253earthen_
earthier1137443earthier
earthily1445613earthily
earthlings1443613earthlings
easting84924303east_ing
eating75134403ea_t_ing
fabling133413623fa_bling
faceting1438783faceting
facetting1535283facetting
facing125321573fa__cing
factoring1537543factoring
fadging134210243fa_dging
fading114821113fa__ding
fagging133714763fa_gging
fagoting1336283fagoting
failing113521333fa_iling
fainting123312163fainting
fairing113614013fa_iring
faking145520983fa__king
falling113621583fa_lling
faltering132211123faltering
faming124922973fa__ming
famishing1845233famishing
fancying1735353fancying
fanning113615073fa_nning
farina94618233far__ina
farmhand1743563farmhand
farmings14298223far_mings
farrowing1645873farrowing
farseeing1344383farseeing
farther1348343farth_er
farthest1499863farthest
farthingale1851013farthingale
fastening13268603fastening
fastings124011943fast_ings
fathering161010093fa_thering
fathoming1844693fa_thoming
fatlings12359303fa_tlings
fattening13287833fattening
faulting12237733faulting
favoring1596673favoring
fawning14409133fa_wning
faxing175117053fa__xing
faying134521073fa__ying
fazing194418643fa__zing
fearing113520033fear__ing
feasting122011323feast_ing
felting113515213felt_ing
ferrying15146253ferrying
feruling1258873feruling
fetching17298413fetching
feting104417793f_et_ing
fetting113517873f_etting
fettling1266773fettling
fighting162710083fighting
filching1736113filching
firing104021723fir__ing
firming132811223fir_ming
firstling1334423firstling
fishing143913863f_ishing
fisting113818123fist_ing
fitting113516563f_itting
flaring114116803flar__ing
flashing153711553flashing
flatling123410013flatling
flatting123511253flatting
fleshing15339303fleshing
fletching18256143fletching
flirting12319013flirt_ing
flitching18265343flitching
fliting113514613flit_ing
flitting123010883flitting
flushing15288833flushing
fluting113815093flut_ing
flyting14378553flyt_ing
footing115017593foot_ing
footling12239923footling
foraging1358063foraging
foraying1537433foraying
forcing134013753for_cing
fording123717043for_ding
fordoing1357303fordoing
forewing1539013forewing
forging124114723for_ging
forgoing1366853forgoing
forking154014843for_king
forming133615733for_ming
fortuning1345493fortuning
fragging14329423fragging
framing133014793f_raming
franking164310863franking
frapping16348103frapping
fraying143413433f_raying
freeing113713913f_reeing
freshing152611023freshing
fretting122711523fretting
fritting123510703fritting
frizing203310873f_rizing
frying134511403f_r_ying
furling114016563fur_ling
furring114013143fur_ring
furthering1744353furthering
futzing20307903f_utzing
gaiting93716583gait_ing
garaging1139043garaging
garbing113613273gar_bing
garbling12249453garbling
gargling11239203gargling
garoting10510703garoting
garotting1136113garotting
garring93116713gar_ring
gartering112111593gartering
gashing125119233ga_shing
gasting95022763gast_ing
gating84826953ga_t_ing
girting93113333girt_ing
graphing1538533graphing
grating93923183grat_ing
hafting144014173haft_ing
halting114419073halt_ing
hanting114124483hant_ing
haring104233003har__ing
harking154120943har_king
harming133717933har_ming
harping134118383har_ping
harrying15157643harrying
hashing145020163ha_shing
hasting114725193hast_ing
hatching173312213hatching
hating104929713ha_t_ing
hatting113920233ha_tting
hearting12513123heart_ing
hurting113914033hurt_ing
hurtling12318313hurtling
inarching1546343inarching
inearthing1443543inearthing
jarring153613193jar_ring
kartings13418523kart_ings
kithing153411553_kithing
kything18285523_kything
larding92917873lar_ding
larking123718253lar_king
lashing114422893la_shing
lasting84725243last_ing
latching143712023latching
lathings12469853la_things
laughing1335933laughing
loathing1247673loathing
lurching14277333lurching
malting103219083malt_ing
mantling112012613mantling
marbling13179893marbling
marking144020143mar_king
marling103322783mar_ling
marring103319563mar_ring
marrying14157233marrying
martin84122533mart_in_
martini93613883mart_ini
martins93322073mart_ins
martyring1535783martyring
mashing134422243ma_shing
masting104325823mast_ing
matching163512393matching
mating94832913ma_t_ing
matting103620143ma_tting
morphing1637553morphing
mouthing142810243mouthing
naethings1343873naethings
narking124015383nar_king
northings13185573northings
nothing113511903_nothing
oaring74225303oar__ing
orating83520323orat_ing
panting104025423pant_ing
parading12313863parading
parawing14310583parawing
parging113318603par_ging
paring94236493par__ing
parking143423043par_king
parling103823773par_ling
paroling113316213paroling
parring103222063par_ring
parrying14168133parrying
parsing103819553par_sing
partaking1698673partaking
partings113513743part_ings
pashing135120513pa_shing
pasting103826553past_ing
patching163212753patching
patting103722343pa_tting
perching163711633perching
pithing134014053_pithing
plaything1843853plaything
porting103021783port_ing
prating103424453prat_ing
rafting113815753raft_ing
ralphing1435413ralphing
ranching141712043ranching
ranting84025413rant_ing
raring74332873rar__ing
rating74938703ra_t_ing
ratting83822363ra_tting
rattling92510873rattling
salting84120793salt_ing
sashing114621473sa_shing
sating74735453sa_t_ing
sauteing937913sauteing
scarphing1735243scarphing
scarting113415263scart_ing
scathing14269703scathing
scything17264883scything
searching1538343searching
seething1239023seething
smarting113212453smart_ing
soothing12269973soothing
sorting83221813sort_ing
southing122811823southing
starching1538593starching
starting93116173start_ing
startling1037373startling
swathing15248713swathing
taring73932283tar__ing
tarring83318303tar_ring
tarrying12146723tarrying
tasting84624213tast_ing
tatting84019523ta_tting
tattling9259473tattling
tauting83316383taut_ing
teething1237163teething
thing96622983___thing
tithing113513893_tithing
toothing12278863toothing
torching142510083torching
trashing122613223trashing
trithing122811773trithing
trothing122410843trothing
turtling9238833turtling
tything14316573_tything
unearthing1454373unearthing
varying1429723var_ying
vatting113614853va_tting
wafting143911663waft_ing
waiting113618953wait_ing
waltzing2134263waltzing
wanting114220173want_ing
warbling14198943warbling
warding123918143war_ding
waring105029443war__ing
warking153519573war_king
warming133515083war_ming
warning113717093war_ning
warping133715183war_ping
warring113717973war_ring
warsling12198593warsling
warstling1335063warstling
warthog1444543warth_og
washing145119283wa_shing
wasting114422843wast_ing
watching173011173watching
wattling12258783wattling
withing143814493_withing
writhing15278673writhing
xanthin1747043xanthin_
xanthine1847253xanthine
xanthins1846943xanthins
yachting1734933yachting
yarding123413143yar_ding
yarning113512953yar_ning

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 Filter1786911461620.406440125.6
2DLD Change Limit1461623827.40619735.6
3Display Results3823820.1562448.7
 (SQL Overall)1786913827.96822426.1
 
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.