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

224 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
lymphs163505(None) 
lymph1547041lymph_
nymphs1633501nymphs
bumphs15467102bumphs
glyphs1534302gly_phs
humphs16528162humphs
lampas106615952lampas
lamps95624832lamp_s
limpas105513082limpas
limps95522672limp_s
lumps95624982lump_s
nymph1555212nymph_
nympha1643572nympha
nympho1643582nympho
nymphos1744082nymphos
oomphs1344722oomphs
sylphs1435542sylphs
syphs13519452sy_phs
alephs1136533alephs
almahs118611613almahs
almehs11619493almehs
amahs107819063_amahs
amps86230343_amp_s
ayahs116813523ay_ahs
bimahs13508303bimahs
blimps12588153blimp_s
blypes13357543bly_pes
bumph144911983bumph_
bumps115921143bump_s
campos125217953campos
camps116330263camp_s
campus125213923campus
caphs124515373_caphs
clamps124515083clamp_s
clomps125212233clomp_s
clumps1215314643clump_s
compas125817063compas
compos124818803compos
comps115526053comp_s
compts125216653compts
cymars13599143cymars
cymas126417883cym_as
cymes1210118923cym_es
cymols1377193cymols
cymous1388403cymous
damps105220413damp_s
dumps105220103dump_s
flumps135112503flump_s
galumphs1642023galumphs
gamps105323713gamp_s
gimps105915203gimp_s
glyph1456473gly_ph_
graphs124510153graphs
gyms107514593gym__s
gyps105115023gy_p_s
hemps126917333hemp_s
humph155712213humph_
humps126322803hump_s
hymens1437993hymens
hymns1337523hym_ns
hypes135818673hy_pes
hypha1637383hy_pha
hypos1312014743hy_pos
hyps125418413hy_p_s
impis96213833_impis
imps86221113_imp_s
jumps165116493jump_s
kaphs144911503_kaphs
kemps135012523kemp_s
khaphs18394323khaphs
kophs145010933_kophs
laichs115110893laichs
laighs10508803laighs
lakhs125210343l_akhs
lamas75532793lam_as
lambs95921413lam_bs
lamedhs13444703lamedhs
lameds94812033lameds
lames75445543lam_es
lamias85020613lamias
lamp86233823lamp__
lampad114510033lampad
lampads12477623lampads
lamped114017543lamped
lampers113817333lampers
lams66552263lam__s
lapis76223153l_apis
laps66848873l_ap_s
laths86022403l_aths
laughs10489023laughs
layups1133993layup_s
leaps75522933leap_s
lemans85316393lemans
lemmas10349163lemmas
lemons84415053lemons
lemurs837253lemurs
limans84816303limans
limas75627633lim_as
limbas105313193limbas
limbos104712133limbos
limbs96118933lim_bs
limbus105710373limbus
limens84618033limens
limes75636503lim_es
limeys11429273limeys
limits82514133limits
limns75718393lim_ns
limos75320813lim_os
limp88432493limp__
limpa97014463limp_a
limped114817123limped
limper104117853limper
limpers113815223limpers
limpest113712313limpest
limpet103518633limpet
limpets11329783limpets
limpid11389743limpid
limply133810033limply
limpsy13516843limpsy
lips67141443l_ip_s
lisps76913903lisp_s
lochs106715513l_ochs
loops75723963loop_s
lopes76437343l_opes
lops66043353l_op_s
lotahs9479873lotahs
loughs105014773loughs
loupes84918053loupes
loups75319623loup_s
lumas75622913lum_as
lumens85013973lumens
lump86531703lump__
lumped114216963lumped
lumpen104010663lumpen
lumpens11298263lumpens
lumper103816653lumper
lumpers113514483lumpers
lumpish14127383lumpish
lumpy126615913lump_y
lums65734243lum__s
lupus74512523l_upus
lyases95211873lyases
lycees11428863lycees
lych126015763ly_ch_
lyches144213613lyches
lycras11287243lycras
lyes75530833ly__es
lyings10488503lyings
lymphoid1945073lymphoid
lymphoma2053653lymphoma
lymphomas2153403lymphomas
lynch13468983lynch_
lynches15378873lynches
lynxes1634323lynxes
lyres85019963ly_res
lyrics11357943lyrics
lyses84518253ly_ses
lysins94610953lysins
lysis84511463ly_sis
lyssas935443lyssas
lyttas985073lyttas
morphs13149433morphs
mumps115619103mump_s
mynahs14416443mynahs
myopes13419963myopes
myrrhs1443593myrrhs
myths135911603my_ths
nymphae1743833nymphae
nymphal1744033nymphal
nymphet1764323nymphet
nymphets1862703nymphets
oompahs1434263oompahs
oomph1236973oomph_
ouphs104311273_ouphs
pampas124913993pampas
pimps114616983pimp_s
plumps124612613plump_s
pomps115316193pomp_s
pumps115520603pump_s
qophs19507813_qophs
ralphs1135373ralphs
ramps96224633ramp_s
romps94617543romp_s
rumps95922293rump_s
rumpus10458893rumpus
samps96124673samp_s
simps94719763simp_s
slumps104313583slump_s
slypes114410483sly_pes
sophs104916023_sophs
staphs114411033staphs
sumps95023433sump_s
sylph1347793sylph_
sylphy1744153sylphy
synchs14408453synchs
synths12377883synths
syph125413273sy_ph_
tamps95524083tamp_s
tempehs14325153tempehs
tempos103812293tempos
temps95417133temp_s
tempts10439453tempts
tophs105220053_tophs
tumps95420793tump_s
tympan13257013tympan
tympans14236813tympans
types105721063ty_pes
typhus14395713ty_phus
typos106015813ty_pos
typps12549303ty_pps
umps85721943_ump_s
vamps125415483vamp_s
wampus13499013wampus
wimps125213803wimp_s
yaps95933523_yap_s
yeahs115214553_yeahs
yechs136112583_yechs
yeps95924403_yep_s
yipes106017843_yipes
yips95226693_yip_s
yodhs12669013_yodhs
yoghs125410593_yoghs
yups96121603_yup_s
zymes1924712943zym_es

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162245.29621283.2
3Display Results2242240.0762947.4
 (SQL Overall)1786912245.51232418.5
 
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.