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
skips11561661(None) 
kips106430531_kips
ships105123771ships
sips65740111s_ips
skeps115614251skeps
skids104615341skids
skies95026841skies
skimps14488041skimps
skims114517201skims
skins94723471skins
skip105421761skip_
skis84825301ski_s
skits94721871skits
slips76023721slips
snips75818011snips
blips95615782blips
chips125721252chips
clips96018302clips
dips75536922_dips
drips85417232drips
flips105117742flips
gips75632932_gips
grips85520132grips
hips96433712_hips
keps106027312_keps
kids96029652_kids
kifs116023522_kifs
kins85747922_kins
kip97042152_kip_
kirs85831752_kirs
kis78051492_ki_s
kiss85227412_kiss
kits86441782_kits
kops107031302_kops
lips67141452_lips
mips85534092_mips
nips65830932_nips
pips85837142_pips
quips164713372quips
rips66237442_rips
saids65328862saids
sails55738102sails
sains55639972sains
sakis95323672saki_s
salps74423242salps
samps96124672samps
saps65346372s_aps
scops95820192scops
scrips105316032scrips
scups95316652scups
seeps74828752seeps
seifs85019332seifs
seis45542392sei_s
shies86136552shies
shims104422552shims
shins85131042shins
ship95228242ship_
shits84731172shits
shivs115018802shivs
shops104222902shops
sibs65933552s_ibs
sics65234102s_ics
sikas94617022sikas
sikes96236082sikes
simps94719762simps
sims65737182s_ims
sins46755282s_ins
sip57656022s_ip_
sipe67341052s_ipe
sipes76036952s_ipes
sirs44338342s_irs
sis37360552s_i_s
sits45050212s_its
skags104316072skags
skas85325712sk_as
skats94621542skats
skees95023122skees
skegs105011232skegs
skeins103911902skeins
skelps12407922skelps
skep105219352skep_
skews125413802skews
ski74925702ski__
skid95720942ski_d
skied104417762skied
skier95119602skier
skiers104713702skiers
skiey125012902skiey
skiff153612812skiff
skiffs16327012skiffs
skill94316732skill
skills104313922skills
skim105322522ski_m
skimo116312552skimo
skimos12548802skimos
skimp135411332skimp
skimpy17475722skimpy
skin85927542ski_n
skink85916862skink
skinks94511652skinks
skint95629232skint
skirl96012922skirl
skirls10449822skirls
skirr94810552skirr
skirrs10448192skirrs
skirt95624672skirt
skirts104111502skirts
skit85437542ski_t
skite95120062skite
skites104418042skites
skive124614122skive
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
tips66436772_tips
trips74923362trips
whips134917082whips
yips95226712_yips
zips155723802_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.330541487.9
2DLD Change Limit538001611.57634137.1
3Display Results1611610.0463500.0
 (SQL Overall)1786911611.95291542.5
 
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.