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

496 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
sophies1231460(None) 
bothies12414782bothies
copies104130302cop_ies
koppies153210012koppies
ophites12310102_ophites
poppies102816192poppies
popsies112816462popsies
shies86136552s__hies
soddies92312852soddies
softies103414612softies
sonnies7315222sonnies
sophism1437852sophism
sophisms1546652sophisms
sophist12311552sophist
sophists1347292sophists
sophs104916022soph__s
sopites93817172sopites
soppier112711582soppier
soppiest122511932soppiest
sorties74126402sorties
spies76037622s_p_ies
tophes115218422toph_es
trophies13413672trophies
aphides134711203_aphides
aphids125110843_aphids
aphis105917133_aphi_s
applies11311213applies
atopies92816433atop_ies
atrophies14410093atrophies
basophiles1744783basophiles
basophils1644303basophils
biopsies1237383biopsies
bobbies103714563bobbies
boccies133311513boccies
boches134618523boch_es
bodies94524143bo_dies
bogies94724313bo_gies
bolshies1338693bolshies
boobies113718203boobies
boodies103721443boodies
boogies103719013boogies
bookies133819403bookies
boonies93422483boonies
booties94124613booties
boshes114721883bosh_es
bossies94116833bossies
bougies103715183bougies
buppies133011063buppies
cochins141413093cochins
colies84837053co_lies
collies94326583collies
commies133718443commies
complies14314523complies
conchies153214853conchies
conies84338593co_nies
cookies133719273cookies
coolies93824963coolies
cooties93725733cooties
copes97747103cop__es
copied114618563cop_ied
copier103722893cop_ier
copiers114215963cop_iers
copihues1543993copihues
coppices1638243coppices
copses104922473cop_ses
corbies113520113corbies
corries94026783corries
coshes115022783cosh_es
cosies84932153co_sies
cowhides1735993cowhides
cowpies143314283cowpies
cowries124218013cowries
cozies174521413co_zies
croppies143111133croppies
daphnes13327683daphnes
dobbies124113063dobbies
dobies94422083do_bies
doggies103613023doggies
dogies85022253do_gies
doilies84017363doilies
dollies83620983dollies
dolphins1445653dolphins
doobies103915673doobies
doodies94218773doodies
doolies83920713doolies
doozies173812723doozies
dopes84935043dop__es
dopier93515923dop_ier
dopiest103315993dop_iest
dories75232363do_ries
dowdies123412733dowdies
dowries114413983dowries
doxies143917853do_xies
doylies114512573doylies
dropsies1138693dropsies
duchies133312313duchies
empties11712243empties
enophiles1448433enophiles
epoxies1637753epoxies
espies83716803esp_ies
floppies1546813floppies
fogies104118063fo_gies
folkies143612253folkies
follies103618943follies
foodies113416753foodies
footies103721543footies
forties104323863forties
gipsies1039903gipsies
goalies8316023goalies
gobies95418053go_bies
goodies93516993goodies
goonies83618333goonies
gopher1239183goph_er
gophers1338983gophers
gothics1336123gothics
gothites1246013gothites
guppies123310523guppies
gypsies1335953gypsies
hies74842833___hies
hippies142813743hippies
hoagies112811993hoagies
hobbies143813343hobbies
hogties112813993hogties
holies94630033ho_lies
hollies103420813hollies
homies114524723ho_mies
hongies112716473hongies
honkies143015143honkies
hoochies1639593hoochies
hoodies113419833hoodies
hookies144017443hookies
hopes105835643hop__es
hoplites13310543hoplites
hoppier143110703hoppier
hoppiest152610723hoppiest
hopples142810713hopples
hotties103016953hotties
howdies142911953howdies
imphees1436693imphees
implies11312113implies
isochimes16103743isochimes
isophotes1466463isophotes
jollies143516273jollies
joshes165114853josh_es
kophs145010933koph__s
kopjes1935363kop_jes
koppie14277873koppie_
lobbies113612463lobbies
lollies73116923lollies
longies82916553longies
loobies93814103loobies
looies65025833lo_oies
loonies73919543loonies
lopes76437343lop__es
loppier11369723loppier
loppiest122410103loppiest
lories64933043lo_ries
lorries74518343lorries
louies64525103lo_uies
mashies12318253mashies
moggies113111723moggies
molies84429513mo_lies
mollies93420233mollies
mommies103912273mommies
monies83233163mo_nies
moperies12313873moperies
mopes95134983mop__es
mopier103914783mop_ier
mopiest113014293mop_iest
mopokes1536693mopokes
morphias1546833morphias
morphines1648223morphines
morphins1538643morphins
moshes115222873mosh_es
mothier121910213mothier
mothiest13311033mothiest
movies115118453mo_vies
moxies154317403mo_xies
murphies1536453murphies
myopies14309713myop_ies
nappies114613393nappies
noddies93512043noddies
noogies82814583noogies
nookies113414963nookies
nopales93812523nopales
noshes96618233nosh_es
ochres113510833_ochres
ohias84415563_o_hias
oldies7314423_oldies
oophytes1646033oophytes
opes65942613_op__es
ophite11410563_ophite
opines84820703_opines
opsins8411713_opsins
optics102810183_optics
optimes1148463_optimes
opuses84012243_opuses
orgies72316093_orgies
ouphes113614633ouph_es
pansophies1774183pansophies
pappies103214823pappies
phis95724903__phi_s
phizes20389133__phizes
pies66949603__p_ies
plies74526513__plies
poesies93217403poesies
pogies94123543po_gies
pokies125921333po_kies
polies84034583po_lies
pommies133712843pommies
ponies84833463po_nies
poperies12316793poperies
popes95933813pop__es
poplins11313153poplins
poppied11388983poppied
popples103011873popples
popsie103013053popsie_
porgies103017003porgies
porkies133416493porkies
posies84431433po_sies
posties93128813posties
potpies113116173potpies
potsies93019483potsies
potties93723543potties
pries74339533__pries
psephites1643843psephites
puppies103212613puppies
qophs19507813qoph__s
raphes115117453raph_es
raphias123511083raphias
raphides14188393raphides
raphis114014323raphi_s
replies94521043replies
roadies83317433roadies
roofies103014413roofies
rookies113917103rookies
roomies93017243roomies
roperies10315763roperies
ropes75940063rop__es
ropier84118803rop_ier
ropiest93317773rop_iest
roshis9311793roshi_s
roughies1298323roughies
rowdies113112693rowdies
sadhes104715373sadh_es
sahibs1137073s_ahibs
sallies73227813sallies
salties73725773salties
samphires1645513samphires
sanies63031953s_anies
sapiens9310173sap_iens
sapotes9313933sapotes
sapphics1743413sapphics
sapphires1644033sapphires
sappier113613113sappier
sappiest122612573sappiest
sashes94728483sash_es
sassies74719263sassies
sauries72821623sauries
savvies1337603savvies
scabies11613333scabies
scopes104719593scop__es
scotties1039733scotties
scries85226823s_cries
selkies113513353selkies
sepias83616103sep_ias
sepses84515883sep_ses
sepsis83011293sepsi_s
septics112810433septics
septimes1238293septimes
series64540973s_eries
serries73925353serries
shavies134213203shavies
shes75734353s__h_es
shied96125493s__hied
shiel811023773s__hiel
shiels95418923s__hiels
shier85428943s__hier
shiers94921753s__hiers
shiest95821523s__hiest
shims104422543s__hims
shines95028913s__hines
shins85131043s__hins
ships105123773s__hips
shires95225573s__hires
shits84731163s__hits
shives124921413s__hives
shivs115018803s__hivs
shoddies1336043shoddies
shoes85429653s__hoes
shophars1646353shophars
shoppes143411383shop_pes
shorties11414573shorties
sickies133717503sickies
silkies113715693silkies
sillies73425073sillies
sipes76036953sip__es
siphons1239343siphons
sissies73716603sissies
sixties14310973sixties
skies95026833s__kies
skoshes14246243skosh_es
slopes84820453slop__es
sloppier1255703sloppier
sloppiest1345973sloppiest
sloshes103811803slosh_es
sloshier1135283sloshier
sloshiest1246673sloshiest
smithies1337913smithies
smoothies1456123smoothies
soapier93411713soapier
soapiest102412843soapiest
soaves94218673so_aves
socages101012053socages
socles8418453so_cles
sodomies11128553sodomies
soffits1335093soffits
softie93312473softie_
soggier93410883soggier
soggiest102711643soggiest
soils55327983so__ils
soirees72411643soirees
sokes95031423so__kes
solaces93116133solaces
solates73523853solates
soldier82812153soldier
soldiers9277773soldiers
soles55547923so__les
solids74116403so_lids
solutes73515263solutes
solves95018223so_lves
somites94219113somites
sondes74922873so_ndes
sones55444143so__nes
sonics84315633so_nics
sonships1357453sonships
sonsie6614853sonsie_
sonsier7711743sonsier
sonsiest8313033sonsiest
soothes103917103soothes
sootier73916603sootier
sootiest84016753sootiest
soph97024203soph___
sophy136611763soph__y
sopite84917713sop_ite
sopited104211053sopited
sopors85215193sop_ors
sopped114819903sop_ped
soppiness1336543soppiness
sopping123917203sopping
sops65244563sop___s
sordines92414063sordines
sores55454283so__res
sorites73825243sorites
soroses73117483soroses
sorrier72313723sorrier
sorriest8413883sorriest
sortie63621983sortie_
sortied83314093sortied
soths86218623soth__s
soubise9118793soubise
soubises10107993soubises
soupier93111753soupier
soupiest102212903soupiest
sources9312173sources
souses64229243so_uses
soviet9720153so_viet
soviets1087293so_viets
soyuzes1932953soyuzes
sozines16611263sozines
sozins15510783so_zins
spaces104722633s_paces
spades94222583s_pades
spaes76029973s_p_aes
spahees1238263spahees
spahis11310383spahi_s
spails84817823s_pails
spaits85017473s_paits
spales84728103s_pales
spares84834553s_pares
spates85028173s_pates
spavies123012943spavies
species11314133species
speils84116223s_peils
speirs85013233s_peirs
speise84614253s_peise
speises93813933s_peises
speiss84311643s_peiss
sphenes123013163s_phenes
spheres123114353s_pheres
sphinges14267483s_phinges
sphinx1866203s_phinx
sphinxes20334403s_phinxes
spices104326033s_pices
spics94123243s_p_ics
spied85427713s_p_ied
spiel74623913s_p_iel
spiels85317953s_p_iels
spier75728033s_p_ier
spiers84421743s_p_iers
spikes124520713s_pikes
spiks114117473s_p_iks
spiles84227913s_piles
spines85132033s_pines
spins75327983s_p_ins
spires84628113s_pires
spites84127333s_pites
spits74429553s_p_its
spivs105114243s_p_ivs
splices113914383s_plices
splines94718893s_plines
splits85416413s_plits
spodes94817433s_podes
spoils84614533s_poils
spokes124417213s_pokes
sponges10311043sponges
spoonies101911753spoonies
spores84726613s_pores
spouses92912813spouses
sprees85620643s_prees
sprier84119063s_prier
spriest92718643s_priest
sprigs94814773s_prigs
sprites94220333s_prites
sprits85122533s_prits
sprues84515763s_prues
spues75025383s_p_ues
spumes1021314883s_pumes
sties55132983s__ties
stimies9316553stimies
stithies1139233stithies
stogies8413693stogies
stoolies8311083stoolies
stopes84525893stop__es
stopples1236953stopples
stories7324273stories
strophes13310593stroph_es
studies82413863studies
stymies1239213stymies
sulkies114315763sulkies
sullies74122223sullies
sulphides1544693sulphides
sulphids1444373sulphids
sulphites1445683sulphites
supes75628303sup__es
supines94216383supines
supples11511283supples
supplies1268823supplies
sushis9311183sushi_s
swamies123712063swamies
sylphids1743953sylphids
sypher14317083syph_er
syphers15317273syphers
syphilis1645823syphilis
syphons1537503syphons
syphs13519453syph__s
syrphids1744243syrphids
techies12513603techies
toadies82914853toadies
tobies84521013to_bies
toddies93011993toddies
todies74223553to_dies
toffies133210213toffies
tommies113812983tommies
toonies73719883toonies
topazes1857313topazes
topees85519703top_ees
topes76941763top__es
tophe106718973toph_e_
tophi105215303tophi__
tophs105220053toph__s
tophus115210363toph_us
topics104714583top_ics
topis76025833top_i_s
toplines102412563toplines
topples113111653topples
topsides1137203topsides
tories65435883to_ries
toshes94520103tosh_es
toughies1278243toughies
towhees13277793towhees
towies93521193to_wies
townies103113623townies
trophied1437643trophied
tushies10312163tushies
vichies15310623vichies
withies133913543withies
woodies113517153woodies
woolies104117363woolies
worries104117133worries
worthies14310283worthies
yippies14279293yippies
yowies123913733yo_wies
yuppies14339263yuppies
zombies2037983zombies
zoophiles2356523zoophiles

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340274967.61017612.0
3Display Results4964960.1862666.7
 (SQL Overall)1786914967.95222471.2
 
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.