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

160 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
slipe7562613(None) 
lipe66839731_lipe
sipe67341041s_ipe
slice74925821slice
slide64725411slide
slime74925751slime
slip67031731slip_
sliped95417061sliped
slipes84921411slipes
slips76023721slips
slipt76627481slipt
slope75823561slope
slype105112361slype
snipe75320571snipe
stipe76523371stipe
swipe105217081swipe
alike95523962alike
aline57243152aline
aliped95414282aliped
alive85722512alive
aslope839012aslope
blip88322772blip_
blips95615782blips
blite76225352blite
blype12429672blype
clepe94617382clepe
clime95720892clime
cline76428532cline
clip86924002clip_
clips96018302clips
clipt96324272clipt
cripe95521142cripe
elide64922642elide
elite56230182elite
elope75219342elope
flip96324262flip_
flips105117742flips
flite85424962flite
glide74521592glide
glime85620192glime
gripe84622962gripe
lice66045062_lice
lie38264522_li_e
life75433732_life
like86040842_like
lime66244932_lime
line46965572_line
lip514755802_lip_
lipa68425922_lipa
lips67141442_lips
lire47845292_lire
lite47054542_lite
live76540992_live
lope65941922_lope
olive84817152olive
pipe86434432_pipe
plie65127392pli_e
ripe66038922_ripe
saice75424052saice
saline65132702saline
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
slake93724052slake
slap66434042slap_
slaps76025712slaps
slate55438282slate
slave84224032slave
sleep74920182sleep
slept75728102slept
sliced94416312sliced
slicer84117602slicer
slices84022852slices
slick115520522slick
slid55828982sli_d
slider73918362slider
slides73922182slides
slier54827242slier
slieve9359272slieve
slily85820032slily
slim66631962sli_m
slimed94915122slimed
slimes84722042slimes
slims75423652slims
slimy105417422slimy
sling66028802sling
slink95422912slink
slipped124711742slipped
slipper113712982slipper
slippy1375842slippy
slipup1034502slipup
slit46250102sli_t
slits56128852slits
sliver94116592sliver
sloe45534952sl_oe
slop66533872slop_
sloped94216852sloped
sloper84615912sloper
slopes84820452slopes
slops75026012slops
slue45332192sl_ue
sluice849512sluice
slypes114410482slypes
smile74823922smile
smite75224872smite
snide64318722snide
snip66424652snip_
sniped94913482sniped
sniper84413642sniper
snipes83917392snipes
snips75818012snips
spice95528812spice
spike114922842spike
spile75230082spile
spine76534422spine
spire75828692spire
spite75430662spite
splice104915102splice
spline86020532spline
stile54931572stile
stime76521802stime
stiped94517072stiped
stipel84412122stipel
stipes84524052stipes
stope74727242stope
stripe85822442stripe
stupe75217752stupe
suite54829562suite
supe65932762s_upe
swine85625302swine
swiped123811092swiped
swipes114114332swipes
swiple11379232swiple
swive115316192swive
tripe75425382tripe
wipe94830282_wipe
yipe96722182_yipe

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.360496363.9
2DLD Change Limit538001601.85628987.1
3Display Results1601600.0463478.3
 (SQL Overall)1786911602.26278996.9
 
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.