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

150 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
nymphs163350(None) 
lymphs1635051lymphs
nymph1555211nymph_
nympha1643571nympha
nympho1643581nympho
nymphos1744081nymphos
bumphs15467102bumphs
humphs16528162humphs
lymph1547042lymph_
nymphae1743832nymphae
nymphal1744032nymphal
nymphet1764322nymphet
nymphets1862702nymphets
oomphs1344722oomphs
sylphs1435542sylphs
syphs13519452sy_phs
alephs1136533alephs
almahs118611613almahs
almehs11619493almehs
amahs107819063_amahs
amps86230343_amp_s
ayahs116813523ay_ahs
bimahs13508303bimahs
bumph144911983bumph_
bumps115921143bump_s
campos125217953campos
camps116330263camp_s
campus125213923campus
caphs124515373_caphs
compas125817063compas
compos124818803compos
comps115526053comp_s
compts125216653compts
cymars13599153cymars
cymas126417883cym_as
cymes1210118923cym_es
cymols1377193cymols
cymous1388403cymous
damps105220413damp_s
dumps105220103dump_s
gamps105323713gamp_s
gimps105915203gimp_s
glyphs1534303glyphs
graphs124510153graphs
gyms107514593gym__s
gyps105115023gy_p_s
hemps126917333hemp_s
humph155712213humph_
humps126322803hump_s
hymens1437993hymens
hymns1337523hym_ns
hypes135818673hy_pes
hypha1637383hy_pha
hypos1312014743hy_pos
hyps125418413hy_p_s
impis96213853_impis
imps86221123_imp_s
jumps165116493jump_s
kaphs144911503_kaphs
kemps135012523kemp_s
khaphs18394323khaphs
kophs145010933_kophs
lampas106615953lampas
lamps95624833lamp_s
limpas105513083limpas
limps95522673limp_s
lumps95624983lump_s
morphs13149433morphs
mumps115619103mump_s
mynahs14416443mynahs
myopes13419963myopes
myrrhs1443603myrrhs
myths135911603my_ths
namers84517333namers
names74833363nam_es
napas75924353n_apas
napes74828463n_apes
nappas105511613nappas
nappes104515623nappes
naps66238583n_ap_s
neaps75618323neap_s
neeps75617883neep_s
neighs10387733neighs
nemas75321573nem_as
nighs95013613n_ighs
nimbus10377283nimbus
nims66226883nim__s
ninths936933ninths
nipas77116673n_ipas
nips65830923n_ip_s
nomads94711603nomads
nomas74726413nom_as
nomes74933123nom_es
nomos75919743nom_os
noms65636403nom__s
norths96812323norths
numbs94913093num_bs
nyalas936903nyalas
nylons9267973nylons
nymphean1842403nymphean
oompahs1434263oompahs
oomph1236973oomph_
ouphs104311273_ouphs
pampas124913993pampas
pimps114616983pimp_s
pomps115316193pomp_s
pumps115520603pump_s
qophs19507813_qophs
ralphs1135373ralphs
ramps96224633ramp_s
romps94617543romp_s
rumps95922293rump_s
rumpus10458893rumpus
samps96124673samp_s
simps94719763simp_s
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
yips95226703_yip_s
yodhs12669013_yodhs
yoghs125410593_yoghs
yups96121603_yup_s
zymes1924712943zym_es

Search took 5 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.1261418182.5
2DLD Change Limit1127161504.62624365.8
3Display Results1501500.0463260.9
 (SQL Overall)1786911504.79837242.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.