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 “syphs” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

57 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
syphs1351945(None) 
sophs104916021sophs
sylphs1435541sylphs
syph125413271syph_
ayahs116813522ayahs
caphs124515372caphs
glyphs1534302glyphs
gyps105115022gyp_s
hypes135818672hypes
hypha1637382hypha
hypos1312014742hypos
hyps125418412hyp_s
kaphs144911502kaphs
kophs145010932kophs
lymphs1635052lymphs
myths135911602myths
nymphs1633502nymphs
ouphs104311272ouphs
psychs1653652psychs
qophs19507812qophs
saps65346372sap_s
scyphi1643172scyphi
scyphus1743202scyphus
septs75420602septs
shahs115919512shahs
sighs95416742sighs
sinhs86719602sinhs
sipes76036952sipes
sips65740112sip_s
skyphos1963732skyphos
slypes114410482slypes
soph97024202soph_
sophy136611762sophy
sops65244562sop_s
soths86218632soths
spas67036722s_pas
staphs114411032staphs
sughs95313322sughs
supes75628302supes
sups64834432sup_s
syces106416462syces
sykes124816862sykes
sylis84316022sylis
sylph1347792sylph_
sylphy1744152sylphy
synchs14408452synchs
syncs104610172syncs
synths12377882synths
sypher14317082sypher
syphers15317272syphers
syphon1436852syphon
syphons1537502syphons
tophs105220052tophs
types105721062types
typhus14395712typhus
typos106015812typos
typps12549302typps

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 Filter178691538000.533335255.2
2DLD Change Limit53800575.17610394.1
3Display Results57570.0163562.5
 (SQL Overall)178691575.72531212.4
 
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.