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

213 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
stiles6432877(None) 
smiles84522291smiles
spiles84227911spiles
stales65538291stales
steles63725661steles
sties55132981sti_es
stifles103013391stifles
stile54931571stile_
stills64118571stills
stilts67915311stilts
stimes85920571stimes
stipes84524051stipes
stoles63927671stoles
styles94418651styles
tiles55542101_tiles
astilbes1044732astilbes
bastiles10313352bastiles
biles75542142_biles
chiles115425302chiles
ediles74016982ediles
etoiles7411292etoiles
exiles134816402exiles
files85441272_files
guiles73919282guiles
hostiles11312212hostiles
istles62814982ist_les
mailes84329112mailes
miles74645072_miles
motiles93317432motiles
ostioles839272ostioles
piles74742612_piles
retiles74426992retiles
riles55343642_riles
rutiles74315842rutiles
sables85026692sables
saices84221802saices
sailed74327762sailed
sailer63526102sailer
sailers73822322sailers
sails55738102sail_s
sales56055592s_ales
satires72617572satires
scales84529312scales
seines65029902seines
seises64026712seises
seizes154317532seizes
selles64426982selles
seniles72618022seniles
settles73916002settles
sextiles1537642sextiles
shales94731252shales
shiels95418922shiels
shies86136552shi_es
shills94519612shills
shines95028912shines
shires95225572shires
shives124921412shives
sices75637272s_ices
sides65838362s_ides
sidles74721152sidles
sikes96236082s_ikes
silds65520522s_ilds
silex123417412s_ilex
silks94620682s_ilks
sills55135992s_ills
silos56029432s_ilos
silts55330822s_ilts
similes92915232similes
sines55954822s_ines
sipes76036952s_ipes
sires55945372s_ires
sises55233832s_ises
sites56045432s_ites
sixes124526362s_ixes
sizes146727762s_izes
skies95026832ski_es
skills104313922skills
skites104418042skites
skives134113942skives
slices84022852slices
slides73922182slides
slimes84722042slimes
slipes84921412slipes
smile74823922smile_
smiled93716432smiled
smiler83916682smiler
smilers94113852smilers
smiley114012302smiley
smileys12336322smileys
smites83921922smites
snipes83917392snipes
socles8418452socles
soiled73822472soiled
soils55327982soil_s
soles55547922s_oles
spales84728102spales
spices104326032spices
spiels85317952spiels
spies76037622spi_es
spikes124520712spikes
spile75230082spile_
spiled94621992spiled
spills84717462spills
spines85132032spines
spires84628112spires
spites84127332spites
stabiles10311402stabiles
stables93219072stables
stades74626242stades
stages75629492stages
stakes103927292stakes
stale55637102stale_
staled74728102staled
staler64025822staler
stalest73720172stalest
stalks104614552stalks
stalls64019932stalls
stanes64933402stanes
stapes85028732stapes
staples93617212staples
stares66038752stares
stases64225562stases
states64337082states
staves94525192staves
steels64117982steels
stele55026842stele_
steres63929532steres
stichs114511652stichs
stickles142512102stickles
sticks125118612sticks
stied65723032sti_ed
stiffs12389962stiffs
stifle93611902stifle_
stifled113511092stifled
stifler102911472stifler
stiflers11238832stiflers
still54922082stil_l
stilled83314782stilled
stiller73414292stiller
stillest8311072stillest
stilly93714092stilly
stilt54831982stil_t
stilted83511472stilted
stime76521802stime_
stimies9316562stimies
stings76220182stings
stinks105616832stinks
stints65119762stints
stipe76523372stipe_
stiped94517072stiped
stipel84412122stipel
stipels9418952stipels
stipples1247022stipples
stipules1037052stipules
stirks104914242stirks
stirpes95011292stirpes
stirps85011822stirps
stirs55921622sti_rs
stiver93915732stiver
stivers103613542stivers
stokes104821792stokes
stole54928812stole_
stoled74521592stoled
stolen64315062stolen
stones65130032stones
stopes84525892stopes
stores65533662stores
stoves93818922stoves
strides84520392strides
strifes104716582strifes
strikes114719092strikes
stripes95320572stripes
strives104119372strives
stulls63912982stulls
stupes84116952stupes
styes86316522st_yes
style85519362style_
styled105613102styled
styler94013302styler
stylers10359352stylers
stylet94018572stylet
stylets10369212stylets
stylus9397462stylus
suites63727402suites
swales93920762swales
swills94213362swills
swipes114114332swipes
swiples12339642swiples
swives123915182swives
tales55451372_tales
teles54536002_teles
tides64830152_tides
ties45248312_ti_es
tikes95628902_tikes
tildes74513962_tildes
tile45451442_tile_
tiled64832942_tiled
tiler56131022_tiler
tilers63523502_tilers
tills54631712_tills
tils45739612_til_s
tilts55325612_tilts
times75630822_times
tines54848422_tines
tires55437492_tires
titles63719922_titles
toiles63923512toiles
toles55147132_toles
tules54532792_tules
utile54718932utile_
voiles94616442voiles
whiles124418012whiles
wiles85437872_wiles

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 Filter178691825510.326548131.9
2DLD Change Limit825512132.29635954.3
3Display Results2132130.0633381.0
 (SQL Overall)1786912132.68566551.6
 
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.