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

75 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
sylis8431602(None) 
syli74318981syli_
cylix17448622cylix
delis64928542delis
hylas114815902hylas
kylix19416322kylix
lis37162272__lis
lysis84511462lysis
pilis75825202pilis
polis74731162polis
pulis74225602pulis
pyxis17458632pyxis
sadis64930852sadis
sails55738102sails
sakis95323672sakis
sales56055592sales
salic73424712salic
salmis8514272salmis
salps74423242salps
sals46851672sal_s
salts55431882salts
saris54544952saris
satis55633682satis
seis45542392s_eis
selfs85220242selfs
sells55134432sells
sels46345982sel_s
semis74623532semis
shris84221452shris
silds65520522silds
silks94620682silks
sills55135992sills
silos56029432silos
silts55330822silts
sis37360542s__is
skis84825292s_kis
skylit1338282skylit
slid55828982s_lid
slim66631962s_lim
slims75423652s_lims
slip67031732s_lip
slips76023722s_lips
slit46250102s_lit
slits56128852s_lits
soils55327982soils
soles55547922soles
soli46637012soli_
solid65025082solid
solids74116402solids
solos54830792solos
sols45448162sol_s
solus54726982solus
split75729012split
splits85416412splits
sris45434152s_ris
styles94418652styles
styli83911172styli_
stylise10208952stylise
stylish13197442stylish
stylist102110282stylist
stylus9397462stylus
sulks94818462sulks
sulus54821882sulus
syces106416462syces
sykes124816862sykes
sylph1347792sylph
sylphs1435542sylphs
sylva11268442sylva
sylvas12288172sylvas
sylvin12247302sylvin
sylvins13246242sylvins
syncs104610172syncs
syphs13519452syphs
wyles114615322wyles
ywis105313102_ywis

Search took 3 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.313570897.8
2DLD Change Limit53800751.84329191.5
3Display Results75750.0302500.0
 (SQL Overall)178691752.18681743.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.