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

118 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
sylphy174415(None) 
sylph1347791sylph_
sylphs1435541sylphs
sophy136611762s_ophy
sulpha1135402sulpha
sylphic1745882sylphic
sylphid1645962sylphid
syph125413272sy_ph_
syphs13519452sy_phs
alpha1049653_alpha
alphyl1484083_alphyl
bolshy1444883bolshy
byplay1634193byplay
filthy15356423filthy
glyph1456473glyph_
glyphs1534303glyphs
gulpy114612763gulp_y
gypsy14636993gy_psy
hypha1637383hy_pha
kelpy145110683kelp_y
lymph1547043lymph_
lymphs1635053lymphs
murphy1654343murphy
myopy15457353myop_y
mythy16568673my_thy
nymph1555213nymph_
nympha1643573nympha
nympho1643583nympho
nymphs1633503nymphs
pulpy124612363pulp_y
ralph1078743ralph_
ralphs1135373ralphs
salary9515213salary
salify12311373salify
sally85129713sal_ly
salp64534093salp__
salpa75018353salp_a
salpae84614273salpae
salpas85116923salpas
salpid9510883salpid
salps74423243salp_s
salty85524383sal_ty
sappy125413473s_appy
saughy13507463saughy
scyphi1643173scyphi
seepy104717973seep_y
selah8319613selah_
selahs9313213selahs
sepoy10314303s_epoy
shy96728193s___hy
shyly144811573shyl__y
silky125315823sil_ky
silly84527623sil_ly
silty84721633sil_ty
simply133010523simply
slaty86523153s_laty
slay76436383s_l_ay
slily85820033s_lily
slimy105417423s_limy
slippy1375843slippy
sloppy1395303sloppy
sloshy12366623sloshy
slushy12417223slushy
sly66228563s_l__y
slyly11489533s_lyly
slype105112363slyp_e
slypes114410483slypes
smithy14508273smithy
snappy1366103snappy
snippy1374843snippy
soapy106114783soap_y
solely93714213solely
soph97024203s_oph_
sophs104916023s_ophs
soppy125113523s_oppy
soupy106115403soup_y
spay96631663s__pay
splashy1543553splashy
splay105816043spl_ay
spry96819123s__pry
spy86023743s__p_y
staph104314653staph_
staphs114411033staphs
stithy12398213stithy
sulky124715363sul_ky
sully84622903sul_ly
sulphas1236243sulphas
sulphid1346113sulphid
sulphur12123873sulphur
sulphury16122753sulphury
sultry938463sultry
supply1346893supply
swishy15365843swishy
syli74318983syl__i
sylis84316023syl_is
sylphids1743953sylphids
sylphish1944273sylphish
sylva11268443syl_va
sylvae12236863sylvae
sylvan12257363sylvan
sylvas12288173sylvas
sylvin12247303sylvin
sympathy2143613sympathy
symphony2144503symphony
synch135011793synch_
synchs14408453synchs
synth113711823synth_
synths12377883synths
sypher14317083sy_pher
syphon1436853sy_phon
syrphid1646103syrphid
syrupy14285823syrupy
syzygy2141113syzygy
trophy1438283trophy
typey135511883ty_pey
typy126013043ty_p_y
yechy16519083_yechy
yuppy15487913_yuppy

Search took 7 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.376475242.0
2DLD Change Limit1127161186.03018692.5
3Display Results1181180.0333575.8
 (SQL Overall)1786911186.43927751.4
 
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.