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

213 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
ships10512377(None) 
chips125721251chips
hips96433701_hips
shies86136551shies
shims104422541shims
shins85131041shins
ship95228231ship_
shits84731161shits
shivs115018801shivs
shops104222891shops
sips65740101s_ips
skips115616601skips
slips76023721slips
snips75818011snips
whips134917081whips
ahis76135382ahi_s
blips95615782blips
chaps125326062chaps
chias104625512chias
chics123920942chics
chimps155713662chimps
chins105631462chins
chip116726422chip_
chirps135414002chirps
chis95933312chi_s
chits105424572chits
chops125019872chops
clips96018302clips
dips75536912_dips
drips85417232drips
flips105117742flips
ghis85020162ghi_s
gips75632922_gips
grips85520132grips
haps96443462_haps
hies74842832_hies
hims95230972_hims
hins76447992_hins
hip86750432_hip_
his66359502_hi_s
hiss75629212_hiss
hits75545132_hits
hops97942632_hops
hyps125418412_hyps
khis117017982khi_s
kips106430512_kips
lips67141442_lips
mips85534072_mips
nips65830922_nips
ohias84415562ohias
phis95724902phi_s
pips85837132_pips
quips164713372quips
reships1239862reships
rips66237432_rips
sahibs1137072sahibs
saids65328852saids
sails55738102sails
sains55639972sains
salps74423242salps
samps96124672samps
saps65346372s_aps
scops95820192scops
scrips105316032scrips
scups95316652scups
seeps74828752seeps
seifs85019332seifs
seis45542392sei_s
shads95124482shads
shags95123862shags
shahs115919512shahs
shams105829412shams
shape105125112shape
shapes115124942shapes
sharps115516082sharps
shaws116226262shaws
shays116021432shays
sheas86331792sheas
sheds96122702sheds
sheiks132510012sheiks
shes75734352sh_es
shews115924712shews
shied96125492shied
shiel811023772shiel
shiels95418922shiels
shier85428942shier
shiers94921752shiers
shiest95821522shiest
shift114225132shift
shifts124412932shifts
shiksa1394652shiksa
shikse1386072shikse
shill85325332shill
shills94519602shills
shily115222012shily
shim95827842shi_m
shin75634302shi_n
shine85533092shine
shines95028912shines
shiny115122142shiny
shire84727132shire
shires95225572shires
shirk124817842shirk
shirks134814122shirks
shirr84716922shirr
shirrs94413172shirrs
shirt84533892shirt
shirts94918332shirts
shist84829602shist
shists96515102shists
shit76745932shi_t
shiv105721162shi_v
shiva115915002shiva
shivas124512412shivas
shive114423422shive
shives124921412shives
shleps114710332shleps
shnaps1148082shnaps
shoes85429652shoes
shogs95319702shogs
shoos84226352shoos
shop95629832shop_
shots84730832shots
shows115324572shows
shrimps14516752shrimps
shris84221442shris
shtiks13297822shtiks
shuls85319712shuls
shuns85018142shuns
shuts85622472shuts
shwas116415102shwas
sibs65933532s_ibs
sics65234092s_ics
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
slaps76025712slaps
slims75423652slims
slip67031732slip_
slipe75626132slipe
slipes84921412slipes
slipt76627482slipt
slits56128852slits
slops75026012slops
snaps74719562snaps
snibs75613752snibs
snip66424652snip_
snipe75320572snipe
snipes83917392snipes
snits54124832snits
soaps75120712soaps
soils55327982soils
sops65244562s_ops
soups75322942soups
spics94123242spics
spies76037622spies
spiks114117472spiks
spins75327982spins
spits74429552spits
spivs105114242spivs
sris45434152sri_s
steps76619882steps
sties55132982sties
stipe76523372stipe
stipes84524052stipes
stirps85011812stirps
stirs55921612stirs
stops74827282stops
strips85719652strips
suits55028052suits
sumps95023432sumps
sups64834432s_ups
swaps104819202swaps
swigs96213662swigs
swims105514142swims
swipe105217082swipe
swipes114114332swipes
swiss86712902swiss
swops105913972swops
thins85826322thins
this76027382thi_s
thrips11299012thrips
tips66436762_tips
trips74923362trips
unships1237202unships
whaps135115162whaps
whids125413982whids
whigs125612642whigs
whims134515332whims
whins114922332whins
whip125521842whip_
whipt135317422whipt
whirs115218092whirs
whits115923822whits
whops135013932whops
whups134210002whups
yips95226692_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.0931921408.6
2DLD Change Limit538002131.36039558.8
3Display Results2132130.0464630.4
 (SQL Overall)1786912131.499119206.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.