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

217 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
stile5493157(None) 
smile74823911smile
spile75230081spile
stale55637101stale
stele55026841stele
stifle93611901stifle
stiles64328761stiles
still54922071still
stilt54831981stilt
stime76521791stime
stipe76523371stipe
stole54928811stole
style85519361style
tile45451441_tile
utile54718931utile
agile65122262agile
anile54634462anile
astilbe945652astilbe
atilt54828472atilt
axile126020512axile
bastile9313912bastile
bile66147172_bile
chile105626892chile
edile64819492edile
etoile6312262etoile
exile126117652exile
file75446642_file
futile93914952futile
guile64521132guile
hostile10312552hostile
istle52214712ist_le
maile75232212maile
mile66352562_mile
motile83818342motile
ostiole739012ostiole
pile65649692_pile
retile65929672retile
rile45650532_rile
rutile65217682rutile
sable74732162sable
saice75424052saice
sail45447162sail_
sailed74327762sailed
sailer63526102sailer
sails55738102sails
sale44959702s_ale
satire63218002satire
scale74629142scale
sectile9311972sectile
sedile73517232sedile
seine55732872seine
seise54727852seise
seize143819502seize
selle54428312selle
senile63420212senile
settle63915662settle
sextile1438572sextile
shale85332832shale
shiel811023772shiel
shill85325332shill
shily115222012shily
shine85533092shine
shire84727132shire
shive114423422shive
sice65545592s_ice
side55444482s_ide
sidle65124032sidle
sike87138782s_ike
sild55030582s_ild
silex123417412s_ilex
silk85529322s_ilk
sill45545152s_ill
silo46037912s_ilo
silt46558192s_ilt
simile83115622simile
sine46560622s_ine
sipe67341042s_ipe
sire46150412s_ire
site47052412s_ite
size135630962s_ize
skill94316722skill
skite95120042skite
skive124614112skive
slice74925822slice
slide64725412slide
slily85820032slily
slime74925752slime
slipe75626132slipe
smiled93716432smiled
smiler83916682smiler
smiles84522292smiles
smiley114012302smiley
smite75224862smite
snide64318722snide
snipe75320572snipe
socle7419572socle
soil46138822soil_
soiled73822472soiled
soils55327982soils
sole46053672s_ole
spale74929212spale
spice95528812spice
spiel74623912spiel
spike114922842spike
spiled94621992spiled
spiles84227912spiles
spill74821162spill
spilt75532222spilt
spine76534422spine
spire75828692spire
spite75430662spite
stabile9312062stabile
stable83921642stable
stade64825302stade
stage65330192stage
stake95927532stake
staled74728102staled
staler64025822staler
stales65538292stales
stalk94518002stalk
stall54722352stall
stane55933002stane
staple84415822staple
stare54440262stare
state56237332state
stave85324992stave
steel55721992steel
stela54019042stela
stelae63716482stelae
steles63725662steles
stere55328542stere
sterile7316602sterile
stich104117922stich
stick115121562stick
stickle132410972stickle
stied65723032stied
sties55132982sties
stiff114219232stiff
stifled113511092stifled
stifler102911462stifler
stifles103013382stifles
stilled83314772stilled
stiller73414282stiller
stills64118562stills
stilly93714072stilly
stilted83511472stilted
stilts67915302stilts
stimes85920572stimes
stimy105114732stimy
sting65330242sting
stink95122502stink
stint57037662stint
stiped94517072stiped
stipel84412122stipel
stipes84524052stipes
stipple1146622stipple
stipule936722stipule
stir45723242sti_r
stirk95717412stirk
stirp76815502stirp
stirs55921612stirs
stiver93915732stiver
stoae55024262stoae
stoke94922512stoke
stoled74521592stoled
stolen64315062stolen
stoles63927672stoles
stone55431182stone
stope74727242stope
store56333812store
stove85220252stove
striae65422272striae
stride75420962stride
strife95318362strife
strike105619732strike
stripe85822442stripe
strive95020962strive
stull54916272stull
stupe75217752stupe
stye76218972st_ye
styled105613102styled
styler94013302styler
styles94418652styles
stylet94018572stylet
styli83911172styli
subtile91912612subtile
suite54829562suite
swale85221592swale
swill83417372swill
swine85625302swine
swipe105217082swipe
swiple11379232swiple
swive115316192swive
tale46154162_tale
tele45040872_tele
tide55237372_tide
tie36557532_ti_e
tike85534482_tike
til36350262_til_
tilde65017342_tilde
tiled64832942_tiled
tiler56131022_tiler
tiles55542102_tiles
till45941202_till
tils45739612_tils
tilt46252422_tilt
time66235012_time
tine45855132_tine
tire46143352_tire
title54721072_title
toile54626492toile
tole46052902_tole
tule45735872_tule
vile76139802_vile
voile84719722voile
while115418692while
wile75944372_wile

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.0931921408.6
2DLD Change Limit538002172.43622085.4
3Display Results2172170.0633444.4
 (SQL Overall)1786912172.59268939.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.