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 “sphinx” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

359 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
sphinx186620(None) 
sphynx2152611sphynx
shin75634312s_hin_
shine85533092s_hine
shins85131042s_hins
shiny115122142s_hiny
sphene113412402sphene
sphinxes20334402sphinxes
spin66231302sp_in_
spine76534422sp_ine
spins75327982sp_ins
spiny104921302sp_iny
spline86020532spline
splint85223282splint
spring94526012spring
sprint84526792sprint
spuing94313362spuing
spying123913252spying
syrinx1637142syrinx
aahing1019015763aahing
aching126521973aching
ahing98928353_ahing
aphid115515393aphi_d
aphids125110843aphids
aphis105917133aphi_s
aping87327233ap_ing
ashing107824093ashing
behind1238063behind
chin96934743_chin_
china105022483_china
chine105231723_chine
chink145321593_chink
chino105823313_chino
chins105631463_chins
eching126315563eching
echini114710433echini
espying1336193espying
hin67559573__hin_
hind85529763__hind
hins76448003__hins
hint77455753__hint
jinx185516583__jinx
meninx1538703meninx
minx137723363__minx
ohing96018813_ohing
oohing104412933oohing
ophite11410563ophite
opine77422463op_ine
oping86322413op_ing
opsin7613473opsin_
opsins8411713opsins
opting94514403opting
pain65647243_pain_
pains75138283_pains
paint75443693_paint
pein65834943_pein_
peins76128063_peins
phenix1837133_phenix
phi86524203_phi__
phial10313203_phial
phis95724903_phi_s
phiz186718843_phi_z
phlox1737333_phlox
phon95925383_phon_
phone105621933_phone
phono104917023_phono
phons105221143_phons
phony136715443_phony
piing85218833_piing
pin57066733_p_in_
pina65842643_p_ina
pine67755723_p_ine
ping75943603_p_ing
pink107039393_p_ink
pins65558463_p_ins
pint66963183_p_int
piny911838363_p_iny
pix126437943_p_i_x
plink115219123_plink
poind84217913_poind
point75338733_point
prink114719673_prink
print74837463_print
pyin96823233_pyin_
pyins105815863_pyins
rhino84614323_rhino
sabin74924953sabin_
sabine84020393sabine
sabins85521983sabins
sahib10314763sahi_b
sahibs1137083sahibs
sain45551293s_ain_
sains55639973s_ains
saint55147073s_aint
salina64221123salina
saline65132703saline
salpinx1636093salpinx
saning75127643saning
saphena1235863saphena
sapling103217863sapling
sapping123519313sapping
sarin55239253sarin_
sarins63932623sarins
sashing114621473sashing
sasin54626573sasin_
sasins64923103sasins
satin55935223satin_
sating74735453sating
satins64930483satins
satiny93817983satiny
savin84625083savin_
savine94220283savine
saving104724513saving
savins93923133savins
sawing104323813sawing
saying104325543saying
schism1338173schism
schist11312653schist
schizo20115993schizo
schizy23115043schizy
seeing74222143seeing
seine55732873s_eine
semina8915573semina
serin55434443serin_
serine65432673serine
sering74731813sering
serins64029673serins
sewing103819623sewing
sexing144313893sexing
shank125422193s_hank
shend94719973s_hend
shent85933503s_hent
shied96125493s_hied
shiel811023773s_hiel
shier85428943s_hier
shies86136553s_hies
shift114225143s_hift
shill85325333s_hill
shily115222013s_hily
shim95827863s_hi_m
shims104422553s_hims
shindy13449323s_hindy
shined104620783s_hined
shiner93820873s_hiner
shines95028913s_hines
shinny124810783s_hinny
ship95228243s_hi_p
ships105123773s_hips
shire84727133s_hire
shirk124817843s_hirk
shirr84716923s_hirr
shirt84533903s_hirt
shist84829613s_hist
shit76745943s_hi_t
shits84731173s_hits
shiv105721173s_hi_v
shiva115915003s_hiva
shive114423423s_hive
shivs115018803s_hivs
shone83725983s_hone
shrine94920053shrine
shrink134511733shrink
shun75122773s_hun_
shuns85018143s_huns
shunt85226513s_hunt
shying134211843shying
siding83822133siding
sighing123311663sighing
sin36265903s__in_
sine46560633s__ine
sing57544183s__ing
sinh76238053s__inh
sink86640153s__ink
sins46755283s__ins
siphon1138463siphon_
siphons1239353siphons
siping94220633siping
sipping123117433sipping
siring75128313siring
siting74126623siting
six105339753s__i_x
sizing163616443sizing
skein94814413skein_
skeins103911903skeins
skiing113610193skiing
skin85927543s_kin_
skink85916863s_kink
skins94723473s_kins
skint95629233s_kint
skying14399983skying
slain54923573slain_
sling66028803s_ling
slink95422913s_link
sluing74315883sluing
soling74226823soling
sophies12314623sophies
sophism1437873sophism
sophist12311573sophist
sopping123917203sopping
soring74731883soring
sowing104222913sowing
sozin14514543sozin_
sozine15712353sozine
sozins15510793sozins
spacing123614493spacing
spading113114383spading
spadix1636113spadix
spaeing103413543spaeing
spahi10311143spahi__
spahis11310383spahi_s
spail74921553spai_l
spails84817823spails
spait75631603spai_t
spaits85017473spaits
span65234663sp_an_
spang84919733sp_ang
spank115919573sp_ank
spans74528733sp_ans
sparing104823873sparing
spavin114210653spavin_
spavins12419323spavins
spawn107811713spawn_
spawns11577923spawns
spaying133014623spaying
spean74620513spean_
speans85417143speans
speil75618643spei_l
speils84116223speils
speir75315363spei_r
speirs85013233speirs
speise84614253speise
speiss84311643speiss
spend85619333sp_end
spent75532833sp_ent
spewing133110453spewing
sphenes123013163sphenes
sphenic1449093sphenic
sphere113313663sphere
sphering142811943sphering
sphery14318883sphery
sphinges14267483sphinges
sphingid1543743sphingid
sphynxes23292423sphynxes
spic85227433sp_i_c
spica94717943sp_ica
spice95528813sp_ice
spicing123914533spicing
spick134519073sp_ick
spics94123243sp_ics
spicy125417713sp_icy
spied85427713sp_ied
spiel74623913sp_iel
spier75728033sp_ier
spies76037623sp_ies
spiff133616403sp_iff
spik105419713sp_i_k
spike114922843sp_ike
spiking144312883spiking
spiks114117473sp_iks
spiky146014113sp_iky
spile75230083sp_ile
spiling102919703spiling
spill74821163sp_ill
spilt75532223sp_ilt
spinal84915313sp_inal
spined95423943sp_ined
spinel85317333sp_inel
spines85132033sp_ines
spinet85629753sp_inet
spinny114510183spinny
spinor839943sp_inor
spinto8410663sp_into
spire75828693sp_ire
spiring103918183spiring
spirt75032953sp_irt
spiry105017353sp_iry
spit65545083sp_i_t
spite75430663sp_ite
spiting103917623spiting
spits74429553sp_its
spitz166017973sp_itz
spiv95917793sp_i_v
spivs105114243sp_ivs
splent84720193splent
splice104915103splice
spliff1438603spliff
splined105013113splined
splines94718893splines
splints94511743splints
split75729013spli_t
splits85416413splits
spoil75818653spoi_l
spoils84614533spoils
spoilt85016593spoilt
spoking143212223spoking
spoon74719443spoon_
spoons84116023spoons
spoony114111793spoony
sporing104319413sporing
sprain83614863sprain_
sprains93013593sprains
sprang95713523sprang
sprent84522383sprent
sprier84119063sprier
sprig85617743spri_g
sprigs94814773sprigs
springe103913983springe
springs104415923springs
springy13359663springy
sprints94113773sprints
sprit76736403spri_t
sprite84421773sprite
sprits85122533sprits
spritz174714423spritz
sprung94610033sprung
spuming1248523spuming
spun66221463sp_un_
spunk114513403sp_unk
spurn74815453spurn_
spurns84811383spurns
squint154214793squint
stain55727943stain_
stains64923653stains
stein54620543stein_
steins64818343steins
sting65330243s_ting
stink95122503s_tink
stint57037663s_tint
string75327563string
stying105414573stying
sughing12359713sughing
suing65026363s_uing
suint55638183s_uint
supine84216693supine
supping123814533supping
swain84919053swain_
swains94513953swains
swine85625303s_wine
swing96124843s_wing
swink125116353s_wink
syphon1436853syphon_
syphons1537503syphons
tahini939893tahini
thin76732393_thin_
thine85026863_thine
thing96622983_thing
think125018803_think
thins85826333_thins
upbind11246313upbind
uphill11106173uphill
uplink12388713uplink
upping114013703upping
upwind12255823upwind
vahine123612113vahine
wahine123813013wahine
whin105225693_whin_
whine116022813_whine
whins114922333_whins
whiny144915573_whiny

Search took 8 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 Filter1786911127160.406440125.6
2DLD Change Limit1127163596.97016171.6
3Display Results3593590.2501436.0
 (SQL Overall)1786913597.62623431.8
 
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.