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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

145 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
shily11522201(None) 
shaly114322861shaly
shill85325331shill
shiny115122141shiny
shyly144811571shyly
slily85820031slily
bushily15268892bushily
chicly16429202chicly
child114516222child
chile105626892chile
chili106218482chili
chill105619872chill
chilly144113222chilly
chivy164810362chivy
cushily15257922cushily
daily95922332daily
doily95321032doily
drily95816522drily
fishily1637642fishily
gaily95020972gaily
gushily14257822gushily
hila76228352_hila
hili75626632_hili
hill76439492_hill
hilly114422162_hilly
hilt75850712_hilt
hiply134113612_hiply
holy106333432_holy
icily101211692icily
lily76730182_lily
mushily152410092mushily
noily86120992noily
oily77932252_oily
pily96132732_pily
pushily15247982pushily
roily86121112roily
sadly94519122sadly
sail45447162sail_
sails55738102sails
sally85129712sally
scaly104718722scaly
schizy23115042schizy
seely84522632seely
sexily1638852sexily
shadily1437722shadily
shady125416512shady
shakily1736902shakily
shaky154616842shaky
shale85332832shale
shaley123714992shaley
shall85024052shall
shalt85534492shalt
shay107133342sh_ay
sheila969842sheila
shelf115221112shelf
shell84424122shell
shelly124414472shelly
shelty124011552shelty
shelvy15377862shelvy
shied96125492shied
shiel811023772shiel
shield106212972shield
shiels95418922shiels
shier85428942shier
shies86136552shies
shift114225142shift
shifty15409262shifty
shills94519612shills
shim95827862shi_m
shimmy16306412shimmy
shims104422552shims
shin75634312shi_n
shindy13449322shindy
shine85533092shine
shingly143210812shingly
shinily13268932shinily
shinny124810782shinny
shins85131042shins
ship95228242shi_p
ships105123772ships
shire84727132shire
shirk124817842shirk
shirr84716922shirr
shirt84533902shirt
shirty124312562shirty
shist84829612shist
shit76745942shi_t
shits84731172shits
shitty124110062shitty
shiv105721172shi_v
shiva115915002shiva
shive114423422shive
shivs115018802shivs
shoaly124010772shoaly
showily1636222showily
showy145714012showy
shrill94712302shrill
shrilly13318562shrilly
shul75823152shul_
shuln84713112shuln
shuls85319712shuls
shy96728192sh__y
sild55030582s_ild
silk85529322s_ilk
silky125315822s_ilky
sill45545152s_ill
silly84527622silly
silo46037912s_ilo
silt46558192s_ilt
silty84721632s_ilty
sizy164816392s_izy
skiey125012892skiey
skill94316722skill
slimly11408902slimly
slimy105417422slimy
sly66228562s__ly
slyly11489532slyly
smile74823922smile
smiley114012302smiley
soil46138832soil_
soils55327982soils
sonly85718052sonly
spicy125417712spicy
spiky146014112spiky
spile75230082spile
spill74821162spill
spilt75532222spilt
spiny104921302spiny
spiry105017352spiry
stile54931572stile
still54922082still
stilly93714092stilly
stilt54831982stilt
stimy105114742stimy
sully84622902sully
surly85124432surly
swill83417372swill
swirly12439252swirly
thill85918732thill
thinly1238672thinly
while115418692while
whiny144915572whiny
whirly15448862whirly
whity145513472whity
wily106428812_wily

Search took 2 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.0931921408.6
2DLD Change Limit538001451.67332157.8
3Display Results1451450.0463152.2
 (SQL Overall)1786911451.81298615.3
 
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.