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

301 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
shins8513104(None) 
chins105631461chins
hins76447991_hins
sains55639971sains
shies86136551shies
shims104422541shims
shin75634301shin_
shine85533091shine
shines95028911shines
shiny115122141shiny
ships105123771ships
shits84731161shits
shivs115018801shivs
shuns85018141shuns
sins46755271s_ins
skins94723461skins
spins75327981spins
thins85826321thins
whins114922331whins
ahing98928342ahing
ahis76135382ahi_s
ains46158882_ains
amins75534312amins
arshins10312572arshins
ashing107824092ashing
ayins85321612ayins
bins66548242_bins
brins75533972brins
cains75334302cains
chains114819702chains
chias104625512chias
chics123920942chics
chin96934742chin_
china105022472china
chinas115119382chinas
chine105231722chine
chines115029172chines
chink145321592chink
chinks155817572chinks
chino105823312chino
chinos115018692chinos
chints115117832chints
chips125721252chips
chis95933312chi_s
chits105424572chits
coins75834552coins
dins56652042_dins
djins1368452djins
fins75849092_fins
foins85523382foins
gains65729512gains
ghis85020162ghi_s
gins55543952_gins
grins65427222grins
hens75642572_hens
hies74842832_hies
hims95230972_hims
hin67559562_hin_
hind85529752_hind
hinds96721472_hinds
hint77455742_hint
hints87330622_hints
hips96433702_hips
his66359502_hi_s
hisn79620932_hisn
hiss75629212_hiss
hits75545132_hits
hons77350782_hons
huns76136932_huns
ins35945602__ins
jins115635012_jins
joins125818412joins
kains96125642kains
khans124615172khans
khis117017982khi_s
kins85747902_kins
lashins103915152lashins
lins47059052_lins
loins56728422loins
mains75635092mains
ohias84415562ohias
ohing96018802ohing
pains75138282pains
peins76128062peins
phis95724902phi_s
phons105221142phons
pins65558452_pins
pyins105815862pyins
quins144819852quins
rains55140232rains
reins56234562reins
rhino84614322rhino
rhinos94411122rhinos
rins46153192_rins
ruins55822032ruins
sabins85521972sabins
sahibs1137072sahibs
saids65328852saids
sails55738102sails
sain45551292sain_
saint55147072saint
saints65122422saints
sans45153352s_ans
sarins63932622sarins
sasins64923102sasins
satins64930482satins
savins93923132savins
scans74625102scans
scions82612232scions
seifs85019332seifs
seine55732872seine
seines65029902seines
seis45542392sei_s
serins64029672serins
shads95124482shads
shags95123862shags
shahs115919512shahs
shairns10276782shairns
shams105829412shams
shank125422192shank
shanks135315582shanks
sharns95516982sharns
shaws116226262shaws
shays116021432shays
sheas86331792sheas
sheds96122702sheds
sheens95116992sheens
sheiks132510012sheiks
shend94719972shend
shends105313772shends
shent85933492shent
shes75734352sh_es
shews115924712shews
shied96125492shied
shiel811023772shiel
shiels95418922shiels
shier85428942shier
shiers94921752shiers
shiest95821522shiest
shift114225132shift
shifts124412932shifts
shiksa1394652shiksa
shikse1386072shikse
shill85325332shill
shills94519602shills
shily115222012shily
shim95827842shi_m
shindy13449322shindy
shindys14314132shindys
shined104620782shined
shiner93820872shiner
shiners104015942shiners
shinny124810782shinny
ship95228232shi_p
shire84727132shire
shires95225572shires
shirk124817842shirk
shirks134814122shirks
shirr84716922shirr
shirrs94413172shirrs
shirt84533892shirt
shirts94918332shirts
shist84829602shist
shists96515102shists
shit76745932shi_t
shiv105721162shi_v
shiva115915002shiva
shivas124512412shivas
shive114423422shive
shives124921412shives
shoes85429652shoes
shogs95319702shogs
shone83725972shone
shoos84226352shoos
shops104222892shops
shots84730832shots
shows115324572shows
shrine94920052shrine
shrines104618692shrines
shrink134511732shrink
shrinks14397912shrinks
shris84221442shris
shtiks13297822shtiks
shuls85319712shuls
shun75122772shun_
shunt85226502shunt
shunts95712012shunts
shuts85622472shuts
shwas116415102shwas
shying134211842shying
sibs65933532s_ibs
sics65234092s_ics
signs65516322signs
sims65737172s_ims
sin36265892s_in_
sine46560622s_ine
sines55954822s_ines
sing57544172s_ing
sings65532702s_ings
sinh76238042s_inh
sinhs86719602s_inhs
sink86640142s_ink
sinks95529182s_inks
sinus55523852s_inus
sips65740102s_ips
sirs44338332s_irs
sis37360542s_i_s
sits45050202s_its
skeins103911902skeins
skids104615322skids
skies95026832skies
skims114517182skims
skin85927522skin_
skink85916852skink
skinks94511652skinks
skint95629222skint
skips115616602skips
skis84825282ski_s
skits94721852skits
slims75423652slims
sling66028802sling
slings74618012slings
slink95422912slink
slinks104315152slinks
slips76023722slips
slits56128852slits
snibs75613752snibs
snips75818012snips
snits54124832snits
soils55327982soils
sons46049552s_ons
sorns55028412sorns
sozins15510782sozins
spans74528732spans
sphinx1866202sphinx
spics94123242spics
spies76037622spies
spiks114117472spiks
spin66231302spin_
spine76534422spine
spines85132032spines
spiny104921302spiny
spits74429552spits
spivs105114242spivs
sris45434152sri_s
stains64923652stains
steins64818342steins
sties55132982sties
sting65330242sting
stings76220182stings
stink95122502stink
stinks105616832stinks
stint57037662stint
stints65119762stints
stirs55921612stirs
stuns54719492stuns
suing65026362suing
suint55638182suint
suints64617782suints
suits55028052suits
sunns55017352sunns
suns45841902s_uns
swains94513952swains
swans84625012swans
swigs96213662swigs
swims105514142swims
swine85625302swine
swing96124842swing
swings104714452swings
swink125116352swink
swinks134610652swinks
swiss86712902swiss
tains54936322tains
theins95015422theins
thens85921832thens
thin76732382thin_
thine85026852thine
thing96622962thing
things104914282things
think125018792think
thinks134613352thinks
this76027382thi_s
tins45251302_tins
twins85118982twins
veins84620492veins
wains86930862wains
whens114618762whens
whids125413982whids
whigs125612642whigs
whims134515332whims
whin105225692whin_
whine116022812whine
whines125120102whines
whiny144915572whiny
whips134917082whips
whirs115218092whirs
whits115923822whits
wins75949172_wins
yins75335122_yins
zeins144715392zeins
zins135735002_zins

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.0961861364.6
2DLD Change Limit538003011.68331966.7
3Display Results3013010.0803762.5
 (SQL Overall)1786913011.85996122.1
 
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.