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

191 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
stopes8452589(None) 
scopes104719591scopes
slopes84820451slopes
stapes85028731stapes
stipes84524051stipes
stokes104821791stokes
stoles63927671stoles
stones65130031stones
stope74727241stope_
stoped94721011stoped
stoper84320101stoper
stopers94217371stopers
stops74827281stop_s
stores65533661stores
stoves93818921stoves
stupes84116951stupes
topes76941761_topes
atones65225772atones
atopies92816432atopies
copes97747102_copes
dopes84935042_dopes
elopes85918162elopes
estops84011222estop_s
etapes85415292etapes
gropes95220402gropes
hopes105835642_hopes
isotopes10228072isotopes
lopes76437342_lopes
metopes11311362metopes
mopes95134982_mopes
myopes13419962myopes
opes65942612__opes
ostoses71213552ostoses
popes95933812_popes
ptoses83514672ptoses
ropes75940062_ropes
scapes105122262scapes
scones84521302scones
scope94821482scope_
scoped115116652scoped
scops95820192scop_s
scores84725922scores
shapes115124952shapes
shoes85429662sho_es
shoppes143411402shoppes
shops104222902shop_s
shores94830412shores
shotes95321912shotes
shoves124919422shoves
sipes76036952s_ipes
slipes84921412slipes
sloes54728872slo_es
slope75823562slope_
sloped94216852sloped
sloper84615912sloper
slopers94213092slopers
slops75026012slop_s
slypes114410482slypes
smokes124814342smokes
snipes83917392snipes
snores64324322snores
sokes95031422s_okes
soles55547922s_oles
sones55444142s_ones
sophs104916022s_ophs
sops65244562s_op_s
sores55454282s_ores
spodes94817432spodes
spokes124417212spokes
spores84726612spores
stades74626242stades
stages75629492stages
stakes103927292stakes
stales65538292stales
stanes64933402stanes
staphs114411032staphs
staples93617212staples
stares66038752stares
stases64225562stases
states64337082states
staves94525192staves
steeps85215192steeps
steles63725662steles
steppes113110692steppes
steps76619882step_s
steres63929532steres
sties55132982st_ies
stiles64328772stiles
stimes85920572stimes
stipe76523372stipe_
stiped94517072stiped
stipel84412122stipel
stipels9418952stipels
stirpes95011292stirpes
stoae55024262stoae_
stoas55126022sto_as
stoats65117482stoats
stobs75718232sto_bs
stocks124715632stocks
stodges9309082stodges
stogey105811542stogey
stogeys11486122stogeys
stogies8413692stogies
stoics8311112stoics
stoke94922512stoke_
stoked114718292stoked
stoker104417622stoker
stokers114515182stokers
stole54928812stole_
stoled74521592stoled
stolen64315062stolen
stomas84816322stomas
stomped124110532stomped
stomper114111232stomper
stompers123610042stompers
stomps105612832stomps
stone55431182stone_
stoned75923142stoned
stoner65823202stoner
stoners74817952stoners
stoney96217352stoney
stooges83611482stooges
stooks105115372stooks
stools65117022stools
stooped103813832stooped
stooper93813192stooper
stoopers103711302stoopers
stoops85917892stoops
stop66532032stop__
stopped124512202stopped
stopper113012602stopper
stoppers123910592stoppers
stopples1236952stopples
stopt76528352stop_t
store56333812store_
stored75524212stored
storer64721672storer
storers75018682storers
storey95217612storey
storeys10559652storeys
stories7324272stories
storks106115952storks
storms85814632storms
stoss54316342sto_ss
stots54828552sto_ts
stotts64612862stotts
stoups85313272stoups
stoures74614162stoures
stours65015632stours
stouts65019002stouts
stove85220252stove_
stover94115642stover
stovers103713732stovers
stowed105817202stowed
stowps115710582stowps
stows86622702sto_ws
streps86218062streps
stripes95320572stripes
strobes93813262strobes
strokes114316322strokes
strophes13310602strophes
strops86220382strop_s
stupas83910882stupas
stupe75217752stupe_
styes86316522st_yes
styles94418652styles
supes75628302s_upes
swipes114114332swipes
swops105913972swop_s
tapes75838602_tapes
toes46956442_to_es
tokes95234972_tokes
toles55147132_toles
tomes76037382_tomes
tones56048662_tones
tope65946382_tope_
toped85631312_toped
topee76029952_topee
topees85519702_topees
toper75231022_toper
topers85025322_topers
tophes115218422_tophes
tophs105220052_tophs
topis76025832_topis
topos75726392_topos
tops66248122_top_s
tores55352672_tores
totes55139682_totes
tropes84824352tropes
tsores65113662tsores
types105721062_types

Search took 4 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.373479064.3
2DLD Change Limit825511912.56332208.7
3Display Results1911910.0633031.7
 (SQL Overall)1786911912.99959583.5
 
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.