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

157 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
stipes8452405(None) 
sipes76036951s_ipes
slipes84921411slipes
snipes83917391snipes
stapes85028731stapes
sties55132981sti_es
stiles64328771stiles
stimes85920571stimes
stipe76523371stipe_
stiped94517071stiped
stipel84412121stipel
stipels9418951stipels
stirpes95011291stirpes
stopes84525891stopes
stripes95320571stripes
stupes84116951stupes
swipes114114331swipes
cripes105120872cripes
etapes85415292etapes
gripes94619872gripes
pipes96030142_pipes
ripes75435772_ripes
saices84221802saices
satires72617572satires
scapes105122262scapes
scopes104719592scopes
seines65029902seines
seises64026712seises
seizes154317532seizes
shapes115124952shapes
shies86136552shi_es
shines95028912shines
ships105123772ship_s
shires95225572shires
shives124921412shives
sices75637272s_ices
sides65838372s_ides
sikes96236082s_ikes
sines55954822s_ines
sipe67341052s_ipe_
siped84927682s_iped
sips65740112s_ip_s
sires55945372s_ires
sises55233832s_ises
sites56045432s_ites
sixes124526362s_ixes
sizes146727762s_izes
skies95026842ski_es
skips115616612skip_s
skites104418042skites
skives134113942skives
slices84022852slices
slides73922182slides
slimes84722042slimes
slipe75626132slipe_
sliped95417062sliped
slips76023722slip_s
slopes84820452slopes
slypes114410482slypes
smiles84522292smiles
smites83921922smites
snipe75320572snipe_
sniped94913482sniped
sniper84413642sniper
snipers93311772snipers
snips75818012snip_s
spices104326032spices
spies76037622spi_es
spikes124520712spikes
spiles84227912spiles
spines85132032spines
spires84628112spires
spites84127332spites
stades74626242stades
stages75629492stages
stakes103927292stakes
stales65538292stales
stanes64933402stanes
staphs114411032staphs
staples93617212staples
stares66038752stares
stases64225562stases
states64337082states
staves94525192staves
steeps85215192steeps
steles63725662steles
steppes113110692steppes
steps76619882step_s
steres63929532steres
stichs114511652stichs
sticks125118612sticks
stied65723032sti_ed
stiffs12389962stiffs
stifles103013392stifles
stile54931572stile_
stills64118572stills
stilts67915312stilts
stime76521802stime_
stimies9316562stimies
stings76220182stings
stinks105616832stinks
stints65119762stints
stipend10386552stipend
stipends11304792stipends
stipites1039652stipites
stipples1247022stipples
stipules1037052stipules
stirks104914242stirks
stirps85011822stirps
stirs55921622sti_rs
stiver93915732stiver
stivers103613542stivers
stokes104821792stokes
stoles63927672stoles
stones65130032stones
stope74727242stope_
stoped94721012stoped
stoper84320102stoper
stopers94217372stopers
stops74827282stop_s
stores65533662stores
stoves93818922stoves
streps86218062streps
strides84520392strides
strifes104716582strifes
strikes114719092strikes
stripe85822442stripe_
striped105214362striped
striper94514792striper
stripers103911592stripers
strips85719652strip_s
strives104119372strives
stupas83910882stupas
stupe75217752stupe_
styes86316522st_yes
styles94418652styles
suites63727402suites
supes75628302s_upes
swipe105217082swipe_
swiped123811092swiped
swiples12339642swiples
swives123915182swives
tapes75838602_tapes
tides64830162_tides
ties45248322_ti_es
tikes95628902_tikes
tiles55542102_tiles
times75630822_times
tines54848422_tines
tipis76019922_tipis
tips66436772_tip_s
tires55437492_tires
topes76941762_topes
tripes85324872tripes
types105721062_types
wipes104827082_wipes
yipes106017842_yipes

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.686260482.5
2DLD Change Limit825511572.67330883.3
3Display Results1571570.0632492.1
 (SQL Overall)1786911573.42252218.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.