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

161 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
skips11561660(None) 
kips106430521_kips
ships105123771ships
sips65740101s_ips
skeps115614251skeps
skids104615331skids
skies95026831skies
skimps14488041skimps
skims114517191skims
skins94723461skins
skip105421751skip_
skis84825291ski_s
skits94721861skits
slips76023721slips
snips75818011snips
blips95615782blips
chips125721252chips
clips96018302clips
dips75536912_dips
drips85417232drips
flips105117742flips
gips75632922_gips
grips85520132grips
hips96433702_hips
keps106027302_keps
kids96029642_kids
kifs116023512_kifs
kins85747912_kins
kip97042142_kip_
kirs85831742_kirs
kis78051482_ki_s
kiss85227402_kiss
kits86441772_kits
kops107031292_kops
lips67141442_lips
mips85534082_mips
nips65830922_nips
pips85837132_pips
quips164713372quips
rips66237432_rips
saids65328852saids
sails55738102sails
sains55639972sains
sakis95323672saki_s
salps74423242salps
samps96124672samps
saps65346372s_aps
scops95820192scops
scrips105316032scrips
scups95316652scups
seeps74828752seeps
seifs85019332seifs
seis45542392sei_s
shies86136552shies
shims104422552shims
shins85131042shins
ship95228242ship_
shits84731172shits
shivs115018802shivs
shops104222902shops
sibs65933542s_ibs
sics65234092s_ics
sikas94617022sikas
sikes96236082sikes
simps94719762simps
sims65737172s_ims
sins46755272s_ins
sip57656012s_ip_
sipe67341042s_ipe
sipes76036952s_ipes
sirs44338332s_irs
sis37360542s_i_s
sits45050202s_its
skags104316072skags
skas85325712sk_as
skats94621542skats
skees95023122skees
skegs105011232skegs
skeins103911902skeins
skelps12407922skelps
skep105219352skep_
skews125413802skews
ski74925692ski__
skid95720932ski_d
skied104417752skied
skier95119592skier
skiers104713702skiers
skiey125012892skiey
skiff153612802skiff
skiffs16327012skiffs
skill94316722skill
skills104313922skills
skim105322512ski_m
skimo116312542skimo
skimos12548802skimos
skimp135411322skimp
skimpy17475722skimpy
skin85927532ski_n
skink85916852skink
skinks94511652skinks
skint95629222skint
skirl96012912skirl
skirls10449822skirls
skirr94810542skirr
skirrs10448192skirrs
skirt95624662skirt
skirts104111502skirts
skit85437532ski_t
skite95120052skite
skites104418042skites
skive124614112skive
skives134113942skives
skuas95611732skuas
slaps76025712slaps
slims75423652slims
slip67031732slip_
slipe75626132slipe
slipes84921412slipes
slipt76627482slipt
slits56128852slits
slops75026012slops
snaps74719562snaps
snibs75613762snibs
snip66424652snip_
snipe75320572snipe
snipes83917392snipes
snits54124832snits
soaps75120712soaps
soils55327982soils
sops65244562s_ops
soups75322942soups
spics94123242spics
spies76037622spies
spiks114117472spiks
spins75327982spins
spits74429552spits
spivs105114242spivs
sris45434152sri_s
steps76619882steps
sties55132982sties
stipe76523372stipe
stipes84524052stipes
stirps85011822stirps
stirs55921622stirs
stops74827282stops
strips85719652strips
suits55028052suits
sumps95023432sumps
sups64834432s_ups
swaps104819202swaps
swigs96213662swigs
swims105514142swims
swipe105217082swipe
swipes114114332swipes
swiss86712902swiss
swops105913972swops
tips66436762_tips
trips74923362trips
whips134917082whips
yips95226702_yips
zips155723792_zips

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.296603685.8
2DLD Change Limit538001611.59333772.8
3Display Results1611610.0305366.7
 (SQL Overall)1786911611.91993116.7
 
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.