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

179 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
skylit133828(None) 
daylit10512492daylit
kylix19416322_kylix
skelpit1344942skelpit
skit85437542sk__it
skylight1943992skylight
skylike1336102skylike
skyline1436792skyline
slit46250102s__lit
split75729012s_plit
stylet94018572stylet
styli83911172styli_
stylist102110282stylist
stylite10219612stylite
sunlit61516102sunlit
syli74318982s_yli_
sylis84316022s_ylis
alit46155693__alit
alkylic16174233alkylic
amylic13108713amylic
beylic1337823beylic
beylik1545883beylik
cylix17448623_cylix
drylot1037403drylot
flit76539273__flit
gaslit7513503gaslit
idylist1146653idylist
kalif125021363_kalif
kelim11912553_kelim
kelt85343203_kel_t
kilim11711903_kilim
kilt86144433_kil_t
kit78559893_k__it
klik74412663_k_lik
knit85728153_k_nit
krait94726773_krait
kyat116025533_ky_at
kyrie123712903_kyrie
lit39377323___lit
mislit83019693mislit
phylic16279553phylic
relit55340683_relit
salic73424713s_alic
sallet63734543sallet
salt45758523s_al_t
samlet84126563samlet
sault55834963saul_t
sayest94217743sayest
sayid95516723say_id
sayst85322003say_st
sayyid13185353sayyid
schuit1139563schuit
sculpt104412693sculpt
sealift10312793sealift
sennit63117923sennit
shalt85534493shal_t
shilpit1247103shilpit
shit76745943s__hit
shyest125511833shyest
shyly144811573shyl_y
sialic8313633sialic
sialid7314943sialid
sibylic1444633sibylic
silt46558203s_il_t
simlin8311733simlin
sit35877763s___it
skald104210173skal_d
skaldic1443553skaldic
skalds11437833skalds
skat87037903sk__at
skeet95429183sk_eet
skein94814413sk_ein
skell94915833skel_l
skells105013783skells
skelm114211293skel_m
skelms12368023skelms
skelp114211423skel_p
skelps12407923skelps
ski74925703sk__i_
skid95720943sk__id
skill94316733skil_l
skillet113512153skillet
skills104313923skills
skim105322523sk__im
skin85927543sk__in
skint95629233sk_int
skip105421763sk__ip
skirt95624673sk_irt
skis84825303sk__is
skite95120063sk__ite
skits94721873sk__its
sklent103614353sklent
skort94925643sk_ort
skulk8479623skul_k
skulks9427243skulks
skull94812033skul_l
skulls10429643skulls
sky106420993sky___
skybox2242293skybox
skycap1742913skycap
skydive1852773skydive
skyed13529923sky_ed
skyey15537223sky_ey
skying14399983skying
skylark1343273skylark
skylights2042843skylights
skylines1535703skylines
skyman1535313skyman
skymen1535313skymen
skysail1462843skysail
skyway1933343skyway
skywrite1842923skywrite
slat46959023s__lat
slid55828993s__lid
slim66631963s__lim
slip67031733s__lip
slipt76627483s__lipt
slits56128853s__lits
slot46049833s__lot
slut45040593s__lut
slyest93811363slyest
slyly11489533slyl_y
smalt74729333smal_t
smalti84111193smalti
smelt74726783smel_t
smit65138413s__mit
smolt74824163smol_t
snit46342473s__nit
sobeit8315363sobeit
soffit1237883soffit
soli46637013s_oli_
solid65025083s_olid
spait75631603s_pait
spelt75430193spel_t
spilt75532223spil_t
spirit83519923spirit
spit65545083s__pit
splat76129343s_plat
splint85223283s_plint
splits85416413s_plits
spoilt85016593spoilt
spotlit947303spotlit
sprit76736403s_prit
starlit71512913starlit
stelic8313083stelic
stilt54831983stil_t
stolid74213183stolid
strait64025893strait
stylar9358113stylar
stylate10179773stylate
style85519363styl_e
styled105613103styled
styler94013303styler
styles94418653styles
stylets10369213stylets
styling112910653styling
stylise10208953stylise
stylish13197443stylish
stylists11207023stylists
stylites11168693stylites
stylitic1356343stylitic
stylize19177453stylize
styloid1137553styloid
stylus9397463stylus
stymie1137623stymie
sublet82827243sublet
sublot82315523sublot
submit10312673submit
suit45649873s__uit
summit10311543summit
suslik1036373suslik
sylph1347793s_ylph
sylva11268443s_ylva
sylvin12247303s_ylvin
sylvite13266353s_ylvite
tallit63422733tallit
twilit949553twilit
unlit55025463_unlit
uplit76020803_uplit

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.373479064.3
2DLD Change Limit1127161795.12621989.1
3Display Results1791790.0602983.3
 (SQL Overall)1786911795.55932144.5
 
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.