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
lips67141441_lips
ships105123771ships
sips65740101s_ips
skips115616601skips
slaps76025711slaps
slims75423651slims
slip67031731slip_
slipe75626131slipe
slipes84921411slipes
slipt76627481slipt
slits56128851slits
slops75026011slops
snips75818011snips
alias55834602alias
alifs86121262alifs
alps65529242al_ps
blimps12588152blimps
blip88322772blip_
bliss75616912bliss
chips125721252chips
claps95626182claps
clip86924002clip_
clipt96324272clipt
clops95924852clops
dips75536912_dips
drips85417232drips
flaps105621382flaps
flics105418362flics
flies85630712flies
flip96324262flip_
flirs85518932flirs
flits85625222flits
flops105920142flops
gips75632922_gips
glias64618492glias
glims87417672glims
glops85619552glops
grips85520132grips
hips96433702_hips
kips106430512_kips
kliks8398822kliks
laps66848872_laps
libs66732762_libs
lids56336452_lids
lies46454192_lies
limps95522672_limps
lins47059052_lins
lip514755802_lip_
lipa68425922_lipa
lipe66839732_lipe
lis37162272_li_s
lisp68926872_lisp
lisps76913902_lisps
lits46252492_lits
lops66043352_lops
mips85534082_mips
nips65830922_nips
olios54520852olios
oxlips1544432oxlips
pips85837132_pips
plies74526512plies
plops95920332plops
quips164713372quips
rips66237432_rips
saids65328852saids
sails55738102sails
sains55639972sains
saleps85014902saleps
salps74423242salps
samps96124672samps
saps65346372s_aps
scops95820192scops
scrips105316032scrips
scups95316652scups
seeps74828752seeps
seifs85019332seifs
seis45542392sei_s
shies86136552shies
shims104422542shims
shins85131042shins
ship95228232ship_
shits84731162shits
shivs115018802shivs
shleps114710332shleps
shops104222892shops
sibs65933542s_ibs
sics65234092s_ics
silds65520522silds
silks94620682silks
sills55135982sills
silos56029422silos
silts55330822silts
simps94719762simps
sims65737172s_ims
sins46755272s_ins
sip57656012s_ip_
sipe67341042s_ipe
sipes76036952s_ipes
sirs44338332s_irs
sis37360542s_i_s
sits45050202s_its
skeps115614252skeps
skids104615322skids
skies95026832skies
skimps14488042skimps
skims114517182skims
skins94723462skins
skip105421742skip_
skis84825282ski_s
skits94721852skits
slabs75322642slabs
slags66525902slags
slams74927902slams
slap66434042slap_
slats55436902slats
slaws85222712slaws
slays85723682slays
sleds64418852sleds
sleeps83913322sleeps
slept75728102slept
slews86220352slews
slice74925822slice
slices84022852slices
slick115520522slick
slicks124816112slicks
slid55828982sli_d
slide64725412slide
slides73922182slides
slier54827242slier
sliest66621942sliest
slily85820032slily
slim66631952sli_m
slime74925752slime
slimes84722042slimes
slimpsy1463332slimpsy
slimsy11407722slimsy
slimy105417422slimy
sling66028802sling
slings74618012slings
slink95422912slink
slinks104315152slinks
sliped95417062sliped
slippy1375842slippy
slipup1034502slipup
slipups1133192slipups
slit46250102sli_t
slobs74419872slobs
sloes54728872sloes
slogs64521842slogs
sloids73712692sloids
sloops85513622sloops
slop66533872slop_
slope75823562slope
slopes84820452slopes
slots54830522slots
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
stirps85011812stirps
stirs55921612stirs
stops74827282stops
strips85719652strips
suits55028052suits
sumps95023432sumps
sups64834432s_ups
swaps104819202swaps
swigs96213662swigs
swims105514142swims
swipe105217082swipe
swipes114114332swipes
swiss86712902swiss
swops105913972swops
sylis84316022syli_s
tips66436762_tips
trips74923362trips
tulips8137252tulips
whips134917082whips
yips95226692_yips
zips155723792_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.0931921408.6
2DLD Change Limit538002142.23624060.8
3Display Results2142140.1401528.6
 (SQL Overall)1786912142.46972373.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.