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

267 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
longeing1017759(None) 
longing93915781long_ing
bingeing12237642bingeing
bonging113316372bong_ing
congaing1239822congaing
congeeing1337902congeeing
gonging103713032gong_ing
hongiing1335602hongiing
lingering11310492lingering
lodging103110812lodg_ing
logging103316802lo_gging
longings10408562long_ings
longline938762longline
lounging1036752loung_ing
lugeing9359112l_ugeing
lunging93714212lung_ing
mongering13310352mongering
nonbeing1137042nonbeing
ongoing938792_ongoing
ponging113416152pong_ing
singeing10209932singeing
tingeing10198532tingeing
tonging93314512tong_ing
tonguing1046262tonguing
ageing84213403__ageing
angeling102811733_angeling
angering102113803_angering
angling92816043_angling
anteing8312813_anteing
banging114019863bang_ing
belonging1335913belong_ing
binging113619383bing_ing
blogging13369013blo_gging
blunging12328413blung_ing
bogeying1575703bo_geying
bogging123615753bo_gging
boggling13257163boggling
bonding113318433bon_ding
boning94223293bon__ing
bonking144116373bon_king
bonneting1236173bonneting
boogeying1643623boogeying
boogieing1343793boogieing
boogying1535373boogying
bunging113616503bung_ing
bungling12269543bungling
canoeing11310213canoeing
clanging124012123clang_ing
clinging122910913cling_ing
clogging13368503clo_gging
cloning103215473clon__ing
clonking153810153clon_king
cogging123513713co_gging
coigning1237173coigning
conceding1559343conceding
congealing1447633congealing
congesting14410113congesting
coning94331823con__ing
conking143618453con_king
conning103718753con_ning
convening15311193convening
conveying1838323conveying
cooeeing1137453cooeeing
coughing15309213coughing
dangering12239303dangering
danging103716093dang_ing
dangling112611233dangling
dinging103618613ding_ing
dodging11299063dodg_ing
dogging113312693do_gging
donating10311803donating
donning93512763don_ning
dunging103012623dung_ing
eloigning1143453eloigning
elongating1244513elongating
fingering1439183fingering
flanging132710583flang_ing
flinging133310053fling_ing
flogging14329173flo_gging
fogging133513733fo_gging
fonding123815423fon_ding
fondling13189353fondling
fondueing1443093fondueing
fonduing13245893fonduing
forging124114723forg_ing
forgoing1366853forgoing
ganging103216193gang_ing
gangling112411403gangling
gingering1238863gingering
goggling10246283goggling
gorging102611363gorg_ing
gouging103410703goug_ing
hanging123518703hang_ing
hinging123917103hing_ing
hoeing104117023ho__eing
hogging133112803ho_gging
hondling132210013hondling
honeying1537673honeying
honing103421503hon__ing
honking153414793hon_king
honoring12310473honoring
hungering14187683hungering
inbeing1038323_inbeing
ingoing9311023_ingoing
ionising9310223ionising
ionizing1839503ionizing
jangling17249623jangling
jingling17188573jingling
jogging173211233jo_gging
joggling18215573joggling
jonesing1636633jonesing
kinging133115033king_ing
kneeing12226523_kneeing
konking113510213kon_king
laagering1136833laagering
lagering102212313l_agering
lagging103316733l_agging
lancing103314123lan_cing
landing92819323lan_ding
laughing1335933laughing
leaguing1035343leaguing
legging103912643l_egging
lending94118533len_ding
leniting9312353leniting
lensing84015103len_sing
leveeing12265963leveeing
linguine937583linguine
linguini945523linguini
lining74526803lin__ing
linking123818253lin_king
linting83820983lin_ting
lionising1046463lionising
lionizing1947053lionizing
loading94114613lo_ading
loafing11319793lo_afing
loaming103613733lo_aming
loaning83614833lo_aning
loathing1247673loathing
lobbing123110913lo_bbing
lobbying1633603lobbying
locating11311503locating
locking143718153lo_cking
locoing102810973lo_coing
lodgings11336243lodg_ings
lofting113311313lo_fting
loggings11398233lo_ggings
login66025003lo_g_in_
logins77820643lo_g_ins
loiding93313403lo_iding
loitering1039683loitering
lolling83415773lo_lling
lomein8410203lo_mein_
lomeins969473lo_meins
longan75612363long_an_
longans84510813long_ans
longe66626463longe___
longed87121373longe__d
longer75823193longe__r
longeron945753longeron
longerons1045893longerons
longers84819533longe_rs
longes75925573longe__s
longest84114953longe_st
longevity1652393longevity
longhand1344493longhand
longies82916553long_ies
longingly1445323long_ingly
longish11229093long_ish
longlines1047983longlines
longtime1144363longtime
longwise1244083longwise
looing73621043lo__oing
looking123415043lo_oking
looming102814853lo_oming
looping103615283lo_oping
loosening1044933loosening
loosing83515963lo_osing
looting83019643lo_oting
loping93921413lo__ping
loppering14237283loppering
lopping123815223lo_pping
lording93115233lo_rding
lordling1077743lordling
losing74022873lo__sing
lotting82917753lo_tting
loudening1144743loudening
louping104313983lo_uping
louring83916503lo_uring
lousing83817733lo_using
louting83719383lo_uting
loving104416723lo__ving
lowering122210913lowering
lowing104623273lo__wing
loxing143615273lo__xing
lugging104114353l_ugging
luging83915293l_ug_ing
lunching143110003lunching
lunting83817743lun_ting
lynching17336083lynching
mangling122312623mangling
mingling122010933mingling
mogging123311493mo_gging
monkeying1944473monkeying
nogging103612723no_gging
nonbeings1244173nonbeings
noncling11310763noncling
nonusing939233nonusing
ogling83211883_o_gling
panging113319113pang_ing
pinging113419553ping_ing
plonking15358563plon_king
ploughing16203673ploughing
plunging12357673plung_ing
poncing122913583pon_cing
pondering132411323pondering
ponding114317083pon_ding
ponying133312123pon_ying
pronging123511843prong_ing
pungling12228663pungling
ranging94120263rang_ing
reneging102111533reneging
ringing93521283ring_ing
rogering10310273ro_gering
rogueing1054313rogueing
roguing9309563ro_guing
roughing13278343roughing
rouging93114703roug_ing
singing93221423sing_ing
singling101913003singling
slanging103413433slang_ing
slinging103312863sling_ing
slogging113410493slo_gging
sloughing14244753sloughing
snogging11318043snogging
sonneting1037003sonneting
soughing13259733soughing
sponging1238823spong_ing
swingeing14144693swingeing
tanging93419523tang_ing
tangling101712533tangling
tangoing10177893tangoing
tinging93619443ting_ing
tingling102210803tingling
toeing74418473to__eing
togging103512743to_gging
toggling11206483toggling
tonguings1143223tonguings
toning74025793ton__ing
toughing13278553toughing
twingeing14143373twingeing
unageing1036273unageing
unbeing1039373_unbeing
venging123710943veng_ing
vogueing1332233vogueing
voguing12296093vo_guing
wangling132310993wangling
whingeing1733513whingeing
wingding1436453wingding
winging123718713wing_ing
wondering142110453wondering
wonning113210793won_ning
wonting113214103won_ting
wronging13327393wrong_ing
youngling1463273youngling
zinging183513943zing_ing
zoning162914333zon__ing
zonking21359113zon_king

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 Limit1461622678.56317069.0
3Display Results2672670.1062518.9
 (SQL Overall)1786912678.82520248.3
 
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.