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

166 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
stipe7652337(None) 
sipe67341041s_ipe
slipe75626131slipe
snipe75320571snipe
stile54931571stile
stime76521801stime
stiped94517071stiped
stipel84412121stipel
stipes84524051stipes
stope74727241stope
stripe85822441stripe
stupe75217751stupe
swipe105217081swipe
cripe95521142cripe
etape74413702etape
gripe84622962gripe
lipe66839732_lipe
pipe86434432_pipe
ripe66038922_ripe
saice75424052saice
satire63218002satire
scape96921842scape
scope94821482scope
seine55732872seine
seise54727852seise
seize143819502seize
shape105125112shape
shine85533092shine
ship95228242ship_
ships105123772ships
shire84727132shire
shive114423422shive
sice65545592s_ice
side55444492s_ide
sike87138782s_ike
sine46560622s_ine
sip57656012s_ip_
siped84927682s_iped
sipes76036952s_ipes
sips65740102s_ips
sire46150412s_ire
site47052412s_ite
size135630962s_ize
skip105421752skip_
skips115616602skips
skite95120052skite
skive124614112skive
slice74925822slice
slide64725412slide
slime74925752slime
slip67031732slip_
sliped95417062sliped
slipes84921412slipes
slips76023722slips
slipt76627482slipt
slope75823562slope
slype105112362slype
smile74823922smile
smite75224872smite
snide64318722snide
snip66424652snip_
sniped94913482sniped
sniper84413642sniper
snipes83917392snipes
snips75818012snips
spice95528812spice
spike114922842spike
spile75230082spile
spine76534422spine
spire75828692spire
spite75430662spite
stade64825302stade
stage65330192stage
stake95927532stake
stale55637102stale
stane55933002stane
stapes85028732stapes
staph104314652staph
staple84415822staple
stare54440262stare
state56237332state
stave85324992stave
steep76020702steep
stele55026842stele
step67126292step_
steppe10319872steppe
steps76619882steps
stere55328542stere
stich104117922stich
stick115121562stick
stied65723032stied
sties55132982sties
stiff114219242stiff
stifle93611902stifle
stiles64328772stiles
still54922082still
stilt54831982stilt
stimes85920572stimes
stimy105114742stimy
sting65330242sting
stink95122502stink
stint57037662stint
stipels9418952stipels
stipend10386552stipend
stipple1146622stipple
stipule936722stipule
stir45723252sti_r
stirk95717412stirk
stirp76815502stirp
stirpes95011292stirpes
stirps85011822stirps
stirs55921622stirs
stiver93915732stiver
stoae55024262stoae
stoke94922512stoke
stole54928812stole
stone55431182stone
stop66532032stop_
stoped94721012stoped
stoper84320102stoper
stopes84525892stopes
stops74827282stops
stopt76528352stopt
store56333812store
stove85220252stove
strep77120852strep
striae65422272striae
stride75420962stride
strife95318362strife
strike105619732strike
strip77524342strip_
striped105214362striped
striper94514792striper
stripes95320572stripes
strips85719652strips
stript85222192stript
stripy115812742stripy
strive95020962strive
stupa74112312stupa
stupes84116952stupes
stye76218972st_ye
style85519362style
suite54829562suite
supe65932762s_upe
swine85625302swine
swiped123811092swiped
swipes114114332swipes
swiple11379232swiple
swive115316192swive
tape64538142_tape
tide55237382_tide
tie36557532_ti_e
tike85534482_tike
tile45451442_tile
time66235012_time
tine45855132_tine
tip56551222_tip_
tipi69924432_tipi
tips66436762_tips
tire46143352_tire
tope65946382_tope
tripe75425382tripe
type96223742_type
utile54718932utile
wipe94830282_wipe
yipe96722182_yipe

Search took 2 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.313570897.8
2DLD Change Limit538001661.59333772.8
3Display Results1661660.0463608.7
 (SQL Overall)1786911661.95291542.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.