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

292 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
laughing133593(None) 
laughings1443481laughings
claughting1742482claughting
coughing15309212coughing
gauging10339962gaug_ing
lagging103316742la_gging
lashing114422892la_shing
latching143712022latching
lathing114315692la_thing
lauding93211902lau_ding
laughingly1842702laughingly
laughline1342912laughline
launching1544782launching
lugeing9359112l_ugeing
lugging104114352l_ugging
luging83915292l_ug_ing
lushing114316112l_ushing
ploughing16203672ploughing
roughing13278342roughing
sloughing14244752sloughing
soughing13259732soughing
sughing12359712_sughing
toughing13278552toughing
waughting1743122waughting
aahing1019015763_a_ahing
aching126521973_a_ching
ageing84213403_a_geing
aging77026353_a_g_ing
ahing98928353_a__hing
alighting1446413alighting
aligning10158533aligning
angling92816043_angling
arching136216693_arching
argling92812733_argling
arguing9248733_arguing
ashing107824093_a_shing
auding83616933_au_ding
auguring1036383_auguring
autoing8314043_autoing
baching156017753ba_ching
badging123712793badg_ing
bagging123316983ba_gging
banging114019863bang_ing
barging114018483barg_ing
bashing135422583ba_shing
batching163712093batching
bathing134816243ba_thing
baulking1536003baulking
blagging13319173bla_gging
blanching17297093blanching
blushing14339333blushing
brushing14359963brushing
bugging123515183_bugging
bugling113615343_bugling
bushing134018583_bushing
caching156317503ca_ching
cadging123610973cadg_ing
caging105321023ca_g_ing
cashing135022553ca_shing
catching163712773catching
caulking1536803caulking
causing103614413cau_sing
chugging1634913chugging
clagging13328883cla_gging
clanging124012123clang_ing
clashing143812193cla_shing
couching163213263couching
crushing143010053crushing
daggling12237063daggling
danging103716093dang_ing
dangling112611233dangling
dashing125917893da_shing
daubing11358623dau_bing
daunting103310403daunting
dauphin1344383dauphin_
dauphine1444493dauphine
dauphins1444523dauphins
dauting93814763dau_ting
douching15349843douching
draughting1642883draughting
drugging12326443drugging
eagling91113603ea_gling
earthing12310333earthing
fadging134210243fadg_ing
fagging133714763fa_gging
faithing1537153faithing
farthing1538073farthing
fashing144918793fa_shing
faulting12237733faulting
flagging14329233fla_gging
flanging132710583flang_ing
flashing153711553fla_shing
flaunting1335043flaunting
flushing15288833flushing
fraughting1843063fraughting
frugging14317053frugging
fugging133912913_fugging
fugling124212513_fugling
fuguing12337483_fuguing
gagging93013533ga_gging
gaggling10217463gaggling
gaging94718403ga_g_ing
ganging103216193gang_ing
gangling112411403gangling
gargling11239203gargling
gashing125119233ga_shing
gauming11319713gau_ming
glugging10316353glugging
gouging103410703goug_ing
gushing124014223_gushing
hagging133114683ha_gging
haggling14227273haggling
hanging123518703hang_ing
hashing145020163ha_shing
hatching173312213hatching
hauling113714433hau_ling
haunting123510053haunting
hugging132710633_hugging
hushing144514473_hushing
jagging173311993ja_gging
jangling17249623jangling
jauking19418323jau_king
jauncing18314783jauncing
jaunting16328633jaunting
jauping17307193jau_ping
jugging172910723_jugging
kluging13356593klug_ing
laagering1136833laagering
labeling11311653labeling
laboring112110143laboring
lacewing1435843lacewing
lacing94626233la__cing
lacking143821543la_cking
ladening1078823ladening
lading84227123la__ding
ladling92813393la_dling
lagering102212313lagering
laggings11298403la_ggings
lairing83715343la_iring
laking115027043la__king
lalling83519633la_lling
lambing123412413la_mbing
laming94528363la__ming
lamming123014583la_mming
lamping123116003la_mping
lancing103314123la_ncing
landing92819323la_nding
lapping124117023la_pping
lapsing103511163la_psing
lapwing13308263la_pwing
larding92917873la_rding
larking123718253la_rking
lashings124412253la_shings
lashins103915153la_shins
lasing74727983la__sing
lassoing946383lassoing
lasting84725243la_sting
latening9711493latening
lathings12469853la_things
laugh94414373laugh___
laughed1235893laugh_ed
laugher1136603laugh_er
laughers1235923laughers
laughlines1442663laughlines
laughs10489023laugh__s
laughter1245113laughter
laureling1035643laureling
lauwine1036373lau_wine
laving104623573la__ving
lavishing1644553lavishing
lawgiving1762143lawgiving
lawing104625283la__wing
layering122310353layering
laying104525703la__ying
lazing164821473la__zing
lazying2046673la_zying
leaching143012833leaching
leaguing1035343leaguing
leashing123310313leashing
leching134613653l_eching
leeching14318373leeching
legging103912643l_egging
letching143810263letching
lighting132811833l_ighting
loathing1247673loathing
lodging103110813lodg_ing
logging103316813l_ogging
longeing10177593longeing
longing93915783long_ing
lounging1036753lounging
louping104313983lou_ping
louring83916503lou_ring
lousing83817733lou_sing
louting83719383lou_ting
lubing94114043l_u_bing
lucking143615833l_ucking
luffing143310103l_uffing
lulling83616803l_ulling
lumping123314643l_umping
lunching143110003lunching
lunging93714213l_unging
lunting83817743l_unting
lurching14277333lurching
luring73820753l_u_ring
lurking123710853l_urking
lusting83619323l_usting
luting75221753l_u_ting
lynching17336083lynching
mangling122312623mangling
marching164312193marching
mashing134422243ma_shing
matching163512393matching
mauling103315683mau_ling
mouching163110583mouching
mouthing142810243mouthing
mugging122711793_mugging
mushing134217633_mushing
naething1236073naething
nagging102613043na_gging
neighing1355523neighing
nighing123410063_nighing
ouching134314903_ouching
oughting1335953_oughting
outlaughing1642463outlaughing
paging104020403pa_g_ing
panging113319113pang_ing
parching164313053parching
parging113318603parg_ing
pashing135120513pa_shing
patching163212753patching
pausing103912813pau_sing
plaguing1236033pla_guing
plashing143311063pla_shing
playgoing1663563playgoing
plaything1843853plaything
plugging13306893plugging
pouching163210413pouching
pugging122912543_pugging
pushing133615453_pushing
quashing2137093quashing
ragging103516683ra_gging
raging85126433ra_g_ing
ralphing1435413ralphing
ranching141712043ranching
ranging94120263rang_ing
rouging93114703roug_ing
ruching133612933_ruching
rugging102512763_rugging
rushing113817703_rushing
sagging103116103sa_gging
sashing114621473sa_shing
saucing10311003sau_cing
saunaing937013saunaing
sauteing937913sauteing
shushing15317743shushing
sighing123311663_sighing
slagging113711583sla_gging
slanging103413433slang_ing
slashing123713413sla_shing
sleighing1434213sleighing
sleuthing1334203sleuthing
slouching15195723slouching
slugging11339423slugging
slushing12299643slushing
smushing14287453smushing
snugging11286933snugging
southing122811823southing
tagging103014913ta_gging
tanging93419533tang_ing
tangling101712543tangling
tangoing10177893tangoing
taunting93510933taunting
tauting83316383tau_ting
touching143211343touching
tugging102611233_tugging
tushing114214013_tushing
vaulting12227233vaulting
vaunting12338753vaunting
vouching17308233vouching
wagging133313353wa_gging
waggling14197063waggling
waging114318383wa_g_ing
wangling132310993wangling
washing145119283wa_shing
watching173011173watching
wauchting1843473wauchting
wauking153410013wau_king
wauling112713113wau_ling
waygoing1633273waygoing
weighing1635283weighing
yauping13357243yau_ping
zagging193210453za_gging

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.483369960.7
2DLD Change Limit1461622927.29620033.2
3Display Results2922920.1262317.5
 (SQL Overall)1786912927.90522604.8
 
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.