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

214 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
slips7602372(None) 
blips95615781blips
clips96018301clips
flips105117741flips
lips67141451_lips
ships105123771ships
sips65740111s_ips
skips115616611skips
slaps76025711slaps
slims75423651slims
slip67031731slip_
slipe75626131slipe
slipes84921411slipes
slipt76627481slipt
slits56128851slits
slops75026011slops
snips75818011snips
alias55834602alias
alifs86121262alifs
alps65529242al_ps
blimps12588152blimps
blip88322772blip_
bliss75616912bliss
chips125721252chips
claps95626182claps
clip86924002clip_
clipt96324272clipt
clops95924852clops
dips75536922_dips
drips85417232drips
flaps105621382flaps
flics105418362flics
flies85630712flies
flip96324262flip_
flirs85518932flirs
flits85625222flits
flops105920142flops
gips75632932_gips
glias64618492glias
glims87417672glims
glops85619552glops
grips85520132grips
hips96433712_hips
kips106430532_kips
kliks8398832kliks
laps66848872_laps
libs66732772_libs
lids56336472_lids
lies46454202_lies
limps95522672_limps
lins47059062_lins
lip514755812_lip_
lipa68425932_lipa
lipe66839742_lipe
lis37162282_li_s
lisp68926892_lisp
lisps76913912_lisps
lits46252502_lits
lops66043352_lops
mips85534092_mips
nips65830932_nips
olios54520852olios
oxlips1544432oxlips
pips85837142_pips
plies74526512plies
plops95920332plops
quips164713372quips
rips66237442_rips
saids65328862saids
sails55738102sails
sains55639972sains
saleps85014902saleps
salps74423242salps
samps96124672samps
saps65346372s_aps
scops95820192scops
scrips105316032scrips
scups95316652scups
seeps74828752seeps
seifs85019332seifs
seis45542392sei_s
shies86136552shies
shims104422552shims
shins85131042shins
ship95228242ship_
shits84731172shits
shivs115018802shivs
shleps114710332shleps
shops104222902shops
sibs65933552s_ibs
sics65234102s_ics
silds65520532silds
silks94620682silks
sills55135992sills
silos56029432silos
silts55330822silts
simps94719762simps
sims65737182s_ims
sins46755282s_ins
sip57656022s_ip_
sipe67341052s_ipe
sipes76036952s_ipes
sirs44338342s_irs
sis37360552s_i_s
sits45050212s_its
skeps115614252skeps
skids104615342skids
skies95026842skies
skimps14488042skimps
skims114517202skims
skins94723472skins
skip105421762skip_
skis84825302ski_s
skits94721872skits
slabs75322642slabs
slags66525902slags
slams74927902slams
slap66434042slap_
slats55436902slats
slaws85222712slaws
slays85723682slays
sleds64418852sleds
sleeps83913322sleeps
slept75728102slept
slews86220352slews
slice74925822slice
slices84022852slices
slick115520522slick
slicks124816112slicks
slid55828992sli_d
slide64725422slide
slides73922182slides
slier54827242slier
sliest66621962sliest
slily85820032slily
slim66631962sli_m
slime74925752slime
slimes84722042slimes
slimpsy1463332slimpsy
slimsy11407722slimsy
slimy105417422slimy
sling66028802sling
slings74618012slings
slink95422912slink
slinks104315152slinks
sliped95417062sliped
slippy1375842slippy
slipup1034502slipup
slipups1133192slipups
slit46250102sli_t
slobs74419872slobs
sloes54728872sloes
slogs64521842slogs
sloids73712692sloids
sloops85513622sloops
slop66533872slop_
slope75823562slope
slopes84820452slopes
slots54830532slots
slows85323462slows
slubs74719532slubs
slues54527172slues
slugs64618562slugs
slumps104313582slumps
slums74623432slums
slurps84410002slurps
slurs54123372slurs
sluts54523982sluts
slype105112362slype
slypes114410482slypes
snaps74719562snaps
snibs75613762snibs
snip66424652snip_
snipe75320572snipe
snipes83917392snipes
snits54124832snits
soaps75120712soaps
soils55327982soils
solids74116402solids
sops65244562s_ops
soups75322942soups
spics94123242spics
spies76037622spies
spiks114117472spiks
spins75327982spins
spits74429552spits
spivs105114242spivs
splits85416412splits
sris45434152sri_s
steps76619882steps
sties55132982sties
stipe76523372stipe
stipes84524052stipes
stirps85011822stirps
stirs55921622stirs
stops74827282stops
strips85719652strips
suits55028052suits
sumps95023432sumps
sups64834432s_ups
swaps104819202swaps
swigs96213662swigs
swims105514142swims
swipe105217082swipe
swipes114114332swipes
swiss86712902swiss
swops105913972swops
sylis84316022syli_s
tips66436772_tips
trips74923362trips
tulips8137252tulips
whips134917082whips
yips95226712_yips
zips155723802_zips

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.296603685.8
2DLD Change Limit538002141.70331591.3
3Display Results2142140.0633396.8
 (SQL Overall)1786912142.06286659.1
 
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.