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

239 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
daylit1051249(None) 
alit46155692_a_lit
dacoit9415452dacoit
dahlia1035772dahlia
dakoit11310352dakoit
dammit11311132dammit
davit93424592da_vit
daylight1644512daylight
daylily1434982daylily
drylot1037402drylot
gaslit7513502gaslit
skylit1338282skylit
tallit63422732tallit
aalii5316133_aalii
adit56443653_a_dit
admit8319493_admit
adroit7518793adroit
adult63520653adul_t
afrit8323173_afrit
aglet65534143_aglet
ait38093903_a__it
alif76242143_a_lif
alist56136783_a_list
allot54933873_allot
alt36467963_a_l_t
ambit94223713_ambit
amylic13108713amylic
aplite8316393_aplite
atilt54828473_atilt
audit62527883_audit
aulic74420243_aulic
await85524493_await
ayin76331743_ay_in
baalim1038473baalim
babysit14145613babysit
backlit15911903backlit
bailie83818363bailie
bait66556003ba__it
ballet84733973ballet
ballot84624093ballot
bandit93821133bandit
bankit123617043bankit
beylic1337823beylic
beylik1545883beylik
cablet104429463cablet
calif104929103ca_lif
calix145317353ca_lix
callet84536763callet
camlet104426583camlet
caplet104226813caplet
caplin103216303caplin
carlin84421823carlin
catlin83819083catlin
caulis85320083caulis
cylix17448623_cylix
dacite91115883da_cite
dacoits1079073dacoits
dacoity1366183dacoity
dactyli1343603dactyli_
dactylic1643673dactylic
dadaist9310103dadaist
daft85537253da__ft
dahl87019223dahl__
dahlias1135723dahlias
dahls95012283dahl_s
dailies84219263dailies
daily95922333dail_y
daimio937463daimio
dais57040703da__is
dakoits1245293dakoits
dakoity1543423dakoity
dal47554953da_l__
dale55643983da_l_e
dales66439743da_les
daleth1038633da_leth
dalles74222063dalles
dallied93713613dallied
dallier84215373dallier
dallies84023193dallies
dally95324743da_lly
dals57145123da_l_s
danio6319783da_nio
daric85623123da_ric
darkie113714013darkie
darling93418363darling
dart55857873da__rt
dashi95013113dashi_
dashis104414393dashis
dassie74615573dassie
daunt65929083da_unt
daut56443563da__ut
dautie72914703dautie
davits104012363da_vits
dawt85435943da__wt
dawtie103011093dawtie
day76254113day___
daybed13438673daybed
dayflies1534463dayflies
dayfly1633813dayfly
dayglow1541843dayglow
daylights1743283daylights
daylong1233973daylong
days87637133day__s
dayside1236173dayside
daytime1344783daytime
deadlift1345633deadlift
dealt65234283deal_t
debit85727853d_ebit
deceit93018213deceit
delft95623323d_elft
deli55631293d_eli_
delict94320333d_elict
delis64928543d_elis
delist74625053d_elist
delt57855273d_el_t
demit84832303d_emit
dialist8517763dialist
diallist949553diallist
digit73825273d_igit
diglot83014333diglot
dimwit1237953dimwit
dit47071333d___it
dixit134420593d_ixit
doit56347853d__oit
dolt56649423d_ol_t
doolie73916833doolie
doyley13487283doyley
doylies114512573doylies
doyly124514013doyl_y
droit65127123d_roit
dryest104811123dryest
drylots1143743drylots
dryly12538453dryl_y
dualist8614053dualist
duality1147963duality
duelist8511413duelist
duit56241583d__uit
dulia61014983d_ulia
dunlin739723dunlin
dwelt94316523dwel_t
dyadic1336093dyadic
eaglet73722583eaglet
fault85428313faul_t
fayalite1447053fayalite
flit76539273__flit
gait56150193ga__it
galiot72322593ga_liot
gallet73630853gallet
gallic9411643gallic
galliot82214133galliot
gambit114714213gambit
garlic9310043garlic
gault65128483gaul_t
gayest104314333gayest
gayly124513093gayl_y
habit103027023ha_bit
haffit1538533haffit
halid94424983ha_lid
halite93624233ha_lite
hallot95426783hallot
halt76056303ha_l_t
hamlet113722793hamlet
haplite12310703haplite
harlot94422803harlot
haslet93222713haslet
hayloft1696963hayloft
hyalin122210043hyalin
hyalite13229473hyalite
idylist1146653idylist
kainit10414483kainit
kalif125021363ka_lif
kaolin1039583kaolin
kayles134712003kayles
kylix19416323_kylix
layin84720333lay_in
layout9513703layout
lit39377313___lit
malic94525663ma_lic
mallet84433053mallet
malt66254813ma_l_t
marlin84220903marlin
marlite92917073marlite
mayest114614793mayest
mayst106622673may_st
mayvin1436523mayvin
mislit83019693mislit
palet74650803pa_let
pallet84232653pallet
pallia83015593pallia
pallid93915283pallid
pandit93820753pandit
paulin8312983paulin
paynim1337363paynim
payout11714653payout
phylic16279553phylic
playlet1239523playlet
playlist1347573playlist
rabbit102914563rabbit
ratlin64116523ratlin
raylike14269253raylike
relit55340683_relit
salic73424713sa_lic
sallet63734543sallet
salt45758523sa_l_t
samlet84126563samlet
sault55834963saul_t
sayest94217743sayest
sayid95516723say_id
sayst85322003say_st
sayyid13185353sayyid
slit46250103__slit
split75729013_split
starlit71512913starlit
stylet94018573stylet
styli83911173styli_
stylist102110283stylist
stylite10219613stylite
sunlit61516103sunlit
syli74318983_syli_
sylis84316023_sylis
tablet84227643tablet
tacit76333673ta_cit
tali46837163ta_li_
tallis63319963tallis
tallith102913063tallith
tallits73215993tallits
twilit949553twilit
unlit55025463_unlit
uplit76020803_uplit
valet84337873va_let
valid94618393va_lid
varlet9423503varlet
vault85823763vaul_t
wait75553693wa__it
wallet93327093wallet
wallie93216803wallie
waylaid1445093waylaid
waylay1535453waylay
zayin174512043zay_in

Search took 10 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.766233278.1
2DLD Change Limit1127162398.12613871.0
3Display Results2392390.0763144.7
 (SQL Overall)1786912398.96819925.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.