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

266 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
northing1219906(None) 
northings13185571northings
nothing113511901no_thing
worthing15178051worthing
airthing12297952airthing
berthing14209602berthing
birthing14338432birthing
earthing12310332earthing
farthing1538072farthing
frothing15208532frothing
girthing13256082girthing
loathing1247672loathing
morphing1637552morphing
mouthing142810242mouthing
naething1236072naething
noshing114612772no_shing
notching14288582notching
nothings12266682no_things
noting74120152no_t_ing
porting103021782port_ing
snorting92613372snort_ing
soothing12269972soothing
sorting83221812sort_ing
southing122811822southing
toothing12278862toothing
torching142510082torching
trothing122410842trothing
aborting11710253abort_ing
airting83616303airt_ing
anorthic1346973anorthi_c
anorthite1245463anorthite
anything1534993anything
arching136216693_arching
bathing134816243_bathing
birching16328463birching
birthings15254623birthings
boating103721303boat_ing
bolting104416763bolt_ing
booting103821363boot_ing
borating113414503borating
boring94724873bor__ing
borking144716173bor_king
botching16359703botching
bottling11279143bottling
carting104228283cart_ing
chortling1535563chortling
clothing14278783clothing
coaching164011963coaching
coating103525313coat_ing
cording113620823cor_ding
coring94433963cor__ing
corking143018823cor_king
corning103720133cor_ning
cortin82423153cort_in_
cortina91915973cort_ina
cortins92421333cort_ins
coshing134316433co_shing
costing104323023cost_ing
coting94629253co_t_ing
couching163213263couching
coughing15309213coughing
courting112514573court_ing
darting94020663dart_ing
dartling1039563dartling
dirtying1336093dirtying
doating93816863doat_ing
doting84821913do_t_ing
dotting93314483do_tting
douching15349843douching
earthling1346193earthling
faithing1537153faithing
farthings1635233farthings
farting114120753fart_ing
footing115017593foot_ing
footling12239923footling
foraging1358063foraging
foraying1537433foraying
forcing134013753for_cing
fording123717043for_ding
fordoing1357303fordoing
forewing1539003forewing
forging124114723for_ging
forgoing1366853forgoing
forking154014843for_king
forming133615733for_ming
fortuning1345493fortuning
girting93113333girt_ing
gorging102611363gor_ging
goring84119573gor__ing
gorming112810833gor_ming
hogtying1633553hogtying
hoorahing1644913hoorahing
hooting113919883hoot_ing
hording123517053hor_ding
horning113015003hor_ning
horsing113215583hor_sing
hosting114318383host_ing
hotching17309313hotching
hotting113116523ho_tting
hurting113914033hurt_ing
hurtling12318313hurtling
inarching1546343inarching
inearthing1443543inearthing
intorting10311413intort_ing
jolting153410913jolt_ing
joshing18519413jo_shing
jostling16207123jostling
jotting152912773jo_tting
karting123716063kart_ing
kithing153411553_kithing
knotting13236573kno_tting
knouting13226793knout_ing
kything18285523_kything
lathing114315693_lathing
loathings1344213loathings
lofting113311313loft_ing
looting83019643loot_ing
lording93115233lor_ding
lordling1077743lordling
lotting82917753lo_tting
louting83719383lout_ing
lurching14277333lurching
marching164312193marching
marting103325013mart_ing
moating104218153moat_ing
molting103517173molt_ing
mooching16259063mooching
mooting103019363moot_ing
morning103215043mor_ning
morphin1439003morphin_
morphine1548703morphine
morphings1744683morphings
morphins1538653morphins
mortaring1237943mortaring
morticing1448013morticing
mortising1238693mortising
moshing134214883mo_shing
mottling11197753mottling
mouching163110583mouching
naethings1343873naethings
narking124015383nar_king
neighing1355523neighing
nerving112910833ner_ving
nesting84320443nest_ing
nestling958893nestling
netting84018763n_etting
nettling957213nettling
niching133612433n_iching
nighing123410063n_ighing
nobbling13228273nobbling
nocking143615113no_cking
nodding103811523no_dding
noddling11237263noddling
nogging103612723no_gging
noising83615173no_ising
nonbeing1137053nonbeing
noncling11310763noncling
nonruling1046433nonruling
nonusing939233nonusing
noodging11185693noodging
noodling10209443noodling
nooning83014853no_oning
noosing83315053no_osing
north86018273north___
norther1039733north_er
northern1145583northern
northerns1244933northerns
northers1139333northers
northland1343553northland
norths96812323north__s
nosing73419843no__sing
notating92513343notating
noticing1139453noticing
nourishing1444243nourishing
nudzhing2242033nudzhing
nurling84215823nur_ling
nursing84012553nur_sing
nursling997603nursling
nurturing1045013nurturing
nutting83316233n_utting
ohing96018813_o__hing
onrushing1364813onrushing
oohing104412933_o_ohing
opting94514403_opt_ing
orating83520323_orating
orbing93312363_or_bing
ouching134314903_ouching
outing74128153_out_ing
outring84021023_outring
outsing83320463_outsing
parching164313053parching
parting103527383part_ing
partying14168893partying
perching163711633perching
pithing134014053_pithing
poaching163510833poaching
pooching16328983pooching
poohing133112323po_ohing
poring94227273por__ing
porking143515813por_king
portaging1346843portaging
portering122012303portering
posting105622243post_ing
potting103720893po_tting
pouching163210413pouching
pouting103519943pout_ing
roaching143210433roaching
rooting83522433root_ing
rootling9269953rootling
rotting82919683ro_tting
roughing13278343roughing
routing83821093rout_ing
scathing14269703scathing
scorching1735633scorching
scything17264883scything
seething1239023seething
shorting122514803short_ing
smoothing1535293smoothing
snooting92813203snoot_ing
snoring83917203snor__ing
snouting92511923snout_ing
something1545403something
sooting82820963soot_ing
sorbing102815263sor_bing
soring74731883sor__ing
sorning83116813sor_ning
sortieing1046163sortieing
soughing13259733soughing
southings13246233southings
sporting112415463sport_ing
swathing15248713swathing
tarting84222653tart_ing
teething1237163teething
thing96622983___thing
tithing113513893_tithing
toiting83217093toit_ing
tooting83019423toot_ing
tootling9279523tootling
torquing1833843torquing
torturing1036253torturing
toting74123793to_t_ing
totting82816843to_tting
touching143211343touching
toughing13278553toughing
touting84118453tout_ing
trithing122811773trithing
trotting92510913trotting
turtling9238833turtling
tything14316573_tything
unearthing1454373unearthing
voting103916033vo_t_ing
vouching17308233vouching
withing143814493_withing
wonting113214103wont_ing
wooshing1536683wooshing
wording123014563wor_ding
working153813253wor_king
worming132811243wor_ming
worrying1534703worrying
worsting1267683worsting
worthier1436713worthier
worthies14310283worthies
worthily1745253worthily
wotting112913843wo_tting
wrathing15248923wrathing
writhing15278673writhing

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.423422437.4
2DLD Change Limit1461622667.67319048.9
3Display Results2662660.1062509.4
 (SQL Overall)1786912668.20221786.3
 
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.