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

212 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
stole5492881(None) 
sole46053671s_ole
stale55637101stale
stele55026841stele
stile54931571stile
stoae55024261stoae
stoke94922511stoke
stoled74521591stoled
stolen64315061stolen
stoles63927671stoles
stone55431181stone
stope74727241stope
store56333811store
stove85220251stove
style85519361style
tole46052901_tole
amole75724592amole
anole55330382anole
atoll57913922atoll
atone56527982atone
azole145118032azole
bole66448692_bole
citole8311502citole
cole66956112_cole
dhole95215362dhole
dole56550002_dole
etoile6312262etoile
haole84820082haole
hole77553392_hole
istle52214712ist_le
jole117233822_jole
mole66251832_mole
obole75917142obole
ole37155212__ole
osmole8128512osmole
ostiole739012ostiole
pistole92414312pistole
pole65951302_pole
prole74527792prole
role45851822_role
sable74732162sable
sale44959702s_ale
scale74629142scale
scold85414862scold
scolex1538242scolex
scone74621832scone
scope94821482scope
score75526742score
selle54428312selle
setose65114772setose
settle63915662settle
shale85332832shale
shoe75933442sho_e
shone83725982shone
shore85432652shore
shote85526102shote
shove114421042shove
sidle65124032sidle
skatole1135692skatole
sloe45534952slo_e
slope75823562slope
smile74823922smile
smoke115015822smoke
smolt74824162smolt
smote75820282smote
snore55424952snore
socle7419572socle
soke85436262s_oke
sol37256622s_ol_
sola45541862s_ola
sold54837412s_old
soled65835172s_oled
solei55624342s_olei
soles55547922s_oles
soli46637012s_oli
solo45538942s_olo
sols45448162s_ols
solve85618942s_olve
some66040382s_ome
sone46649982s_one
sore47059532s_ore
sotol54917652sotol_
sotols63714472sotols
spale74929212spale
spile75230082spile
spode84617702spode
spoke114818662spoke
spore75428592spore
stable83921642stable
stade64825302stade
stage65330192stage
stake95927532stake
staled74728102staled
staler64025822staler
stales65538292stales
stalk94518002stalk
stall54722352stall
stane55933002stane
staple84415822staple
stare54440262stare
state56237332state
stave85324992stave
steel55721992steel
stela54019042stela
stelae63716482stelae
steles63725662steles
stere55328542stere
stifle93611902stifle
stiles64328772stiles
still54922082still
stilt54831982stilt
stime76521802stime
stipe76523372stipe
stoa45425912sto_a
stoai55417872stoai
stoas55126022stoas
stoat57135952stoat
stob66724612sto_b
stobs75718232stobs
stock114417562stock
stodge8369042stodge
stogey105811542stogey
stogie7311322stogie
stogy95414082stogy
stoic7317252stoic
stoked114718292stoked
stoker104417622stoker
stokes104821792stokes
stolid74213182stolid
stollen747592stollen
stolon64112072stolon
stoma75918272stoma
stomp95616662stomp
stoned75923142stoned
stoner65823202stoner
stones65130032stones
stoney96217352stoney
stony85818642stony
stood65517712stood
stooge73811662stooge
stook95218212stook
stool55619892stool
stooled84313892stooled
stoolie739722stoolie
stools65117022stools
stoop75821542stoop
stop66532032sto_p
stoped94721012stoped
stoper84320102stoper
stopes84525892stopes
stopple1156582stopple
stops74827282stops
stopt76528352stopt
stored75524212stored
storer64721672storer
stores65533662stores
storey95217612storey
stork96819692stork
storm76520402storm
story86723032story
stoss54316342stoss
stot46347332sto_t
stots54828552stots
stott56929792stott
stoup75517072stoup
stour54916742stour
stoure64814942stoure
stout57434052stout
stover94115642stover
stoves93818922stoves
stow77325742sto_w
stowed105817202stowed
stowp105614232stowp
stows86622702stows
strobe84513812strobe
strode75215972strode
stroke105116172stroke
stroll6311602stroll
strove95014792strove
stull54916272stull
stupe75217752stupe
stye76218972st_ye
styled105613102styled
styler94013302styler
styles94418652styles
stylet94018572stylet
styli83911172styli
swale85221592swale
swore84920822swore
systole1035762systole
tale46154162_tale
tele45040872_tele
thole85620842thole
tile45451442_tile
toe310166852_to_e
toile54626492_toile
toke86738492_toke
tola45236332_tola
told56132202_told
toled65934922_toled
toles55147132_toles
toll45535262_toll
tolu45529152_tolu
tome67543192_tome
tone46953742_tone
tope65946382_tope
tore47359322_tore
tote46643672_tote
tule45735872_tule
utile54718932utile
vole75236982_vole
whole114418092whole

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.296603685.8
2DLD Change Limit538002121.61033416.1
3Display Results2122120.0633365.1
 (SQL Overall)1786912121.96990752.2
 
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.